[SOVLED] I am getting "invalid character value for cast specification"
Hey all i getting an error in my log file "(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 22018 : Microsoft OLE DB Provider for SQL Server: [22018] Invalid character value for cast specification." First time Flow is run fine but for second time its gives an error. Its rejects the records due to DBMS Error. Can anybody help me
AmmyThis message has been edited. Last edited by: <Kathryn Henning>,
December 20, 2005, 08:49 AM
<RickW>
Based on what little information you provided, my guess is it's a problem with your SQL code.
May 18, 2006, 11:27 AM
Francis Mariani
I am getting this error right now. This seems to be caused by a MODIFY FILE os a MS SQL Server DB. I am matching on a unique Identifier column, "ENTITYID".
The code is something like this:
MODIFY FILE CRMLISTMEMBER FIXFORM FROM HOLDC1
MATCH LISTNAME ENTITYID ON MATCH UPDATE LISTNAMESORT BUSINESSUNITNAME USERID ON NOMATCH INCLUDE
DATA ON HOLDC1 END
My first thought is to modify the table to make the unique identifier an alpha column instead.
Anyone have any ideas?
Thanks,
Francis.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 18, 2006, 03:24 PM
newtofocus
Posting the MFD would help.
WF7.1.4 Prod/Test, MRE, self serve, DM
May 16, 2013, 11:16 PM
vaayu
I've seen this one before and I got one today. In my scenario I had a default value for a field in sql server table which was trying to insert a date to a date/time field. I have that value added as a transform now instead of field default. Or I could've tried to change my default value from getdate() to some format convert it right to match HYYMDs type value.