SAP Knowledge Base Article - Preview

3215897 - ASE upgrade via saphostctrl failed Number 10330, SELECT permission denied on object DDDDLSRC, database SID, owner SAPSR3.

Symptom

  • Error: Command execution failed. : Server message: Number 10330, Severity 14, State 1, Line 1, Server FIP --- Message string: DELETE permission denied on object _##DDLSRC, database saptempdb, owner dbo . (fault code: 127) ASE upgrade via saphostctrl failed:

    /usr/sap/hostctrl/exe # ./saphostctrl -user sapadm  -function LiveDatabaseUpdate -dbname SID -dbtype syb -updatemethod Execute -updateoption TASK=UPDATE_ASE -updateoption DROP_LOCATION="/soft/ase16sp04pl02" -updateoption UPDATE_FORCE=1
  • Error: Command execution failed. : Server message: Number 10330, Severity 14, State 1, Line 1, Server PIQ --- Message string: SELECT permission denied on object DDDDLSRC, database PIQ, owner SAPSR3 . (fault code: 127)

  • All ASE configuration parameter settings are normal;


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 for Business Suite
  • SAP Host Agent 721 PL51
  • Linux

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

DDDDLSRC, 10330, SELECT permission denied , 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.