CMS Snapshot Analysis - Compute Snapshot - Fatal Error - Error while executing procedure - exact fetch returns more than requested number of rows

 This page will help you find a solution, if your snapshot is failing and the below mentioned error is found in the Cast-MSx.log.txt file.

ORA-01422: exact fetch returns more than requested number of rows
                             ORA-06512: at "L820_8913_DTI.DSS_APP_FIND_PARENT_CLASS", line 25
                             ORA-06512: at "L820_8913_DTI.DSSAPP_FILL_METHOD_M_LINKS", line 17
                             ORA-06512: at "L820_8913_DTI.DSSAPP_SCOPE_INIT_CLASSES", line 125
                             ORA-06512: at line 1

Take snapshot of an application sharing an object with another application

Snapshot fails

1. This error is encountered when some object belongs to several applications : only one row is expected, but if the object is shared between several applications, the query will return several rows.The issue will be fixed in Service Pack 8.2.5

   Apply the attached script, which will update procedure DSS_APP_FIND_PARENT_CLASS (add a DISTINCT clause to the SELECT query, and re-take snapshot.

2. Check if your application has object of type "JV_GENERIC_INTERFACE" by executing the below query on the Knowledge Base -

   select count(idkey)
   from keys
   where objtyp = 990

    

   1. If the query returns a value greater than 0 then there are objects of type JV_GENERIC_INTERFACE in your analysis results which are not handled in the procedure, this bug will be fixed in a future version of Cast AIP, apply the below workaround -
      
      1. Install the stored procedure FIX_DSS_APP_FIND_PARENT_CLASS.sql on Knowledge Base
      2. Rerun the snapshot by skipping analysis
   2. If the query returns 0 then contact  Cast Technical Support and provide them with Relevant Input
      

Ticket # 8913 , 11566