CSMRPSQL fails with SQLCODE -14

Products

• DATACOM - AD
• Mainframe Software Manager (Chorus Software Manager)

Issue/Introduction

The process documented in article 197545 in an effort to load a Chorus Software Manager SMP CSI into z/OSMF fails with Datacom SQLCODE -14  

___________SQL ERROR SUMMARY START___________                     
                                                                   
 SQLCODE = -14, SQLSTATE=42704                                     
 MESSAGE = TABLE/VIEW DOES NOT EXIST: CSIDATA AUTHID: CASWMGT      
 ____________SQL ERROR SUMMARY END____________            

 

Environment

Release : 15.1 - 15.0 - 14.0

Component : Datacom/AD

Cause

Wrong CUSLIB used when running DBSQLPR.

Resolution

Check the CUSLIB in the MSMMUF STEPLIB and use the same CUSLIB in the DBSQLPR job.