Data deploy inserting but not updating data

Hi Friends,

I am using TS 672 and OD 6.2.1 running on Solaris with DB Oracle 10.
When I create a DCR and run DD for the first time, it is successfuly inserting a new record in the tables. The problem occurs when I modify the DCR and try to update the database using data deploy it fails.I am mentioning the correct format in the ddconfig.xml file but
DD log shows
"ERROR Smiley Frustrated

QLException while selecting rows from table: ORA-01821: date format not recognized"

Any pointer on how to resolve this?

Thanks,

Find more posts tagged with

Comments

sniv

Hey Vikas,

The issue should be with db-datetime-format only. Check with you ddconfig.xml file. The db-datetime-format must match the date format of DB.

It works for you first time.. As there is no record in db first time, But for second time for existing record the date format mismatch with database n its causes to fail.

So do check with date format.

Hope this helps you

Thanks!
Vinayak

vikasp

Hey Vikas,

The issue should be with db-datetime-format only. Check with you ddconfig.xml file. The db-datetime-format must match the date format of DB.

It works for you first time.. As there is no record in db first time, But for second time for existing record the date format mismatch with database n its causes to fail.

So do check with date format.

Hope this helps you

Thanks!
Vinayak

Thanks Vinayak,
There was problem with date format.