During LOAD of policy in CA OPS/MVS getting a SQLCODE -7406

Document ID : KB000008475
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Using SSMv3, the Policy Manager in CA OPS/MVS (OPSView option 4.11.P) can LOAD resource. 
Previous to the LOAD you do the VERIFY of the resource and this was successful.
However during the LOAD you get the message : 

    LOAD: UPDATE OF RESOURCE RRS FAILED: SQLCODE = -7406 

What does it mean. The SQLCODE is not documented in the manuals

Environment:
z/OS any supported releaseCA OPS/MVS release 12.3 and above Using SSMv3
Cause:

Something went wrong during the LOAD process because STCTBL or POLICY table is missing a column.. 

Resolution:

First check if the conversion utility OPSSM3CV did run without errors and the SSMVERSION is set to 3. This utility will create the additional columns needed to run SSM version 3.

If that all is done and no errors were displayed in that process, there is this last option :

 Delete the STCTBL and POLICY table and created them again. 

Additional Information:

To check the SQLCODE description, check for the OPSnnnnE messages, where nnnn is the SQLCODE.

Like in this case the SQLCODE -7406, check the message OPS7406E in the manuals :

OPS7406E OPERATION FAILED. COLUMN rdfcol IS NOT DEFINED IN TABLE rdftbl 
  Modifiable: Yes 

Explanation: 
  A column name that does not exist in the specified table appeared 
  in an SQL statement. The column name may be misspelled. 
Action: 
  Correct the column name and reissue the command. 

The variable fields of the message text are: 
  rdftbl The RDF table name 
  rdfcol The RDF column name