Currently we are on Clarity14.3 and trying to install Jaspersoft alongwith Data Warehouse.
We are able to set up dblink from database side using cmn_dblink_sp.
.ppm_dwh.cmn_dblink_sp 'PPMDBLINK','DB Server Host Name,Port' , 'Clarity Database Name' ,'ClarityDB Login', 'ClarityDBLogin Password'
We validated this dblink by executing below query which is giving correct output.
select COUNT(1) from PPMDBLINK.ClarityDev.niku.srm_resources
We have created separate login for data warehouse with ppm_dwh.
When we are trying to configure from CSA, we are facing error regarding connectivity between database and data warehouse.It seems that CSA is ignoring the custom link which we have created in previous step using cmn_dblink_sp.
We checked NSA logs and found below error.
ERROR 2016-04-25 21:19:55,727 [http-nio-8090-exec-5] handlers.DWHDBLinkConnectionHandler (clarity:sa:3X/F9v1IsPbfAZWV263rUeBjBbTmctOTz4TYj/bjUiU0:nsa.properties.datawarehouse.save) Connection with the database could not be established with Database link
SQL error code: 1326
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Named Pipes Provider: Could not open a connection to SQL Server .
ODBC is running fine from CSA server to DBserver.
Has anybody come across this error while configuring Data Warehousing.