Hello Suman,
Below is the screenshot of Data Warehouse configuration in the NSA. Can you please check if the parameters are correct.
PPM_DWH is the login created for data warehouse.
ERROR 2016-04-26 08:28:39,378 [http-nio-8090-exec-2]
handlers.DWHDBLinkConnectionHandler
(clarity:sa:8ZUTgs9cbIEd0+SrOa3cGsioMde6UeOBPWzuzikQis00: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].
Executed:
SELECT count(1) dblinkvalid
from [PPMDBLINK].ClarityDev.niku.DWH_SETTINGS
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement
sortColumnPath="/data/header/sortInfo/@sortColumn"
sortDirectionPath="/data/header/sortInfo/@sortDirection"
slicePath="/data/header/pagination/sliceInfo/@slice"
sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize"
inputSource="map"
xmlns="http://schemas.niku.com/2002/pmd">
<sql
dbVendor="all">
<text>@dynamic@</text>
<param
direction="IN" dynamicReplacement="@dynamic@"
expressionListDelimiter=","/>
</sql>
</statement>
Not sure why we are seeing network error as Clarity Database and Data Warehouse DB both are on the same SQL Server and Clarity App is able to talk with Clarity Database.
Admin Log is as below :-
4/25/16 7:51 PM (niku) execute: remote = false
4/25/16 7:51 PM (niku) execute: hosts.xml out of date
4/25/16 7:51 PM (niku) execute: Config Mgr setup
4/25/16 7:51 PM (niku) execute: read hosts.xml
4/25/16 7:52 PM (niku) execute: remote = false
4/25/16 7:52 PM (niku) execute: hosts.xml out of date
4/25/16 7:52 PM (niku) execute: Config Mgr setup
4/25/16 7:52 PM (niku) execute: read hosts.xml
4/25/16 7:58 PM (niku) execute: remote = false
4/25/16 7:58 PM (niku) execute: hosts.xml out of date
4/25/16 7:58 PM (niku) execute: Config Mgr setup
4/25/16 7:58 PM (niku) execute: read hosts.xml
4/25/16 7:58 PM (niku) execute: remote = false
4/25/16 7:58 PM (niku) execute: hosts.xml out of date
4/25/16 7:58 PM (niku) execute: Config Mgr setup
4/25/16 7:58 PM (niku) execute: read hosts.xml
4/25/16 7:58 PM (niku) Deploying service(s)...
4/25/16 7:58 PM (niku) Initialized...
4/25/16 7:58 PM (niku) Executing ant script
4/25/16 7:58 PM (niku) Executed ant script
4/25/16 7:58 PM (niku) Updating service: beacon
4/25/16 7:58 PM (niku) Updating windows service: CA Clarity PPM Beacon
4/25/16 7:58 PM (niku) Updated windows service: CA Clarity PPM Beacon
4/25/16 7:58 PM (niku) Done.
4/25/16 7:58 PM (niku) execute: remote = false
4/25/16 7:58 PM (niku) execute: hosts.xml out of date
4/25/16 7:58 PM (niku) execute: Config Mgr setup
4/25/16 7:58 PM (niku) execute: read hosts.xml
4/25/16 7:58 PM (niku) Deploying service(s)...
4/25/16 7:58 PM (niku) Initialized...
4/25/16 7:58 PM (niku) Executing ant script
4/25/16 7:59 PM (niku) Executed ant script
4/25/16 7:59 PM (niku) Updating service: nsa
4/25/16 7:59 PM (niku) Updating windows service: CA Clarity PPM System Admin Server
4/25/16 7:59 PM (niku) Updated windows service: CA Clarity PPM System Admin Server
4/25/16 7:59 PM (niku) Done.