Hi,
DataDeploy is giving me a strane problem.
I'm using TS 5.5.2 SP3 on Win2K with OD/DD 5.6 SP1
I'm using DD to deploy only the Metadata to oracle (8i)database.
All my data is getting deployed correctly except for Date fields.
I've defined date fields to be of 'dd-mm-yyyy' format.
After deploying to DB, its always showing the month to be Jan and the year and day are getting written correctly.
i.e. if the date is 11-09-2003 (dd-mm-yy), its writing 01-01-2003 to the database..
I'm using OD-DD intergration which uses ddsync.ipl to the dump metadata to an XML file and then reads this dump to write to datbase.
Here are the excerpts from various files.
loaddb.cfg (Config file that is used to create DB schema)
===========================
<column name="LaunchDate" data-type="DATE" data-format="dd-mm-yyyy" value-from-field="TeamSite/Metadata/Launch Date" />
iwdd.loaddb.out (log file for DD)
===========================
Parameter Index: 6, Value: 11-09-2003, Converting '11-09-2003' to TIMESTAMP
Column: LaunchDate, field: TeamSite/Metadata/Launch Date, Index: 6,Converting '11-09-2003' to TIMESTAMP
teamsite_metadata.dump (Dump file for metadata)
===========================
<tuple-field name="TeamSite/Metadata/Launch Date">07-09-2003</tuple-field>
The date fields are getting correctly written to the XML dump file, but somehow its not written to the database.
Has anyone faced this kind of problem?
What could be wrong?
btw I've 3 date fields in my metadata and all the 3 have the same problem.
Thanks in Advance
Edited by ashish_deshpande on 09/11/03 09:30 PM (server time).
