- Our DevgTest Registry server is running in remote location(onsite),
- We are trying to launch the workstation from offshore by providing remote registry server ip (tcp://<<remote registry server ip>>:2010/Registry)
- After that, it is asking for credentials and we provide credentials(admin/admin), we are all using default common credentials(admin/admin)
- After login we are getting User does not have permission to use DevTest Workstation with this registry. Please contact your DevTest administrator. [user=admin]
- We are able to launch VSE Console in the same offshore machine, but not able to connect the workstation
- Please help us to resolve this issue , we are struggling with this issue last two weeks
Please find the Offshore work station error Log below
com.itko.lisa.gui.TestAdmin - Preflighting database
2016-11-01 09:09:05,604Z (14:39) [Preflighting database] INFO com.itko.lisa.gui.TestAdmin - Database preflight completed
2016-11-01 09:09:09,406Z (14:39) [ProcDlgThreadCallbk@31c19bee] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [applicationContext-security.xml]
2016-11-01 09:09:09,516Z (14:39) [ProcDlgThreadCallbk@31c19bee] INFO org.springframework.context.support.GenericXmlApplicationContext - Refreshing org.springframework.context.support.GenericXmlApplicationContext@2b2012c5: startup date [Tue Nov 01 14:39:09 IST 2016]; root of context hierarchy
2016-11-01 09:09:11,584Z (14:39) [ProcDlgThreadCallbk@31c19bee] INFO com.itko.lisa.utils.db.ConnectionPoolManager - Created pool named common
2016-11-01 09:09:11,600Z (14:39) [ProcDlgThreadCallbk@31c19bee] INFO org.eclipse.persistence - EclipseLink, version: Eclipse Persistence Services - 2.3.2.v20111125-r10461
2016-11-01 09:10:18,649Z (14:40) [ProcDlgThreadCallbk@31c19bee] ERROR com.itko.lisa.acl.utils.AclJpaUtil - Could not configure database persistence for unit: itko-acl
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)
at com.itko.lisa.acl.utils.AclJpaUtil.updateCacheExpirationPolicy(AclJpaUtil.java:1258)
at com.itko.lisa.acl.utils.AclJpaUtil.setCacheTimeoutMillis(AclJpaUtil.java:1254)
at com.itko.lisa.acl.utils.AclJpaUtil.<init>(AclJpaUtil.java:145)
at com.itko.lisa.acl.utils.AclJpaUtil$1.initialValue(AclJpaUtil.java:62)
at com.itko.lisa.acl.utils.AclJpaUtil$1.initialValue(AclJpaUtil.java:60)
at java.lang.ThreadLocal.setInitialValue(Unknown Source)
at java.lang.ThreadLocal.get(Unknown Source)
at com.itko.lisa.acl.utils.AclJpaUtil.getJpaUtil(AclJpaUtil.java:78)
at com.itko.lisa.acl.ActivityCache.loadActivities(ActivityCache.java:47)
at com.itko.lisa.acl.ActivityCache.getInstance(ActivityCache.java:33)
at com.itko.lisa.acl.RoleActivityCache.loadRoles(RoleActivityCache.java:60)
at com.itko.lisa.acl.RoleActivityCache.getInstance(RoleActivityCache.java:37)
at com.ca.dts.security.authentication.RemoteAuthenticationManager.createUser(RemoteAuthenticationManager.java:223)
at com.ca.dts.security.authentication.RemoteAuthenticationManager.authenticate(RemoteAuthenticationManager.java:183)
at com.itko.lisa.test.LisaSecurityManager.authenticate(LisaSecurityManager.java:730)
at com.itko.lisa.test.LisaSecurityManager.authenticateUser(LisaSecurityManager.java:686)
at com.itko.lisa.test.LisaSecurityManager.authenticateUserFromGUI(LisaSecurityManager.java:928)
at com.itko.lisa.gui.TestAdmin$1.doCallback(TestAdmin.java:232)
at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:194)
at java.lang.Thread.run(Unknown Source)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:309)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:330)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:293)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:418)
at org.eclipse.persistence.sessions.server.ConnectionPool.buildConnection(ConnectionPool.java:216)
at org.eclipse.persistence.sessions.server.ConnectionPool.startUp(ConnectionPool.java:504)
at org.eclipse.persistence.sessions.server.ServerSession.connect(ServerSession.java:484)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:633)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:208)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)
... 24 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at com.itko.lisa.utils.db.LisaWrappedDataSource.getConnection(LisaWrappedDataSource.java:38)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)
... 34 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1463)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:639)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:549)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
... 37 more
Registry log from server
INFO com.itko.lisa.coordinator.TestRegistryImpl - adding new live workstation:<<Offshore Devtest Wokstation Host Details>>
2016-10-25 08:39:25,145Z (01:39) [qtp1143721110-127341] WARN com.itko.lisa.utils.db.LisaSessionCustomizer - SQL query took a long time (113 ms) : SELECT t1.ACTIVITY_ID, t1.DESCRIPTION, t1.LICENSE_TYPE, t1.ACTIVITY_NAME, t1.PARENT_ACTIVITY_ID, t0.ROLE_ID FROM ACL_ROLES_ACTIVITIES t0, ACL_ACTIVITIES t1 WHERE ((t1.ACTIVITY_ID = t0.ACTIVITY_ID) AND (t0.ROLE_ID IN ?))
2016-10-25 08:39:25,292Z (01:39) [qtp1143721110-127341] WARN com.itko.lisa.utils.db.LisaSessionCustomizer - SQL query took a long time (110 ms) : SELECT t1.ACTIVITY_ID, t1.DESCRIPTION, t1.LICENSE_TYPE, t1.ACTIVITY_NAME, t1.PARENT_ACTIVITY_ID, t0.ROLE_ID FROM ACL_ROLES_ACTIVITIES t0, ACL_ACTIVITIES t1 WHERE ((t1.ACTIVITY_ID = t0.ACTIVITY_ID) AND (t0.ROLE_ID IN ?))