WEBI - Unspecified Error

building reports webintelligence
1

I have a WEBI report, it’s an ad-hoc query. After being executing for about 15 minutes, a pop-up comes with this error, no code, just a red X and the “Unspecified error”. This is not an schedule, it’s happening when y click the “run query” button.

Same query in DESKI runs OK.

Any Ideas??

Thanks in advance

Astro :argentina: (BOB member since 2007-02-15)

2

Sounds to me like a timeout in Webi.

Could be caused by a dozen of things. Try the folowing:

Change the default (20 mins) Web_Intelligence Report Server Connection Timeout:
-in the CMC go to Servers
-select the Web_IntelligenceReportServer
-change the default to 60 minutes

Change the Command Line Timeout Parameters of the Web_IntelligenceReportServer & Webi JobServer:

  • Go to the CCM (Central Configuration Manager)
    -Stop these 2 servers (services)
    -Go to the service Properties (right mouse) and edit the command line
    -Add -requesttimeout 3600000
    (in milliseconds, that is 60mins).
    -Restart all BO servces

Success

dbuitend :netherlands: (BOB member since 2006-01-16)

3

dbuitend,

I also have the same problem with webi. When i run a webi report i often get a error message Unspecifiek error.
I’ve checked the settings so you adviced and all things are the same.

[i]Change the default (20 mins) Web_Intelligence Report Server Connection Timeout:
-in the CMC go to Servers
-select the Web_IntelligenceReportServer
-change the default to 60 minutes

Change the Command Line Timeout Parameters of the Web_IntelligenceReportServer & Webi JobServer:

  • Go to the CCM (Central Configuration Manager)
    -Stop these 2 servers (services)
    -Go to the service Properties (right mouse) and edit the command line
    -Add -requesttimeout 3600000
    (in milliseconds, that is 60mins).
    -Restart all BO servces [/i]

Do you have any other ideas?
error.jpg

oeliasa :timor_leste: (BOB member since 2008-01-18)

4

Hi oeliasa,dbuitend & Astro

We too have the same problem. If you have come across any solution please share with me.

Thanks in advance
Raja

smrsraja (BOB member since 2009-07-06)

5

I have the same thing happening. Our time out is 10 minutes with an adhoc WebI report.
Any help is appreciated!

A Durgan :us: (BOB member since 2006-02-24)

6

Its a time out issue, change the webi config file parameters, you need to change the file on local machine as well on the server too.Also change the server time out in CMC too.

Thanks,
Madhu.

madhu@P (BOB member since 2008-08-04)

7

We use XIR2 SP5. We have the same issue before.
Beside the above timeout setting, you should also change regesitry.
1.run regedit on the server
2.find HKEY_LOCAL_MACHINE>SOFTWARE>Business Objects>Suite 11.5>CER
3. change the connection timeout value from 600000 (which means 600 sec) to the one you want ex. 3600000 (1 hour)

singti :taiwan: (BOB member since 2006-04-18)