Database error 3997

[Former Member]

I have problem with WAS 6.40 installation on SQL Server 2005 database anw Windows 2003 Server. After installing i receive errors in Syslog:

Database 3997 at EXE

> A transaction that was started in a MARS batch is still

> active at the end of the batch. The transaction is rolled

> back.

Database error 3997

When i look into R3Syslog, i can see that it propably has something to do with database statistic update - the log shows that the program name is RSMSSUPDATEDBSTATS. Do i have to worry about this error (i'm afraid it may affect system performance)? Is there any way to correct this?

[Former Member · Accepted solution]

Hi,

you could try using this parameter:

dbs/mss/use_mars = 0

But according to my information, this error shouldn't come up with WAS 6.40. Give it a shot - maybe somebody else has a better idea.

Regards,

Sven

[Former Member · Accepted solution]

I couldn't find this parameter in parameter list, but I have tried this. Unfortunately this doesn't work.

Message was edited by: Przemyslaw Siudzinski

[Former Member · Accepted solution]

Sorry, i was wrong. The parameter DID help!