WorldJDE
Well Known Member
Hello All,
We are having an issue in running an application that is taking 2-3 minutes to display 1000 records from F0411 table.
Checked from database end and there is no issue from backend side. No issue with the indexes even.
I am trying to analyse the logs and not sure of how to read the entries.
Seems to be related to Synchronous call to some Business Function.
I can see the time difference like for executing one Event it starts at 08:42:02 then the immediate next event is fired at 08:45:45. What has happened in the time between?
If I read the debuglog, I see enteries like:
Jun 06 08:42:14 ** 3732/3584 *** Start dumping data structure for business function FormatCompany
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/3584 OUT->[ 1] <Item>: idBhvrErrorId <type>: ID <Value>: [73121560]
Jun 06 08:42:14 ** 3732/3584 OUT->[ 2] <Item>: szBehaviorEditString <type>: STRING <Value>: []
Jun 06 08:42:14 ** 3732/3584 OUT->[ 3] <Item>: szDescription001 <type>: STRING <Value>: []
Jun 06 08:42:14 ** 3732/3584 OUT->[ 4] <Item>: szCompany <type>: STRING <Value>: [ ]
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/3584 *** End dumping data structure for business function FormatCompany
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/3584 Return value is 0 for FormatCompany. (BSFNLevel = 1)
Jun 06 08:42:14 ** 3732/3584 Entering JDB_AuditingOn
Jun 06 08:42:14 ** 3732/3584 Exiting JDB_AuditingOn with success
Jun 06 08:42:14 ** 3732/3584 Calling Business function FormatCompany for JDE. Application Name [P0413M], Version [ZJDE0001] (BSFNLevel = 1)
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 *** Start dumping data structure for business function IsColumnInAddressBook
Jun 06 08:42:14 ** 3732/4004 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 OUT->[ 1] <Item>: idBhvrErrorId <type>: ID <Value>: [0]
Jun 06 08:42:14 ** 3732/4004 OUT->[ 2] <Item>: szBehaviorEditString <type>: STRING <Value>: [5058]
Jun 06 08:42:14 ** 3732/4004 OUT->[ 3] <Item>: szDescription001 <type>: STRING <Value>: [EMO AS ]
Jun 06 08:42:14 ** 3732/4004 OUT->[ 4] <Item>: mnAddressnumber <type>: MATH_NUMERIC <Value>: [5058]
Jun 06 08:42:14 ** 3732/4004 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 *** End dumping data structure for business function IsColumnInAddressBook
Jun 06 08:42:14 ** 3732/4004 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 Return value is 0 for IsColumnInAddressBook. (BSFNLevel = 1)
Jun 06 08:45:12 ** 3732/3584 CRTBusinessView::SelectKeyed Call to JDB_SelectKeyed failed[T:e00 F:C:\b7\system\JDEUSER\jdecgrt\RT_BVIEW.CPP Ln:184 Lv:LEVEL1]
Jun 06 08:45:12 ** 3732/3584 Entering JDB_SetRequestOptions (Option No = 7 , Setting = 22)
Jun 06 08:45:12 ** 3732/3584 RT: >>>Beginning ER: Last Grid Record Has Been Read App: Form: W0413ME [T:e00 F:C:\b7\system\JDEUSER\jdecgrt\RT_ER.cpp Ln:2977 Lv:LEVEL3]
Jun 06 08:45:12 ** 3732/3584 RT: <<<Finished ER: Last Grid Record Has Been Read App: Form: W0413ME [T:e00 F:C:\b7\system\JDEUSER\jdecgrt\RT_ER.cpp Ln:3001 Lv:LEVEL3]
I don't know what it means by BF: IsColumnInAddressBook and FormatCompany.
There are no such Busines Functions in the code.
If possible kindly put an insight into Levels as(BSFNLevel = 1)
I am very much confused.
Release: B7333, SP-23
Many Thanks in advance.
Regards
World JDE
We are having an issue in running an application that is taking 2-3 minutes to display 1000 records from F0411 table.
Checked from database end and there is no issue from backend side. No issue with the indexes even.
I am trying to analyse the logs and not sure of how to read the entries.
Seems to be related to Synchronous call to some Business Function.
I can see the time difference like for executing one Event it starts at 08:42:02 then the immediate next event is fired at 08:45:45. What has happened in the time between?
If I read the debuglog, I see enteries like:
Jun 06 08:42:14 ** 3732/3584 *** Start dumping data structure for business function FormatCompany
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/3584 OUT->[ 1] <Item>: idBhvrErrorId <type>: ID <Value>: [73121560]
Jun 06 08:42:14 ** 3732/3584 OUT->[ 2] <Item>: szBehaviorEditString <type>: STRING <Value>: []
Jun 06 08:42:14 ** 3732/3584 OUT->[ 3] <Item>: szDescription001 <type>: STRING <Value>: []
Jun 06 08:42:14 ** 3732/3584 OUT->[ 4] <Item>: szCompany <type>: STRING <Value>: [ ]
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/3584 *** End dumping data structure for business function FormatCompany
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/3584 Return value is 0 for FormatCompany. (BSFNLevel = 1)
Jun 06 08:42:14 ** 3732/3584 Entering JDB_AuditingOn
Jun 06 08:42:14 ** 3732/3584 Exiting JDB_AuditingOn with success
Jun 06 08:42:14 ** 3732/3584 Calling Business function FormatCompany for JDE. Application Name [P0413M], Version [ZJDE0001] (BSFNLevel = 1)
Jun 06 08:42:14 ** 3732/3584 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 *** Start dumping data structure for business function IsColumnInAddressBook
Jun 06 08:42:14 ** 3732/4004 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 OUT->[ 1] <Item>: idBhvrErrorId <type>: ID <Value>: [0]
Jun 06 08:42:14 ** 3732/4004 OUT->[ 2] <Item>: szBehaviorEditString <type>: STRING <Value>: [5058]
Jun 06 08:42:14 ** 3732/4004 OUT->[ 3] <Item>: szDescription001 <type>: STRING <Value>: [EMO AS ]
Jun 06 08:42:14 ** 3732/4004 OUT->[ 4] <Item>: mnAddressnumber <type>: MATH_NUMERIC <Value>: [5058]
Jun 06 08:42:14 ** 3732/4004 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 *** End dumping data structure for business function IsColumnInAddressBook
Jun 06 08:42:14 ** 3732/4004 **********************************************************************************
Jun 06 08:42:14 ** 3732/4004 Return value is 0 for IsColumnInAddressBook. (BSFNLevel = 1)
Jun 06 08:45:12 ** 3732/3584 CRTBusinessView::SelectKeyed Call to JDB_SelectKeyed failed[T:e00 F:C:\b7\system\JDEUSER\jdecgrt\RT_BVIEW.CPP Ln:184 Lv:LEVEL1]
Jun 06 08:45:12 ** 3732/3584 Entering JDB_SetRequestOptions (Option No = 7 , Setting = 22)
Jun 06 08:45:12 ** 3732/3584 RT: >>>Beginning ER: Last Grid Record Has Been Read App: Form: W0413ME [T:e00 F:C:\b7\system\JDEUSER\jdecgrt\RT_ER.cpp Ln:2977 Lv:LEVEL3]
Jun 06 08:45:12 ** 3732/3584 RT: <<<Finished ER: Last Grid Record Has Been Read App: Form: W0413ME [T:e00 F:C:\b7\system\JDEUSER\jdecgrt\RT_ER.cpp Ln:3001 Lv:LEVEL3]
I don't know what it means by BF: IsColumnInAddressBook and FormatCompany.
There are no such Busines Functions in the code.
If possible kindly put an insight into Levels as(BSFNLevel = 1)
I am very much confused.
Release: B7333, SP-23
Many Thanks in advance.
Regards
World JDE