Unable to start Collab, Getting "Error reading connection expiration time property from JVM"

Hi All,

Collab was worked fine till yesterday and has stopped working from morning. While Starting I seen the below Errors in the CollabConsole.txt

[Nov 25, 2014 3:21:35 PM (main)]: Error reading connection expiration time property from JVM

Also I could see below Errors as well in the Old Logs.

[Nov 25, 2014 3:21:56 PM (main)]: ORM inner error was:
java.sql.SQLException: The Network Adapter could not establish the connection
   at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
   at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
   at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
   at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
   at java.sql.DriverManager.getConnection(DriverManager.java:571)
   at java.sql.DriverManager.getConnection(DriverManager.java:215)
   at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.establishConnection(JDBCConnectionPool.java:341)
   at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getFreeConnection(JDBCConnectionPool.java:253)
   at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getReadOnlyConnection(JDBCConnectionPool.java:87)
   at com.intraspect.objrel.db.jdbc.JDBCDatabase.initAdaptor(JDBCDatabase.java:192)
   at com.intraspect.objrel.db.jdbc.JDBCDatabase.<init>(JDBCDatabase.java:184)
   at com.intraspect.objrel.db.relational.oracle.OracleDatabase.<init>(OracleDatabase.java:39)

However, I have restarted DataBase but still getting the

"Error reading connection expiration time property from JVM"

Thanks

Jay

Find more posts tagged with

Comments

Venkatasatyanarayana Chirravuri

Hi,from the below error logs it seems it is unable to connect to DataBse?Can you please check the network connectivity from Collab to DB?java.sql.SQLException: The Network Adapter could not establish the connectionMurthy________________________________________From: eLink Entry: Vignette Collaboration Developers Forum [vignettecollaborationdevelopersforum@elinkkc.opentext.com]Sent: Tuesday, November 25, 2014 5:20 PMTo: eLink RecipientSubject: Unable to start Collab, Getting "Error reading connection expiration time property from JVM"Unable to start Collab, Getting "Error reading connection expiration time property from JVM" Posted by jayaram.ponnusamy@mannai.com.qa (Ponnusamy, Jayaram) On 11/25/2014 06:48 AMHi All,Collab was worked fine till yesterday and has stopped working from morning. While Starting I seen the below Errors in the CollabConsole.txt[Nov 25, 2014 3:21:35 PM (main)]: Error reading connection expiration time property from JVMAlso I could see below Errors as well in the Old Logs.[Nov 25, 2014 3:21:56 PM (main)]: ORM inner error was:java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.establishConnection(JDBCConnectionPool.java:341) at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getFreeConnection(JDBCConnectionPool.java:253) at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getReadOnlyConnection(JDBCConnectionPool.java:87) at com.intraspect.objrel.db.jdbc.JDBCDatabase.initAdaptor(JDBCDatabase.java:192) at com.intraspect.objrel.db.jdbc.JDBCDatabase.(JDBCDatabase.java:184) at com.intraspect.objrel.db.relational.oracle.OracleDatabase.(OracleDatabase.java:39)However, I have restarted DataBase but still getting the "Error reading connection expiration time property from JVM"ThanksJay________________________________[To post a comment, use the normal reply function]Forum: Vignette Collaboration Developers ForumContent Server: Knowledge Center

Venkatasatyanarayana Chirravuri

Hi,If database is down when Collab is running you will observe the below errors in logs after database come up, Collab should start gracefully? if not yet started can you please restart Collab and check the logs Murthy________________________________________From: eLink Entry: Vignette Collaboration Developers Forum [vignettecollaborationdevelopersforum@elinkkc.opentext.com]Sent: Tuesday, November 25, 2014 5:20 PMTo: eLink RecipientSubject: Unable to start Collab, Getting "Error reading connection expiration time property from JVM"Unable to start Collab, Getting "Error reading connection expiration time property from JVM" Posted by jayaram.ponnusamy@mannai.com.qa (Ponnusamy, Jayaram) On 11/25/2014 06:48 AMHi All,Collab was worked fine till yesterday and has stopped working from morning. While Starting I seen the below Errors in the CollabConsole.txt[Nov 25, 2014 3:21:35 PM (main)]: Error reading connection expiration time property from JVMAlso I could see below Errors as well in the Old Logs.[Nov 25, 2014 3:21:56 PM (main)]: ORM inner error was:java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.establishConnection(JDBCConnectionPool.java:341) at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getFreeConnection(JDBCConnectionPool.java:253) at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getReadOnlyConnection(JDBCConnectionPool.java:87) at com.intraspect.objrel.db.jdbc.JDBCDatabase.initAdaptor(JDBCDatabase.java:192) at com.intraspect.objrel.db.jdbc.JDBCDatabase.(JDBCDatabase.java:184) at com.intraspect.objrel.db.relational.oracle.OracleDatabase.(OracleDatabase.java:39)However, I have restarted DataBase but still getting the "Error reading connection expiration time property from JVM"ThanksJay________________________________[To post a comment, use the normal reply function]Forum: Vignette Collaboration Developers ForumContent Server: Knowledge Center

Jayaram Ponnusamy

Thanks for your Quick reply,

Actually there was some network changes done and the IP address has changed.

So, the Collab couldn't communicate with DataBase. I have updated the new IP in the Host and restarted the Collab. Now its working fine.

Once again Thanks for all!

Jay

Aaron_Eichenseer

Hi Jay,

I wanted to add that "Error reading connection expiration time property from JVM" is benign. That just means you haven’t set the database connection expiration, but setting the database expiration is optional. Usually, you only set the database expiration if something is timing out the database connection like a firewall.

Regards,

Aaron

From: eLink Entry: Vignette Collaboration Developers Forum [mailto:vignettecollaborationdevelopersforum@elinkkc.opentext.com]
Sent: Tuesday, November 25, 2014 8:00 AM
To: eLink Recipient
Subject: RE Unable to start Collab, Getting "Error reading connection expiration time property from JVM" 2

RE Unable to start Collab, Getting "Error reading connection expiration time property from JVM" 2

Posted byvchirrav@opentext.com (Chirravuri, Venkatasatyanarayana) On 11/25/2014 08:59 AM

Hi,
If database is down when Collab is running you will observe the below errors in logs after database come up, Collab should start gracefully? if not yet started can you please restart Collab and check the logs

Murthy
________________________________________
From: eLink Entry: Vignette Collaboration Developers Forum [vignettecollaborationdevelopersforum@elinkkc.opentext.com]
Sent: Tuesday, November 25, 2014 5:20 PM
To: eLink Recipient
Subject: Unable to start Collab, Getting "Error reading connection expiration time property from JVM"

Unable to start Collab, Getting "Error reading connection expiration time property from JVM"<https://knowledge.opentext.com/knowledge/cs.dll/open/56173658> Posted by jayaram.ponnusamy@mannai.com.qa<mailto:jayaram.ponnusamy@mannai.com.qa> (Ponnusamy, Jayaram) On 11/25/2014 06:48 AM

Hi All,

Collab was worked fine till yesterday and has stopped working from morning. While Starting I seen the below Errors in the CollabConsole.txt

[Nov 25, 2014 3:21:35 PM (main)]: Error reading connection expiration time property from JVM

Also I could see below Errors as well in the Old Logs.

[Nov 25, 2014 3:21:56 PM (main)]: ORM inner error was:
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.establishConnection(JDBCConnectionPool.java:341)
at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getFreeConnection(JDBCConnectionPool.java:253)
at com.intraspect.objrel.db.jdbc.JDBCConnectionPool.getReadOnlyConnection(JDBCConnectionPool.java:87)
at com.intraspect.objrel.db.jdbc.JDBCDatabase.initAdaptor(JDBCDatabase.java:192)
at com.intraspect.objrel.db.jdbc.JDBCDatabase.<init>(JDBCDatabase.java:184)
at com.intraspect.objrel.db.relational.oracle.OracleDatabase.<init>(OracleDatabase.java:39)

However, I have restarted DataBase but still getting the

"Error reading connection expiration time property from JVM"

Thanks

Jay

________________________________
[To post a comment, use the normal reply function]
Forum: Vignette Collaboration Developers Forum<https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=17430698&objAction=view>
Content Server: Knowledge Center<https://knowledge.opentext.com/knowledge/cs.dll>

[To post a comment, use the normal reply function]
Topic:	Unable to start Collab, Getting "Error reading connection expiration time property from JVM"
Forum:	Vignette Collaboration Developers Forum
Content Server:	Knowledge Center