Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-47

1.6 RC3 Issue: Following successful install, i2b2 will not return query results

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6.00-RC3
    • Fix Version/s: 1.6.00
    • Component/s: CRC Cell, Install
    • Labels:
      None
    • Environment:
      Linux / RHE - App Server
      windows 2008 - DB Server
      Database MSSQL
    • Rank:
      0|i0010n:

      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.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code