Bug 780422 (SOA-2853)

Summary: ModeShape - CTC is getting different query results for modeshape across different os environments on Hudson
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Warren Gibson <wgibson>
Component: EDSAssignee: Warren Gibson <wgibson>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER8CC: vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2853
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Windows Server
Last Closed: 2011-04-01 13:42:18 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
ModeShape_Win2k3_diff.ods
none
test-files.zip
none
create_procedure_statements.ddl
none
oracle_test_statements.ddl
none
test-integration-db-7.1.1.jar none

Description Warren Gibson 2011-01-28 19:21:48 UTC 
project_key: SOA

CTC is seeing different query results for ModeShape queries across different os enviornments.  The differences involve zip file and ddl.

See the attached spreadsheet.  The left column shows the actual query results and the left column shows the expected results.
 
I am also attaching the zip file and ddl files.
Comment 1 Warren Gibson 2011-01-28 19:28:55 UTC 
Attachment: Added: ModeShape_Win2k3_diff.ods
Attachment: Added: test-files.zip
Comment 2 Warren Gibson 2011-01-28 23:38:28 UTC 
Attachment: Added: create_procedure_statements.ddl
Attachment: Added: oracle_test_statements.ddl
Comment 3 Van Halbert 2011-01-30 16:48:04 UTC 
Patch for ctc framework
Comment 4 Van Halbert 2011-01-30 16:48:04 UTC 
Attachment: Added: test-integration-db-7.1.1.jar
Comment 5 Van Halbert 2011-01-30 16:55:18 UTC 
Attached is a patch for the ctc framework, this contains the previous patch that wasn't committed to svn (traversing the exception to get the inner most exception) and I found an issue with handling of blobs.

With the patch, I was able to take a new server, publish the oracle .ddl file, then execute ctc to create new expected results.   Then re-publish the .ddl file over and over and re-run the ctc test ( after each publish) to compare results, and saw no difference in the results.
Comment 6 Len DiMaggio 2011-04-01 13:32:05 UTC 
Please recheck this - was this a test issue? Can it be closed?  Thx.
Comment 7 Warren Gibson 2011-04-01 13:42:18 UTC 
Release Notes Text: Added: Retested prior to SOAP 51 release.