AnsweredAssumed Answered

Data Warehouse Job Fail

Question asked by AbhijitClarity on Apr 26, 2016
Latest reply on May 2, 2016 by Nika_Hadzhikidi

Dear All,

 

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

com.niku.union.persistence.PersistenceException:

SQL error code: 1326

Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Named Pipes Provider: Could not open a connection to SQL Server [1326].

 

ODBC is running fine from CSA server to DBserver.

Has anybody come across this error while configuring Data Warehousing.

 

Kind Regards,

Abhijit

 

 

 

 

 

 

 

 

Attachments

Outcomes