Random Table Convesion Error

[sselman]

I have been dealing with a problem with different table conversions erroring out for some time. These TCs are run multiple times a day with no problems. Every once in a while, 1 will error out for no apparent reason. On the next hourly run, it processes just fine. The data has not changed so I should be able to safely rule that out.

I get this same access violation error from time to time running 10 different TCs. Very confused.

Any ideas?

10976/10292 MAIN_THREAD Thu Mar 29 16:09:57.764001 Runbatch.c317
INITIALIZING RUNBATCH job: 695275

10976/10292 MAIN_THREAD Thu Mar 29 16:09:57.780000 ipcmisc.c299
process 10976 <runbatch.exe> registered in entry 11

10976/10292 MAIN_THREAD Thu Mar 29 16:09:57.780001 Runbatch.c462
Startup for User=schedusr, Env=PD9, Role=*ALL, Job#=695275

10976/10292 MAIN_THREAD Thu Mar 29 16:09:57.780002 Runbatch.c479
bAPListening=0

10976/10292 MAIN_THREAD Thu Mar 29 16:09:58.077000 zdrv.cpp328
Initializing the Z Driver

10976/10292 MAIN_THREAD Thu Mar 29 16:09:58.077001 zdrv.cpp342
Gettting user data from hEnv

10976/10292 MAIN_THREAD Thu Mar 29 16:09:58.077002 zdrv.cpp364
User data is SCHEDUSR, PD9

10976/10292 MAIN_THREAD Thu Mar 29 16:09:58.077003 zdrv.cpp373
Creating XML Session

10976/10292 MAIN_THREAD Thu Mar 29 16:09:59.436000 Rtk_expn.c525
RUN0000059 - Data type in expression does not match the data type of the dictionary item.

10976/10292 MAIN_THREAD Thu Mar 29 16:09:59.436001 ntexhnd.cpp101
Exception code: C0000005 ACCESS_VIOLATION

10976/10292 MAIN_THREAD Thu Mar 29 16:10:01.186000 ntexhnd.cpp151
====> Exception occurred with call stack:

TCMoveParam+19E E:\PeopleSoft\ddp\B9\system\bin32\tcengine.dll
TCPerformGBRCallBSFN+19F E:\PeopleSoft\ddp\B9\system\bin32\tcengine.dll
TCPerformGBR+14E E:\PeopleSoft\ddp\B9\system\bin32\tcengine.dll
TCRunJDBConversion+631 E:\PeopleSoft\ddp\B9\system\bin32\tcengine.dll
TCRunConversion+1CB E:\PeopleSoft\ddp\B9\system\bin32\tcengine.dll
TCStartEngine+1B6 E:\PeopleSoft\ddp\B9\system\bin32\tcengine.dll
TCEntryPoint+82 E:\PeopleSoft\ddp\B9\system\bin32\jdekrnl.dll
UBEReport_Start+2A6 E:\PeopleSoft\ddp\B9\system\bin32\jdekrnl.dll
ubeReport_EntryPoint+5F5 E:\PeopleSoft\ddp\B9\system\bin32\jdekrnl.dll
WinMain+1227 E:\PeopleSoft\ddp\B9\system\bin32\runbatch.exe
WinMainCRTStartup+185 E:\PeopleSoft\ddp\B9\system\bin32\runbatch.exe
IsProcessorFeaturePresent+9E C:\WINDOWS\system32\kernel32.dll

INFO: Done setting IPC Handle State structures to abandoned. Process exiting. iParam: 0000010976

 

[sselman]

Here is the log from the run which occurred 1 hour later and was successful. The data did not change (more data may have been added to the table, but the "bad" errors were still there)

8540/8780 MAIN_THREAD Thu Mar 29 17:10:10.813000 Runbatch.c317
INITIALIZING RUNBATCH job: 695424

8540/8780 MAIN_THREAD Thu Mar 29 17:10:10.813001 ipcmisc.c299
process 8540 <runbatch.exe> registered in entry 12

8540/8780 MAIN_THREAD Thu Mar 29 17:10:10.813002 Runbatch.c462
Startup for User=schedusr, Env=PD9, Role=*ALL, Job#=695424

8540/8780 MAIN_THREAD Thu Mar 29 17:10:10.813003 Runbatch.c479
bAPListening=0

8540/8780 MAIN_THREAD Thu Mar 29 17:10:11.328000 zdrv.cpp328
Initializing the Z Driver

8540/8780 MAIN_THREAD Thu Mar 29 17:10:11.328001 zdrv.cpp342
Gettting user data from hEnv

8540/8780 MAIN_THREAD Thu Mar 29 17:10:11.344000 zdrv.cpp364
User data is SCHEDUSR, PD9

8540/8780 MAIN_THREAD Thu Mar 29 17:10:11.344001 zdrv.cpp373
Creating XML Session

8540/8780 MAIN_THREAD Thu Mar 29 17:10:12.938000 Rtk_expn.c525
RUN0000059 - Data type in expression does not match the data type of the dictionary item.

8540/8780 WRK:Starting jdeCallObject Thu Mar 29 17:10:23.500000 ipcmisc.c299
API ipcSawUnregisterProcV1 : process 8540 unregistered in entry 12

8540/8780 WRK:Starting jdeCallObject Thu Mar 29 17:10:23.547000 zdrv.cpp389
Terminating Z driver

8540/8780 WRK:Starting jdeCallObject Thu Mar 29 17:10:23.547001 zdrv.cpp406
Calling freeSession

 

[BKalk]

Sean,

Did you ever find a resolution for this random table conversion error? We are having the exact same problem. We have several table conversion UBE's that have been running fine for 2+ years. When we upgraded from Windows 2000 to Windows 2003, we started seeing these intermittent errors. Oracle was hoping the issue would be resolved by going to the latest tools release; however, we just installed tools 8.96.1.0 and are still having the issue. Any additional information would be greatly appreciated!

Thanks,
Brenda Kalk

EnterpriseOne 8.10, Tools 8.96.1.0
Windows 2003, SQL 2000
Websphere 6

 

[sselman]

No I haven't. Someone else posted this

TC Error

I haven't seen the SAR yet though.