[closed] Issue with creating tables for Data Warehouse using DB2z database. Need to resolve a CRJAZ1745E issue.
![]()
Matthew Hardin (50●8●14)
| asked Dec 07 '21, 8:43 p.m.
closed Apr 25 '23, 5:49 p.m. by David Honey (1.8k●1●7)
ELM 7.0.2 (iFix 008)
Database is DB2z (DB2 on z/OS) PH14604/UI64434 Attempting to create the tables for the Data Warehouse. Database was created using documentation from https://www.ibm.com/docs/en/elm/7.0.2?topic=database-setting-up-db2-zos-system
When attempting to create the tables, using the "Create Tables" button in the online setup, we are getting an error:
"The data warehouse tables could not be created. Try the action again.ID CRJAZ1745E CRRTC8030E The creation of the data warehouse failed."
The data warehouse tables could not be created. Try the action again.ID CRJAZ1745E CRRTC8030E The creation of the data warehouse failed. com.ibm.team.repository.common.TeamRepositoryException: CREATE TABLE ETL_INFO (ETL_ID VARCHAR(36) NOT NULL, START_DATETIME TIMESTAMP DEFAULT NOT NULL , END_DATETIME TIMESTAMP, STATUS INTEGER, DATASOURCE_ID VARCHAR(36) NOT NULL, LOAD_TYPE CHAR(1) DEFAULT 'D' NOT NULL) IN DATABASE DW702 at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:434) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:247) at com.ibm.team.datawarehouse.service.db2z.internal.DB2zDataWarehouseDbProvider.createDataWarehouseCoreTables(DB2zDataWarehouseDbProvider.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at com.sun.proxy.$Proxy1999.createDataWarehouseCoreTables(Unknown Source) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:237) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$6.run(RemoteDatabaseService.java:557) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:531) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:522) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:223) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at com.sun.proxy.$Proxy1972.createRemoteSchemas(Unknown Source) at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$6.run(InternalDataWarehouseService.java:770) Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=JAZZ;CREATE TABLE;DW702, DRIVER=4.29.24 at com.ibm.db2.jcc.am.b7.a(b7.java:810) at com.ibm.db2.jcc.am.b7.a(b7.java:66) at com.ibm.db2.jcc.am.b7.a(b7.java:140) at com.ibm.db2.jcc.am.k9.c(k9.java:2844) at com.ibm.db2.jcc.am.k9.d(k9.java:2828) at com.ibm.db2.jcc.am.k9.b(k9.java:2188) at com.ibm.db2.jcc.t4.ab.k(ab.java:444) at com.ibm.db2.jcc.t4.ab.c(ab.java:102) at com.ibm.db2.jcc.t4.p.b(p.java:38) at com.ibm.db2.jcc.t4.av.h(av.java:124) at com.ibm.db2.jcc.am.k9.ak(k9.java:2183) at com.ibm.db2.jcc.am.k9.a(k9.java:3387) at com.ibm.db2.jcc.am.k9.e(k9.java:1135) at com.ibm.db2.jcc.am.k9.execute(k9.java:1114) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:242) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:173) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:71) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeStatement(AbstractDataWarehouseDbProvider.java:277) at com.ibm.team.datawarehouse.service.db2z.internal.DB2zDataWarehouseDbProvider.executeStatement(DB2zDataWarehouseDbProvider.java:387) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:409) ... 24 more |
Comments
Did you find a resolution to this issue? We are having the same issue. Database auth looks fine but we are getting a -551. Doesn't make sense to me....
Please open a case with IBM Rational technical support.
Will do. Thanks David.