i getting an error in my log file
"(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 22018
: Microsoft OLE DB Provider for SQL Server:  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>,
Based on what little information you provided, my guess is it's a problem with your SQL code.
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
My first thought is to modify the table to make the unique identifier an alpha column instead.
Anyone have any ideas?
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
Posting the MFD would help.
WF7.1.4 Prod/Test, MRE, self serve, DM
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.
Either ways, it solved for me.
|Powered by Social Strata|