DB002040 C-4M6003: Type mismatch Table:SYSCA.GET_DIAGNOSTICS

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

After running the CONVERT CATALOG for release 19.0, attempt to run the VIEW19U and receive this:
ALTER PROCEDURE SYSCA.GET_DIAGNOSTICS
ADD (IDMS_ROWID_INSERT BINARY(8)) ;
Status = -4 SQLSTATE = 42000 Messages follow:
DB002040 C-4M6003: Type mismatch Table:SYSCA.GET_DIAGNOSTICS
 
What is causing this error?
 

Environment

Release: IDADSO00200-19.0-ADS-for CA-IDMS
Component:

Resolution

This error can occur if you have never run VIEW17U that adds the procedure SYSCA.GET_DIAGNOSTICS to the catalog. This job should be in your CAGJSAMP. You will need to run the VIEW17U first, then the VIEW19U.