It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,883
×6,114
×83

question asked: Feb 12 '14, 2:34 a.m.
question was seen: 6,227 times
last updated: Feb 12 '14, 8:45 a.m.

Related questions

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

0
Vijayalakshmie K Ekan (7●1●11●16) | asked Feb 12 '14, 2:34 a.m.
retagged Feb 12 '14, 6:37 a.m. by Francesco Chiossi (5.7k●1●11●19)
Getting error on Database configuration on CCM as follows. Where as Database configuration for jts was successful.

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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Feb 12 '14, 6:36 a.m.
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
0
permanent link
Vijayalakshmie K Ekan (7●1●11●16) | answered Feb 12 '14, 8:45 a.m.
 
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






Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.