Tag: Desktop Intelligence

How to fix Business Objects “Exception: CS, Job already in use”

Error Message: “Exception: CS, Job already in use”

The error message was received when data analyst ran a “Yearly” report

bo cs job already in use

 

The explanation I found. The BusinessObjects Desktop Intelligence client is connecting to the server using an HTTP protocol which uses the network settings in the Internet Explorer.

Internet Explorer IE6 by default set to 60 min time for send/receive timeout

Internet explorer IE7+ by default send/receive timeout set to 30 sec. Running “Yearly” report exceeded the threshold. To fix we can modify the registry manually, ReceiveTimeout DWORD value with a data value of (<number of seconds>)*1000.

Reference http://support.microsoft.com/kb/181050

 

Resolving DA0003 error

 

  1. Download registry patch fix IEFix.reg here
  2. Double click on file and “Run” to install the patch
  3. You will get a security notice about installing the update, click the required buttons to allow changes to the computer
  4. After installation complete you get a message indicating that your registry has been updated. Click the OK button to finish
  5. Restart the PC
  6. Also double check your universe’s connection parameters, and the configuration parameters (screen 3/4). Make sure you have at least the following: Pool timeout of 10 minutes, array fetch size: 10; Array bind size: 5; Login Timeout: 60 minutes.

 

How to Show a friendly message when “No Data to Fetch” in Business Objects reports

Receiving “No data to retrieve in <query>” or “There is no data corresponding to this query…” pop-up boxes is very confusing for end users. In addition your Web Intelligence (viewers and Java Report Panels) and Desktop Intelligence document may look not as intended. It will typically show column headers without any content, zero totals, and some formulas may even display awkward error messages.

Business Objects "No data to fetch"

Causes for the “No data to retrieve in” message

There could be lots of different factors. I list the most common issues

  1. Parameters and/or report conditions are too restrictive or negating each other.
  2. The data is missing in the table you query from the report
  3. Row-level restrictions for the current user
  4. Incorrect universe connections

However there are times when you may expect that report will not have any data for any or all queries. So how can we suppress this pop-up window

Suppressing the “No data to retrieve” message?

To overturn this message some Business Objects forum threads proposing the use of VB macro or some other SDK integration. Yet there are more simple ways to do this.

1. Use conditions in the report objects. Create a variable that will hold number of rows returned by data provider eg variable “RowCount”, formula =NumberOfRows(DataProvider(<MyQuery1>))

The next step is to assign condition to your table/chart to be visible when datasourse returns some data and hide it otherwise. Create “No data” block to display when datasource contains no data. Position both objects on top of each other

2. Create a union in your datasource query such that always one of the queries returns a value. I usually use my dummy empty objects for the second query. The only catch is that number of objects and objects types in the “Result Objects” pane must be the same. To keep you report clean you may need to add report level filter. Note dummy objects must reference dummy table or view in order to parse in Designer.