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]

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.