SAP Knowledge Base Article - Preview

2922489 - DB6: SQL20342N occurs when renaming the system via SWPM

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.