SAP Knowledge Base Article - Preview

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

Symptom

  • 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. 


Read more...

Environment

  • 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

Product

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.