Bug 780420 (SOA-2851) - Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server
Summary: Teiid Web Services: After redeploying VDB, Web services gets "Specified sessi...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2851
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER8
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.0 GA
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-28 17:19 UTC by Paul Nittel
Modified: 2011-02-08 16:39 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-08 16:39:56 UTC
Type: Bug

Attachments (Terms of Use)
DeadSession.log (28.57 KB, text/plain)
2011-01-28 17:20 UTC, Paul Nittel 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2851 0 None None None Never
Red Hat Issue Tracker TEIID-1454 0 None None None Never

Description Paul Nittel 2011-01-28 17:19:47 UTC 
Workaround: Workaround Exists
Workaround Description: The datasource needed a test query to purge old connections.   And by adding test query (select 1) to the VDB data source fixes the issue.

project_key: SOA

I had deployed a VDB and WAR, but there was an error in the transformation, so executing a web service query failed. After correcting the transformation and re-deploying the VDB, the Web service got an error. Checking the server log showed the session was invalid.

Ted and I believe this should have recovered without the exception.

I'll attach the applicable section from the server log.
Comment 1 Paul Nittel 2011-01-28 17:20:19 UTC 
Excerpt from the server log
Comment 2 Paul Nittel 2011-01-28 17:20:19 UTC 
Attachment: Added: DeadSession.log
Comment 3 Van Halbert 2011-01-28 19:27:25 UTC 
Link: Added: This issue Cloned to SOA-2854
Comment 4 Van Halbert 2011-02-02 17:28:16 UTC 
Workaround Description: Added: The datasource needed a test query to purge old connections.   And by adding test query (select 1) to the VDB data source fixes the issue.

Workaround: Added: [Workaround Exists]
Comment 5 Van Halbert 2011-02-02 17:29:07 UTC 
There is a configuration step that needs to done.  This is noted in the workaround.
Comment 6 Paul Nittel 2011-02-08 16:39:56 UTC 
Tested with ER9 and closed.
Note You need to log in before you can comment on or make changes to this bug.