3639955 - SQL syntax error in phase SQLRUNTASK_RRC_TRIGGERS during SUM upgrade - SAP ASE with BS

• Error encountered during the phase "MAIN_SHDRUN/SUBMOD_RRC_TRIGGER_DEFAULT/SQLRUNTASK_RRC_TRIGGERS" in the Software Update Manager (SUM) process.
• Error message: "Incorrect syntax near the keyword "WHILE"".
• Database error code: "DB code 156" and ASE error code: "ASE Error SQL156" from log file: "SQLRUN_RRC-TRIGGERS.DFD". Please check the example below.
• In the error message appears some missing "WHERE" clause of the SQL statement.

On SQLRUNTASK.log:
3 ETQ399 Log Scanner: Start scanning log file 'log/SQLRUN_RRC-TRIGGERS.DFD'
3WETQ399 Log Scanner: Finished scanning log file 'log/SQLRUN_RRC-TRIGGERS.DFD' (from offset 0 until 11767)
1EETQ399 Log Scanner: Found 1 failures during the log scan (exit code: 20)!
1EETQ399 Log Scanner: Found 3 errors during the log scan (exit code: 20)!
2EETQ109 Found 1 errors in logs.
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20250720151709
2 ETQ102 Finished execution of 1 process(es).
3 ETQ127 Interval: 20250720151706-20250720151709, time     3.0/    0.0/    0.0/0MB real/usr/sys/maxmem
2 ETQ108 Analyzing logs for errors.
3 ETQ114 Analyzed 1 log files.
2EETQ106 1 processes failed.
1EETQ399 Last generated error message is: 1 error during parallel execution of processes
1EETQ399XCheck summary log 'SQLRUNTASK_RRC-TRIGGERS.ELG' for details!
1EETQ204 Upgrade phase "SQLRUNTASK_RRC_TRIGGERS" terminated with severe errors ("20250720151709").

On SQLRUN_RCC-TRIGGERS.DFD, the error message appear right after the table with missing index/ inconsistency on database side:
3 ETQ398XSQL:     INSERT INTO [UPGTRTOUCH] VALUES( '<tableName>' )
3 ETQ398XSQL:   END
3 ETQ398XSQL: END
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20250720151707
4 ETQ399 Rollback.
1EETQ008 Error message: dbrc = 99: 'all DB errors, except for ...'
1EETQ009XDB code 156
1EETQ009X[ASE Error SQL156]Incorrect syntax near the keyword 'WHILE'.
1EETQ003 exit code: "20"

SAP Adaptive Server Enterprise with Business Suite

syntax error,  sqlruntask_rrc_triggers, main_shdrun, submod_rrc_trigger_default, db code 156, ase error sql156, missing indexes, database consistency check, sap ecc upgrade, software update manager, sum phase error, sql syntax error, trigger templates, abap function failure, WHILE , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem