Hello all,
Thanx for your input. Here is my situation. The report is not modified in any way it is just a copy of the original report. The R09321 (the original report) runs fine and it does not give me any errors.
I have enable logging to see where the error but it doesn't report anything like an error. Here is what I've done:
- When the report crashed I looked at the debug log to see what has gone wrong I did not see nothing:
[ QUOTE ]
Jun 30 10:52:19.181195 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181196 - 2692/1820 WRK:Starting jdeCallObject *** Start dumping data structure for business function GetAddressBookDescriptionA7
Jun 30 10:52:19.181197 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181198 - 2692/1820 WRK:Starting jdeCallObject IN->[ 1] <Item>: mnAddressNumber <type>: MATH_NUMERIC <Value>: [4360]
Jun 30 10:52:19.181199 - 2692/1820 WRK:Starting jdeCallObject IN->[ 2] <Item>: szAddressBookDescription <type>: STRING <Value>: []
Jun 30 10:52:19.181200 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181201 - 2692/1820 WRK:Starting jdeCallObject *** End dumping data structure for business function GetAddressBookDescriptionA7
Jun 30 10:52:19.181202 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181203 - 2692/1820 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Jun 30 10:52:19.181204 - 2692/1820 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Jun 30 10:52:19.181205 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_InitBhvr
Jun 30 10:52:19.181206 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_InitBhvr with Success (UserHandle 1925A958)
Jun 30 10:52:19.181207 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_OpenTable(Table = F0101)
Jun 30 10:52:19.181208 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_OpenTable(Table = F0101) with Success
Jun 30 10:52:19.181209 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_FetchKeyed
Jun 30 10:52:19.181210 - 2692/1820 WRK:Starting jdeCallObject ORACLE DBRsetReq conn=084D24C0 requ=20548D60 jdeent9 (jdeent9)
Jun 30 10:52:19.181211 - 2692/1820 WRK:Starting jdeCallObject SELECT ABAN8, ABALPH FROM TESTDTA.F0101 WHERE ( ABAN8 = 4360.000000 )
Jun 30 10:52:19.181212 - 2692/1820 WRK:Starting jdeCallObject ORACLE DBFetch conn=084D24C0 requ=20548D60 maxrows=100
Jun 30 10:52:19.181213 - 2692/1820 WRK:Starting jdeCallObject Fetched the record
Jun 30 10:52:19.181214 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_CloseTable
Jun 30 10:52:19.181215 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_CloseTable(Table = F0101)
Jun 30 10:52:19.181216 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_ClearSequencing
Jun 30 10:52:19.181217 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_ClearSequencing with Success
Jun 30 10:52:19.181218 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_ClearSelection
Jun 30 10:52:19.181219 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_ClearSelection with Success
Jun 30 10:52:19.181220 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_ClearAggregate
Jun 30 10:52:19.181221 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_ClearAggregate with Success
Jun 30 10:52:19.181222 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_ClearGroupBy
Jun 30 10:52:19.181223 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_ClearGroupBy with Success
Jun 30 10:52:19.181224 - 2692/1820 WRK:Starting jdeCallObject ORACLE DBFreeReq conn=084D24C0 requ=20548D60 CLOSE
Jun 30 10:52:19.181225 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_ClearBuffers
Jun 30 10:52:19.181226 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_ClearBuffers with success.
Jun 30 10:52:19.181227 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_CloseTable(Table = F0101) with Success
Jun 30 10:52:19.181228 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_CloseTable with Success
Jun 30 10:52:19.181229 - 2692/1820 WRK:Starting jdeCallObject Entering JDB_FreeBhvr (UserHandle 1925A958)
Jun 30 10:52:19.181230 - 2692/1820 WRK:Starting jdeCallObject Exiting JDB_FreeBhvr with Success(UserHandle 1925A958)
Jun 30 10:52:19.181231 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181232 - 2692/1820 WRK:Starting jdeCallObject *** Start dumping data structure for business function GetAddressBookDescriptionA7
Jun 30 10:52:19.181233 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
[/ QUOTE ]
the log end's here.
When I click the window with the error to terminate the UBE the log continues normally.
[ QUOTE ]
un 30 10:52:19.181234 - 2692/1820 WRK:Starting jdeCallObject OUT->[ 1] <Item>: mnAddressNumber <type>: MATH_NUMERIC <Value>: [4360]
Jun 30 10:52:19.181235 - 2692/1820 WRK:Starting jdeCallObject OUT->[ 2] <Item>: szAddressBookDescription <type>: STRING <Value>: [Allen Supplies ]
Jun 30 10:52:19.181236 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181237 - 2692/1820 WRK:Starting jdeCallObject *** End dumping data structure for business function GetAddressBookDescriptionA7
Jun 30 10:52:19.181238 - 2692/1820 WRK:Starting jdeCallObject **********************************************************************************
Jun 30 10:52:19.181239 - 2692/1820 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Jun 30 10:52:19.181240 - 2692/1820 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Jun 30 10:52:19.181241 - 2692/1820 WRK:Starting jdeCallObject Return value is 0 for GetAddressBookDescriptionA7. (BSFNLevel = 1)
Jun 30 10:53:03.985000 - 2692/1820 UNKNOWN Entering JDB_FreeUser (UserHandle 1925A958)
Jun 30 10:53:03.985001 - 2692/1820 UNKNOWN Cleaning up 2 cached spec handles.
Jun 30 10:53:03.985002 - 2692/1820 UNKNOWN Checking in cached spec handle, 18e1f0e8.
Jun 30 10:53:03.985003 - 2692/1820 UNKNOWN Checking in cached spec handle, 193bee30.
Jun 30 10:53:03.985004 - 2692/1820 UNKNOWN JDB4200003 - OPEN TABLE NOT CLOSED = F0411
Jun 30 10:53:03.985006 - 2692/1820 UNKNOWN Entering JDB_CloseTable
Jun 30 10:53:03.985007 - 2692/1820 UNKNOWN Entering JDB_ClearSequencing
Jun 30 10:53:03.985008 - 2692/1820 UNKNOWN Exiting JDB_ClearSequencing with Success
Jun 30 10:53:03.985009 - 2692/1820 UNKNOWN Entering JDB_ClearSelection
Jun 30 10:53:03.985010 - 2692/1820 UNKNOWN Exiting JDB_ClearSelection with Success
Jun 30 10:53:03.985011 - 2692/1820 UNKNOWN Entering JDB_ClearAggregate
....
[/ QUOTE ]
with the errors about the oppened tables.
I mention that in the report I have commented out the line where GetAddressBookDescriptionA7 is called, and then the report fails in other BSFN.
Thanx,
Alex.