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.
SAP Knowledge Base Article - Preview