Cannot check out or promote CA 2E implementation object custom-function-name code RPGSQLI

Products

• CA 2E

Issue/Introduction

We failed to promote with this in the joblog

 

Message ID . . . . . . :   VIM4501       Severity . . . . . . . :   30        
Message type . . . . . :   Diagnostic                                         
Date sent  . . . . . . :   08/27/25      Time sent  . . . . . . :   10:58:11  

Message . . . . :   Cannot check out or promote CA 2E implementation object   
  custom-function-name code RPGSQLI.                                                      
Cause . . . . . :   Cannot check out or promote implementation object when the
  development environment is flagged as "Dependent" and the object type is    
  EXCUSRSRC or EXCUSRPGM.                                                     
Recovery  . . . :   The associated model object can be checked out from within
  CA 2E. The model object and its implementation objects can then be promoted 
  through the Create Request option.

 

The custom-function-name function does have SQL program/SQLRPGLE outside of 2E. We have CA 2E 8.7.

Environment

CA 2E 8.7/8.7.1/8.7.2/8.7.3

Resolution

Please follow these steps

1) Take a backup of SQLRPGLE source outside of 2E.
2) Check out the EEF RTV Order for some model object list and also generate the function by option G.
3) Step 2) overrides the source. So again, copy the source from the backup.
4) Now promote again.

Additional Information

This issue is addressed by one of the enhancements in 8.7.4

Allow SQL Type EXCUSRSRCs and EXCUSRPGMs

Therefore it is a good idea to consider upgrading to 8.7.4 and once upgrade is done, then you won't need to perform any steps outlined in the Resolution.

Steps to upgrade to 8.7.4:

Installing CA 2E 8.7.4