problemas con la primary key de una tabla!!!!!!
Publicado por Paula (1 intervención) el 22/02/2005 18:23:50
Les cuento que estoy trabajando con JDEdwards y con SQL y mi problema es que cuando intento recorrer una vista de una tabla aparece el siguiente mensaje de error y ya genere la tabla otra vez y sus indices!!!
Se les ocurre algo que pueda hacer???????
Este es el error que se genera, miren eso de " Exiting JDB_SelectKeyed with Failure " al final de todo!!!
[JDBOLEDB] SQL: request = 0x1431B260:1641: SELECT * FROM JDE_DEVELOPMENT.TESTDTA.F42119 WHERE ( ( SDMCU = ' 314' AND SDIVD >= 102001 AND SDIVD <= 103001 AND SDCRCD = 'USD' ) ) ORDER BY SDAN8 ASC.
[JDBOLEDB] error: Failure in object ODSelect / method ODSelect::execute().
[JDBOLEDB] error: HRESULT = 80040e31, SQLState = HYT00, NativeError = 0, msg = Timeout expired.
[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
Se les ocurre algo que pueda hacer???????
Este es el error que se genera, miren eso de " Exiting JDB_SelectKeyed with Failure " al final de todo!!!
[JDBOLEDB] SQL: request = 0x1431B260:1641: SELECT * FROM JDE_DEVELOPMENT.TESTDTA.F42119 WHERE ( ( SDMCU = ' 314' AND SDIVD >= 102001 AND SDIVD <= 103001 AND SDCRCD = 'USD' ) ) ORDER BY SDAN8 ASC.
[JDBOLEDB] error: Failure in object ODSelect / method ODSelect::execute().
[JDBOLEDB] error: HRESULT = 80040e31, SQLState = HYT00, NativeError = 0, msg = Timeout expired.
[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
Valora esta pregunta
0