KevinCourtney
Active Member
Hello,
I have questions about the Table I/Os that use the Open/Close and Handles. I have not come across these before.
I'm researching some performance issues in the Homebuilder module and have narrowed some log errors down to the N44H0058 F44H611ProcessBidTiers:
In the jde.log I find this:
Failed to validate Request handle
In the jdedebug.log:
Exiting JDB_CloseTable with Failure
In the code:
The Open Statement:
VA evt_idF44H611Handle_HF44H61 = F44H611.Open Handle
Several Fetch Singles
F44H611(VA evt_idF44H611Handle_HF44H61).Fetch Single
And at the end of the function, the Close statement:
F44H611(VA evt_idF44H611Handle_HF44H61).Close
I don't see too many options to change how these statements work but the log errors can't be helping performance.
Can any of you please pass on your knowledge of these Handles and is there an advantage to use them over just the standard Fetch Singles? Any ideas why the Close would be raising an error in the log?
Thanks,
Kevin
I have questions about the Table I/Os that use the Open/Close and Handles. I have not come across these before.
I'm researching some performance issues in the Homebuilder module and have narrowed some log errors down to the N44H0058 F44H611ProcessBidTiers:
In the jde.log I find this:
Failed to validate Request handle
In the jdedebug.log:
Exiting JDB_CloseTable with Failure
In the code:
The Open Statement:
VA evt_idF44H611Handle_HF44H61 = F44H611.Open Handle
Several Fetch Singles
F44H611(VA evt_idF44H611Handle_HF44H61).Fetch Single
And at the end of the function, the Close statement:
F44H611(VA evt_idF44H611Handle_HF44H61).Close
I don't see too many options to change how these statements work but the log errors can't be helping performance.
Can any of you please pass on your knowledge of these Handles and is there an advantage to use them over just the standard Fetch Singles? Any ideas why the Close would be raising an error in the log?
Thanks,
Kevin