Details
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.
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.