IBM Support

Error during summarizing the warehouse data: The name of the object to be created is identical to the existing name "<warehouse table>" of type "TABLE"

Troubleshooting


Problem

Receiving the error during summarizing the warehouse data: The name of the object to be created is identical to the existing name "<warehouse table>" of type "TABLE".. SQLCODE=-601, SQLSTATE=42710, DRIVER=3.67.27

Symptom

== 6031 t=work1 SQLException occured. SQL State = 42710 , SQL Error Code = -601
== 6032 t=work1 com.ibm.db2.jcc.am.SqlSyntaxErrorException: The name of the object to be created is identical to the existing name "<warehouse table name>" of type "TABLE".. SQLCODE=-601, SQLSTATE=42710, DRIVER=3.67.27

    at com.ibm.db2.jcc.am.gd.a(gd.java:749)
    at com.ibm.db2.jcc.am.gd.a(gd.java:66)
    at com.ibm.db2.jcc.am.gd.a(gd.java:135)
    at com.ibm.db2.jcc.am.so.b(so.java:2430)
    at com.ibm.db2.jcc.am.so.c(so.java:2413)
    at com.ibm.db2.jcc.t4.ab.l(ab.java:406)
    at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
    at com.ibm.db2.jcc.t4.o.a(o.java:50)
    at com.ibm.db2.jcc.t4.ub.b(ub.java:220)
    at com.ibm.db2.jcc.am.to.pc(to.java:3415)
    at com.ibm.db2.jcc.am.to.b(to.java:4380)
    at com.ibm.db2.jcc.am.to.hc(to.java:782)
    at com.ibm.db2.jcc.am.to.executeUpdate(to.java:760)
    at com.tivoli.twh.ksy.db.WHPreparedStatement.executeUpdate(WHPreparedStatement.java:810)
    at com.tivoli.twh.ksy.agg.AggTable.createInDatabase(AggTable.java:1010)
    at com.tivoli.twh.ksy.agg.RawTable.setupAggregationTables(RawTable.java:2575)
    at com.tivoli.twh.ksy.agg.RawTable.createAggregatesAndPrune(RawTable.java:3551)
    at com.tivoli.twh.ksy.agg.RawTable.executeWork(RawTable.java:5067)
    at com.tivoli.twh.ksy.agg.Worker.run(Worker.java:86)

Cause

May be two SY agents trying to summarize the same table 

Environment

AIX, Linux and Windows 

Diagnosing The Problem

Check the default RAS1 log of Summarizing and Pruning Agent

Resolving The Problem

This could be due to two Summarizing and Pruning (SY) agents pointing to the same warehouse database. if yes, issue may be  with one SY agent creating partitions and then the 2nd SY agent coming in and trying to create the same partitions. So please check, if you have two or more SY agents pointing to the same warehouse database.

 

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTFXA","label":"Tivoli Monitoring"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 September 2018

UID

ibm10730267