BusinessObjects Board

Designer crashes when using DECODE/CASE WHEN

building semantic layer
#1

Hi All,

Based on the values I have to open different reports in WebI/WebISDK, so for that that I modified my object defination in universe like this.

Case When column = ‘AA’ THEN ‘’||Table.column||’’ when column = ‘BB’ then ‘’||Table.column||’’ ELSE tablename.column END

like that I have around 15 values…

I added like this upto 5 but after 6th vlaue the Designer crahes with the following error msg…

1 processor Pentium Family 6 Model 8 Stepping 10
Windows 2000 Workstation v5.0 build 2195 (Service Pack 3)
Physical Total/Avail: 259.600 Kb / 54.068 Kb
Temp directory C:\DOCUME~1\kkum\LOCALS~1\Temp\ (14590688 Kb available)
‘Unknown’ 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: 0x60423a73
address: 0x60486493
address: 0x60480d31
address: 0x60460bc4
Module at 0x01b70000: C:\Oracle\Ora81\bin\OCIW32.dll v 1.0.0.5 [English (United States)]
address: 0x01b72217
Module at 0x34540000: C:\Program Files\Business Objects\Data Access 5.0\SQBOCI50.DLL
address: 0x34548499
address: 0x345548c0
Module at 0x31b30000: C:\Program Files\Business Objects\BusinessObjects 5.0\cnxsrv50.dll
address: 0x31b4d8ea
Module at 0x345f0000: C:\Program Files\Business Objects\BusinessObjects 5.0\tools50.dll
address: 0x347534fe

I tried this using DECODE also… with that also Designer crashes…

Anybody has any idea why its happening…and any solution??

Cheers,
Vijay

vijaykollu :us: (BOB member since 2003-05-08)

#2

Could you please let me know whether you connected the DESIGNER in online mode or offline mode?

Thanks,

  • Arun.

nellaiarun :india: (BOB member since 2003-01-15)

#3

btw… its on On-line mode…anyway… my problem was solved by defining the object like this in universe…

‘’||table.column||’’

like this for N number values it works fine without crashing the desinger using DECODE and CASE WHEN

Cheers,
Vijay

vijaykollu :us: (BOB member since 2003-05-08)

#4

It crashes when parsing, correct? I see that you’ve solved it, but have a look here. It is a known bug.

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

#5

Thanks Dwayne…

vijaykollu :us: (BOB member since 2003-05-08)