Created On:  08 February 2011

Problem:

When running the following standard clipper query...

FIND DATAPORT

         such that PORTTYPE like "CALL*"

and

        such that PORTNAME IN ("UMFSEND","UMFMAPIN")


an ORA-01427 error is produced with following details...

SELECT “ObjType”, “Name”, Count(*) FROM hcSource

GROUP BY “ObjType”, “Name”  HAVING Count(*) > 1

The error messge displayed is "ORA-01427 Single-row subquery returns more than one row "

 
What can cause this and how can it be overcome?

Resolution:

The cause of this is a corruption in the workspace repository. To overcome the problem: 

1.      Run the following query against the workspace repository.

SELECT “ObjType”, “Name”, Count(*) FROM hcSource

GROUP BY “ObjType”, “Name”  HAVING Count(*) > 1

2.      This will identify any corrupted items (sources) in the repository.

3.      Delete the sources identified by the query, from the workspace from within Modernization Workbench.

4.      Re-Add the sources delete in step 3 to the workspace and re-verify.
Incident #2484739