failure while data deploying PDF files...

Hi all,
I am trying to datadeploy PDF by pRoviding the URL to PDFs.

This is the error I get.

env:
SQL Ent edition : NT
OD Version is 6.0.1.0.0

The field in DB is defined as VARBINARY(8000)

This is my ddcfg config detail:

This are the snippets from log files:

DD:Try connecting using jdbc:inetdae:10.203.61.62:1433?database=Northwind&sql7=true...
DD:
Connected to jdbc:inetdae:10.203.61.62:1433?database=Northwind&sql7=true
DD: Driver i-net UNA 2000
DD: Version 4.17
DD:Connected to [10.203.61.62:1433?database=Northwind]

DD:
DD:*******************************************************
DD Smiley Frustrated

QLException occured in TDbSchemaGroupCfg
DD:Exception Message: [WNY02KDEV3]Operand type clash: ntext is incompatible with varbinary
DD:Vendor Error Code: 206
DD Smiley Frustrated

QL state: 22005
DD:*******************************************************

Any hint?
thx in adv..

Find more posts tagged with

Comments

Migrateduser

What is the data type for the column you are trying to deploy?

It looks as though it's a binary column, perhaps expecting the PDF content as opposed to a path or URL to the content.

What does your table look like?

mindy1

datatype:VARBINARY length=8000..
thts wht I am trying to do, I want to deploy the PDF to the column, niot the path or URL...
Oracle DB has column type as BLOB...and seems MSSQL has VARBINARY as opposed to BLOB..

nipper

datatype:VARBINARY length=8000..
thts wht I am trying to do, I want to deploy the PDF to the column, niot the path or URL...

Why ?

I have dropped large chuncks of HTML into Oracle BLOBs before, but never MSSL. That being said this is a seriously bad design.

Migrateduser

That being said this is a seriously bad design.

Why do you say that? It's hard for me to say either way, not knowing other details about the business requirements of technical architecture but this is why there are BLOB columns in the first place.

This can be done in both Oracle and MSSQL -- but I had a problem about a year ago with v6.0.1 when trying to deploy blobs when they're replicants. The short reponse from Interwoven was that this didn't work and to try another method. So, I did. Other than that, I've had success deploying blobs into both Oracle and SQL Server.

Perhaps you can share the rest of your dd config?

mindy1

DDCFG..

db = "10.203.61.62:1433?database=Northwind"
user = "cms"
password = "cms"
vendor = "microsoft-inetuna"
max-id-length = "128"
update-type="standalone" state-field="state"
delete-tracker="yes" enforce-ri="no">

Migrateduser

( Good to know "view source" is always an option... )

Have you tried declaring the column as VARBINARY(8000) instead of BLOB? I'm not clear on why BLOB would be used if we're deploying to MSSQL. Also, I remember that DD can be finicky when deploying a binary field. If C:/t1.pdf will always be present, why not declare allows-null as "no"? Also, since you're not using replicants here, state is-replicant="no". You may also need to play with the slash / backslash situation. Your file:/// is just fine but you may need either C:\ or C:\\ after it.

Dave

nipper

Why do you say that? It's hard for me to say either way, not knowing other details about the business requirements of technical architecture but this is why there are BLOB columns in the first place.

True

My point is performance. A PDF, JPG, etc, will always be loaded faster from a webserver via a link rather than a BLOB in a DB. I have never seen a reason to have binary data in a BLOB over the filesystem.

Migrateduser

My point is performance. A PDF, JPG, etc, will always be loaded faster from a webserver via a link rather than a BLOB in a DB. I have never seen a reason to have binary data in a BLOB over the filesystem.

Then we're in agreement. However, sometimes it just makes sense to insert a PDF (or other asset) as a binary object. I did a project for the federal gov't last year and part of my requirement was to insert a submitted PDF into an Oracle database as well as OpenDeploy the file to a separate repository. We were fitting it in to a legacy system and this actually worked out pretty well, although I had to do write the SQL transaction raw because DD couldn't handle it (this is the replicant situation I wrote of earlier).

mindy1

tht did the trick..
I have changed BLOB type to VARBINARY(8000)...
thx..

Migrateduser

Great! Just remember that DataDeploy has no formal parameters behind what populates the datatype field. That is, it's CDATA and it's there to relay to the JDBC driver what data type you're attempting to deploy so that it can process it appropriately. I think most or maybe all of the datatype examples in the DD manual are either generic or Oracle-specific. So, I don't believe it makes any or at least much reference to VARBINARY, MEDIUMTEXT or other non-Oracle data types.

Dave

mindy1

gr8 tip..

just to add to the debate of why deploy contents like PDF in DB instead of doing opendeploy to file servers,it ahs to do with budgeting ,the client does not want to invest in more OD receivers...