x Want to participate? Join the group to interact
Sage CRM
Related
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

Parents

  • I saw that error when I changed the server name. The error on the screen was: The Dashboard has experienced a problem. Please contact your System Administrator. The error in the scrmsql log file was org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

    Changing this line:

    jdbc.url=jdbc:log4jdbc:sqlserver://;databaseName=

    in jdbc.properties to point to the correct server and doing an iisreset got it working again.

Comment

  • I saw that error when I changed the server name. The error on the screen was: The Dashboard has experienced a problem. Please contact your System Administrator. The error in the scrmsql log file was org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

    Changing this line:

    jdbc.url=jdbc:log4jdbc:sqlserver://;databaseName=

    in jdbc.properties to point to the correct server and doing an iisreset got it working again.

Children
No Data
Generic Content
Generic Content

*Community Hub is the new name for Sage City