BSAE: Reports cannot be run in the web client

The following message may appear while attempting to run a report in BSAE (Business Service Automation Essentials) web client (also known as BusinessObjects (BO)):

A database error occurred. The database error text is: SQL statement to execute cannot be empty or null. (WIS 10901)

This message can be caused by a number of situations.

The most common cause of the problem is that the end user created some criteria that resulted in a no data condition.

The next most common cause is that BSAE was restarted but the web interface (bsae-bo) was not restarted at the same time.

The end user can review the report criteria and make sure it is appropriate. If it is correct then the following procedure can be used to restart BSAE correctly.

Restart BusinessObjects (BO):

1) Logon to the BSAE server via SSH as root

2) Restart BO:

/etc/init.d/bsae-bo restart

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s