nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deploy Error

awgolk

I am having some trouble with Data Deploy. The deployment executes successfully, but the destination table is not being updated, but the IWDELTRACKER table is being updated with the proper keys. Has anyone seen this before, or knows where I should look for debugging purposes?

System: Solaris 9
Database: IBM DB2
Data Deploy 6.02

Configuration File
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?>
<data-deploy-configuration>
<data-deploy-elements filepath="/usr/od-home/OpenDeployNG/etc/database.xml" />
<client>
<deployment name="hcsc_taxm">
<source>
<xml-source options="wide" area="$WORKAREA^" area-type="os-filesystem" xml-type="custom">
<path name="$RPATH^"/>
</xml-source>
</source>
<destinations>
<database use="$dbname^"
update-type="standalone"
state-field="state"
delete-tracker="yes"
enforce-ri="yes"
real-update="yes">

<dbschema>
<group name="TAG_VAL" table="TAG_VAL" root-group="yes">
<attrmap>
<column name="TAG_VAL_ID" data-type="INT" value-from-element="TAXM/0/TAG_VAL/0/SVTerm/[0-1000]/TAG_VAL_ID/0" allows-null="no" is-url="no" is-replicant="yes"/>
<column name="TAG_VAL" data-type="VARCHAR(255)" value-from-element="TAXM/0/TAG_VAL/0/SVTerm/[0-999]/LABEL/0" allows-null="yes" is-url="no" is-replicant="yes" />
<column name="TAG_VAL_NM" data-type="VARCHAR(20)" value-from-attribute="TAXM/0/TAG_VAL/0/SVTerm/[0-999]/UID" allows-null="no" is-url="no" is-replicant="yes"/>
<column name="TAG_FLTR_TXT" data-type="VARCHAR(50)" value-from-attribute="TAXM/0/TAG_VAL/0/SVTerm/[0-999]/TAG_FLTR_TXT/0" allows-null="no" is-url="no" is-replicant="yes"/>
<column name="TAG_ID" data-type="INT" value-from-element="TAXM/0/TAG/0/TAG_ID/0" allows-null="no" is-url="no"/>

</attrmap>
<keys>
<primary-key>
<key-column name="TAG_VAL_ID"/>
<key-column name="TAG_ID"/>
</primary-key>
</keys>
</group>

</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

Edited by awgolk on 08/29/05 10:44 AM (server time).

Find more posts tagged with

Comments

reddyl

check the micro & macro deployment logs in OD_HOME/log directory.

Product Sales by State.zip

awgolk

Checked both logs, no errors thrown. Is there a way to turn on additional debug logging? For reference I attached a copy of the micro log.

reddyl

you can specify the log-level attribute for database element in data deploy configuration file. Check if you get any rows after runing this query
SELECT COUNT(*) FROM TAG_VAL WHERE TAG_VAL_ID=19594 AND TAG_ID=1219 on the database.

awgolk

db2 => SELECT COUNT(*) FROM TAG_VAL WHERE TAG_VAL_ID=19594 AND TAG_ID=1219

1
-----------
0

1 record(s) selected.

Also when I manually run the insert command, it will insert the row.

Edited by awgolk on 08/29/05 11:55 AM (server time).