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