It's all about the answers!

Ask a question

[closed] Issue with creating tables for Data Warehouse using DB2z database. Need to resolve a CRJAZ1745E issue.


Matthew Hardin (50814) | asked Dec 07 '21, 8:43 p.m.
closed Apr 25 '23, 5:49 p.m. by David Honey (1.8k17)

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."

I will post full error/stack trace below.

I am not a DB2z SME, so the client DB2z SME asked this question with regards to this step in the setup:
"I’m not finding a Tablespace in the DB=DW702 when it’s trying to create a table. So is the ID=JAZZ requesting a CREATE Tablespace, and then running into an issue while creating a table or is it requesting a table be created in an implicitly created tablespace?"

Complete stack error is:

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
Steve Johnson commented Apr 25 '23, 5:47 p.m. | edited Apr 25 '23, 5:49 p.m.

 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....


David Honey commented Apr 25 '23, 5:49 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Please open a case with IBM Rational technical support.


Steve Johnson commented Apr 25 '23, 5:50 p.m. | edited Apr 26 '23, 3:35 a.m.

 Will do. Thanks David.

The question has been closed for the following reason: "Problem is not reproducible or outdated" by davidhoney Apr 25 '23, 5:49 p.m.