Symptom

When adding a Runtime or a Log Database in Analytics, the following error occurs: "Connection to the data source could not be established - Reason : Could not connect to the data source".

Possible cause 1:

The JDBC driver corresponding to the Runtime log database is not properly set in <STAMBIA_WEBAPP_HOME>/jdbc directory.


Solution

Install the JDBC drivers for the Runtime log database, into the <STAMBIA_WEBAPP_HOME>/jdbc directory:

[~/analytics_webapp_home/]# ls -l
internal
jdbc
navigator
repositories
stambia.logs
temp
users

Reminder: the analytics's webapp home depends on your Application Server installation. This location can be controlled with the STAMBIA_WEBAPP_HOME environment variable. It is different from the webapp installation directory inside your application server (which contains META-INF and WEB-INF folders). 


Possible cause 2:


An "Illegal character in authority" error may occur when there is a backslash inside the url defined at the "userLogRdbmsUrl" log parameter in the runtime engineParamters.xml file.

For exemple:

[engineParamters.xml]

<parameter name="userLogRdbmsUrl" value="jdbc:sqlserver://localhost\LOCALMSSQLSERVER;sendStringParametersAsUnicode=false"/>


This is because backslashes back inside the URLs.



Solution

Specify the instance using, for example

jdbc:sqlserver://localhost;instance=LOCALMSSQLSERVER

instead of

jdbc:sqlserver://localhost\LOCALMSSQLSERVER

in the connection url in the engineParameters.xml file on runtime's side.