SAP Knowledge Base Article - Preview

3545214 - DB6: SQL0204N error at granting privileges during system copy

Symptom

System copy failed with SQL0204N error when granting privileges on tables.

e.g.  

TRACE      2024-11-13 09:44:53.803 (hst01\Administrator) (startInstallation) [Installer Callback]
Found Error, error_codes[0] = <GRANT SELECT ON SAPABC.SVERS TO USER db2abc 
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0204N  "SAPABC.SVERS" is an undefined name.  SQLSTATE=42704>


<snipped>

TRACE      2024-11-13 09:44:53.804 (hst01\Administrator) (startInstallation) [Installer Callback]
Found Error, error_codes[15] = <GRANT SELECT ON SAPABC.TRESC TO USER db2abc 
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0204N  "SAPABC.TRESC" is an undefined name.  SQLSTATE=42704>

TRACE      2024-11-13 09:44:53.804 (hst01\Administrator) (startInstallation) [Installer Callback]
During execution of <GrantPrivilegesOnTables.sql>, <16> errors occured.

ERROR      2024-11-13 09:44:53.804 (hst01\Administrator) (startInstallation) [CInstallerCallBackImpl.cpp:260] id=dbmoddb6.generic errno=MDB-01999 CInstallerCallBackImpl::abortInstallation()
Error occurred, first error is: <SQL0204N  "SAPABC.SVERS" is an undefined name.  SQLSTATE=42704>

* Here source system sid is ABC.


Read more...

Environment

  • SAP on IBM DB2 for Linux, UNIX, and Windows 

Product

SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

system copy, SQL0204N, GrantPrivilegesOnTables, GRANT SELECT, SVERS , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-INS , Installation SAP System , 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.