Question Re: Database error 3997 in Technology Q&A

Database error 3997

Former Member — Fri, 18 Aug 2006 11:30:36 GMT

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?

Re: Database error 3997

Former Member — Fri, 18 Aug 2006 11:58:05 GMT

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.

Re: Database error 3997

Former Member — Fri, 18 Aug 2006 11:58:56 GMT

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

Re: Database error 3997

Former Member — Tue, 22 Aug 2006 11:21:02 GMT

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

Re: Database error 3997

Former Member — Mon, 04 Sep 2006 09:52:00 GMT

Sorry, i was wrong. The parameter DID help!

Re: Database error 3997

Former Member — Tue, 05 Sep 2006 17:11:14 GMT

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

Re: Database error 3997

Former Member — Wed, 06 Sep 2006 09:32:23 GMT

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.