AdsGetRecordCount() - Returning AE_SUCCESS with count 2^32 (4294967295)

[former_member230550]

Hi,

Under what conditions does AdsGetRecordCount() return a success code, but set the record count to 2^32 (2 to the power of 32)? It doesn't seem to be documented.

There definitely aren't that many records in my result set.

Also, what do I need to do to be able to raise incidents? When I try to do so I get a message saying I have no roles assigned.

[Former Member · Accepted solution]

From the AdsGetRecordCount documentation:

When using SQL statements and cursors the hObj parameter can be replaced with either a statement handle or a cursor handle. If passed a cursor handle, AdsGetRecordCount will return the row count of the cursor. If passed a statement handle, the returned value will be the number of rows affected by the last SQL statement or SQL script executed on this handle. If the last executed SQL statement is not a DML statement, or if the last executed SQL script does not have any DML statement, then the value returned will be -1 (0xFFFFFFFF). If there are multiple DML statements in the last executed SQL script, the value returned will be the cumulative updated record count of all DML statements in the script.

Perhaps that's the reason...

[former_member230550 · Accepted solution]

Thanks, I honestly read through that document several times but glossed over it each time

Perhaps you can help me with a follow up question. From my reading of that passage, provided I always pass in a cursor handle I should get a record count? It is only when I pass in a statement handle that I should be getting the -1?

We are in the process of upgrading from ADS 8 to ADS 11 have suddenly started receiving the -1 values.

Cheers!

[Former Member · Accepted solution]

From the documentation, yes.

If you pass a cursor you should always get the number of rows.

[former_member230550 · Accepted solution]

As it turned out we were passing in a statement handle that shares the same ID as an earlier cursor handle had. ADS was correctly returning the -1 result for the handle which now represents a statement, where we were expecting to get a result for a cursor.

My guess is that ADS 11 reuses handle id's much more than ADS 8 did, otherwise I'm at a loss to explain why this particular crash hasn't been seen before.

Thanks for the assistance!

[former_member207653]

https://websmp101.sap-ag.de/~sapidp/011000358700000560361996E

It sounds like you have not the correct permissions to create incidents. Please phone the Global Support Customer Interaction team. You can find phone numbers in the link above