Data Deploy issue when I am trying to publish data to DB2

Hi,

I am getting below error when i am trying to publish data record to Db2 through Data Deploy. Please let me know what may be the issue.

Deployment configuration file:-

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data-deploy-configuration>
<client>
<deployment name="basearea">
<source>
<teamsite-templating-records options="wide" area="/Agency/main/CAG/STAGING" custom="yes">
<path name="templatedata/CAG/Commercial_Appetite_Guide/data"/>
</teamsite-templating-records>
</source>
<destinations>
<database db="PEGADEV" user="pegadev2" password="pega#@!" vendor="IBM" update-type="standalone" use-db2-driver-type="app"
delete-tracker="yes" >
<dbschema>
<group name="CAG" table="SIC_ELIGIBILITY" root-group="yes">
<attrmap>

</attrmap>
<keys>
<primary-key>
<key-column name="SIC_CD"/>
<key-column name="CLASS_CD"/>
<key-column name="STATE"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

Connected to jdbc:db2 Smiley Tongue EGADEV2
DBD: Driver IBM DB2 JDBC 2.0 Type 2
DBD: Version 09.05.0000
DBD: Connected to [PEGADEV2]
DBD: SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'IWOV_IDMAPS'
DBD: SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'IWOV_IDMAPS'
DBD: Creating identifier mapping table: IWOV_IDMAPS
DBD: CREATE TABLE IWOV_IDMAPS (TYPE INT NOT NULL, SHORTID VARCHAR(30) NOT NULL, LONGID VARCHAR(1024) NOT NULL)
DBD: Created identifier mapping table: IWOV_IDMAPS Successfully
DBD: Creating index on IWOV_IDMAPS
DBD: SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'IWDELTRACKER'
DBD: CREATE TABLE IWDELTRACKER ( PATH VARCHAR(255) NOT NULL , AREA VARCHAR(255) NOT NULL , KEYCOLNAME VARCHAR(255) NOT NULL , KEYCOLVALUE VARCHAR(255) NOT NULL )
DBD: CREATE INDEX iwdelt_idx ON IWDELTRACKER( PATH , AREA )
DBD: IWDELTRACKER created successfully.
DBD: SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'SIC_ELIGIBILITY'
DBD: Table [SIC_ELIGIBILITY] exists.
DBD: Running deployment [basearea]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/Agency/main/CAG/WORKAREA/load
DBD: base area=/Agency/main/CAG/STAGING
DBD: /Agency/main/CAG/WORKAREA/load/templatedata/CAG/Commercial_Appetite_Guide/data
DBD: Generate DirectoryContents start:Tue Feb 02 12:10:44 PST 2016
DBD: Generate DirectoryContents end :Tue Feb 02 12:10:44 PST 2016
DBD: Generate TCustomDCRTupleProducer start:Tue Feb 02 12:10:44 PST 2016
DBD: Generate TCustomDCRTupleProducer end :Tue Feb 02 12:10:44 PST 2016
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={TeamSite/Templating/DCR/Type=CAG/Commercial_Appetite_Guide, root/0/Underwriting_Highlights_Minimum_Acceptability_Requirements/0=This SIC is only available t
hrough the Contractor Property BOP program, and General liability coverage is not available for it. Risks must otherwise meet the standard underwriting requirements. ,
root/0/State_Specific_Guidelines/0=There are no state-specific rules for this operation., root/0/Eligible_Operations/0=Please review the Artisan Contractor Underwritin
g Guidelines for Property-Only eligibility., root/0=, root/0/Industry/0=Artisan Contractor, state=Original, root/0/Notes/0=, root/0/WC_Industry_Description/0=, root/0/E
xpiration_Date/0=2099-01-01, root/0/Effective_Date/0=2016-06-04, root/0/State/0=AK, root/0/Ineligible_Operations/0=Please review the Artisan Contractor Underwriting Gui
delines for Property-Only ineligibility., root/0/Owner_Email/0=test@gmail.com, root/0/Owner/0=test, root/0/Classification_Name/0=General Contractors - Single Family Hou
ses, root/0/Business_Description/0=This classification includes general contractors engaged in construction (including new work, additions, alterations, remodeling, and
repair) of single-family houses., root/0/BOP_Industry_Category/0=, path=templatedata/CAG/Commercial_Appetite_Guide/data/CAGDataRecords0, root/0/Line_of_Business/0=BOP,
root/0/SIC_Code/0=1521, root/0/WC_UW_Grade/0=, root/0/SIC_Name/0=General Contractors - Single Family Houses, root/0/WC_Industry_Category/0=, root/0/Classification_Code
/0=None, root/0/Keyword_Search_Terms/0=,house,home,dwelling,building,condominium,residential,single-family,contractor,builder,construction,general,new,sub-contractor,su
bcontractor,general,general-contractor,contractor,contracting,sub contractor,subcontracting,,1521, root/0/uw_Rules/0=https://eagent.farmersinsurance.com/PLA/eAgent/Ade/
adedynamic.dynamic.ade?req_page=dynamic&dynamicLinkName=ac_und, root/0/Related_Classifications/0=General contractors engaged in the construction of multi-unit residenti
al buildings are classified under SIC 1542.

General contractors engaged in the construction of industrial buildings are classified in SIC 1541., IWOV_PROC_FLAG=true}
DBD: TDbSchemaGroupCfg:RowsExistForTuple Smiley Frustrated ELECT COUNT(*) FROM SIC_ELIGIBILITY WHERE SIC_CD IN ( ? ) AND CLASS_CD IN ( ? ) AND STATE IN ( ? )
DBD: TTableSchemaHelper not found in cache for [SIC_ELIGIBILITY]. Creating new.
DBD: Defaulting to version: 3
DBD: SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
DBD:
DBD: *******************************************************
DBD: SQLException occured in Error
DBD: Exception Message: [IBM][CLI Driver][DB2/AIX64] SQL0204N "PEGADEV2.SIC_ELIGIBILITY" is an undefined name. SQLSTATE=42704

DBD: Vendor Error Code: -204
DBD: SQL state: 42S02
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/AIX64] SQL0204N "PEGADEV2.SIC_ELIGIBILITY" is an undefined name. SQLSTATE=42704

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(Unknown Source)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2190)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1065)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1044)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:421)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1083)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:530)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:632)
at java.lang.Thread.run(Thread.java:619)

DBD: TTableSchemaHelper object for [SIC_ELIGIBILITY] found in cache.
DBD: INSERT:INSERT INTO SIC_ELIGIBILITY(LOB,SIC_CD,CLASS_CD,STATE) VALUES (?,?,?,?)
DBD: Column: LOB, field: root/0/Line_of_Business/0, Index: 1,Converting 'BOP' to VARCHAR
DBD: Column: SIC_CD, field: root/0/SIC_Code/0, Index: 2,Converting '1521' to VARCHAR
DBD: Column: CLASS_CD, field: root/0/Classification_Code/0, Index: 3,Converting 'None' to VARCHAR
DBD: Column: STATE, field: root/0/State/0, Index: 4,Converting 'AK' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: [IBM][CLI Driver][DB2/AIX64] SQL0204N "PEGADEV2.SIC_ELIGIBILITY" is an undefined name. SQLSTATE=42704

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1301)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1175)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1087)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:477)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1083)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:530)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)

Find more posts tagged with

Comments

There are no comments yet