Getting error when running Jazz Custom Setup wizrd, CCM Database Configuration ID CRJAZ1571E hide details The database creation failed with an exception com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0487I The database was unable to create t
Getting error on Database configuration on CCM as follows. Where as Database configuration for jts was successful.
CAn any one help me in this.
Regards,
Viji
ID CRJAZ1571E
hide details
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0487I The database was unable to create the required tables/schemas for the package "com.ibm.team.tpt.Impex". Check the log file for the error sent by the database. at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:254) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchemaForPackage(AbstractDatabaseService.java:220) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreatePackageSchemas(AbstractDatabaseService.java:207) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:200) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:123) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:121) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:111) at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40) at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:488) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:312) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381) at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:600) 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.$Proxy587.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:308) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:286) at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runExclusive(PrimitiveTransactionService.java:139) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:600) 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.$Proxy623.runExclusive(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:107) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:98) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:600) 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.$Proxy662.rebuildAllSchemas(Unknown Source) at com.ibm.team.repository.service.internal.DatabaseCreationProgressService$1.run(DatabaseCreationProgressService.java:188) at java.lang.Thread.run(Thread.java:738) Caused by: com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577E The following SQL query did not execute properly on the server: CREATE TABLE Y1_IMPEX.IMPORT_REQUEST(STATE_ID CHAR(23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, IMPORT_REQUEST_ID VARCHAR(250) NOT NULL) IN DATABASE CCM401 at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:237) at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:114) at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQueryOn(JdbcDB.java:103) at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatement(JdbcDBBuilder.java:148) at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:272) at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.buildArtifactsFromCreateStatements(JdbcDBBuilder.java:277) at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.buildArtifactsFromCreateStatements(PluggableJdbcDbBuilder.java:90) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchema(AbstractDatabaseService.java:310) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:248) ... 41 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=Y1_IMPEX.IMPORT_REQUEST;TABLE, DRIVER=3.65.96 at com.ibm.db2.jcc.am.cd.a(cd.java:698) at com.ibm.db2.jcc.am.cd.a(cd.java:60) at com.ibm.db2.jcc.am.cd.a(cd.java:127) at com.ibm.db2.jcc.am.ko.b(ko.java:2420) at com.ibm.db2.jcc.am.ko.c(ko.java:2403) at com.ibm.db2.jcc.t4.ab.l(ab.java:374) at com.ibm.db2.jcc.t4.ab.a(ab.java:61) at com.ibm.db2.jcc.t4.p.a(p.java:50) at com.ibm.db2.jcc.t4.rb.b(rb.java:220) at com.ibm.db2.jcc.am.lo.nc(lo.java:3415) at com.ibm.db2.jcc.am.lo.b(lo.java:4380) at com.ibm.db2.jcc.am.lo.hc(lo.java:2744) at com.ibm.db2.jcc.am.lo.execute(lo.java:2724) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:54) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:68) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:53) at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:226) ...CAn any one help me in this.
Regards,
Viji
2 answers
Hello Viji,
the DB2 error you get is the following:
SQL0601N
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql00601n.html
The name of the object to be created is identical to the existing name > name of type > type .
I would check that the database you are using is empty before you try to create it.
You might consider to drop and re create it.
Best Regards,
Francesco Chiossi
the DB2 error you get is the following:
SQL0601N
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql00601n.html
The name of the object to be created is identical to the existing name > name of type > type .
I would check that the database you are using is empty before you try to create it.
You might consider to drop and re create it.
Best Regards,
Francesco Chiossi
Yes Francesco, You are right. SQL Code -601 stands for object already exist. When I run through wizard and click on Create Table button, it first drops the tables and then creating it. I have checked.
When I ran second time, it started deleting all the object and creating again. So in that case I don't want to perform manual delete.
It nearly creates 3224 tables for CCM. Because my VCAT is ROYAL, so after clicking this Create Table button, I just get into ISPF 3.4 and tested with ROYAL.DSNDBC.CCM410.** . It deletes all firts and creates again.
So I am tried again one more time, let as see .
Regards,
Viji