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
Something went wrong during the LOAD process because STCTBL or POLICY table is missing a column..
z/OS any supported releaseCA OPS/MVS release 12.3 and above Using SSMv3
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.
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
A column name that does not exist in the specified table appeared
in an SQL statement. The column name may be misspelled.
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