Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
TeamSite
TeamSite, LiveSite and OpenDeploy
Converting to BIT error
Migrateduser
We have a checkbox field check, (value='1') and it is deployed to a column with datatype BIT in MSSQL 2005. While deploying if we uncheck the checkbox, deployments goes through. But if the checkbox is selected deployment fails.
The error log states that
failed to convert '1' to BIT.
So we changed the datatype in table to Varchar(3). Now while deploying if we uncheck the checkbox, deployments goes through as usual. But if the checkbox is selected deployment fails with the following log
DBD: Column: colname, field: dctq/0/check, Index: 3,
Converting '1' to BIT
The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Paramater 13: Datatype 0x32 is unknown.
When we have changed the datatype in table from BIT to varchar why DataDeploy is still converting the field in DCT to BIT?
In deployment configuration xml we have datatype set to varchar.
Any pointers will be of great help.
thanks in advance
Find more posts tagged with
Comments
There are no comments yet