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!

[Former Member]

It is not a good idea to use the undocumented profile parameter dbs/mss/use_mars. It will help avoid the 3997 database error, but it will almost certainly create more problems down the road.

You should have a look at note #903705 and make sure that you are running a reasonably current SAP kernel (including DBMSSSLIB.DLL). Please also make sure that your system is on SAP_BASIS support package level 15 or higher (note #905634).

Please open a SAPNet/OSS message, if the error persists.

Best regards,

Christian Hiller

[Former Member]

The problem exists only until applying SP Stack. After importing SP Stack the problem doesn't exest anymore. But thanks for the helpful answer anyway.

[Former Member]

I am not up on my SQL, but I did come across this for you.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=235861&SiteID=1

Read though it, you may find an idea here.