"-1 Rows affected"-SQL Server Call Execute Failed
Posted: Thu Aug 11, 2011 5:27 am
Hi,
After going through different search outputs i am posting this topic,
We recently upgraded from DS7.5 to DS8.1 Server edition and facing the below issue. Data is not getting updated properly in SQL Server DB.
DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE IntlHeadCount.dbo.TIFEED_STAGING SET Process_Indicator = ? WHERE (Month_End_Date = ? AND Employee_ID = ? AND Entry_Dt = ?)
-1 Rows affected.
Month_End_Date(TIME_STAMP format) = "2011-07-31 00:00:00.000"
Employee_ID = "6511521"
Entry_Dt(TIME_STAMP format) = "2011-08-11 04:27:12.000"
Process_Indicator = "Y"
When we tried to change the "Transaction Handling" Settings as
Isolation Level - None, Rows per trabsaction 0, Parameter array size 1,
it was updating, still with warnings. We are confused on the ACTUAL CAUSE.
Any inputs / resolution will be appreciated.
Thank you very much!
After going through different search outputs i am posting this topic,
We recently upgraded from DS7.5 to DS8.1 Server edition and facing the below issue. Data is not getting updated properly in SQL Server DB.
DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE IntlHeadCount.dbo.TIFEED_STAGING SET Process_Indicator = ? WHERE (Month_End_Date = ? AND Employee_ID = ? AND Entry_Dt = ?)
-1 Rows affected.
Month_End_Date(TIME_STAMP format) = "2011-07-31 00:00:00.000"
Employee_ID = "6511521"
Entry_Dt(TIME_STAMP format) = "2011-08-11 04:27:12.000"
Process_Indicator = "Y"
When we tried to change the "Transaction Handling" Settings as
Isolation Level - None, Rows per trabsaction 0, Parameter array size 1,
it was updating, still with warnings. We are confused on the ACTUAL CAUSE.
Any inputs / resolution will be appreciated.
Thank you very much!