Login Problem - Deadlock?

[Former Member]

Hi All,

I started the transaction to create a Root Organizational Unit.

The SAP Gui says its compiling (for hours).

Since I have started the transaction, <b>no user can login</b> in the system via SAPGui and Visual Administrator.

What is the solution to stop the compiling, to kick the user, shutdown the database?

The System is Netweaver SAP Web Application Server 6.40 Technolgy Preview on MaxDB 7.5 on Suse Linux 9.3.

Any help is really appreciated,

Tom

[Former Member · Accepted solution]

Hi Tom,

Can you pls check and send the trace file to know the more details of the problem:

/usr/sap/SID/DVEBMGS01/log/TRACE001

Regards,

Vivek

[Former Member]

Hi Tom,

Go through these links for database rollback ... this may help you :-

1) http://dev.mysql.com/doc/maxdb/en/69/0dc4406b658431e10000000a1550b0/content.htm

2)http://dev.mysql.com/doc/maxdb/en/72/16b83fa6b33c17e10000000a114084/content.htm

Cheers,

Vivek

[Former Member]

Probably all your "dialog" work processes are busy. You can either wait or stop SAP. Increase number of dialog work processes (rdisp/wp_no_dia) in the INSTANCE profile and strat SAP again.

Cheers,

Sanjeev

[Former Member]

Thanks Sanjeev but it doesn't work.

The System has two work processes and when the problem occurred only one user was connected. The system has had several hours but it doesn't work.

So I stopped the Application Server and than the Database (both takes much longer than usually) and restarted Linux and SAP.

Nevertheless I can't login via SAP Gui login. Nor can i connect to the system via visual administrator.

The databasecheck at stop and start of the system was positive but may be there is an error.

Is there a possibility to check and correct the database via command line, may be a rollback?

Thanks Tom