2396177 - CDS view activation errors 102, 208, 11021, 2812 - SAP ASE for Business Suite

• On SAP ASE 160 SP02 systems , CDS views cannot be activated during/after SUM, SPAM
• For ASE 160 SP03 PL0x systems, see SAP KBA 2195659
  
  
• Errors related to CDS view activation arise during --
  
  SPAM  (phase:IMPORT_PROPER)
  SUM (phase: PREP_GENCHECKS/SYB_CHECKS_ASE_16UPGRADE or PREP_GENCHECKS/SYB_CHECKS_ASE_1603UPGRADE)
  SUM (execution of report RUTDDLSCREATE)
  
  
• Errors -
   
  3 ETP000 >>>>>>>>> DIPGNTAB END_ISUROWS <<<<<<<<<
  2WETP000 13:58:54: Retcode 1: error in DDL statement for "ESJICUSTQUERY " - repeat2EETP345 13:59:06: Retcode 1: SQL-error "102-[ASE Error SQL102:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near '('.
  2EETP345 " in DDL statement for "ESJICUSTQUERY "
  
  Error 208-[ASE Error SQL208:42000][SAP][ASE ODBC Driver] when executing ADD-FIELD of
  Error in DDL statement for when executing ADD-FIELD of DB-ROLLBACK()
  No DDL commands found for activation of ESJIEMPLOYEE
  
  [ASE Error SQL11021][SAP][ASE ODBC Driver][Adaptive Server Enterprise] Function V_RACK_AGGR invoked with wrong number or type of argument(s).
  
  [ASE Error SQL2812][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Stored procedure 'GOIJ05_RDOCS_27818684' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

   
  **********************************************************
  CURRENT PHASE: RUN_RUTDDLSCREATE

  1PEPU203X--> Messages extracted from log file "RUTDDLSCREATE.DHS" <--
  A3PEDDU 705 "DDL Source" "CDS_FCTYPE" could not be activated":"
  A3PEDDU 705 "DDL Source" "CDS_OIJNE" could not be activated":"
  A3PEDDU 705 "DDL Source" "CDS_OIJNE_SIM" could not be activated":"
  A3PEDDU 705 "DDL Source" "OIJ05_BOOK_INV" could not be activated":"
  ***********************************************************

• None of the SAP KBAs and Notes from the BC-DWB-DIC-AC component which reference missing and inactive CDS views, are applicable in this case. 
  
  

• SAP Adaptive Server Enterprise (ASE) 16.0 SP02 for Business Suite
• SAP NetWeaver 7.4, 7.5
• SAP ERP 6.0 EHP8 (6.08)
• SL Toolset - latest SP

SQL2812, IMPORT_PROPER, SPAM, GTT, RUTDDLSCREATE, function, CDS, views, SUM, EHP8, upgrade, SQL11021, SQL102, SQL2812, 799417, CR 799417, 804868, CR 804868, CR 799523, 102, 208, SQL208, PREP_GENCHECKS/SYB_CHECKS_ASE_16UPGRADE, PREP_GENCHECKS/SYB_CHECKS_ASE_1603UPGRADE , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem