x Want to participate? Join the group to interact
Sage CRM
Recommended

If the Interactive Dashboard refuses to work, this could an error in the JDBC configuration

Less than one minute read time.

The Interactive Dashboard and SData features use JDBC to interact with the database

If you find that your Interactive Dashboard refuses to work then it may be a problem with the information in the jdbc properties file.

Assuming that your install of Sage CRM is called "crm" then

Navigate to C:\Program Files (x86)\Sage\CRM\CRM\tomcat\webapps\crmj\WEB-INF

Within the file you will need to check the name of the server:

If the line looks like

jdbc.url=jdbc:log4jdbc:sqlserver://(local)\\SQLEXPRESS:1433;databaseName=CRM;integratedSecurity=true;

or

jdbc.url=jdbc:log4jdbc:sqlserver://(local):1433;databaseName=CRM

The "(local)" needs to be replaced with either the server name or localhost. If your server is called 'goliath' then the following would be correct entries.

e.g

jdbc.url=jdbc:log4jdbc:sqlserver://GOLIATH\\SQLEXPRESS:1433;databaseName=CRM70;integratedSecurity=true;

or

jdbc.url=jdbc:log4jdbc:sqlserver://GOLIATH:1433;databaseName=CRM

Anonymous
Parents

  • I ran into this problem and it now makes sense why I had an issue. My external name used would not resolve on the local server (internal). Once I added the external dns name being used to the local dns list, the dashboard started to work correctly.

    Great information. Thanks

Comment

  • I ran into this problem and it now makes sense why I had an issue. My external name used would not resolve on the local server (internal). Once I added the external dns name being used to the local dns list, the dashboard started to work correctly.

    Great information. Thanks

Children
No Data