Skip to main content

Software  >  Workplace  >  

Error: '...Subquery returned more than 1 value...' occurs when running Course Progress by User report
 Technote (troubleshooting)
 
 
Problem
You are using IBM® Workplace™ Collaborative Learning version 2.7.0.2 with Microsoft SQL 2000 Server as the backend database. When you attempt to run the Course Progress by User report, you receive a "Workplace Collaborative Learning Application Error".
 
Symptom
If Reporter debugging is enabled, a similar message to the one below is recorded in the JReporter.log:

===Java Exception
The Java VM version : 1.4.2
JReport Server Engine version : 5.0.4; Build Number : 579.6; Help Version : 579.
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    at
com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown Source)
    at
com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown Source)
    at
com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
    at
com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
...
    Error recorded in SystemOut.log:

    [datetime] 000000bc JReportWrappe E   CLQAH2011E: JReport error while running the report.
    [datetime] 000000bc JReportWrappe E   CLQAH2000E: Error! details java.lang.Exception: Error!
      at
    com.ibm.workplace.elearn.reporter.JReportWrapper.executeReport(JReportWrapper.java:331)
      at
    com.ibm.workplace.elearn.reporter.JReportWrapper.runReport(JReportWrapper.java:1316)
    ...

    [datetime] 0000009a taglib  E   CLQAH2231E: An exception occurred in the application
     
    Cause
    The subquery that causes this problem is missing a condition.
     
    Resolving the problem
    This issue was reported to Quality Engineering as SPR# MNGN7TQLS6 and was resolved in the 2.7.0.3 fix pack and later releases.
    Customers are encouraged to upgrade Workplace Collaborative Learning to take advantage of the fixes and enhancements included in the latest fixpack.

    Fix Central provides fixes and updates for your system's software, hardware, and operating system. Refer to the following link: http://www-933.ibm.com/eserver/support/fixes/fixcentral
     
    Related information
    Fix Central
     
     
    		 

    Copyright and trademark information
    IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
    Rate this page
    Please take a moment to complete this form to help us better serve you.
    This material provides me with the information I need.




    This material is clear and easy to understand.




    Did the information help you to achieve your goal?
    What updates, improvements, or related information would you like to see in this document?
    Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
    Input the verification number to submit feedback:
    Document information
     Product categories:
     Software
     Organizational Productivity, Portals & Collaboration
     Learning Software
     Workplace Collaborative Learning
     SQL Server
     Operating system(s):
      AIX, Linux, Solaris, Windows, i5/OS
     Software version:
      2.7.0.2
     Reference #:
      1393583
     IBM Group:
     Software Group
     Modified date:
     2009-07-13

    Translate My Page
     
     

    Rate this page

    Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.