Created On: 13 April 2012
Problem:
User receives error message when attempting to perform any query into the database of a Modernization Workbench. Some actions are Clipper query or Apply Filter from Change Analyzer. Error message is:
Run-Time error IBM CLI DRIVER DB2 SQL The result of a sclaer fullselect, SELECT INFO statement, or VALUES INTO statement is more than one row: SQLSTATE 21000
Run-Time error IBM CLI DRIVER DB2 SQL The result of a sclaer fullselect, SELECT INFO statement, or VALUES INTO statement is more than one row: SQLSTATE 21000
Resolution:
Message is related to duplicate rows in the SQL database. Running "Cleanup HCSources Table" from the Modernization Workbench Administration window will resolve the issue.
Incident #2558856
Old KB# 35811
#SupportTip
#EnterpriseAnalyzer