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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.00-RC3
    • 1.6.00
    • CRC Cell, Install
    • None
    • 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

            mem61 Mike Mendis
            sully93@uw.edu Daniel Sullivan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: