DataDeploy deployment error

Hi all,

I'm working with DataDeploy using a DAS deployment.
I have done a modified to the configuration xml file(attacched), adding a new fileld (REF-DATE), but after this moment DD return some errors for this field.
Attached the log errror and the configuration file.

Can anyone help me?
Thanks
Raffaele

Find more posts tagged with

Comments

nipper

It is likely this:

DBD: Column REF_DATE not found in array
DBD: WARNING:Value for [REF_DATE] exceeds column width [ 10 > -1]
DBD: Column REF_DATE not found in array
DBD: Column: REF_DATE, field: metadata/0/ref-date, Index: 26,Converting '...........' to LONGVARCHAR
D

Since the data seems correct: metadata/0/ref-date=2008-04-03

I suspect you need to check how the DB has REF_DATE defined.

nakumar

This is an oracle error, because you tried to enter a literal with a format string, but the length of the format string was not the same length as the literal. Please see:

http://www.techonthenet.com/oracle/errors/ora01861.php

Please check the length of the format string.

lele1

The configuration of the database table is ok, we have added correctly the "date" column.
I think that the problem is that Datadeploy doesn't see the new column in database because
in the log it says that:
DBD: TTableSchemaHelper object for [CMS_EDITORIAL] found in cache.

Is there anyway to clean the cache?Could be a cache problem?

Thanks

nakumar

use cache-db-connection parameter and set it as "no". So that it won't use cache data.

[html]

use = "db2-db"
max-id-length = "128"
update-type="standalone" state-field="state"
delete-tracker="yes" enforce-ri="no" cache-db-connection="no"/>
[/html]

Also you can restart the OD Services to clean the cache