ERROR: Unable to locate table in specified datasource for section....

[Shirley]

Hi!

My problem is that I create a new key for the table F42119 and when I generate the index of the table appeared the following in the log:

Feb 21 17:09:29.387 - 1548/1508
[JDBOLEDB] SQL: request = 0x177714D8:2676: DROP INDEX TESTDTA.F42119.F42119_1.
Feb 21 17:09:29.402 - 1548/1508
[JDBOLEDB] error: Failure in object ODDropIndex / method ODDropIndex::execute().
Feb 21 17:09:29.402 - 1548/1508

[JDBOLEDB] error: HRESULT = 80040e14, SQLState = 42S12, NativeError = 3703, msg = Cannot drop the index 'TESTDTA.F42119.F42119_1', because it does not exist in the system catalog..
Feb 21 17:09:29.402 - 1548/1508

[JDBOLEDB] ODDBPerformRequest::main() 0x177714D8:2676 pSession = 0x1777E6C8; cursType = 4; syntaxFlag = 256.
Feb 21 17:09:29.402 - 1548/1608

[JDBOLEDB] error: DB API function DBPerformRequest failed; rc = 0.


Because of this, When I create any Business View with the table F42119 and I associated that BSVW with a saction in an UBE appeared the following message for example:
"Unable to locate table in specified datasource for section: Vista de F42119"

and in jde.log the following message:


1144/1824 Wed Feb 09 17:48:06.687 ODRequest.h661
error: Failure in object ODSelect / method ODSelect::execute().

1144/1824 Wed Feb 09 17:48:06.687 WRetObj.cpp321
error: HRESULT = 80004005, SQLState = UNKWN, NativeError = 0, msg = Unspecified error.

1144/1844 Wed Feb 09 17:48:06.687 ODDBPerformRequest.cpp155
error: DB API function DBPerformRequest failed; rc = 0.

1144/1844 Wed Feb 09 17:48:06.703 ODDBPerformRequest.cpp200
Failed processing SQL statement: SELECT * FROM JDE_DEVELOPMENT.TESTDTA.F42119 WHERE ( ( SDIVD >= ? AND SDIVD <= ? AND SDMCU = ? AND SDCRCD = ? ) ) ORDER BY SDDOCO ASC,SDDCTO ASC,SDKCOO ASC,SDLNID ASC.

1144/1844 Wed Feb 09 17:48:06.703 jdb_drvm.c942
JDB9900401 - Failed to execute db request

I really will be gratefull if somebody could help me!

Thankss!!

 

[Shirley]

hi! Please somebody can help me! because I generated the table and the indexes and the error still happend!!

I will give you more information, this is the log when I execute the UBE:

[JDBOLEDB] Info: Connection is lost and do 1 retry.
error: Failure in object ODSelect / method ODSelect::execute().
error: HRESULT = 80004005, SQLState = UNKWN, NativeError = 0, msg = Unspecified error.
[JDBOLEDB] ODDBPerformRequest::main() 0x1431B260:1641 pSession = 0x7E1B250; cursType = 4; syntaxFlag = 0.
error: DB API function DBPerformRequest failed; rc = 0.
Failed processing SQL statement: SELECT * FROM JDE_DEVELOPMENT.TESTDTA.F42119 WHERE ( ( SDMCU = ' 314' AND SDIVD >= 102001 AND SDIVD <= 103001 AND SDCRCD = 'USD' ) ) ORDER BY SDAN8 ASC.
JDB9900401 - Failed to execute db request
Exiting JDB_SelectKeyed with Failure

But I have already creted everything! what it could be happening here?

 

[apurva]

Hi,
I faced the same problem some times back but it was with the customized table. I simply generated the table again & the problem was solved.
You can try the same but need to take utmost care since a std table is involved in your case (take a proper back up of the data & then try it).
Wish you luck !!