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 for Me (Login required).

Search for additional results

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