Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
error while data deploying xml to DB...
motlnt
Hi All,
I am facing an issue while deploying custom xml to database.
here is what my xml looks like..
<!--joblisting-->
<!--id>123
<!--title>test
<!--description>testing
<!--/item>
<!--item>
<!--id>456
<!--title>test1
<!--description>testing1
<!--/item>
and my ddcfg looks like this..
<!--deployment name="">
<!--source>
<!--xml-source area="$area" area-type="os-filesystem" custom="yes" options = "full,wide" xml-type="custom">
<!--path name="$job_xml" visit-directory="deep"/>
<!--/xml-source>
<!--/source>
<!--destinations>
<!--database name="microsoft-db"
db = ""
user = ""
password = ""
vendor = "microsoft-inetuna"
timeout="10" max-id-length = "128"
update-type="standalone" delete-tracker="yes" enforce-ri="no">
<!--dbschema>
<!--group name="jobs" root-group="yes">
<!--attrmap>
<!--column name="JobCode" data-type="VARCHAR(11)" value-from-attribute="joblisting/[0-10]/item/id" is-replicant="yes" allows-null="no" is-url="no"/>
<!--column name="JobTitle" data-type="VARCHAR(100)" value-from-attribute="joblisting/[0-10]/item/title" is-replicant="yes" allows-null="no" is-url="no"/>
<!--column name="JobDescription" data-type="VARCHAR(2000)" value-from-attribute="joblisting/[0-10]/item/description"
is-replicant="yes" allows-null="no" is-url="no"/>
<!--/attrmap>
<!--keys>
<!--primary-key>
<!--key-column name="JobCode"/>
<!--/primary-key>
<!--/keys>
<!--/group>
<!--/dbschema>
<!--/database>
<!--/destinations>
<!--/deployment>
the path to xml file is well passed.
not sure what goes wrong but the DD does not deploy any rows and status says completed.
any help is appreciated..
thx
Find more posts tagged with
Comments
nipper
Can you post the log the DD created ?
motlnt
here is the DD log...
motlnt
Any RTFM?.
nipper
DBD: No data capture contents for listings\1048941_job_list.xml
This implies that DD is thinking that this is a DCR and is looking a DCT.
I will recheck the manual but I assume there is a config part missing, not certain which.
motlnt
got it!..
the area type should be 'ts-filesystem' and not 'os-filesystem', since I am referring an XML from the backing store.
thx a lot.
RajatChopra
Hi MotInt,
Could you please post your datacaptire.cfg. We are facing a similar problem. Just wanted to verify.
Thanks,
Rajat
commentsRD.rptdesign
mindy1
here is the file..
sorry for the late reply..