Unable to open Inbound/outbound Collaboration

Unable to Open Inbound/Outbound Collaboration


Scenario:

While in the EBI Studio, we tried to open inbound and outbound and error occurred.



Issue:

During the opening of the collaboration, a dialog window appeared indicating an administrative error occurred.

EXTOL Business Integrator Auditor Error :: Server.log

2016-03-28 15:06:07,397 ERROR [STDERR] java.sql.SQLException: You cannot invoke other java.sql.Clob/java.sql.Blob methods after calling the free() method or after the Blob/Clob's transaction has been committed or rolled back.
2016-03-28 15:06:07,412 ERROR [STDERR] at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
2016-03-28 15:06:07,412 ERROR [STDERR] at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
2016-03-28 15:06:07,412 ERROR [STDERR] at org.apache.derby.client.am.Blob.length(Unknown Source)
2016-03-28 15:06:07,412 ERROR [STDERR] at org.apache.derby.client.am.Cursor.getBytes(Unknown Source)
2016-03-28 15:06:07,412 ERROR [STDERR] at org.apache.derby.client.am.ResultSet.getBytes(Unknown Source)
2016-03-28 15:06:07,412 ERROR [STDERR] at com.extol.util.jdbc.JDBCUtilities.getObject(JDBCUtilities.java:68)
2016-03-28 15:06:07,412 ERROR [STDERR] at com.extol.collaboration.datamanagement.cp.LocalCollaborationStorage.b(LocalCollaborationStorage.java:549)



Resolution:

According to EXTOL support, 1 of the 2 issues might be occurring
1. Clients are left open and at some point something could have interrupted the service causing the client to become desynched and the only way to fix that is to shut down the client and server and restart them.
2. When someone performs a search on the collaboration profiles as the collaboration profiles are being used to fill in the collaboration parameters. Either of these could be the issue and both can be hard to reproduce.

In either case, I have personally had to restart the EXTOL Service to restore Collaboration access.



By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.