SAP Knowledge Base Article - Preview

2680853 - TUDF recreate fails during ASE upgrade - SAP ASE for Business Suite

Symptom

SAP ASE upgrade to ASE 16 SP03 PL04 from ASE 160 SP02 PL0X on SAP systems fails with below error message.

The upgrade is done via saphostctrl (per SAP Note 1982469)

Info: saphostcontrol: Executing LiveDatabaseUpdate
Error: sapdbctrl: recreating CDS objects failed.
Error: sapdbctrl: Recreate for tudf V_SO_OUTPUT_QCI (262675627) failed.
Error: sapdbctrl: Recreate for tudf V_PO_FINAL_OUT (550676653) failed.
Error: sapdbctrl: Recreate for tudf V_PROD_PP (986154202) failed.
Error: sapdbctrl: Recreate for tudf V_OIJ05_PLNNOM (1629632492) failed.
Error: sapdbctrl: Recreate for tudf V_OIJ05_IPD_INV (1357631523) failed.
Error: sapdbctrl: Recreate for tudf V_IPD_PHY_INV (829629642) failed.
Error: sapdbctrl: Recreate for tudf V_CLASSIFY_TKT (2077634088) failed.
Error: sapdbctrl: Recreate for tudf V_SC_QCI_OUT (381628046) failed.
Error: sapdbctrl: Recreate for tudf V_RACK_RESULTS (1665108616) failed.
Error: sapdbctrl: Recreate for tudf V_
Error: saphostcontrol: LiveDatabaseUpdate failed (sapdbctrl exit code = 1)

Manual creation of the offendings TUDFs (Table User-defined functions) via SE14 fails with the following rror:

Msg 267, Level 16, State 5:
Server 'N01', Procedure 'V_SO_OUTPUT_QCI', Line 15:
Object '##GOIJ05_SO_OUT_QC' cannot be found.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 for Business Suite

Product

SAP ERP 6.0

Keywords

saphostctrl, upgrade, tudf, recreate, 267, 208, "not found", GTT , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.