BusinessObjects Board

refresh report bo crash

building reports desktopintelligence
#1

When refreshing a report Business Objects keeps crashing.

I have two versions of the report, one which uses prompts and a second which uses queries that referenced a spreadsheet for query parameters.
Both reports crash when refreshing, particulary the spreadsheet based report. I have attached the report which uses the prompts.
I have also attached a log file from your dump screen.

BO Version 6.1b
Database oracle

not possible to add an attachments i am pasting log file here
1 processor Pentium Family 6 Model 11 Stepping 1
Windows 2000 Workstation v5.0 build 2195 (Service Pack 4)
Physical Total/Avail: 1.046.944 Kb / 250.384 Kb
Temp directory C:\DOCUME~1\pop\LOCALS~1\Temp\ (12.068.019 Kb available)
‘???’ video card
1024 x 768 in true color

Unhandled Exception
Code: c0000005
Description: EXCEPTION_ACCESS_VIOLATION

Call stack:

Module at 0x22250000: E:\apps\BusinessObjects Enterprise 6\bin\cube.dll v 61.21.0.226 [French (France)]
address: 0x2234a6f0
address: 0x01010006

Application:

584 “E:\apps\BusinessObjects Enterprise 6\bin\busobj.exe”
current thread 0x604
started: Friday, December 09, 2005 at 16:32 PM
ends: Friday, December 09, 2005 at 16:35 PM
User mode: 20319 ms Kernel mode: 3364 ms

Loaded modules:

0x00400000	E:\apps\BusinessObjects Enterprise 6\bin\busobj.exe	 v 61.21.0.226 	[English (United States)]
0x01310000	C:\WINNT\system32\SynTPFcs.dll	 v 6.0.20.0 	[English (United States)]
0x01810000	E:\apps\BusinessObjects Enterprise 6\bin\language\userappen.dll	 v 61.21.0.226 	[French (France)]
0x018A0000	E:\apps\BusinessObjects Enterprise 6\bin\language\dpvbadlgen.dll	 v 61.21.0.226 	[French (France)]
0x018C0000	E:\apps\BusinessObjects Enterprise 6\bin\language\dpxmlen.dll	 v 61.21.0.226 	[French (France)]
0x09840000	E:\apps\BusinessObjects Enterprise 6\bin\language\wdxdlgen.dll	 v 61.21.0.226 	[French (France)]
0x09850000	E:\apps\BusinessObjects Enterprise 6\bin\language\wdxsnden.dll	 v 61.21.0.226 	[French (France)]
0x09C60000	C:\PROGRA~1\DELL\ACCESS~1\Dadkeyb.dll	 v 0.0.0.0 
0x0F9A0000	C:\WINNT\system32\VBAJET32.DLL	 v 6.0.1.9431 	[English (United States)]
0x0F9C0000	C:\WINNT\system32\expsrv.dll	 v 6.0.72.9589 	[Language Neutral]
0x10000000	E:\apps\BusinessObjects Enterprise 6\dataAccess\RDBMS\legacy\sqbodbc.dll	 v 61.21.0.226 	[English (United States)]
0x1A400000	C:\WINNT\system32\urlmon.dll	 v 6.0.2800.1519 	[English (United States)]
0x1B000000	C:\WINNT\System32\msjet40.dll	 v 4.0.9025.0 	[Language Neutral]
0x1B2C0000	C:\WINNT\System32\msjter40.dll	 v 4.0.6508.0 	[Language Neutral]
0x1B2D0000	C:\WINNT\System32\MSJINT40.DLL	 v 4.0.6508.0 	[English (United States)]
0x1B5D0000	C:\WINNT\System32\mswstr10.dll	 v 4.0.6508.0 	[English (United States)]
0x1B810000	C:\WINNT\System32\msjtes40.dll	 v 4.0.9025.0 	[Language Neutral]
0x1F7A0000	C:\WINNT\system32\ODBC32.dll	 v 3.525.1022.0 	[English (United States)]
0x1F840000	C:\WINNT\system32\odbcint.dll	 v 3.525.1022.0 	[English (United States)]
0x1F8E0000	C:\WINNT\System32\odbcji32.dll	 v 4.0.6200.0 	[English (United States)]

Plz help me to resolv this isue

vishald1 (BOB member since 2006-01-06)

#2

Welcome to B:bob:B!

I’m afraid the attachments didn’t make it. Give it another try, and we’ll see if we can help.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

Dear Dwayne,

Thank you very much for your reply

I have pest the log file in my mail.

How to resolve this type of issue!!!. Issue occurs particularly with spread sheet report.
When I am trying to refresh other report then also Bo gets crashes.

Does it occur with one particular machine or it happen in all the machines?
Yes on other machine also.

Vishal

vishald1 (BOB member since 2006-01-06)

#4

Hi Vishal

See if this post helps you.

https://bobj-board.org/t/15541

Good luck
Rahul.

rahul80 (BOB member since 2005-01-30)

#5

Hi Rahul,

Thank you very much for providing me this link. I am working on this issue, with the help of link which you have provided.

vishald1 (BOB member since 2006-01-06)

#6

I have retested the report using the suggestions you have made, and it does appear to be more stable when setting the SQL option. Clearing the registry did not seem to make any improvements.
I still periodically recieve a error similar to before when refreshing the data providers -
Some of the reports I am using using conitions based upon other queries. I have noticed that these reports are more likely to crash or fail. E.g. I have a report which retrives data from a spreadsheet and then a number of queries which have conitions based upin the first query. I have notice that these reports more often crash or need the conditions to be removed
and re-added.

Plzz help

vishald1 (BOB member since 2006-01-06)