sat3314
Member
Hello All,
I am a an oracle dba trying to solve an issue that has all of us including JDE experts confusing.
We went ahead and partitioned F0911 table based on GLDGJ column.
Partition in oracle should be transparent from the JDE side.
But when we run a report through JDE, we get an error saying
------
Unable to execute - SELECT GLKCO, GLDCT, GLDOC, GLDGJ, GLJELN, GLEXTL, GLICU, GLICUT, GLDICJ, GLCO, GLANI, GLAID, GLMCU, GLOBJ, GLSBL, GLSBLT, GLLT, GLFY, GLCRCD, GLAA, GLU, GLUM, GLEXR, GLALT1, GLBCRC, GLCRRM FROM PRODSUPDTA.F0911 WHERE ( ( GLLT = :KEY1 AND GLDCT IN ( :KEY2,:KEY3,:KEY4 ) ) AND ( GLKCO = :KEY5 AND GLDGJ >= :KEY6 AND GLDGJ <= :KEY7 AND GLSBL = :KEY8 AND GLICU = :KEY9 AND GLDCT = :KEY10 ) ) ORDER BY GLKCO ASC,GLMCU ASC,GLDCT ASC,GLANI ASC,GLSBL ASC,GLICU ASC
Feb 11 17:34:35.776002 - 1552/2292 MAIN_THREAD OCI0000179 - Error - ORA-12801: error signaled in parallel query server P006, instance SERV-DB31:ajc64dev1 (1)
ORA-01722: invalid number
Feb 11 17:34:35.776004 - 1552/2292 MAIN_THREAD JDB9900401 - Failed to execute db request
Feb 11 17:34:35.776006 - 1552/2292 MAIN_THREAD Exiting JDB_SelectKeyed with Failure
--UBE--[0]-- Unable to locate table in specified datasource for section: Integrity (F0911)
Feb 11 17:34:35.870000 - 1552/2292 MAIN_THREAD Entering JDB_CloseView (VIEW = V554111B)
----------
We can run this select query with hard coded values from UTB or sqlplus or other oracle clients but not from the JDE application.
We get the invalid number error.
I am presuming that JDE is going to convert date column into julian date. Somewhere there is a conversion issue.
Has anyone come across this issue.
If so what needs to be done to resolve it.
Paritition is going to give us good benefits.
No help from JDE support on this so far.
Thanks
I am a an oracle dba trying to solve an issue that has all of us including JDE experts confusing.
We went ahead and partitioned F0911 table based on GLDGJ column.
Partition in oracle should be transparent from the JDE side.
But when we run a report through JDE, we get an error saying
------
Unable to execute - SELECT GLKCO, GLDCT, GLDOC, GLDGJ, GLJELN, GLEXTL, GLICU, GLICUT, GLDICJ, GLCO, GLANI, GLAID, GLMCU, GLOBJ, GLSBL, GLSBLT, GLLT, GLFY, GLCRCD, GLAA, GLU, GLUM, GLEXR, GLALT1, GLBCRC, GLCRRM FROM PRODSUPDTA.F0911 WHERE ( ( GLLT = :KEY1 AND GLDCT IN ( :KEY2,:KEY3,:KEY4 ) ) AND ( GLKCO = :KEY5 AND GLDGJ >= :KEY6 AND GLDGJ <= :KEY7 AND GLSBL = :KEY8 AND GLICU = :KEY9 AND GLDCT = :KEY10 ) ) ORDER BY GLKCO ASC,GLMCU ASC,GLDCT ASC,GLANI ASC,GLSBL ASC,GLICU ASC
Feb 11 17:34:35.776002 - 1552/2292 MAIN_THREAD OCI0000179 - Error - ORA-12801: error signaled in parallel query server P006, instance SERV-DB31:ajc64dev1 (1)
ORA-01722: invalid number
Feb 11 17:34:35.776004 - 1552/2292 MAIN_THREAD JDB9900401 - Failed to execute db request
Feb 11 17:34:35.776006 - 1552/2292 MAIN_THREAD Exiting JDB_SelectKeyed with Failure
--UBE--[0]-- Unable to locate table in specified datasource for section: Integrity (F0911)
Feb 11 17:34:35.870000 - 1552/2292 MAIN_THREAD Entering JDB_CloseView (VIEW = V554111B)
----------
We can run this select query with hard coded values from UTB or sqlplus or other oracle clients but not from the JDE application.
We get the invalid number error.
I am presuming that JDE is going to convert date column into julian date. Somewhere there is a conversion issue.
Has anyone come across this issue.
If so what needs to be done to resolve it.
Paritition is going to give us good benefits.
No help from JDE support on this so far.
Thanks