INVALID QUALIFIER SUPPLIED

I'm using Serena Changeman version 7.1.3. I created a package and checked out a COBOL-DB2 program. Post compilation of the components, I'm trying to promote the package from STAGING to DEVT area. During this promotion, BIND occurs and fails with the error

*** REJECTED BY USER EXIT

*** INVALID BIND PARAMETERS: INVALID QUALIFIER SUPPLIED

The Qualifier I used in the BIND command is a valid schema in the DB2 Subsystem. Still this error comes up.

I removed the QUALIFIER parameter from the BIND and tried to promote the changeman package to DEVT. But again the BIND fails with SQLSTATE=42704; SQLCODE=-204, because it is trying to use OWNER=CMNS as the schema for the DB2 table used in the program, which DB2 is rejecting.

The initial failure (Error: INVALID QUALIFIER) is in the step CMNDB2PL. From the Changeman documentation, I could understand that CMNDB2PL calls the USEREXIT program CMNEX101 and sends in the BIND parameters. It seems CMNEX101 is rejecting the QUALIFIER (as per the error: REJECTED BY USER EXIT). But why the USEREXIT program is rejecting a valid QUALIFIER is what I don't understand.

Could someone please help to understand from changeman perspective how to solve this INVALID QUALIFIER error and get the BIND successful during the package promotion to DEVT.

Also, is there any way to bypass the BIND during the changeman package promotion to DEVT. If the BIND error can be ignored or bypassed, we could try the BIND manually, after the changeman package gets promoted to DEVT.

Tags: