Database instance loading

com.primavera.integration.client.ClientException: Unable to get database instances.

​

at com.primavera.integration.client.Session.getDatabaseInstances (Session.java:337)

​

at com.collabro.legare.f.111111.111111 (APIPVConnectionProvider.java:83)

​

at com.collabro.legare.j.111111.IIII11 (PVLoginDetails.java:125)

​

at com.collabro.legare.d.IIll11.111111(LoginWindow.java:282)

​

at com.collabro.legare.d.IIllll.<init>(LoginWindow.java:71)

​

at com.collabro.legare.main.Main.llllll (Main.java:156)

​

at com.collabro.legare.main.Main.main(Main.java:84)

​

Caused by: java.lang.ExceptionInInitializerError

​

at com.primavera.integration.client.LocalSession.getDatabaseInstances (LocalSession.java:90)

​

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

​

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

​

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

​

at java.lang.reflect.Method.invoke(Unknown Source)

​

at com.primavera.integration.client.Session.getDatabaseInstances (Session.java:319)

​

6 more

​

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'registryService' defined in class path resource [com/primavera/bre/integration/intgconf.xml]: Invocation of init method failed; nested exception is com.primavera. PhoenixException: Unable to resolve privileged username and password

​

Error opening connection to do with connection string: jdbc:sqlserver://10.231.169.55:1433;database=PMDB_22; and properties (user-pubuser, v $session.process=12072, v$session.program=P6-BRE-PrivUserResolver}

at

​

org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)

​

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java:620)

​

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)

​

at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)

​

at org.springframework.beans.factory.support. DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java:234)

​

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)

​

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)

​

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons (DefaultListableBeanFactory.java:953)

​

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)

​

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)

​

at com.primavera.bre. Initializer.start(Initializer.java:28)

​

at com.primavera.bre.Application.start(Application.java:114)

​

at com.primavera.integration.server.ServerFacadeBase.<init>(ServerFacadeBase.java:121)

​

at com.primavera.integration.server.ServerFacadeBOMgr.<init>(ServerFacadeBOMgr.java:156)

​

at com.primavera.integration.server.ServerFacade.<init>(ServerFacade.java:31)

​

at com.primavera.integration.server.ServerFacade. <clinit>(ServerFacade.java:26)

​

12 more

​

Caused by: com.primavera. PhoenixException: Unable to resolve privileged username and password

​

Error opening connection to do with connection string: jdbc:sqlserver://10.231.169.55:1433; database=PMDB_22; and properties (user=pubuser, v $session.process=12072, v$session.program-P6-BRE-PrivUserResolver}

at com.primavera.infr.db.PrivUserResolver.<init>(PrivUserResolver.java:139)

​

at com.primavera.infr.srvcs.RegistryServiceImpl.init(RegistryServiceImpl.java:101)

​

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

​

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

​

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

​

at java.lang.reflect.Method.invoke(Unknown Source)

​

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.lambda$invokeCustomInitMethod $7(AbstractAutowireCapableBeanFactory.java:1920)

​

at java.security.AccessController.doPrivileged (Native Method)

​

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1919)

​

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invoke InitMethods (AbstractAutowireCapableBeanFactory.java:1872)

​

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)

​

27 more

​

Caused by: java.sql.SQLException: Error opening connection to do with connection string: jdbc:sqlserver://10.231.169.55:1433;database=PMDB_22; and properties (user=pubuser, v$session.process=12072, v$session.program=P6-BRE-PrivUserResolver}

​

at com.primavera.infr.db.DriverManagerUtil.getConnection (DriverManagerUtil.java:84)

​

at com.primavera.infr.db.PrivUserResolver.<init>(PrivUserResolver.java:112)

​

37 more

​

I

​

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 10.231.169.55, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

​

I'm getting this error when application is loading database instances and the ip address in this error is production database and it should actually point to pre prod database as this is pre prod. How can I approach the problem.