DB2 SQL Error: SQLCODE=-554, SQLSTATE=42502 when you try to load database schema
When you are preparing a database for HCL Commerce Version 9, you need to run the initdb_db2_sample utility. During execution, you might encounter a message similar to the following error.
Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runSql() INFO: Running file C:\v9\WCDE_V9\\schema\9.0.0.0\db2\Create_Workspaces_For_WCS.sql Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runScript() SEVERE: Error executing: GRANT CREATEIN, ALTERIN, DROPIN ON SCHEMA WCW101 TO USER DB2INST1 Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runSql() SEVERE: SQLException information Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runSql() SEVERE: Error msg: DB2 SQL Error: SQLCODE=-554, SQLSTATE=42502, SQLERRMC=null, DRIVER=3.69.24
Problem
You might have specified the dbuser field with a database administrator username.Solution
Ensure that you do not use an administrator username in the dbuser field.
- Restore the database.
- Rerun the initdb_db2_sample utility.For example, in the following command, the dbauser is db2inst1 and
the dbuser is wcs.
.\initdb_db2_sample.bat staging mall mydb.ibm.com 50000 db2inst1 db2instpassword wcs wcs1 aaaa1aaaa1aaaa12aaaa1aaaa1aaaa12 wcsadminSalt1 wcsadminPwd1 spiuserSalt1 passw0rd sampleData