SAP CRM / CS Supports

Symptom

Unable to login to ARS DB.

Other terms

LockManager recovery error, Login failed

Reason and Prerequisites

This happens because some Windows service and SAP MAR Central Service are running from port 1002. During a MAR installation also, sometimes SAP MAR Central Service would not get properly installed because of a port conflict with another service which is also running from port 1002.Hence, even though Central Service is shown as running from the services console, it is not ready to accept any connection from the clients.

Solution

This can be resolved by uninstalling Central Service and then reinstalling the same on another port. This is a three step process and following the steps as mentioned below would resolve this error:
1. Uninstall the current instance of SAP MAR Central Service by running the following command from the command prompt:
\ARSCentralServerInstaller.exe /DNTUninstall /SNM”SAP MAR Central Service”
Click the OK Button on the message box displayed next.
2. Define a free port number (Free Port Number) on the target machine. You may need to contact your systems administrator to determine a list of free ports on the machine.
3. Restart the machine and run the following command from the command prompt:
\ARSCentralServerInstaller.exe /DNTInstall /SNM”SAP MAR Central Service” /PRT /UCP”” /PFP””
Click the OK Button on the message box displayed next.
4. Open the query analyzer and run the following query in the query editor:
use ars_db
update ars_systable set value=’0000‘ where param=’RemoteSocketPort’
5. Open the file called ARSCentralServer.properties (located in the Mobile Bin Folder) in the notepad and navigate to the fourth line in the file:
This should contain the following string:
ARSCentralServer.port 1002
Change this to:
ARSCentralServer.port (free port number)
Save and close this file.
5. Shut down SAP MAR Central Service.
6. Restart MS Sql Server
7. Restart SAP MAR Central Service.
Now the connection to ARS_DB would work.