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
z/OS
OPS/MVS release 12.3 and above Using SSMv3
Something went wrong during the LOAD process because the STCTBL or POLICY table is missing a column..
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.
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