最具影响力的数字化技术在线社区

乔帮主 发表于 2014-12-3 13:02:03

SAP BO Web Intelligence Server (WIS) Error Messages

Some objects are no longer available in the universe. (WIS00001)CauseOne or more objects in a universe are no longer available to a document.ActionDelete the objects from the query that seem to be missing. The availableobjects are listed on the Data tab. Rebuild the query without the obsoleteobjects.

Some objects are not available to your user profile. You cannot refresh this document. See your Business Objects administrator. (Error: WIS 00002)CauseYou do not have the correct user rights to access the data for one or moreobjects included in a query. As you are not permitted to access the data forthese objects, you cannot refresh the report.ActionAsk your BusinessObjects administrator to change your user profile to makethese objects accessible.Some pre-defined filters are no longer available in the universe. (WIS00003)CauseOne 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.ActionRemove the predefined filters from the query, and manually create the samecondition in the query by using the appropriate operators and operands.Some database tables are no longer available in the universe. See yourBusiness Objects administrator. (Error: WIS 00004)CauseOne or more database tables referenced by objects in the universe are nolonger available. The tables may have been renamed, or removed from thedatabase.ActionThe universe designer can update the universe structure by selecting View> Refresh Structure in Designer.Invalid Prompt definition. See your BusinessObjects administrator. (WIS00005)CauseThe syntax in the prompt is not valid, or the prompt makes reference to anobject that no longer exists in the universe.ActionThe universe designer can verify that the prompt syntax is correct, and checkthat all objects referenced in the prompt exist.Invalid Aggregate Aware definition. See your Business Objects administrator.(Error: WIS 00006)CauseOne or more objects in the query use the aggregate aware function in theirdefinition. The syntax for the aggregate aware function is not valid.ActionThe universe designer must verify that the aggregate aware syntax is correct.A filter contains a wrong value. You cannot run this query. (WIS00007)CauseThe 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 alphanumericvalue.ActionVerify the filter syntax.The query cannot run, because it contains incompatible objects. See yourBusiness Objects administrator. (Error: WIS 00008)CauseThe query contains objects that return data sets that can not be combinedor synchronized. This can be due to parameters that have not been set inthe universe to allow multiple SQL statements for each context, or multipleSQL statements for each measure.ActionThe universe designer can do the following:? Select the options Multiple SQL statements for each context and MultipleSQL statements for each measure. These are on the SQL page of theUniverse 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)CauseThe advanced filter is a subquery. You can not combine incompatible objectsin a sub query.ActionChange the advanced filter definition to use only compatible objects.The universe does not allow using a complex expression in a GROUP BYstatement. You cannot run this query. See your BusinessObjects administrator.(WIS00010)CauseA query contains a GROUP BY clause that uses formulas or aliases. Theuniverse does not allow these expressions in GROUP BY clauses. Thebehavior is determined by the parameterYin the PRM file for the target RDBMS.ActionYou have two solutions:? Modify the query so that objects using formulas or aliases are not includedin the query.? A universe designer can open the PRM file for the target RDBMS andchange the value for the parameter GROUPBY_EXCLUDE_COMPLEXto N. This change should be made only if you are sure that your RDBMSsupports complex GROUP BY expressions.
The object(s): {obj_list} contain multiple attributes. This syntax is no longersupported in this version. See your Business Objects administrator. (Error:WIS 00011)CauseOne or more objects in the query use a comma (“,”) instead of a concatenationoperator in their definition. This syntax is no longer supported for currentversions.ActionThe universe designer has three options:? Redefine the objects that use the comma to concatenate the data for twoobjects. You can use the standard concatenation operator for yourRDBMS.? If you do not want to redefine the objects, you can add the following lineto the PRM file for the target RDBMS:This will enable the comma to be accepted syntax for concatenation inobject definitions.? Set the value of REPLACE_COMMA_BY_CONCAT to “Yes” in theuniverse.You can not run this query as it will produce a Cartesian product. See yourBusinessObjects administrator. (WIS00012)CauseThe query will produce a Cartesian product. This is a result set that containsall possible combinations of rows from the tables inferred by objects in thequery. This is rarely a correct result. Parameters have been set in the universeto prevent Cartesian products.ActionThe universe designer has two options:? Modify the universe table schema to include the appropriate joins andrestrictions to prevent the possible occurrence of a Cartesian product.? If Cartesian products are acceptable in your business context, then fromDesigner, set the Cartesian Products option to Warn. This option is onthe SQLl page of Universe Parameters dialog box. The user will bewarned, but the production of a Cartesian product will not be prevented.SQL generation failed. See your BusinessObjects administrator. (WIS00013)CauseError occurs during SQL generation of the query. This can be due to a numberof reasons; for example the query doesn’t involve any table in the database.ActionAsk your BusinessObjects administrator to check the SQL associated withthe objects involved in the query.Aggregate aware resolution failed. (WIS00014)CauseThe query objects exclude all possible SQL choices for an aggregate awarefunction.ActionThe universe designer can remove the incompatibility between the objectsin Designer. Select Tools > Aggregate Navigation and remove theincompatibility for the concerned objects.Multiple query filters contain a prompt with the same text, but the promptsuse a different operand type or operator count of values. (Error: WIS 00015)CauseThe query has multiple prompts that display the same message. WebIntelligence combines prompts with the same message and displays theprompt once. If the operator defined for some of these prompts requires youto enter one value while the operator in other prompts with the same messagerequires you to enter multiple values, Web Intelligence cannot combine theprompt.ActionYou need to modify the definition of the prompts. How you do this dependson how you are viewing the document:? Via InfoView — click the Edit link, and then use the Web Intelligence reportpanel options to modify the prompts. For more information on how to dothis, refer to the Building Reports Using the Java Report Panel or BuildingReports Using the HTML Report Panel guide.? In the Web Intelligence Java Report Panel — go to Query View by clickingEdit Query in the report panel toolbar, and then double-click the promptsyou want to edit and select operators for each prompt. For moreinformation on how to do this, refer to the Building Reports Using the JavaReport Panel or Building Reports Using the HTML Report Panel guide.Example:The operators you define for the prompts with the same message text mustall require one of the following:? one value (for example: Equal to, Different from, Greater than, Greaterthan 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 yourBusinessObjects administrator. (WIS00016)CauseThe SQL generated by the query for this document includes an @Script()function, which is not supported.ActionYour administrator will need to remove the @Script in the universe selectedfor this document.The following objects cannot be used as Result Objects: {0}. (WIS00017)CauseThe query definition for this document includes objects in the Result Objectspane that cannot be used in queries.ActionDo one of the following:? Go to Query View by clicking the Edit Query button on the report paneltoolbar, and then remove the listed objects from the Result Objects pane.? Contact your BusinessObjects administrator and request the ability toinclude the listed objects in the Result Objects defined for the query.The following objects cannot be used as Query Filters: {0}. See yourBusinessObjects Designer to resolve the conditional object. (WIS00018)CauseThe query definition for this document includes objects in the Query Filterspane that cannot be used in query filters.ActionDo one of the following:? Go to Query View by clicking the Edit Query button on the report paneltoolbar, and then remove the listed objects from the Query Filters pane.? Contact your BusinessObjects administrator and request the ability toinclude the listed objects in filters defined on the queryA query filter object contains too many values for the object to be used in aquery filter. (Error: WIS 0019) (WIS 00019)CauseToo many values were selected in the query filterActionSelect fewer valuesThe SQL generated by the query is invalid. (WIS00020)CauseThe SQL generated by the query is invalidActionVerify the query and the generated SQLThis combined query is too complex. One of the queries contains incompatibleobjects. (WIS00021)CauseOne of the queries in the combined queries contains incompatible objectsActionRemove the incompatible objectsThe query does not reference any table. (WIS00022)CauseThe query does not reference a database tableActionModify the query to reference a table

abner 发表于 2014-12-3 18:33:11

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

abner 发表于 2014-12-3 18:33:29

表示大部分没看懂,算了,当练阅读了
页: [1]
查看完整版本: SAP BO Web Intelligence Server (WIS) Error Messages