Business Intelligence with SAP Business Objects 4.3

Connection failed. server has reached maximum number of simultaneous connections (Error: RWI 00239)

2023-11-09T07:38:00.000-08:00

All was working perfectly with SAP BusinessObjects BI 4.3 Support Pack 3 Patch 4 Version: 14.3.3.4607

Suddenly we had:

Connection failed. server has reached maximum number of simultaneous connections (Error: RWI 00239) (Error:INF)

Cause:

The maximum number of server connections allowed has been reached.

Action:

Either raise the value of the maximum connections server parameter, or add another server instance.

To modify the maximum connections value:

Log on to Business Objects Enterprise Central Management Console (CMC).

Click on Servers.

Expand Server Categories, and click on Web Intelligence.

Under Server name, double-click on WebIntelligenceProcessingServer. The Properties window appears.

In Properties window, under Web Intelligence Processing Service, enter the value for Maximum Connections.

I setted it to 50 this fixed the issue

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

2015-05-27T08:21:00.004-07:00

window.dataLayer = window.dataLayer || [];

function gtag(){dataLayer.push(arguments);}

gtag('js', new Date());

gtag('config', 'G-NL0CYP13VZ');

</script>

Cannot find the BusinessObjects Enterprise report source. (LO 26608)

Environment SAP BO XI 4.1 SP 5 two nodes Cluster

Windows Server 2012

While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased.

SAP says:

Cause

The document is not available; for example it does not exist, or it has been

removed.

Action

Check the report path from CMS and use SetLocation in Live Office to

re-define the report source. Otherwise, check if the user has sufficient rights

to view the object.

Solution

In our case we fixed this problem was to removing all Live Office connections from the Dashboard and re-created them and then we saved back to platform!
When you make changes to your Live Office connection inside of the nested Excel instance, the data manager wont detect and apply changes to your Live Office configuration. Simply deleting and re-adding your Live Office connections in the data manager will solve the problem if you modify the Live Office objects or prompts.

Webi Error XI 4.1 - Your security profile does not include permission to edit this documents (WIS 30252)

2015-05-07T06:37:00.003-07:00

Webi Error XI 4.1 - Your security profile does not include permission to edit this documents (WIS 30252)

Symptom

Below mentioned mentioned error message is displayed while performing drill in a Web Intelligence(WebI) report by non-Administrator user:

"Your security profile does not include permission to edit this documents (WIS 30252)".

Environment

SAP Business Objects XI 4.1 SP 4 - two node cluster

Windows Server 2012 R2

Database Teradata 14

Reproducing the Issue

1. Login to WebI Rich client/BILaunchPad using Administrator account and create a new Webi report on a universe.

2. In the query panel select a dimension and a measure.

3. Save report to the repository.

4. Enable "Drill" in the report. Administrator is able to successfully perform drill in the report.

5. Logout and login to BIlaunchPad using Non-Administrator user and open the same report in View mode.

6. Try to perform Drill in the report. Below mentioned error message is displayed:

"Your security profile does not include permission to edit this documents (WIS 30252)."

Cause

User do not have "Edit query" right on the document.

Resolution

1. Login to the Central Management Console (CMC)

2. Go to the Applications.

3. Select Web Intelligence

4. Select User Security

5. Select the user / group with which we are getting error.

6. Go to Assign Security

7. Go to Advanced tab ; Add/Remove Rights

8. Under Application ; Web Intelligence ; Specific Rights for Web Intelligence

9. Grant the right "Reporting Enable Formatting"

Information Design Tool XI 4.1 SP 5 - Problem on opening a session as designer user not administrator

2015-04-27T06:57:00.003-07:00

Information Design Tool - Problem on opening a session as designer user not administrator

Environment
IDT 4.1 SP 5 - 2 nodes Cluster
Windows 2012 R2

Our customer has a problem while opening session on Information Design Tool loggin on with a not administator user.

We found the solution on SAP Knoledge base in the following note.

1916649 - Information Design Tool session terminated right after login for certain users

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3139313636343926

Reproducing the Issue

In the CMC deny the "View Objects" and "View objects that the user owns" access level on "UserA" 's Inbox
Log in IDT using "UserA"
Notice that the session is terminated and an error message might appear

Cause

The user has not been granted right access into its BI Inbox

Solution

Make sure the users have view rights on their own Inboxes:

In order to open session in IDT , designer user need full control access on Inbox

After giving the related rights on the inbox root folder the designer user solved its problem on accessing in the repository as you can see in the following image

BO XI R 3.1 - Changing Business Objects Server Hostname

2014-11-18T06:34:00.000-08:00

If you need to change the hostname of BOE XI 3.1 server machine follow these steps

1. Disable all job servers so schedules are protected until you are confident your changes have been executed correctly.
2. Change the machine name. Restart the server and 3.0 backend is solid and working.
3. Reconfigure the application servers. Stand alone or not, these may need to be reconfigured:
a. Java based (Tomcat, Jboss, etc):
- Make a copy and then edit the WEB.XML files which in Tomcat are under the following directories:
1. /webapps/CmcApp/WEB-INF
2. /webapps/InfoViewApp/WEB-INF
- Edit each of the Web.xml files with a text editor
Navigate to the context-param key. Edit to read as follows:
CMS
NEWHOSTNAME
b. .NET based (IIS)
- Create a copy and then edit the WEB.CONFIG files which are in the following directories:
1. \BusinessObjects Enterprise 12.0\WebContent\InfoViewApp\CmcApp\
2. \BusinessObjects Enterprise 12.0\WebContent\InfoViewApp\InfoViewApp\
Navigate to the context-param key. Edit to read as follows:
CMS
NEWHOSTNAME
4. Reconfigure the web.xml files if you have added any cluster and cluster member information in them or other references to the old server name
5. Reconfigure the shortcuts created by the install: delete the old shortcuts and create new ones using the new URL
6. Node names: if you have performed a default installation, the install creates a node with the name of the server in the format .
i.e: OLDSERVER.SERVICENAME
You can keep the old naming without affecting the functionality of the Business Objects Enterprise Installation but if you want to rename the nodes for more clarity:
- log on to the CMC, navigate to Servers select Properties and rename it
or
- create a new node, add it to the cluster, then delete the old one
7. SIA node: it is not possible to change the SIA node name, you should create a new one and then create a new set of servers associated to the new SIA, once all tests confirm that the Business Objects deployment is fully functional you can delete the old one
8. Ensure the File Repository Servers are still referencing the correct location for the file store root directory
CMC > Servers
They may still be using local location defined by default variables or they may have changed.
Confirm they are still configured correctly.
9. Database reporting: If there is a database on this server and you have created any machine name specific references to it for db reporting, these will need to be re-configured as well. Such configurations will not affect our application specifically but it will affect our application's ability to service your user requests.
10. Change the default URL ("SI_VIEWER_URL") if you need to email the report to the users. Refer to the SAP Note 1259126 for the details.

Refer also to:

https://service.sap.com/sap/support/notes/1310352

Please note that changing just IP Address should NOT have any impact on the system.

Desktop Compatibility Pack (DCP) with SAP BI Platform 4.1 SP1

2014-05-26T08:00:00.001-07:00

Desktop Compatibility Pack (DCP)

The “Desktop Intelligence Compatibility Pack” has been delivered in Fix Pack (FP) 6.1 which is to be installed over Desktop Intelligence XI 3.1 SP6 desktop product.

When installed, it allows the Desktop Intelligence reports, users, universes and database connections to be managed by the BI 4.1 platform.

The goal is to allow Desktop Intelligence users and content to move to BI 4 as easily as possible.

The Desktop Intelligence Compatibility Pack helps in scenarios with reports are difficult or costly to convert to Web Intelligence.

Don't bet on "DCP" to keep your Deski documents alive, this feature is only there to facilitate your migration project and nothing more. We must not forget that a migration project is often associated with a project to convert your Deski (.REP) documents to Webi (WID).

The steps to follow for installing are the following:

1. Install SBOP Enterprise Clients 3.1 Service Pack 6

2. Install SAP BI 4.1 Clients

Side-By-Side

Mandatory components to be installed

Web Intelligence Rich Client

Report Conversion Tool

3. Install SBOP Enterprise Client Tools XI 3.1 FixPack 6.1 or later (Please apply the latest SBOP Enterprise Client Tools XI 3.1 FixPack)

IMPORTANT

1. XI 3.1 FixPack should be installed AFTER BI 4.1 Client Installation

2. If you are upgrading from SBOP Enterprise Client Tools XI 3.1 FixPack 6.1 to 6.2, then please refer to SAP NOTE: 1903183

You can refer to the SAP NOTE: 1896617, for a sample script on how to create a slient installer, this can be customized as per requirements.

Webi 4.0 Error: c3_qtds_error_it_505

2014-05-16T05:09:00.003-07:00

Error c3_qtds_error_it_505

Envirnonment

SAP BO 40 SP 8

Db Oracle 10 i

The problem was that no group had the right at least to view this connection

So in order to solve the error we gave the view right to the specific group

Another solution you can try to solve this problem requires to follow these steps:

Log on to CMC->Universe Connection->Manage->Top level Security

Assign the Data access right in Relational connection

Choose your connection

Data Access(Owner right)

Use Connection (Owner Right)

Soon: troubleshooting with UMT & Promotion Management

2014-03-26T07:44:00.002-07:00

Dear readers
soon I will write down for you troubleshooting with Upgrade Management Tool and Promotion management
while migrating from XI R3.1 SP 4 to BI 4 sp8.
Best regards
Giuseppe

CCM Error: Visual C++ Runtime library

2014-03-04T06:38:00.002-08:00

CCM Error : Visual C++ Runtime library

Environment

BI 4 SP 8

Windows Server 2008 R2 sp1

On opening the CCM tool from the BO server it crashed more times.

In our case we just restared the Server and this solved the problem.

Error:RWI 00226 - Cannot initialize Report Engine Server. (Error:RWI 00226)(Error:INF)

2014-02-26T01:53:00.004-08:00

Cannot initialize Report Engine Server. (Error:RWI 00226) (Error:INF)

Environment BO XI R3.1 SP 4

Windows Server 2008 R2 sp1

While rescheduling a Webi report one of our users experienced the error in exam.

Solution:

In our case we just restared WebIntelligence group servers:

See also:

SAP BI 4.0 Errors List

XI R 3.1 errors solutions

HTTP Status 500 - BI Launchpad URL after moving BI 4 server under Windows Domain

2014-02-19T07:01:00.001-08:00

After moving the server under Win Domain
both cmc and bi launchpad url erased the following error:

Environment

SAP BI 4.0 SP 8
Microsoft Windows Server 2008 R2

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.lang.NullPointerException

com.businessobjects.servletbridge.customconfig.Config.(Config.java:37)

com.businessobjects.servletbridge.customconfig.ConfigReader.getConfig(ConfigReader.java:274)

com.businessobjects.pinger.TimeoutManagerFilter.getSessionState(TimeoutManagerFilter.java:201)

com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:82)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.

The problem was caused by the user wich started SIA wich was Windows Domain user that was administrator of the machine, we have to change the user that started the SIA that is BO Administrator

SAP BI 4 - Scheduling reports error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]

2014-02-12T07:35:00.003-08:00

Scheduling reports error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]

Environment SAP BI 4 SP8

The BI 4 server is not in windows domain but SIA service is runned by a domain user

As suggested in other B.O. forum we perfomed the following steps:

in CMC, the Job Server must use a NETWORK SERVICE user that has all the permissions to read/write, that run's as a service, log on as service account etc. ( admin user) ;

user has full read/write access to the folders.

we are following the UNC naming conventions while specifying the folder name including the sub-directories.

So when we scheduled reports in order to create acrobat files on a network folder such as \\ServerName\Path directories.

the scheduled istance Fails and raises the error

source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]

Solution:

In our case we decide to move the server in the Windows Domain and this solved the problem!

See also

SAP BI 4 errors

BO XI R3.1 error list

Query Builder:queries for extract reports refreshed after o before a specific date

2014-02-06T03:54:00.000-08:00

Query Builder:queries for extract reports refreshed after o before a specific date

which could be useful to extract Webi reports in a specific folder with their name , owner, cuid, update date
that have been refreshed since a date

select si_name, SI_NAME, SI_OWNER, SI_CUID, SI_PARENT_FOLDER_CUID, SI_UPDATE_TS

FROM CI_INFOOBJECTS

where SI_KIND='WEBI'

and SI_NAME NOT like '%Nuovo documento Web Intelligence%'

and SI_INSTANCE='false'

and SI_UPDATE_TS > '2013.01.01.00.00.00'

and SI_PARENT_FOLDER = 851970

order by SI_UPDATE_TS asc

Removing SI_KIND='WEBI' you can extract also other document kind

select si_name, SI_NAME, SI_OWNER, SI_CUID, SI_PARENT_FOLDER_CUID, SI_UPDATE_TS

FROM CI_INFOOBJECTS

where

and SI_INSTANCE='false'

and SI_UPDATE_TS > '2013.01.01.00.00.00'

and SI_PARENT_FOLDER = 851970

order by SI_UPDATE_TS asc

You can also exclude Administrator as owner

select si_name, SI_NAME, SI_OWNER, SI_CUID, SI_PARENT_FOLDER_CUID, SI_UPDATE_TS

FROM CI_INFOOBJECTS

where

and SI_INSTANCE='false'

and SI_UPDATE_TS > '2013.01.01.00.00.00'

and SI_PARENT_FOLDER = 851970

and si_owner not like 'Administrator'

ERR_WIS_30271 - Maximum binary output size limit reached

2014-02-05T08:26:00.003-08:00

Maximum binary output size limit reached (ERR_WIS_30271)

Environment SAP BI 4 SP 8

While exporting a huge Web Intelligence report in Excel format BO raised the error:
Max Binary file size limit exceeded. The document is too large to be processed by the server. Error WIS 30271

Cause

This error message appears because BusinessObjects Enterprise allows documents to be saved with the limit specified for Web Intelligence Report server settings in the Central Management Console(CMC).

To resolve the error follow the below steps:

- Login to Central Management Console (CMC) using BusinessObjects Enterprise "Administrator".

- Navigate to "Home >> Servers".

- Click on "WebIntelligenceProcessingServer" to open its properties.

Increase:

Maximum Character Stream Size (MB)

which specifies the maximum character stream size sent to the Web Intelligence client.
Default value is 5. The valid range is 1 to 65535 MB.

Binary Stream Maximum Size (MB)

which s

pecifies the maximum size, in MB, of a binary stream sent to the Web Intelligence client.

Default value is 50. The valid range is 1 to 65535 MB.

- Click on "Apply" and then on "Update".

- Allow the Web Intelligence server to restart.

Increasing these values too high could impact Web Intelligence performance when users attempt to save excessively large files.

See also

SAP BI 4 Errors

CMC BI 4.0 -Visual Difference

2014-01-31T05:47:00.002-08:00

Visual Difference

SAP BusinessObjects Business Intelligence 4.0 - Version 4.0 SP2 Fixpack 5

Features

- Visual Difference framework allows easy identification of changes
- Comparison plug ins and viewers for each BI content type. (Eventually…)
- LCMBIAR viewer answers: “How is this version of the BI application different from a
previous version?”
- Future service packs will provide comparison viewers for universes and other content
types
- For example, will answer: “What is different between these two versions of a universe?
Can I easily merge changes?”
- Impact Analysis
- Understanding which objects in a universe have changed allows tester to focus only on
reports which use changed objects.

See Also

Visual Difference Overview

Lifecycle management console features: Overrides - Visual Difference Overview

2014-01-28T02:28:00.002-08:00

Lifecycle management console features

SAP BusinessObjects Business Intelligence 4.0 - Version 4.0 SP2 Fixpack 5

Lifecycle management console is now included in SAP BusinessObjects Business Intelligence

servers install package.

New Visual Difference capabilities allow easy identification of changes.

Scriptable promotions supported via a command line interface.

• Central Management Console– Visual Difference, Promotion and Version Mgmt.

Lifecycle management is now in CMC:

New Objects supported

Categories based promotion is now supported.

Server group promotion is supported however the servers are not promoted.

LCM is now localized.

• Job is copied

• Job is migrated

Update Source system of job when Overrides no longer job specific

Supports new improved BI platform Audit infrastructure

There are 2 new features specifically for integrated deployments with BW:

• SAP Authentication is now supported.

• Integration with the SAP standard change transport system (CTS)

Overrides Overview

Updating database connections (overrides) in XI 3.1 are job specific, in BI 4.0 are global.

In 4.0, Lifecycle management scans for all Crystal Reports, OLAP and Universe

Connections and QaaWS URLs in the origin system.

Scan information can be updated with values for destination.

When a report connection is promoted, database connection information is automatically promoted.

Overrides can be from one or many origins to one or many destinations.

Visual Difference

Visual Difference framework allows you to easily identify changes.

It provides comparison plug-in and viewers for BI content

In SAP BusinessObjects BI 4.0 only LCM Jobs and LCMBIAR comparisons are possible.

– LCMBIAR to LCMBIAR

– LCM Job to LCMBIAR

– LCM Job to LCM Job

LCMBIAR comparison includes:

- Metadata

- Primary Objects.

- Dependent Objects.

- The differences process results in 3 types of differences

- Removed

- Modified

- Inserted

See also

BI 4.0 - How to import or export a LifeCycle Manager BIAR file using command line utility

BI 4 - LCMBIAR Overview - LCM Command Line Tool

Visual difference

BI 4 - LCMBIAR Overview - LCM Command Line Tool

2014-01-28T02:15:00.001-08:00

LCMBIAR Overview - LCM Command Line Tool

SAP BusinessObjects Business Intelligence 4.0Version 4.0 SP2 Fixpack 5

Allows to:

Promote content between Development, Test, and Production SAP BusinessObjects BI 4.0 environments.

Allows you to use scripting to automate the import of objects.

Terms

BIAR and LCMBIAR:

BIAR:(BI Archive) is a collection of any binaries associated with a BI object and its associated metadata, all materialized in a zip file.

An LCMBIAR file is the same idea, but each object is stored in an individual BIAR.

Considerations:

Lifecycle management tool is to promote objects from BI platform 4.x to BI platform 4.X version only.

Upgrades from a previous BO version to BI 4.0 must be done using the Upgrade management tool.

To rollback a job you need to use the UI, not command line

LCM Command Line tool is not used when CTS+ is available.

What can you do with LCM Cmd line tool?

Report developer creates LCM Job with content to promote

LCM Administrator uses Command Line Tool (CLI) to create LCMBIAR

Export an existing Lifecycle Management job:

Report developer creates LCM job with content to promote

LCM Administrator uses CLI to promote LCM job content to destination

Promote existing job:

LCM Administrator uses CLI to promote LCMBIAR content to destination

Promote an existing LCMBIAR file:

LCM Administrator or developer writes one or more queries to specify the content selection and LCMBIAR file is created.

Export single or multiple platform queries:

LCM Administrator or developer writes multiple queries to specify content selection, the BOE content selected by the queries is promoted to the destination

See also

BI 4.0 - How to import or export a LifeCycle Manager BIAR file using command line utility

Lifecycle management console features: Overrides - Visual Difference Overview

BI 4.0 - How to import or export a LifeCycle Manager BIAR file using command line utility

2014-01-28T00:32:00.003-08:00

SAP NOTE 1634962 - BI4 - How to import or export a LifeCycle Manager BIAR file using command line utility

If you need to export or import a Life Cycle Manager (LCM) BIAR in BI 4 using command line utility.

Environment

l SAP BusinessObjects Business Intelligence Platform (BI) 4.0

l SAP BusinessObjects Business Intelligence Platform (BI) 4.1

Follow these steps:

1. Create a Properties file: Start by creating a properties file (Example c:\lcm1.properties) as below. Note that the names of properties and

lcmbiar files are not specific and can be anything.

While the below examples are provided with Windows syntax, they are applicable to unix environments as well with minor changes to file path

locations.

Here is an example of a properties file to EXPORT to an lcmbiar file:

exportLocation=C:/lcm1.lcmbiar

action=export

LCM_CMS=localhost:6400

LCM_userName=Administrator

LCM_password=password

LCM_authentication=secEnterprise

Source_CMS=localhost:6400

Source_userName=Administrator

Source_password=password

Source_authentication=secEnterprise

exportQuery1=select * from ci_Infoobjects where si_kind='Webi'

Here is an example of a properties file to IMPORT from an lcmbiar file:

importLocation=C:/lcm1.lcmbiar

action=promote

LCM_CMS=localhost:6400

LCM_userName=Administrator

LCM_password=password

LCM_authentication=secEnterprise

Destination_CMS=localhost:6400

Destination_userName=Administrator

Destination_password=password

Destination_authentication=secEnterprise

2. Run the Command line option: To run the LCM command line tool

1. Launch a command window or terminal, and navigate to location of the folder which contains the lcm_cli tool

Example: (in Windows) C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64

\scripts\lcm_cli.bat

(in UNIX) \sap_bobj\lcm_cli.sh

2. From this folder location, run the LCM Command line script lcm_cli [.bat or .sh] file as follows: lcm_cli.bat(OR .sh) -lcmproperty

Example: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\scripts\lcm_cli.bat -

lcmproperty c:\lcm1.properties

3. If prompted, provide an LCMBIAR Password for encryption and decryption of the lcmbiar file. [providing this password is optiona

Note: If lcm_cli.bat does not recognize the properties file, moving that file to the C:\ device can help to resolve the problem.

For more information, please refer to Lifecycle management console for SAP BusinessObjects Business Intelligence platform 4.0 User Guide

See also:

BI 4 - LCMBIAR Overview - LCM Command Line Tool

Lifecycle management console features: Overrides - Visual Difference Overview

Lcm managing infoobject versions

Lifecycle management console & BO Dashboard

WIS 00504 You do not have the rights to access data returned by this universe

2014-01-20T04:02:00.003-08:00

Error: WIS 00504

Message: You do not have the rights to access data returned by this universe. See your business objects administrator

Non si dispone dei diritti di accesso ai dati restituiti da questo universo. (WIS 00504)

Environment SA BI 4.0 SP 8

In order to solve this issue on refreshing a WebI report

check user permissions at user/folder/object level

Check the access rights for all the universes and universe connections

in this case for assigning rights to the user for Universe and connections, Login to CMC and go to Universes.

Select the universe which you are using,right click and select user security,check if your user has rights on that universe if not then use Add principals and assign rights to the user you are using.

Then go to Connections in CMC and select the connection which your universe is using and follow the same thing as done for Universes.

Moreover on the rights tab and for the user/group on the Access Level drop down, choose Advanced ->

look for Web Intelligence Document section and click on the + to expand.

Check that Refresh Report Data is Granted and anything else that might be required for your users (Refresh LOV's)

WIS 00005 Invalid Prompt definition

2014-01-10T08:54:00.001-08:00

Invalid Prompt definition. See your Business Objects administrator. (Error: WIS 00005)

Environment BI 4 SP 8

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.

WIJ 20002 Error - WebI Rich Client XI R3.1

2014-01-09T06:55:00.004-08:00

WebI Rich Client XI R3.1

Environment XI R3.1 SP 4

When we try to open an imported reports in Webi Rich Client, BO raises the following Error Code WIJ 20002 Error

Workaround:

Log in Web Intelligence Rich Client.

Go to Tools > Options

Go to Locale (tab) and set "Interface locale" and "Formatting locale" to English (United States) > OK.

Open a report in Web Intelligence Rich Client it runs !

See Also

XI R 3.1 errors solutions

Information design Tool - How to refresh the structure of a universe

2014-01-08T06:34:00.001-08:00

In order to refresh the structure of the universe in the Information design Tool

Open the Data Foundation

Click on detect button

and select Refresh Structure

as you can see in the following image

Err QTJ 00511 - Circular references : check your @select and @where calls (QTJ 00511)

2014-01-07T07:03:00.002-08:00

Circular references : check your @select and @where calls (QTJ 00511)

Environment BI 4 SP 8

Cause

An @Select or @Where call in the script refers to itself. This is not allowed.

Action
Check the declaration of the @Select and @Where calls and correct or modify the script.

See also:

Sap BI 4.0 errors list

Error UNV0023 - Parse Failed: Invalid Definition (UNV0023)

2013-12-18T02:09:00.006-08:00

Parse Failed: Invalid Definition (UNV0023)

Environment BI 4 SP 8

We are working with Universe Design Tool on universes
that require the same tables so after inserting the tables in one universe and creating classes/objects/meta data, we copied the same classes and objects into other universes as the tables are the same.

But when we parse the objects in the table after copying we got following error: Parse Failed:Invalid definition (UNV0023).

The only way to solve the problem was to go into each object and copy, delete and then past the table object name.

So the advise that in similar cases is:

first you have to add the tables

and then you can add relative objects and not viceversa!

2nd case

We got the error in another case

For an object with the following select:

CASE WHEN @Select(PromptList\....) IN @Prompt('Code:','N','PromptList\CatCode',multi,constrained)
THEN @Select(PromptLis\generic)
ELSE (SELECT LTRIM(MAX(SYS_CONNECT_BY_PATH(LISTA,', ')) KEEP (DENSE_RANK LAST ORDER BY curr),', ')
FROM (SELECT DESC_CA AS LIST
,ROW_NUMBER() OVER (ORDER BY 1) curr
,ROW_NUMBER() OVER (ORDER BY 1) -1 prev
FROM CAT_DESC
WHERE CODE_CAT IN @Prompt('Code:','N','PromptList\CatCode',multi,constrained)
)
CONNECT BY prev = PRIOR curr
START WITH curr = 1
)

END

The error was due to CatCode witch has been changed in CatC
and so we forgot to change it in the string @Prompt('Code:','N','PromptList\CatCode',multi,constrained).

See also

http://businessobjectsbi4.blogspot.it/2013/09/sap-bi-40-errors-list.html

BI 4 Error - Index is not ready. Please try again later (PSS 01004)

2013-12-13T06:35:00.002-08:00

Index is not ready. Please try again later (PSS 01004)

Environment BI 4.0 SP 8

When we tried to find a document name in the search field the error above has been raised.

Resolution

Go to CMC->Application-> Right Click 'Platform Search Application'->Properties

Go down in the page and select the option "Rebuild Index", save and close.

Let the index rebuild and

Restart the SIA

Check also the SAP NOTE

http://service.sap.com/sap/support/notes/1634413

Business Intelligence with SAP Business Objects 4.3

Connection failed. server has reached maximum number of simultaneous connections (Error: RWI 00239)

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

Cannot find the BusinessObjects Enterprise report source. (LO 26608)

Webi Error XI 4.1 - Your security profile does not include permission to edit this documents (WIS 30252)

Information Design Tool XI 4.1 SP 5 - Problem on opening a session as designer user not administrator

BO XI R 3.1 - Changing Business Objects Server Hostname

If you need to change the hostname of BOE XI 3.1 server machine follow these steps

Please note that changing just IP Address should NOT have any impact on the system.

Desktop Compatibility Pack (DCP) with SAP BI Platform 4.1 SP1

Desktop Compatibility Pack (DCP)

Webi 4.0 Error: c3_qtds_error_it_505

Error c3_qtds_error_it_505

Soon: troubleshooting with UMT & Promotion Management

CCM Error: Visual C++ Runtime library

CCM Error : Visual C++ Runtime library

Error:RWI 00226 - Cannot initialize Report Engine Server. (Error:RWI 00226)(Error:INF)

Cannot initialize Report Engine Server. (Error:RWI 00226) (Error:INF)

HTTP Status 500 - BI Launchpad URL after moving BI 4 server under Windows Domain

After moving the server under Win Domain both cmc and bi launchpad url erased the following error:

Environment

SAP BI 4.0 SP 8Microsoft Windows Server 2008 R2

SAP BI 4 - Scheduling reports error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]

Scheduling reports error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]

Query Builder:queries for extract reports refreshed after o before a specific date

Query Builder:queries for extract reports refreshed after o before a specific date

Removing SI_KIND='WEBI' you can extract also other document kind

ERR_WIS_30271 - Maximum binary output size limit reached

Maximum binary output size limit reached (ERR_WIS_30271)

CMC BI 4.0 -Visual Difference

Visual Difference

Lifecycle management console features: Overrides - Visual Difference Overview

Lifecycle management console features

Overrides Overview

Visual Difference

LCMBIAR comparison includes:

BI 4 - LCMBIAR Overview - LCM Command Line Tool

LCMBIAR Overview - LCM Command Line Tool

SAP BusinessObjects Business Intelligence 4.0Version 4.0 SP2 Fixpack 5

BI 4.0 - How to import or export a LifeCycle Manager BIAR file using command line utility

SAP NOTE 1634962 - BI4 - How to import or export a LifeCycle Manager BIAR file using command line utility

WIS 00504 You do not have the rights to access data returned by this universe

Error: WIS 00504

Message: You do not have the rights to access data returned by this universe. See your business objects administrator

WIS 00005 Invalid Prompt definition

Invalid Prompt definition. See your Business Objects administrator. (Error: WIS 00005)

WIJ 20002 Error - WebI Rich Client XI R3.1

WebI Rich Client XI R3.1

Information design Tool - How to refresh the structure of a universe

In order to refresh the structure of the universe in the Information design Tool

Err QTJ 00511 - Circular references : check your @select and @where calls (QTJ 00511)

Circular references : check your @select and @where calls (QTJ 00511)

Error UNV0023 - Parse Failed: Invalid Definition (UNV0023)

Parse Failed: Invalid Definition (UNV0023)

BI 4 Error - Index is not ready. Please try again later (PSS 01004)

Index is not ready. Please try again later (PSS 01004)

After moving the server under Win Domain
both cmc and bi launchpad url erased the following error:

SAP BI 4.0 SP 8
Microsoft Windows Server 2008 R2