cancel
Showing results for 
Search instead for 
Did you mean: 

cannot run any query in BI70

kirkmiller
Explorer
0 Kudos

I get the following error when running any query. I have read several messages here that describe the fix as merely re-importing the new version of 0ANALYSIS_PATTERN from content. A log of the import of the content is at the end. There are no errors.

Error while loading the Web template "0ANALYSIS_PATTERN" (return value "4")

ERROR: Command type SWITCH_AXES of object not recognized

ERROR: Parameter GENERAL_TEXT_ELEMENT not recognized; check your metadata

com.sap.ip.bi.base.exception.BIBaseRuntimeException: Error while loadingthe Web template "0ANALYSIS_PATTERN" (return value "4")

at

com.sap.ip.bi.webapplications.runtime.service.template.impl.TemplateService.getTemplateContent(TemplateService.java:60)

at

com.sap.ip.bi.webapplications.runtime.jsp.portal.service.template.PortalTemplateAccessService.getTemplateContent(PortalTemplateAccessService.java:80)

at

com.sap.ip.bi.webapplications.runtime.preprocessor.Preprocessor.parseTemplate(Preprocessor.java:161)

at

com.sap.ip.bi.webapplications.runtime.xml.XmlTemplateAssembler.doInit(XmlTemplateAssembler.java:83)

at

com.sap.ip.bi.webapplications.runtime.template.TemplateAssembler.init(TemplateAssembler.java:128)

-


CONTENT IMPORT LOGS----


Installation of: BEx Web Item (BITM)

Transfer/Merge of the Content Version (Object Type BEx Web Item )

Object BEx Web Item 0PATTERN_BARCHART_SWITCHED: Installation of the Content Version

Activation of Objects with Type BEx Web Item

Saving Objects with Type BEx Web Item

Saving BEx Web Item 0PATTERN_BARCHART_SWITCHED

BEx Web Item 0PATTERN_BARCHART_SWITCHED saved successfully

Internal Activation (BEx Web Item )

Preprocessing / Creation of DDIC Objects for BEx Web Item 0PATTERN_BARCHART_SWITCHED

Post Processing/Checking the Activation for BEx Web Item 0PATTERN_BARCHART_SWITCHED

BEx Web Item 0PATTERN_BARCHART_SWITCHED activated

Transferring the 1 objects from type BITM took 10,0 seconds

Installation of: BEx Web Template (BTMP)

Transfer/Merge of the Content Version (Object Type BEx Web Template )

Object BEx Web Template 0ANALYSIS_PATTERN_EXPORT: Installation of the Content Version

Object BEx Web Template 0ANALYSIS_PATTERN_FILTER: Installation of the Content Version

Object BEx Web Template 0ANALYSIS_PATTERN_FOOTER: Installation of the Content Version

Object BEx Web Template 0ANALYSIS_PATTERN_HEADER: Installation of the Content Version

Object BEx Web Template 0ANALYSIS_PATTERN_INFO: Installation of the Content Version

Activation of Objects with Type BEx Web Template

Saving Objects with Type BEx Web Template

Saving BEx Web Template 0ANALYSIS_PATTERN_EXPORT

BEx Web Template 0ANALYSIS_PATTERN_EXPORT saved successfully

Saving BEx Web Template 0ANALYSIS_PATTERN_FILTER

BEx Web Template 0ANALYSIS_PATTERN_FILTER saved successfully

Saving BEx Web Template 0ANALYSIS_PATTERN_FOOTER

BEx Web Template 0ANALYSIS_PATTERN_FOOTER saved successfully

Saving BEx Web Template 0ANALYSIS_PATTERN_HEADER

BEx Web Template 0ANALYSIS_PATTERN_HEADER saved successfully

Saving BEx Web Template 0ANALYSIS_PATTERN_INFO

BEx Web Template 0ANALYSIS_PATTERN_INFO saved successfully

Internal Activation (BEx Web Template )

Preprocessing / Creation of DDIC Objects for BEx Web Template 0ANALYSIS_PATTERN_EXPORT

Preprocessing / Creation of DDIC Objects for BEx Web Template 0ANALYSIS_PATTERN_FILTER

Preprocessing / Creation of DDIC Objects for BEx Web Template 0ANALYSIS_PATTERN_FOOTER

Preprocessing / Creation of DDIC Objects for BEx Web Template 0ANALYSIS_PATTERN_HEADER

Preprocessing / Creation of DDIC Objects for BEx Web Template 0ANALYSIS_PATTERN_INFO

Post Processing/Checking the Activation for BEx Web Template 0ANALYSIS_PATTERN_EXPORT

BEx Web Template 0ANALYSIS_PATTERN_EXPORT activated

Post Processing/Checking the Activation for BEx Web Template 0ANALYSIS_PATTERN_FILTER

BEx Web Template 0ANALYSIS_PATTERN_FILTER activated

Post Processing/Checking the Activation for BEx Web Template 0ANALYSIS_PATTERN_FOOTER

BEx Web Template 0ANALYSIS_PATTERN_FOOTER activated

Post Processing/Checking the Activation for BEx Web Template 0ANALYSIS_PATTERN_HEADER

BEx Web Template 0ANALYSIS_PATTERN_HEADER activated

Post Processing/Checking the Activation for BEx Web Template 0ANALYSIS_PATTERN_INFO

BEx Web Template 0ANALYSIS_PATTERN_INFO activated

Transferring the 5 objects from type BTMP took 6,7 seconds

Installation of: Role (ACGR)

Transferring the 1 objects from type ACGR took 0,1 seconds

Post-processing of Objects after activation

The post-processing lasts 0,0 seconds

-


VERSION INFO----


SAP_ABA 700 0012 SAPKA70012 Cross-Application Component

SAP_BASIS 700 0012 SAPKB70012 SAP Basis Component

PI_BASIS 2005_1_700 0012 SAPKIPYJ7C PI_BASIS 2005_1_700

SAP_BW 700 0014 SAPKW70014 SAP NetWeaver BI 7.0

BI_CONT 703 0006 SAPKIBIIP6 Business Intelligence Content

______________________________ __________ ____ ____________________ ________________________________________________________________________________

Accepted Solutions (0)

Answers (4)

Answers (4)

kirkmiller
Explorer
0 Kudos

1) load 0ANALYSIS_PATTERN in Web Application Designer

2) delete it

3) reinstall from business content

No-one here has mentioned the critical but non-intuitive steps 1 and 2

Former Member
0 Kudos

Hi Kirk,

We are having exactly the same issue when executing the query.

Can you pls. provide the steps that you have performed in resolving the issue.

Your help will be highly appreciated.

Thanks in advance.

Praveen

kirkmiller
Explorer
0 Kudos

Figured out that I have to delete the template via WAD (web app designer).

Two different tools to work on the same object...great.

kirkmiller
Explorer
0 Kudos

further info: here is log from SE38:RS_TEMPLATE_MAINTAIN_70

Command type SWITCH_AXES of object not recognized 17:35:27

Command type SWITCH_AXES of object not recognized 17:35:27

Command type SWITCH_AXES of object not recognized 17:35:27

Parameter GENERAL_TEXT_ELEMENT not recognized; check your metadata 17:35:27

Parameter GENERAL_TEXT_ELEMENT of object item:GROUP_ITEM:GROUP_ITEM_1 not recognized 17:35:37

Command type SWITCH_AXES of object item:GROUP_ITEM:GROUP_ITEM_1 not recognized 17:35:37

Command type SWITCH_AXES of object item:GROUP_ITEM:GROUP_ITEM_1 not recognized 17:35:37

Command type SWITCH_AXES of object item:GROUP_ITEM:GROUP_ITEM_1 not recognized 17:35:37

Command SWITCH_AXES cannot be located in parameter ACTION 17:35:37

Command SWITCH_AXES cannot be located in parameter ACTION 17:35:37

Command SWITCH_AXES cannot be located in parameter ACTION 17:35:37

Parameter GENERIC_TEXT_BINDING of object item:GROUP_ITEM:GROUP_ITEM_1 cannot be higher-level node of GENERAL_TEXT_ELEMENT 17:35:37

Item item:GROUP_ITEM:GROUP_ITEM_1 of type DROPDOWN_ITEM cannot be a parent node of DATA_PROVIDER_REF 17:35:37

Item item:GROUP_ITEM:GROUP_ITEM_1 of type CHART_ITEM cannot be a parent node of VISIBLE 17:35:37

Item item:GROUP_ITEM:GROUP_ITEM_1 of type CHART_ITEM cannot be a parent node of LEGEND_POSITION 17:35:37

Item item:GROUP_ITEM:GROUP_ITEM_1 of type CHART_ITEM cannot be a parent node of LEGEND_VISIBLE 17:35:37

Item item:GROUP_ITEM:GROUP_ITEM_1 of type CHART_ITEM cannot be a parent node of LEGEND_ONLY 17:35:37

Invalid parameter value for parameter ACTION in object item:GROUP_ITEM:GROUP_ITEM_1 17:35:37

Invalid parameter value for parameter ACTION in object item:GROUP_ITEM:GROUP_ITEM_1 17:35:37

Invalid parameter value for parameter ACTION in object item:GROUP_ITEM:GROUP_ITEM_1 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

bi-Tag bi:item has unknown attribute key. Please check your spelling 17:35:37

Query 0D_DX_M01_Q0006 does not exist in the BI System (Object QU: 0D_DX_M01_Q0006) 17:35:39

Cannot instantiate data provider 17:35:39