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