data deploy cache error?

i created a couple of fields in a sql table, one of those fields was a "nameX" datatype BIT, then i change the datatype of that field "nameX" to datatype varchar(50) but open deploy still recognized that filed as BIT, i already change it and save it on the sql database.

Is there a caching problem on open deploy? i never heard of it before.

i am getting the valued from a dct calling it on the datadeploy file as:

<column name="hidePost" data-type="varchar(50)" value-from-field="Hide Post" allows-null="yes"/>

I hightlighted the field in question hidePost fieldname, it is varchar(50) on the database

this is the log:

DBD: Column: category, field: Category, Index: 5,Converting 'Health-Tips, Ask-a-Doctor' to VARCHAR
DBD: Column: postDate, field: Date/0/DBDate, Index: 6,Converting '2015-04-21' to TIMESTAMP
DBD: Column: imageAlt, field: Post Images/0/Image Alt, Index: 7,Converting 'Purple box' to VARCHAR
DBD: Column: hidePost, field: Hide Post, Index: 8,Converting '1' to BIT
DBD: Column: webName, literal: jhs, Index: 9,Converting 'jhs' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: [SQLSRVETSDPRD3]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): Data type 0x32 is unknown.
DBD: Vendor Error Code: 8009
DBD: SQL state: 01000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [SQLSRVETSDPRD3]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): Data type 0x32 is unknown.
   at com.inet.tds.e.a(Unknown Source)
   at com.inet.tds.e.a(Unknown Source)
   at com.inet.tds.b.new(Unknown Source)
   at com.inet.tds.b.executeQuery(Unknown Source)

Find more posts tagged with

Comments

Rick Poulin

Yes, datadeploy does sometimes cache schema information. I've never figured out exactly how to clear it, but some combination of "iwodcmd serverreset" and/or restarting the service and/or sacrificing some farm animals seems to eventually work.

PM.png

pm7.rptdesign

praveen t n

I had experienced this same issue. Back then, I changed the field name in DCT and DD config file and tried deploying, and it went through.

regards,

Praveen

PM.png

pm7.rptdesign

Alex Varga

Thanks for your suggestions it works like that, HP should be address about the issue, it is annoying. again thanks for your help.

PM.png

pm7.rptdesign

Rick Poulin

Well it's really just a documentation bug. The way the product works is just fine because you don't want to constantly check for schema updates, but it would be nice if they documented how it works and how to clear it. I suggest you log a support ticket if you care that much about it.

PM.png

pm7.rptdesign