[CORE-47] 1.6 RC3 Issue: Following successful install, i2b2 will not return query results Created: 12/Apr/11 Updated: 05/Jun/14 Resolved: 27/Oct/11 |
|
Status: | Closed |
Project: | i2b2 Core Software |
Component/s: | CRC Cell, Install |
Affects Version/s: | 1.6.00-RC3 |
Fix Version/s: | 1.6.00 |
Type: | Bug | Priority: | Major |
Reporter: | Daniel Sullivan | Assignee: | Mike Mendis |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Linux / RHE - App Server windows 2008 - DB Server Database MSSQL |
Rank: | 0|i0010n: |
Participant/s: |
Description |
Tested the install by trying to run a query and got no results. Checked the JBoss log and found that it was failing on not being able to locate a stored procedure. See text below: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'i2b2demodata.UPDATE_QUERYINSTANCE_MESSAGE'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) I searched the folder which contains ALL the scripts and could not find any sql script which would create this stored procedure. This is a blocking bug, so I am hopeful I can get a response back on this ASAP. |
Comments |
Comment by Daniel Sullivan [ 19/Apr/11 ] |
The version of the RC was missing stored procedures, after getting a different version this was fixed. |
Comment by Mike Mendis [ 27/Oct/11 ] |
All stored procedures where varied in the final. |