SAP Knowledge Base Article - Preview

2736731 - SQL0478N on SAPTOOLS.DB2_WORKLOAD_CHECK encountered during System Copy

Symptom

During system copy where there is a change in <SID>, you encounter the SQL0478N error during the step changeRoleSapmonBR. You will see the error in the following logs:

  • sapinst.log & sapinst_dev.log

WARNING 2019-01-02 11:52:20.456
 CJSlibModule::writeWarning_impl()
Execution of the command "db2 -td; -vf revoke_SAPAPP_from_old_connect_user.sql -r revoke_SAPAPP_from_old_connect_user.res -z revoke_SAPAPP_from_old_connect_user.out" finished wit 4. Output:
UPDATE COMMAND OPTIONS USING S OFF
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING A OFF
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING X ON
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING O OFF

ERROR 2019-01-02 11:52:20.468 [CInstallerCallBackImpl.cpp:229]
MDB-01999 Error occured, first error is: <SQL0478N DROP, ALTER, TRANSFER OWNERSHIP, REVOKE, or CREATE OR REPLACE on >

ERROR 2019-01-02 11:52:20.469
 CJSlibModule::writeError_impl()
MUT-03025 Caught ESAPinstException in module call: .

ERROR 2019-01-02 11:52:20.797 [CSiStepExecute.cpp:1158]
FCO-00011 The step changeRoleSapmonBR with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbaostload|ind|ind|ind|ind|postload|0|NW_Postload_DB6|ind|ind|ind|ind|db6|0|changeRoleSapmonBR was executed with status ERROR ( Last error reported by the step: Error occured, firstQL0478N DROP, ALTER, TRANSFER OWNERSHIP, REVOKE, or CREATE OR REPLACE on >).

  • revoke_SAPAPP_from_old_connect_user.out

revoke role SAPAPP from user SAP<SID>
DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned:
SQL0478N  DROP, ALTER, TRANSFER OWNERSHIP, REVOKE, or CREATE OR REPLACE on object type "ROLE" cannot be processed because there is an object "SAPTOOLS.DB2_WORKLOAD_CHECK", of type "VIEW", which depends on it. 
SQLSTATE=42893

 


Read more...

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.