chakri
Member
Hi ALL,
Here I have a request to you all experts,do any body know what Business Functions is used or triggered to Insert into F96225.
Here I am attaching part of the DEBUG log which is generated while applying an ESU.
Strange thing we noticed is busbuild is taking long time like forever.
when examined the log file it is the JDB_InsertTable(Exit) which is taking long timeapprx 10min,and this is repeating for every insert.
Nov 12 10:41:47.354000 - 4384/5900 FOREIGN_THREAD SELECT * FROM SY811.F96225 WHERE ( HDPKGNAME = 'ESTEST03' AND HDPATHCD = 'ES811' AND HDDATP = 'CLIENT' AND HDBLDDTE = 107316 AND HDBLDTME = 104000.000000 AND HDPKGOPTION = 'CDMDSCH' ) ORDER BY HDPKGNAME ASC,HDPATHCD ASC,HDDATP ASC,HDBLDDTE ASC,HDBLDTME ASC,HDPKGOPTION ASC,HDVERS ASC
Nov 12 10:41:47.354001 - 4384/5900 FOREIGN_THREAD Exiting JDB_SelectKeyed with Success
Nov 12 10:41:47.354002 - 4384/5900 FOREIGN_THREAD ORACLE DBFetch conn=05298748 requ=05D28FD8 maxrows=100
Nov 12 10:41:47.354003 - 4384/5900 FOREIGN_THREAD No More Data found
Nov 12 10:41:47.354004 - 4384/5900 FOREIGN_THREAD Entering JDB_InsertTable(Table F96225)
Nov 12 10:41:47.354005 - 4384/5900 FOREIGN_THREAD ORACLE DBRsetReq conn=05298748 requ=05F2ACE8 SERV-DB1 (ajcprodjde)
Nov 12 10:41:47.354006 - 4384/5900 FOREIGN_THREAD INSERT INTO SY811.F96225 (HDPKGNAME, HDPATHCD, HDDATP, HDBLDDTE, HDBLDTME, HDPKGOPTION, HDPKGOPER, HDVERS, HDSPECREAD, HDSPECWRIT, HDPACKREAD, HDPACKWRIT, HDSPECSTS, HDPACKSTS, HDSPECERROR, HDPACKERROR, HDPKGBULFUT5, HDPKGBULFUT6, HDPKGBULFUT7, HDPKGBULFUT8, HDPID, HDJOBN, HDUPMJ, HDUPMT, HDUSER) VALUES ('ESTEST03','ES811','CLIENT',107316,104000.000000,'CDMDSCH','03',' ',0.000000,0.000000,0.000000,0.000000,'03','01',' ',' ',' ',' ',' ',' ','BUSBUILD','SERV-DEP1',107316,104147.000000,'PSFT')
Nov 12 10:41:47.354007 - 4384/5900 FOREIGN_THREAD Exiting JDB_InsertTable with Success(Table F96225)
Nov 12 10:51:44.213000 - 4384/5900 FOREIGN_THREAD Entering JDB_GetUser
Nov 12 10:51:44.213001 - 4384/5900 FOREIGN_THREAD Exiting JDB_GetUser
Nov 12 10:51:44.213002 - 4384/5900 FOREIGN_THREAD Entering JDB_ClearSelection
Nov 12 10:51:44.213003 - 4384/5900 FOREIGN_THREAD Exiting JDB_ClearSelection with Success
Nov 12 10:51:44.213004 - 4384/5900 FOREIGN_THREAD Entering JDB_SelectKeyed
Nov 12 10:51:44.213005 - 4384/5900 FOREIGN_THREAD ORACLE DBInitReq conn=05298748 requ=05D28FD8 SERV-DB1 (ajcprodjde) reuse .
Please help me out if you have any Idea or any proved solution.
Thanks in advance.
Kalyan/ERP 8.11/SP1 Windows Oracle 10g(64Bit).
Here I have a request to you all experts,do any body know what Business Functions is used or triggered to Insert into F96225.
Here I am attaching part of the DEBUG log which is generated while applying an ESU.
Strange thing we noticed is busbuild is taking long time like forever.
when examined the log file it is the JDB_InsertTable(Exit) which is taking long timeapprx 10min,and this is repeating for every insert.
Nov 12 10:41:47.354000 - 4384/5900 FOREIGN_THREAD SELECT * FROM SY811.F96225 WHERE ( HDPKGNAME = 'ESTEST03' AND HDPATHCD = 'ES811' AND HDDATP = 'CLIENT' AND HDBLDDTE = 107316 AND HDBLDTME = 104000.000000 AND HDPKGOPTION = 'CDMDSCH' ) ORDER BY HDPKGNAME ASC,HDPATHCD ASC,HDDATP ASC,HDBLDDTE ASC,HDBLDTME ASC,HDPKGOPTION ASC,HDVERS ASC
Nov 12 10:41:47.354001 - 4384/5900 FOREIGN_THREAD Exiting JDB_SelectKeyed with Success
Nov 12 10:41:47.354002 - 4384/5900 FOREIGN_THREAD ORACLE DBFetch conn=05298748 requ=05D28FD8 maxrows=100
Nov 12 10:41:47.354003 - 4384/5900 FOREIGN_THREAD No More Data found
Nov 12 10:41:47.354004 - 4384/5900 FOREIGN_THREAD Entering JDB_InsertTable(Table F96225)
Nov 12 10:41:47.354005 - 4384/5900 FOREIGN_THREAD ORACLE DBRsetReq conn=05298748 requ=05F2ACE8 SERV-DB1 (ajcprodjde)
Nov 12 10:41:47.354006 - 4384/5900 FOREIGN_THREAD INSERT INTO SY811.F96225 (HDPKGNAME, HDPATHCD, HDDATP, HDBLDDTE, HDBLDTME, HDPKGOPTION, HDPKGOPER, HDVERS, HDSPECREAD, HDSPECWRIT, HDPACKREAD, HDPACKWRIT, HDSPECSTS, HDPACKSTS, HDSPECERROR, HDPACKERROR, HDPKGBULFUT5, HDPKGBULFUT6, HDPKGBULFUT7, HDPKGBULFUT8, HDPID, HDJOBN, HDUPMJ, HDUPMT, HDUSER) VALUES ('ESTEST03','ES811','CLIENT',107316,104000.000000,'CDMDSCH','03',' ',0.000000,0.000000,0.000000,0.000000,'03','01',' ',' ',' ',' ',' ',' ','BUSBUILD','SERV-DEP1',107316,104147.000000,'PSFT')
Nov 12 10:41:47.354007 - 4384/5900 FOREIGN_THREAD Exiting JDB_InsertTable with Success(Table F96225)
Nov 12 10:51:44.213000 - 4384/5900 FOREIGN_THREAD Entering JDB_GetUser
Nov 12 10:51:44.213001 - 4384/5900 FOREIGN_THREAD Exiting JDB_GetUser
Nov 12 10:51:44.213002 - 4384/5900 FOREIGN_THREAD Entering JDB_ClearSelection
Nov 12 10:51:44.213003 - 4384/5900 FOREIGN_THREAD Exiting JDB_ClearSelection with Success
Nov 12 10:51:44.213004 - 4384/5900 FOREIGN_THREAD Entering JDB_SelectKeyed
Nov 12 10:51:44.213005 - 4384/5900 FOREIGN_THREAD ORACLE DBInitReq conn=05298748 requ=05D28FD8 SERV-DB1 (ajcprodjde) reuse .
Please help me out if you have any Idea or any proved solution.
Thanks in advance.
Kalyan/ERP 8.11/SP1 Windows Oracle 10g(64Bit).
