Get msg UPDATE OF RESOURCE RRS FAILED: SQLCODE = -7406 on policy LOAD
search cancel

Get msg UPDATE OF RESOURCE RRS FAILED: SQLCODE = -7406 on policy LOAD

book

Article ID: 8475

calendar_today

Updated On:

Products

OPS/MVS Event Management & Automation

Issue/Introduction

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

OPS/MVS release 12.3 and above Using SSMv3

Cause

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

Resolution

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

If the above is correct, and no errors were displayed in that process, then 

 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.

In the case mentioned above, 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