Symptom
Got the following error during the system rename via SWPM:
sapinst.log:
ERROR 2020-04-11 21:58:34.795 (root/sapinst) id=dbmoddb6.generic errno=MDB-01999
Error occured, first error is: <SQL20342N "SAP<SID>" does not have one or more required privileges "READ" on >
ERROR 2020-04-11 21:58:34.796 (root/sapinst) id=modlib.jslib.caughtException errno=MUT-03025
Caught ESAPinstException in module call: Error occured, first error is: <SQL20342N "SAP<SID>" does not have one or more required privileges "READ" on >.
ERROR 2020-04-11 21:58:34.924 (root/sapinst) id=controller.stepExecuted errno=FCO-00011
The step transferOwnership_3 with step key |offlineadjustment_dialogs|ind|ind|ind|ind|0|0|offlineadjustment_db_post|ind|ind|ind|ind|db_post|0|db6_rename_db_post_dia|ind|ind|ind|ind|db6|0|transferOwnership_3 was executed with status ERROR ( Last error reported by the step: Error occured, first error is: <SQL20342N "SAP<SID>" does not have one or more required privileges "READ" on >).
sapinst_dev.log:
TRACE 2020-04-11 21:58:34.794 (root/sapinst)
Found Error, error_codes[0] = <transfer ownership of view "SAP<SID>"."ATO_V_PK_OPREQ" to user SAP<SID> preserve privileges
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20342N "SAP<SID>" does not have one or more required privileges "READ" on
object "CLIENT" of type "VARIABLE" necessary for ownership of the object.>
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
SQL20342N, "transfer ownership of view", privileges "READ", object "CLIENT", type "VARIABLE" , 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