[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:

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.

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.

Generated at Fri Aug 19 15:00:39 UTC 2022 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.