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!
"-1 Rows affected"-SQL Server Call Execute Failed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
fixpacks up to date
Hi Chulett,
Thanks for the response, we verified the Fixpacks and all are up to date.
We are trying to contact support directly though, any other leeds in this regard ?
Thank you very much again!
Thanks for the response, we verified the Fixpacks and all are up to date.
We are trying to contact support directly though, any other leeds in this regard ?
Thank you very much again!