Problem with WAD

[Former Member]

Hi,

I have a problem with WAD. It is allowing me to create a new template but when I am trying to open

an existing web report using WAD it is giving me an error "Subscript out of Range" error.

Can someone help me in solving this issue.

Rgds,

James.

[Former Member]

SAP note 887002 appears to address this problem and says it is due to inconsistent or incorrect definition of the references to BW objects.

Their suggestion is to report SCAN_BW_REFERENCES. There is a code correction attached to the note that they suggest you implement for "full functionality of the report"

[Former Member]

Hi All,

I have just checked the technical names of all the queries(web) I have created. All of them show as SAP_BW_TEMPLATE, but the desc is different for all the queries. Is this how the technical name will be or am I doing something wrong? This might be the cause of the problem.

Rgds,

James.

[edwin_harpino]

hi James,

no, the technical name should be different for each web templates. how do you check the technical name ? when try to open web templates ? with tab 'history'/'role' ?

what's your bw version and front end support package level ? you may need to apply bw front end support package. hope this helps.

[edwin_harpino]

hi James,

is it happened to all web templates opened ?

there is oss note

SAP Note 887002 BEx Open/Save Dialogs: known errors

BEx Open/Save Dialogs: known errors

SAP Note Number: 887002

Symptom

Note contains information about known symptoms which may happen during accessing queries, workbooks or web templates, assigned to user's Favorites or Role Menu, in the BEx Open/Save dialogs of BW front end applications.

Other terms

BW frontend, Open Dialog, Save Dialog, Favorites, Role Menu, references, query, web template, workbook.

Reason and Prerequisites

The symptoms in the Open/Save Dialogs can be divided into 2 groups according to the reasons:

Errors caused by the wrong definition of the structure of Favorites or Roles in the database tables SMEN_BUFFC and AGR_HIER.

Errors caused by the incorrect or inconsistent references to BW objects located in the Favorites or Roles.

1. Errors caused by errors in the definition of Favorites/Role Menu structure

'Type mismatch' - frontend termination in Open Dialog accessing Favorites or Role Menu;

'Can not use leaf as parent' - frontend termination in Save Dialog during creation a reference to BW object in Favorites or Role Menu;

The possible reason for these terminations is inconsistent definition of the reference. The origin of the errors is located in the database tables SMEN_BUFFC (Favorites) and AGR_HIER (Roles).

The Favorites and Roles have the hierarchical structure in the corresponding database tables where the nodes of this hierarchy must be presented by the folders. Each object must have so-called parent object represented by the folders. If the parent object is not found in the database or is not a folder type (for example, another BW object), the tree can not be constructed. This causes one of the symptoms mentioned above depending upon the dialog type (Open/Save).

The same symptoms can also in the situation when OBJECT_ID of the parent object is duplicated within Favorites of a particular user of role within Role Menu of a particular Role. When the parent objects with the duplicated OBJECT_ID are folders, this does not cause any problem. But when one object is a folder and another duplicate has any other object type, this non-folder can be selected as a parent. This causes the terminations as described above.

Another possible error prerequisite happens when the leafs of this hierarchical structure are located on the not appropriated menu levels. The database tables contain the corresponding field MENU_LEVEL storing this information. If the MENU_LEVEL for the leaf is less or equal than MENU_LEVEL for the parent object, this may also cause the same errors.

In some seldom cases the described symptoms may also happen because of the wrong information contained in the table buffers. The tables SMEN_BUFFC and AGR_HIER are fully buffered and may contain wrong structure information. In such cases the table buffer can be reset by using the commands $TAB SMEN_BUFFC and $TAB AGR_HIER.

2. Error messages and error situation because of inconsistent or incorrect definition of the references to BW objects

The following error messages or error situations are possible:

'The requested query does not exist on the current server' - error message during query execution/load;

'Element XXX (version A) does not exist in the database' - error message during expanding folders in Favorites or Roles;

'The workbook does not exist in the document store ' - error message during execution of a workbook.

'Subscript is out of range' - termination in Web Application Designer Open Dialog accessing Favorites or Role Menu.

Different queries are executed from Favorites or Roles in BEx Analyzer and Web browser;

Object can not be executed in BEx Analyzer, but available in the Web Browser;

Query can not be executed in the Web Browser, but available in BEx Analyzer.

The described symptoms may happen during execution of a corresponding BW object.

The reasons for these errors messages can be:

An object (query, workbook, template) does not exist in the system or not activated (exists only in object version 'D');

SAP_GUID field is empty in the tables SNEM_BUFFC or AGR_HIER. Object can not be retrieved and executed in BEx Analyzer;

No records found for the queries or web templates in the tables SMEN_BUFFI or AGR_BUFFI. No URL for objects exists. Object can not be executed in Web Browser;

More that one query exists in the system with the same technical name (COMPID). It is possible, that one of those queries with duplicated names is taken for execution in BEx Analyzed and another one is taken for execution in the Web Browser. See note 907025 for error details.

Solution

Use report SCAN_BW_REFERENCES in order to find out the described issues in Favorites and Roles. The report is available from following Support Packages:

SP30 for BW 30B;

SP24 for BW 3.1;

SP16 for BW 3.5

Implement the attached code correction in order to enable the full functionality of the report

Issues with Favorites (structure and references consistency) can be fixed using the corresponding edit procedures available in the report.

The recommended tool for fixing issues with Role Menu is transaction PFCG.

[former_member188975]

Hi James,

What is your BW version? You can read through OSS note 887002: BEx Open/Save Dialogs: known errors. This mentions the error you are facing.

Hope this helps...