Multi-Row SQL Extendfetch faild

[javidahmad]

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

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)

F5301BZ1

Database Business Data - CRP

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

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

S1010

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.



Javid




Win NT 4.0, SQL 7.0,Xe sp 16.1

 

[Zoltan_Gyimesi]

Javid,

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.

Regards,
Zoltán

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

 

[David Robertson]

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,
David