3596245 - Cancellation of UMG_PMIG_MASTER_JOB due to DBSQL_ARGUMENT_ERROR

• During the Unicode Conversion preparation phase, the job SPUMG UMG_PMIG_MASTER_JOB is getting cancelled periodically.
• The SPUMG consistency check has been completed successfully, but the periodic jobs for the master job and worker job are getting cancelled.
• The job name is UMG_PMIG_MASTER_JOB and the error is DBSQL_ARGUMENT_ERROR.
• The dump DBSQL_ARGUMENT_ERROR contains the following details:

|Error analysis                                                                                    
|    An exception has occurred which is explained in more detail below. The                        
|    exception, which is assigned to class 'CX_SY_OPEN_SQL_DB' was not caught and                  
|    therefore caused a runtime error. The reason for the exception is:                            
|    No description available                                                                      
|                                                                                                  
|    Parameter:                                                                                    
|    P1 UMGPMIG                                                                                    
|    P2 SQL code: 0                                                                                
|    P3 SQL message:                                                                               
|    P4 SQL dbsl rc: 2                                                                             
|    P5                                                                                            
|    P6                                                                                            
|    P7                                                                                            
|    P8                                                                                            
|    P9 " "                                                                                        

• The log dev_w* of the work process contains the error:

C  MSSQL: Too many parameters: 20002. Cannot handle more than 10000 parameters.
B  ***LOG BYK=> current SQL statement exceeds a database limit [dbdbslst     5199]
B  dumping DbDbslStatement ...

Read more...

• SAP systems based on SAP NetWeaver
• non-Unicode
• MSSQL database
• Unicode conversion preparation 

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

SPUMG, UMG_PMIG_MASTER_JOB, DBSQL_ARGUMENT_ERROR, Unicode Conversion, SQL statement, worker jobs, tables selection parameter, cannot handle more than 10000 parameters, too many parameters, MSSQL, current SQL statement exceeds a database limit , KBA , BC-I18-UNI , Unicode , Problem