Last week I posted a crystal report question regarding subreports.
Troy responded with this message:
Do you have ODBC installed on the Vantage Server? And you are running the
report from the Vantage server? OR is the report being run from a client
via ODBC on the client, with the report residing on the client computer?
Troy Funte
Liberty Electronics
Here is the response to Troy's question:
The ODBC driver is installed on the server. Individually both reports run
without a problem. When one report is made a subreport of the other, it
crashes the Progress server. The report is being run from a client
workstation using the ODBC driver. The only error message I found was a
DRWatson log entry as follows:
Application exception occurred:
App: \\ruddles/i_90b_nt/90b/nt/patch/37c/work/oidrvr32.exe (pid=104)
When: 3/22/2001 @ 10:57:8.884
Exception number: e0000003
()
*----> System Information <----*
Computer Name: EEC_PDC
User Name: SYSTEM
Number of Processors: 2
Processor Type: x86 Family 6 Model 1 Stepping 9
Windows Version: 4.0
Current Build: 1381
Service Pack: 5
Current Type: Multiprocessor Free
Registered Organization: Electron Energy
Registered Owner: Electron Energy
*----> Task List <----*
0 Idle.exe
2 System.exe
30 smss.exe
42 csrss.exe
34 winlogon.exe
50 services.exe
53 lsass.exe
78 spoolss.exe
108 admsrvc.exe
113 benser.exe
123 jre.exe
142 CPQRCMC.exe
144 defwatch.exe
154 pds.exe
174 llssrv.exe
183 LogWatNT.exe
194 rtvscan.exe
203 OFMNT.exe
217 LOCATOR.exe
224 RpcSs.exe
229 SYSDOWN.exe
234 oibrkr32.exe
238 ups.exe
249 VncSBMgr.exe
262 hndlrsvc.exe
281 MsgSys.exe
292 iao.exe
297 xfr.exe
109 pvlsvr.exe
313 nsvr.exe
318 tcpsvcs.exe
131 DKService.exe
323 dns.exe
332 msdtc.exe
376 NscTop.exe
416 pstores.exe
419 qserver.exe
430 alertserver.exe
451 beserver.exe
507 bengine.exe
513 benetns.exe
52 prosrvc.exe
127 domtimes.exe
120 domtimem.exe
163 _mprosrv.exe
167 _mprshut.exe
103 _mprshut.exe
165 _mprshut.exe
544 _mprosrv.exe
580 _mprosrv.exe
610 _mprosrv.exe
168 _mprosrv.exe
104 oidrvr32.exe
570 _mprosrv.exe
94 _mprosrv.exe
622 drwtsn32.exe
0 _Total.exe
(00400000 - 005e5000) \\ruddles/i_90b_nt/90b/nt/patch/37c/work/oidrvr32.exe
(77f60000 - 77fbe000) dll\ntdll.dbg
(78000000 - 78040000)
(77f00000 - 77f5e000) dll\kernel32.dbg
(77dc0000 - 77dff000) dll\advapi32.dbg
(77e70000 - 77ec4000) dll\user32.dbg
(77ed0000 - 77efc000) dll\gdi32.dbg
(77e10000 - 77e67000) dll\rpcrt4.dbg
(77800000 - 7783a000) dll\netapi32.dbg
(77840000 - 77849000) dll\NetRap.dbg
(777e0000 - 777ed000) dll\samlib.dbg
(776d0000 - 776d8000) dll\wsock32.dbg
(776b0000 - 776c4000) dll\ws2_32.dbg
(776a0000 - 776a7000) dll\ws2help.dbg
(77bf0000 - 77bf7000) dll\rpcltc1.dbg
(77660000 - 7766f000) dll\msafd.dbg
(77690000 - 77699000) dll\wshtcpip.dbg
(74ff0000 - 74ffe000) dll\rnr20.dbg
(76ac0000 - 76add000) dll\imagehlp.dbg
State Dump for Thread Id 0x9f
eax=0012f494 ebx=7ffdf000 ecx=008c7a08 edx=00000000 esi=0012edc8
edi=0208002c
eip=77f1d493 esp=0012f490 ebp=0012f4e4 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246
function: RaiseException
77f1d476 83c604 add esi,0x4
77f1d479 8bc1 mov eax,ecx
77f1d47b 49 dec ecx
77f1d47c 85c0 test eax,eax
77f1d47e 75ef jnz RaiseException+0x46 (77f1d46f)
77f1d480 eb07 jmp RaiseException+0x60 (77f1d489)
77f1d482 c745c000000000 mov dword ptr [ebp-0x40],0x0
ss:015adeea=????????
77f1d489 8d45b0 lea eax,[ebp-0x50]
ss:015adeea=????????
77f1d48c 50 push eax
77f1d48d ff15b4c3f377
ds:77f3c3b4=77f88f6c
call dword ptr [GetDateFormatW+0x4d9f
(77f3c3b4)]
FAULT ->77f1d493 5e pop esi
77f1d494 8be5 mov esp,ebp
77f1d496 5d pop ebp
77f1d497 c21000 ret 0x10
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012f4e4 005b013f e0000003 00000000 00000000 00000000
kernel32!RaiseException
0012f510 0040a63f 00000000 0012f554 0012f518 005db480 oidrvr32!utcore
0012f52c 0040852f 00000002 00000002 00300ce4 00000001 oidrvr32!drexit
0012f554 004080f3 00007002 0012f570 000000a3 00300ce4 oidrvr32!msgout
0012f908 005ad367 000000a3 00000016 00000007 e900040e oidrvr32!msgn
0012f928 005ad485 00000007 e900040e 00000001 00000000 oidrvr32!seektobdll
0012f94c 005ad4f5 00000007 e900040e 008b36e8 00000800 oidrvr32!readfrmbdll
0012f96c 005b0ae7 00000007 e900040e 008b36e8 00000800 oidrvr32!readfrmdll
0012f988 0041f527 00000007 e900040e 008b36e8 00000800 oidrvr32!readfrm
0012f9a0 004d392b 008b36e8 e900040e 0012f9e4 00012017 oidrvr32!uttfbkf
0012f9bc 0049d3f2 008b36e8 e900040e 00000004 008b36e8 oidrvr32!mvsfbks
0012f9d4 0049d374 00339030 008b36e8 0012fa30 004bd1cd oidrvr32!bfsend
0012f9e4 004bd1cd 00339030 00000000 00000000 00000000 oidrvr32!bfsend
0012fa30 004b51fd 003396d0 00000000 005a0c7d 00340003 oidrvr32!rncloseqry
0012fa5c 00553d7a 00348b5f 003396d0 00120000 00000000 oidrvr32!rnsqcrclo
0012faa8 005529e2 0032df0c 0208002c 0012edc8 005db480 oidrvr32!hliclose
0012fad0 00431d03 0032df0c 00000002 00000000 00000000 oidrvr32!sqldynclose
0012fb20 00430d76 00302e5c 00333d20 0012fb40 00000068 oidrvr32!nsasrvhli
0012fb60 004309af 00302e5c 00000001 00000000 00000000 oidrvr32!nsasrvhli
0012ff4c 005b6a28 00000015 00300de0 00300c10 005bb000 oidrvr32!main
0012ffc0 77f1ba06 0208002c 0012edc8 7ffdf000 e0000003
oidrvr32!mainCRTStartup
0012fff0 00000000 005b6945 00000000 000000b0 00000100
kernel32!GetProcessPriorityBoost
00000000 00000000 00000000 00000000 00000000 00000000 oidrvr32!<nosymbols>
*----> Raw Stack Dump <----*
0012f490 c8 ed 12 00 03 00 00 e0 - 00 00 00 00 00 00 00 00
................
0012f4a0 93 d4 f1 77 00 00 00 00 - 36 14 00 78 00 00 2f 00
...w....6..x../.
0012f4b0 00 00 00 00 08 7a 8c 00 - 2c 00 08 02 c8 ed 12 00
.....z..,.......
0012f4c0 00 f0 fd 7f e0 f4 12 00 - 78 09 45 00 82 09 45 00
........x.E...E.
0012f4d0 00 00 00 00 7c 63 30 00 - a0 61 2f 00 b0 ff 12 00
....|c0..a/.....
0012f4e0 03 ef 00 78 10 f5 12 00 - 3f 01 5b 00 03 00 00 e0
...x....?.[.....
0012f4f0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0012f500 08 7a 8c 00 00 00 00 00 - 00 00 00 00 03 00 00 e0
.z..............
0012f510 2c f5 12 00 3f a6 40 00 - 00 00 00 00 54 f5 12 00
,...?.@.....T...
0012f520 18 f5 12 00 80 b4 5d 00 - 02 70 00 00 54 f5 12 00
......]..p..T...
0012f530 2f 85 40 00 02 00 00 00 - 02 00 00 00 e4 0c 30 00
/.@...........0.
0012f540 01 00 00 00 ab f5 12 00 - 00 00 00 00 00 02 00 00
................
0012f550 3b 00 00 00 08 f9 12 00 - f3 80 40 00 02 70 00 00
;.........@..p..
0012f560 70 f5 12 00 a3 00 00 00 - e4 0c 30 00 02 70 00 00
p.........0..p..
0012f570 53 59 53 54 45 4d 20 45 - 52 52 4f 52 3a 20 53 65 SYSTEM ERROR:
Se
0012f580 65 6b 20 65 72 72 6f 72 - 20 32 32 2c 20 66 69 6c ek error 22,
fil
0012f590 65 20 37 2c 20 61 64 64 - 72 20 2d 33 38 35 38 37 e 7,
addr -38587
0012f5a0 34 39 33 30 2e 20 28 31 - 36 33 29 00 ca 00 00 00 4930.
(163).....
0012f5b0 00 00 00 00 04 00 00 00 - 02 00 00 00 00 00 00 00
................
0012f5c0 d1 8a 8c 00 d5 8a 8c 00 - fd 8a 8c 00 17 00 15 00
................
Kathy Hambleton
Electron Energy Corporation
Troy responded with this message:
Do you have ODBC installed on the Vantage Server? And you are running the
report from the Vantage server? OR is the report being run from a client
via ODBC on the client, with the report residing on the client computer?
Troy Funte
Liberty Electronics
Here is the response to Troy's question:
The ODBC driver is installed on the server. Individually both reports run
without a problem. When one report is made a subreport of the other, it
crashes the Progress server. The report is being run from a client
workstation using the ODBC driver. The only error message I found was a
DRWatson log entry as follows:
Application exception occurred:
App: \\ruddles/i_90b_nt/90b/nt/patch/37c/work/oidrvr32.exe (pid=104)
When: 3/22/2001 @ 10:57:8.884
Exception number: e0000003
()
*----> System Information <----*
Computer Name: EEC_PDC
User Name: SYSTEM
Number of Processors: 2
Processor Type: x86 Family 6 Model 1 Stepping 9
Windows Version: 4.0
Current Build: 1381
Service Pack: 5
Current Type: Multiprocessor Free
Registered Organization: Electron Energy
Registered Owner: Electron Energy
*----> Task List <----*
0 Idle.exe
2 System.exe
30 smss.exe
42 csrss.exe
34 winlogon.exe
50 services.exe
53 lsass.exe
78 spoolss.exe
108 admsrvc.exe
113 benser.exe
123 jre.exe
142 CPQRCMC.exe
144 defwatch.exe
154 pds.exe
174 llssrv.exe
183 LogWatNT.exe
194 rtvscan.exe
203 OFMNT.exe
217 LOCATOR.exe
224 RpcSs.exe
229 SYSDOWN.exe
234 oibrkr32.exe
238 ups.exe
249 VncSBMgr.exe
262 hndlrsvc.exe
281 MsgSys.exe
292 iao.exe
297 xfr.exe
109 pvlsvr.exe
313 nsvr.exe
318 tcpsvcs.exe
131 DKService.exe
323 dns.exe
332 msdtc.exe
376 NscTop.exe
416 pstores.exe
419 qserver.exe
430 alertserver.exe
451 beserver.exe
507 bengine.exe
513 benetns.exe
52 prosrvc.exe
127 domtimes.exe
120 domtimem.exe
163 _mprosrv.exe
167 _mprshut.exe
103 _mprshut.exe
165 _mprshut.exe
544 _mprosrv.exe
580 _mprosrv.exe
610 _mprosrv.exe
168 _mprosrv.exe
104 oidrvr32.exe
570 _mprosrv.exe
94 _mprosrv.exe
622 drwtsn32.exe
0 _Total.exe
(00400000 - 005e5000) \\ruddles/i_90b_nt/90b/nt/patch/37c/work/oidrvr32.exe
(77f60000 - 77fbe000) dll\ntdll.dbg
(78000000 - 78040000)
(77f00000 - 77f5e000) dll\kernel32.dbg
(77dc0000 - 77dff000) dll\advapi32.dbg
(77e70000 - 77ec4000) dll\user32.dbg
(77ed0000 - 77efc000) dll\gdi32.dbg
(77e10000 - 77e67000) dll\rpcrt4.dbg
(77800000 - 7783a000) dll\netapi32.dbg
(77840000 - 77849000) dll\NetRap.dbg
(777e0000 - 777ed000) dll\samlib.dbg
(776d0000 - 776d8000) dll\wsock32.dbg
(776b0000 - 776c4000) dll\ws2_32.dbg
(776a0000 - 776a7000) dll\ws2help.dbg
(77bf0000 - 77bf7000) dll\rpcltc1.dbg
(77660000 - 7766f000) dll\msafd.dbg
(77690000 - 77699000) dll\wshtcpip.dbg
(74ff0000 - 74ffe000) dll\rnr20.dbg
(76ac0000 - 76add000) dll\imagehlp.dbg
State Dump for Thread Id 0x9f
eax=0012f494 ebx=7ffdf000 ecx=008c7a08 edx=00000000 esi=0012edc8
edi=0208002c
eip=77f1d493 esp=0012f490 ebp=0012f4e4 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246
function: RaiseException
77f1d476 83c604 add esi,0x4
77f1d479 8bc1 mov eax,ecx
77f1d47b 49 dec ecx
77f1d47c 85c0 test eax,eax
77f1d47e 75ef jnz RaiseException+0x46 (77f1d46f)
77f1d480 eb07 jmp RaiseException+0x60 (77f1d489)
77f1d482 c745c000000000 mov dword ptr [ebp-0x40],0x0
ss:015adeea=????????
77f1d489 8d45b0 lea eax,[ebp-0x50]
ss:015adeea=????????
77f1d48c 50 push eax
77f1d48d ff15b4c3f377
ds:77f3c3b4=77f88f6c
call dword ptr [GetDateFormatW+0x4d9f
(77f3c3b4)]
FAULT ->77f1d493 5e pop esi
77f1d494 8be5 mov esp,ebp
77f1d496 5d pop ebp
77f1d497 c21000 ret 0x10
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012f4e4 005b013f e0000003 00000000 00000000 00000000
kernel32!RaiseException
0012f510 0040a63f 00000000 0012f554 0012f518 005db480 oidrvr32!utcore
0012f52c 0040852f 00000002 00000002 00300ce4 00000001 oidrvr32!drexit
0012f554 004080f3 00007002 0012f570 000000a3 00300ce4 oidrvr32!msgout
0012f908 005ad367 000000a3 00000016 00000007 e900040e oidrvr32!msgn
0012f928 005ad485 00000007 e900040e 00000001 00000000 oidrvr32!seektobdll
0012f94c 005ad4f5 00000007 e900040e 008b36e8 00000800 oidrvr32!readfrmbdll
0012f96c 005b0ae7 00000007 e900040e 008b36e8 00000800 oidrvr32!readfrmdll
0012f988 0041f527 00000007 e900040e 008b36e8 00000800 oidrvr32!readfrm
0012f9a0 004d392b 008b36e8 e900040e 0012f9e4 00012017 oidrvr32!uttfbkf
0012f9bc 0049d3f2 008b36e8 e900040e 00000004 008b36e8 oidrvr32!mvsfbks
0012f9d4 0049d374 00339030 008b36e8 0012fa30 004bd1cd oidrvr32!bfsend
0012f9e4 004bd1cd 00339030 00000000 00000000 00000000 oidrvr32!bfsend
0012fa30 004b51fd 003396d0 00000000 005a0c7d 00340003 oidrvr32!rncloseqry
0012fa5c 00553d7a 00348b5f 003396d0 00120000 00000000 oidrvr32!rnsqcrclo
0012faa8 005529e2 0032df0c 0208002c 0012edc8 005db480 oidrvr32!hliclose
0012fad0 00431d03 0032df0c 00000002 00000000 00000000 oidrvr32!sqldynclose
0012fb20 00430d76 00302e5c 00333d20 0012fb40 00000068 oidrvr32!nsasrvhli
0012fb60 004309af 00302e5c 00000001 00000000 00000000 oidrvr32!nsasrvhli
0012ff4c 005b6a28 00000015 00300de0 00300c10 005bb000 oidrvr32!main
0012ffc0 77f1ba06 0208002c 0012edc8 7ffdf000 e0000003
oidrvr32!mainCRTStartup
0012fff0 00000000 005b6945 00000000 000000b0 00000100
kernel32!GetProcessPriorityBoost
00000000 00000000 00000000 00000000 00000000 00000000 oidrvr32!<nosymbols>
*----> Raw Stack Dump <----*
0012f490 c8 ed 12 00 03 00 00 e0 - 00 00 00 00 00 00 00 00
................
0012f4a0 93 d4 f1 77 00 00 00 00 - 36 14 00 78 00 00 2f 00
...w....6..x../.
0012f4b0 00 00 00 00 08 7a 8c 00 - 2c 00 08 02 c8 ed 12 00
.....z..,.......
0012f4c0 00 f0 fd 7f e0 f4 12 00 - 78 09 45 00 82 09 45 00
........x.E...E.
0012f4d0 00 00 00 00 7c 63 30 00 - a0 61 2f 00 b0 ff 12 00
....|c0..a/.....
0012f4e0 03 ef 00 78 10 f5 12 00 - 3f 01 5b 00 03 00 00 e0
...x....?.[.....
0012f4f0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0012f500 08 7a 8c 00 00 00 00 00 - 00 00 00 00 03 00 00 e0
.z..............
0012f510 2c f5 12 00 3f a6 40 00 - 00 00 00 00 54 f5 12 00
,...?.@.....T...
0012f520 18 f5 12 00 80 b4 5d 00 - 02 70 00 00 54 f5 12 00
......]..p..T...
0012f530 2f 85 40 00 02 00 00 00 - 02 00 00 00 e4 0c 30 00
/.@...........0.
0012f540 01 00 00 00 ab f5 12 00 - 00 00 00 00 00 02 00 00
................
0012f550 3b 00 00 00 08 f9 12 00 - f3 80 40 00 02 70 00 00
;.........@..p..
0012f560 70 f5 12 00 a3 00 00 00 - e4 0c 30 00 02 70 00 00
p.........0..p..
0012f570 53 59 53 54 45 4d 20 45 - 52 52 4f 52 3a 20 53 65 SYSTEM ERROR:
Se
0012f580 65 6b 20 65 72 72 6f 72 - 20 32 32 2c 20 66 69 6c ek error 22,
fil
0012f590 65 20 37 2c 20 61 64 64 - 72 20 2d 33 38 35 38 37 e 7,
addr -38587
0012f5a0 34 39 33 30 2e 20 28 31 - 36 33 29 00 ca 00 00 00 4930.
(163).....
0012f5b0 00 00 00 00 04 00 00 00 - 02 00 00 00 00 00 00 00
................
0012f5c0 d1 8a 8c 00 d5 8a 8c 00 - fd 8a 8c 00 17 00 15 00
................
Kathy Hambleton
Electron Energy Corporation