Datadeploy-BLOB

Hi,

I am using Datadeploy 5.6 and TS5.5.2

I am inserting files into DB as BLOB content it is working fine if i use
update-type="standalone" delete-tracker="yes" in my configuration file

If i use

update-type="standalone" delete-tracker="yes" real-update="yes"

first time it is inserting .Second time if i update dcr submit for deploy it is giving the following error

SQLException occured in TDbSchemaGroupCfg
Exception Message: Data size bigger than max size for this type: 12295
Vendor Error Code: 17070
SQL state: null

Any suggestion is appreciated
Thanx in advance

Find more posts tagged with

Comments

Migrateduser

Please contact support for this problem, this will be fixed in a upcoming patch.

Migrateduser

Thanx for your reply i will do that
Just i am wondering is it known issue ?I mean r u able to recreate same issue?
Thanx in advance

Migrateduser

Actually there are 2 problems :
1. You might have a view name with same name as table name in the database probably created by some user causing oracle JDBC driver to give incorrect table metadata.
You will still need to fix this problem by using a different table name. You could getaround the problem you mentioned by changing the table name.
2. DD had a problem updating blob columns. (This will be included in an upcoming patch)

Migrateduser

Thanx for your reply.

In first case i have different name than view.
I have a trigger on a table which takes this data puts in to the view.Does this cause problem?

Thanx once again

Migrateduser

can you make sure that there is no view with the same name as the table name created by some other user in the database.