Summary:

When logging into Sage CRM the following error message is displayed on the Interactive Dashboard:

Description 


Symptoms:

If you navigate to the the localhost_access_log.txt file (C:\Program Files (x86)\Sage\CRM\CRM\tomcat\logs) it is showing a HTTP 500 error when loading the dashboard:

127.0.0.1 - - [24/Jul/2014:13:12:57 +0200] "GET /crmj/layout/-/$service/lp_logout?SID=213741032547420 HTTP/1.1" 500 60655
127.0.0.1 - - [24/Jul/2014:13:13:04 +0200] "GET /crmj/layout/-/$service/lp_getpage?lpId=6007&SID=121497636847421&contextEntityId=-1&contextRecordId=-1 HTTP/1.1" 500 60655

Also if you run Fiddler on the Dashboard it is displaying the 500 error also:

Description 


Cause:

The cause of this issue was that The TCP/IP port was incorrect in the db.properties. It was set to use 1433, but this SQL install was set use a dynamic port.

Resolution:

Is to update the db.properites to use the dynamic port number or you can alternatively use a static port and set the same port in the db.properties.