SAP BO Web Intelligence Server (WIS) Error Messages

Some objects are no longer available in the universe. (WIS00001)

Cause

One or more objects in a universe are no longer available to a document.

Action

Delete the objects from the query that seem to be missing. The available

objects are listed on the Data tab. Rebuild the query without the obsolete

objects.

Some objects are not available to your user profile. You cannot refresh this document. See your Business Objects administrator. (Error: WIS 00002)

Cause

You do not have the correct user rights to access the data for one or more

objects included in a query. As you are not permitted to access the data for

these objects, you cannot refresh the report.

Action

Ask your BusinessObjects administrator to change your user profile to make

these objects accessible.

Some pre-defined filters are no longer available in the universe. (WIS00003)

Cause

One or more predefined filters are no longer available in the universe.

Predefined filters are condition objects that are predefined WHERE clauses.

You use these to restrict the data returned in a query.

Action

Remove the predefined filters from the query, and manually create the same

condition in the query by using the appropriate operators and operands.

Some database tables are no longer available in the universe. See your

Business Objects administrator. (Error: WIS 00004)

Cause

One or more database tables referenced by objects in the universe are no

longer available. The tables may have been renamed, or removed from the

database.

Action

The universe designer can update the universe structure by selecting View

> Refresh Structure in Designer.

Invalid Prompt definition. See your BusinessObjects administrator. (WIS00005)

Cause

The syntax in the prompt is not valid, or the prompt makes reference to an

object that no longer exists in the universe.

Action

The universe designer can verify that the prompt syntax is correct, and check

that all objects referenced in the prompt exist.

Invalid Aggregate Aware definition. See your Business Objects administrator.

(Error: WIS 00006)

Cause

One or more objects in the query use the aggregate aware function in their

definition. The syntax for the aggregate aware function is not valid.

Action

The universe designer must verify that the aggregate aware syntax is correct.

A filter contains a wrong value. You cannot run this query. (WIS00007)

Cause

The filter has a wrong operand. For example, a filter with an empty constant,

or a filter that deals with numeric values is defined with an alphanumeric

value.

Action

Verify the filter syntax.

The query cannot run, because it contains incompatible objects. See your

Business Objects administrator. (Error: WIS 00008)

Cause

The query contains objects that return data sets that can not be combined

or synchronized. This can be due to parameters that have not been set in

the universe to allow multiple SQL statements for each context, or multiple

SQL statements for each measure.

Action

The universe designer can do the following:

? Select the options Multiple SQL statements for each context and Multiple

SQL statements for each measure. These are on the SQL page of the

Universe Parameters dialog box.

? Create a new context that includes the incompatible objects.

The query cannot run as an advanced filter contains an incompatible object.

See your BusinessObjects administrator. (WIS00009)

Cause

The advanced filter is a subquery. You can not combine incompatible objects

in a sub query.

Action

Change the advanced filter definition to use only compatible objects.

The universe does not allow using a complex expression in a GROUP BY

statement. You cannot run this query. See your BusinessObjects administrator.

(WIS00010)

Cause

A query contains a GROUP BY clause that uses formulas or aliases. The

universe does not allow these expressions in GROUP BY clauses. The

behavior is determined by the parameter

Y

in the PRM file for the target RDBMS.

Action

You have two solutions:

? Modify the query so that objects using formulas or aliases are not included

in the query.

? A universe designer can open the PRM file for the target RDBMS and

change the value for the parameter GROUPBY_EXCLUDE_COMPLEX

to N. This change should be made only if you are sure that your RDBMS

supports complex GROUP BY expressions.
The object(s): {obj_list} contain multiple attributes. This syntax is no longer

supported in this version. See your Business Objects administrator. (Error:

WIS 00011)

Cause

One or more objects in the query use a comma (“,”) instead of a concatenation

operator in their definition. This syntax is no longer supported for current

versions.

Action

The universe designer has three options:

? Redefine the objects that use the comma to concatenate the data for two

objects. You can use the standard concatenation operator for your

RDBMS.

? If you do not want to redefine the objects, you can add the following line

to the PRM file for the target RDBMS:

This will enable the comma to be accepted syntax for concatenation in

object definitions.

? Set the value of REPLACE_COMMA_BY_CONCAT to “Yes” in the

universe.

You can not run this query as it will produce a Cartesian product. See your

BusinessObjects administrator. (WIS00012)

Cause

The query will produce a Cartesian product. This is a result set that contains

all possible combinations of rows from the tables inferred by objects in the

query. This is rarely a correct result. Parameters have been set in the universe

to prevent Cartesian products.

Action

The universe designer has two options:

? Modify the universe table schema to include the appropriate joins and

restrictions to prevent the possible occurrence of a Cartesian product.

? If Cartesian products are acceptable in your business context, then from

Designer, set the Cartesian Products option to Warn. This option is on

the SQLl page of Universe Parameters dialog box. The user will be

warned, but the production of a Cartesian product will not be prevented.

SQL generation failed. See your BusinessObjects administrator. (WIS00013)

Cause

Error occurs during SQL generation of the query. This can be due to a number

of reasons; for example the query doesn’t involve any table in the database.

Action

Ask your BusinessObjects administrator to check the SQL associated with

the objects involved in the query.

Aggregate aware resolution failed. (WIS00014)

Cause

The query objects exclude all possible SQL choices for an aggregate aware

function.

Action

The universe designer can remove the incompatibility between the objects

in Designer. Select Tools > Aggregate Navigation and remove the

incompatibility for the concerned objects.

Multiple query filters contain a prompt with the same text, but the prompts

use a different operand type or operator count of values. (Error: WIS 00015)

Cause

The query has multiple prompts that display the same message. Web

Intelligence combines prompts with the same message and displays the

prompt once. If the operator defined for some of these prompts requires you

to enter one value while the operator in other prompts with the same message

requires you to enter multiple values, Web Intelligence cannot combine the

prompt.

Action

You need to modify the definition of the prompts. How you do this depends

on how you are viewing the document:

? Via InfoView — click the Edit link, and then use the Web Intelligence report

panel options to modify the prompts. For more information on how to do

this, refer to the Building Reports Using the Java Report Panel or Building

Reports Using the HTML Report Panel guide.

? In the Web Intelligence Java Report Panel — go to Query View by clicking

Edit Query in the report panel toolbar, and then double-click the prompts

you want to edit and select operators for each prompt. For more

information on how to do this, refer to the Building Reports Using the Java

Report Panel or Building Reports Using the HTML Report Panel guide.

Example:

The operators you define for the prompts with the same message text must

all require one of the following:

? one value (for example: Equal to, Different from, Greater than, Greater

than or equal to, Less than, Less than or equal to, Except.)

? multiple values when the prompt is answered (for example: Between,

Not between, In list, Not in list, Matches pattern, Different from pattern,

Both.)

The Query contains an @script() function, which is not supported. See your

BusinessObjects administrator. (WIS00016)

Cause

The SQL generated by the query for this document includes an @Script()

function, which is not supported.

Action

Your administrator will need to remove the @Script in the universe selected

for this document.

The following objects cannot be used as Result Objects: {0}. (WIS00017)

Cause

The query definition for this document includes objects in the Result Objects

pane that cannot be used in queries.

Action

Do one of the following:

? Go to Query View by clicking the Edit Query button on the report panel

toolbar, and then remove the listed objects from the Result Objects pane.

? Contact your BusinessObjects administrator and request the ability to

include the listed objects in the Result Objects defined for the query.

The following objects cannot be used as Query Filters: {0}. See your

BusinessObjects Designer to resolve the conditional object. (WIS00018)

Cause

The query definition for this document includes objects in the Query Filters

pane that cannot be used in query filters.

Action

Do one of the following:

? Go to Query View by clicking the Edit Query button on the report panel

toolbar, and then remove the listed objects from the Query Filters pane.

? Contact your BusinessObjects administrator and request the ability to

include the listed objects in filters defined on the query

A query filter object contains too many values for the object to be used in a

query filter. (Error: WIS 0019) (WIS 00019)

Cause

Too many values were selected in the query filter

Action

Select fewer values

The SQL generated by the query is invalid. (WIS00020)

Cause

The SQL generated by the query is invalid

Action

Verify the query and the generated SQL

This combined query is too complex. One of the queries contains incompatible

objects. (WIS00021)

Cause

One of the queries in the combined queries contains incompatible objects

Action

Remove the incompatible objects

The query does not reference any table. (WIS00022)

Cause

The query does not reference a database table

Action

Modify the query to reference a table

表示大部分没看懂，算了，当练阅读了

表示大部分没看懂，算了，当练阅读了