Bug 780420 (SOA-2851)

Summary: Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Paul Nittel <pnittel>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER8   
Target Milestone: ---   
Target Release: 5.1.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2851
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-08 16:39:56 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
DeadSession.log none

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.