SAP Knowledge Base Article - Preview

3260493 - ASE Error SQL208 object not found error during SUM using DMO option - SAP ASE

Symptom

  • Migrating/upgrading SolMan 7.1 system to SolMan 7.2 using the DMO option of SUM
  • SAPup.log shows below errors:
    ------------------------------------
    CURRENTPHASE MAIN_SWITCH/XCNV_DEL
    ...started at timestamp
    # Using phase log file 'XCNVDELE.LOG'.
    ...finished at timestamp with status ABORTED.
    # Error message set: 'Process /work/sw/ibm_mig/SID/SUM/abap/bin_749/SAPuptool exited with 20, see '/work/sw/ibm_mig/SID/SUM/abap/log/SQLSTMTSTD.OUT' for details'
    ...begin dialog at timestamp
    ...end dialog at timestamp
    ...answered at timestamp .
    -> decided to try again.
    ------------------------------------
  • SQLSTMTSTD.OUT shows below errors:
    ------------------------------------
    EXECUTING /work/sw/ibm_mig/SID/SUM/abap/bin_749/SAPuptool execdb ../var/XCNVDEL.XQL
    Logging to '/work/sw/ibm_mig/SID/SUM/abap/log/XCNVDEL.LOG'
    1EETQ008 Error message: DBSL error 103 (db code 208): 
    1EETQ008 [ASE Error SQL208:42000]ATAB not found. Specify
    1EETQ009X owner.objectname or use sp_help to check whether the object exists (sp_help
    1EETQ009X may produce lots of output).
    1EETQ003 exit code: "20"
    SAPup> Process with PID 26490 terminated with status 20 at timestamp !
    SAPup> Starting subprocess with PID xxx in phase 'XCNV_DEL' at timestamp
        ENV: DIR_LIBRARY=/work/sw/ibm_mig/SID/SUM/abap/bin_749
        ENV: JAVA_HOME=/usr/sap/SID/DVEBMGS30/exe/sapjvm_4
      *GENV: LD_LIBRARY_PATH=/work/sw/ibm_mig/SID/SUM/abap/bin_749:/usr/sap/SID/SYS/global/syb/linuxx86_64/sybodbc:/usr/sap/SID/SYS/exe/run:/usr/sap/SID /SYS/exe/uc/linuxx86_64:/oracle/client/11x_64/instantclient
        ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
        ENV: ORACLE_SID=SID
      *GENV: PATH=/work/sw/ibm_mig/SID/SUM/abap/bin_749:/usr/sap/SID/SYS/global/syb/linuxx86_64/sybodbc:/usr/sbin:/usr/bin/X11:/usr/local/bin:/usr/sap/SID/DVEBMGS30/exe/sapjvm_4/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/sap/SID/SYS/exe/uc/linuxx86_64:/usr/sap/SID/SYS/exe/run:/home/esdadm:.:/usr/sap/hostctrl/exe
      *GENV: RSEC_SSFS_DATAPATH=/usr/sap/SID/SYS/global/security/rsecssfs/data
      *GENV: RSEC_SSFS_KEYPATH=/usr/sap/SID/SYS/global/security/rsecssfs/key
        ENV: SAPDATA_HOME=/oracle/SID
        ENV: SAPSYSTEMNAME=SID
      *GENV: dbms_type=SYB
        ENV: dbs_ora_schema=SAPSR3
        ENV: dbs_ora_tnsname=SID
      *GENV: dbs_syb_dbname=SID
      *GENV: dbs_syb_port=4901
     *DBENV: dbs_syb_schema=SAPSR3
      *GENV: dbs_syb_server=HOSTNAME
      *GENV: rsdb_ssfs_connect=1
     *DBENV: (auth_shadow_upgrade)
        PWD: /work/sw/ibm_mig/SID/SUM/abap/tmp
    ------------------------------------
  • A manual check on the affected object in ASE DB, it does exist, but its shadow is with owner SAPSR3:
    ------------------------------------
    select name, loginame from sysobjects where name like '%ATAB%'
    go
    name   loginame
    ATAB  SAPSR3
    ATAB~  SAPSR3
    ------------------------------------


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP04

Keywords

SQL208, SAPSR3SHD, SAPSR3, sa_role, sapsso, granular permission, ownership , 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 for Me (Login required).

Search for additional results

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