"-1 Rows affected"-SQL Server Call Execute Failed

[major]

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!

[chulett]

Don't recall ever seeing a negative number in this context. Suggest you get your official support provider involved and also make sure (if you haven't already) that you are current on your fixpacks.

[ray.wurlod]

Are there earlier errors in the log, particularly from SQLAllocEnv() or SQLConnect() ? Can other jobs connect to this data source?

[major]

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!

[major]

Hi Ray,

There isn't any previous errors or other logs for the specific run.
We are able to connect and retrieve from this data source.

Issue occurs during INSERT/UPDATE and while we change the "Transaction Handling" options, the WARNINGS behave differently.
We are still to find a resolution.

Thanks

[SURA]

Is it ODBC Connector stage / ODBC Enterprise stage?

Try it both as well as Dynamic RDBMS

Just a guess.

DS User