Multi-Row SQL Extendfetch faild


Active Member
My consultant has created a custom BSFN that queries F5301BZ1 table. When

the custom BSFN locally or on the Enterprise server, he is getting the

following error message:

1192/1000 Mon Oct 01 09:15:28 2001 JTP_CM.C1090

JDB9909007 - Unable to obtain driver request handle

1192/1312 Mon Oct 01 09:15:28 2001 ODBC_P1.C1572

ODB0000179 - Multi-row SQLExtendedFetch failed in Table(1st)


Database Business Data - CRP

1192/1312 Mon Oct 01 09:15:28 2001 ODBC_P1.C1577

[Microsoft][ODBC Driver Manager] Function sequence error - SQLSTATE:


1192/1312 Mon Oct 01 09:15:28 2001 jdb_drvm.c947

JDB9900172 - Failed to exeute db fetch

This only happens when code uses secondary index of the table; using primary

index does not generate the error message.

Thanx in advanced.


Win NT 4.0, SQL 7.0,Xe sp 16.1


Legendary Poster

Have you tried already to re-genarate the indicies of your F5301BZ1 table?

If the problem still exist after re-generation then try to re-create the Table I/O statement(s) in your BSFN.

Please, let us know your results. Thanks.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

David Robertson

Reputable Poster
I get something very similar to this with APPL's and UBE's that use a new secondary index over the TBLE. When trasfering, the new secondary index is often forgotten, so does not exist in the new environment. Just regenerating the index fixes it for me.

Good luck,