BusinessObjects Board

Automation Exception

building semantic layer
#1

I’m getting the following error when I try to parse this object

Decode(@Select(Roll 3 Mth Product TRx’s\Migraine Market Roll 3 Mth TRx),0,0,@Select(Roll 3 Mth Product TRx’s\KOTE/S)/@Select(Roll 3 Mth Product TRx’s\Migraine Market Roll 3 Mth TRx)

It parses fine when I do it throught the check integrity. What is going on here, I’ve tried the Case statement as well and it still crashes

Please Help Bo 5.1.6 Oracle 8.1 :shock:

1 processor Pentium Family 6 Model 8 Stepping 6
Windows 2000 Workstation v5.0 build 2195 (Service Pack 2)
Physical Total/Avail: 259.664 Kb / 56.292 Kb
Temp directory C:\DOCUME~1\wooldma\LOCALS~1\Temp\ (9955408 Kb available)
‘Intel815 Video Accelerator’ video card
1024 x 768 with 65536 colors

Unhandled Exception
Code: c0000005
Description: EXCEPTION_ACCESS_VIOLATION

Call stack:

Module at 0x60400000: c:\Oracle\Ora81\bin\ORACLIENT8.DLL v 0.0.0.0 [English (United States)]
address: 0x60429373
address: 0x60489b53
address: 0x604843f1
address: 0x60469c14
Module at 0x032a0000: c:\Oracle\Ora81\bin\OCIW32.dll v 1.0.0.5 [English (United States)]
address: 0x032a1a80
Module at 0x34520000: C:\Program Files\Business Objects\Data Access 5.0\SQBOCI50.DLL
address: 0x34527a51
address: 0x345282e9
address: 0x34534360
Module at 0x31b20000: C:\Program Files\Business Objects\BusinessObjects 5.0\cnxsrv50.dll
address: 0x31b3be6a
address: 0x0104ed26
address: 0x83ec8b55

mwooldri :us: (BOB member since 2002-07-10)

#2

are you crashing in reporter? If so Nick daniels has a the definitive post on the topic:

Do try and clean out your temp folder too. JP brooks has a post on universe generated unhandled exception errors in the same string.

SteveBickerton :canada: (BOB member since 2002-08-15)

#3

It does it in Desinger when I try and parse an object. The parse works when I do it through the check integrity. One user said that he was modifying objects at a high rate of speed, well, I have been doing that. Modifying, saving, testing, modifying, saving, testing, all day over and over again, ohh well, the objects work in reporter, I just don’t like the fact that Desinger crashes

mwooldri :us: (BOB member since 2002-07-10)

#4

Have you considered parsing it on some other computer?

reemagupta (BOB member since 2002-09-18)

#5

I’ve never had designer crash when parsing an individual object, of course we’re still on 5.0.4.

Do you have quick parsing or thorough parsing selected in the Integrity Check Dialogue. if on quick, when you switch it to thorough, does it crash? very wierd behavior…

SteveBickerton :canada: (BOB member since 2002-08-15)

#6

I’ve had Designer crash while parsing objects that were particularly complex (like lengthy Case statements). I have always wondered if it was at a certain number of characters in the Select statement, but haven’t taken the time to prove it. The interesting thing though, is that it crashes ONLY when parsing the individual object. It would pass the integrity check (thorough) just fine.

I guess the solution is like the old joke. Patient: “Doc, my neck hurts when I do this.” Doctor: “Well then don’t do that!” I’ve learned to save often, and if it crashes when parsing, then run the integrity check instead.

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

#7

That’s exactly what is going on. It parses through check integrity but not individually. The thing is, I’m also using lengthy Case Statements, as well as Decodes.

mwooldri :us: (BOB member since 2002-07-10)