Search This Blog

Showing posts with label Errors. Show all posts
Showing posts with label Errors. Show all posts

Thursday, May 7, 2015

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

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"

Monday, April 27, 2015

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



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



Wednesday, February 26, 2014

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


 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:

Wednesday, February 12, 2014

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

 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!

Wednesday, February 5, 2014

ERR_WIS_30271 - Maximum binary output size limit reached

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

Monday, January 20, 2014

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 

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)

Friday, January 10, 2014

WIS 00005 Invalid Prompt definition

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.

Thursday, January 9, 2014

WIJ 20002 Error - WebI Rich Client XI R3.1

 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

Wednesday, December 18, 2013

Error UNV0023 - Parse Failed: Invalid Definition (UNV0023)

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

Monday, December 9, 2013

Error WIS 10901 - A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32x_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found)

WebI Error WIS 10901

A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32x_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found)

Environment BO XI 3.1 SP 4

We get this error when  to create a  Rich Client  report from a user's machine, against a universe with a connection to an oracle database.


Solution


This usually due to  incorrect ODBC configuration
so in order to solve this issue try the following steps:

1.      Stop all the services from BO Central configuration Manager.
2.      Open odbc.sbo file located at "Program Files\Business Objects\BusinessObjects Enterprise    11.5\win32_x86\dataAccess\connectionServer\odbc"

3.     Go to parameter setting for "Generic ODBC datasource ".

4.     Change the value of "Transactional Available" parameter to No.

5.     Add this new parameter setting for "Generic ODBC datasource ": 0

6.     Save and close the file.

7.     Start all the services from BO Central configuration Manager.


8.     Go to BO Web Intelligence, create a new web document and execute.

An alternative work around
is to use the system name  with J2EE  connection

See also

Wis 10901 webi rich client error db

Business Objects errors

Wednesday, December 4, 2013

Error ERR_WIS_30285 -The Web Intelligent server is running out of memory, your document has been closed. If the problem persists, contact your BusinessObjects administrator. (Error ERR_WIS_30285) while refreshing a large Webi report.

Error ERR_WIS_30285 -The Web Intelligent server is running out of memory, your document has been closed. If the problem persists, contact your BusinessObjects administrator. (Error ERR_WIS_30285)  while refreshing a large Webi report.


Envirnonement BO XI R3.1 SP 4

This error was erased while scheduling or refreshing  a large Webi report.


The cause is connections  timed out.

Resolution
File Repository Servers:-
Input Server: Maximum Idle Time : 60 Minutes (CMC-->servers-->Input File Repository Server)                                                
Output Server: Maximum Idle Time : 60 Minutes (CMC-->servers-->Output File Repository Server)
Universe - Timeout parameter limit in the Universe - set this in Designer
Open the designer > import the universe. Click File > Parameters, select the controls tab, increase the Limit execution time to 60 minutes.
WebIntelligenceProcessingServer Connection Timeout - This is set in the CMC > Servers > WebIntelligenceProcessingServer (Default is 20 mins , please make it 60 mins) .
Command Line Timeout Parameters for WebIntelligenceProcessing server - right click to Properties and edit the command line and add the following at the end :                                                                                              
-requesttimeout 3600000 (This is in milliseconds, so 60mins). Then restart the servers.
In the Central Management Console (CMC) go to the Servers page Select WebIntelligenceProcessingServer. Increase the values for these two properties:
Memory Maximum Threshold: set to 2000
Memory Upper Threshold: set to 2000.


For further information please check SAP NOTE 1538502

See also:

Monday, October 28, 2013

Err_WIS_30270 While exporting in Excel a report Webi - XI R3.1 SP 4



Err_WIS_30270 While exporting in Excel a report Webi


Environment XI R3.1 SP 4

This problem happened to an user which received a report WebI in the In box when she tried to export it in xls format.

Resolution
We edited the advanced rights on favorite folder of this user as the rights to export in csv, pdf and xls were not specified and then in her case not allowed!

So we granted them under WebI Report Content  as you can see in the following figure!


Friday, September 6, 2013

WIS 10901 - Webi Rich Client error - DB Driver failed to load

WIS 10901 - Webi Rich Client error - DB Driver failed to load


Environment BO XI R 3.1 SP4

This error occurred opening a LOV on refreshing a Rich client report.


Solution

If you're logging into rich client in 2-tier mode (system name with computer icon) then the TNSNAMES.ora will be picked from local machine( in this case you must have an Oracle client installation and an up to date Tnsnames)
Instead when using 3-tier (system name with world icon) then the TNSNAMES.ora will be picked from the BOBJ server 
So the server may not be configured properly if the latter option is used 

This rule has to be applied on a DeskI application setup 

Wednesday, September 4, 2013

FWB 00027- CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator

 CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator 


Environment BO XI R 3.1 SP4

Please follow these steps

1. Check the database connectivity 
2. Check the Logfile(s) 

 If everything is right, restart the SIA agent.


This issue usually indicates problem with CMS database and this might also occur if CMS table entry is corrupted.

Thursday, August 29, 2013

Connection or SQL sentence error. (DA0005) - DESKI

Connection or SQL sentence error. (DA0005)





Cause
Connection Server can generate a connection or SQL sentence error after the date format has been changed in the relevant .sbo file. This can occur if the format set in the .sbo file does not agree with that set in the database.


Action
Verify that the Oracle NLS_DATE_FORMAT parameter is set to the date format that you have set in the data access .sbo file. Check your Oracle documentation for more information. See the "Data Access Guide" for information on parameters defined in the .sbo files, and how to modify them.

Cause
Your Oracle data access drivers have been moved, deleted, renamed, or damaged.
Action
Re-install the Oracle data access driver

Friday, May 3, 2013

FWM 01002 - Unable to reconnect to the CMS. The session has been logged off or has expired.

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002)



Environment BO XI R 3.1 SP 4

In order to solve this issue we found a  SAP released note 1422296 

1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1.

Symptom
Not able to schedule WebIntelligence reports.
Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)'

Environment
BusinessObjects XI 3.1.

Reproducing the Issue
Schedule a WebIntelligence report to run now.
Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)'

Resolution
1. From Central Configuration Manager, disable all the services and re-enable them.
2. Log into Central Management Console and go to the server area.
3. Go to the properties of Central Management Server, in command line parameters type -requesttimeout 3600000.
4. Save the changes and restart the server.
5. Follow the same steps for WebIntelligence Processing Server and Adapter Job Server.
6. Go to the connection server properties and increase "Ideal connection timeout" to 120, restart the server

See also:
BUSINESS OBJECTS ERRORS LIST

Tuesday, April 30, 2013

Error RFC 00101 - No server was available to process the request

Error RFC 00101 - No server was available to process the request. Please try again later. (Error RFC 00101) (Error: INF )

Environment BO XI R 3.1 SP4


This error often happens during the peak business hours while scheduling WebI reports.
In our case we solved the problem  increasing the Maximum connection perameter in WebIntelligenceProcessingServer on CMS.
The  default value is 50 connections per one WebI Processing Server. 
The best way is to create the new webi processing server from the CMS.

In case of DeskI reports:


Following solution might be helpful in resolving the issue.

To resolve the error message

Log on to the Central Management Console as administrator.
Click Servers > Desktop Intelligence Report Server.
Increase the following time-out parameters to at least twice the current value:

Minutes before Idle connection is closed
Minutes before an idle report job is closed


Moreover if this solution does not work for you, you can checkthe following SAP Notes in  "Help & Support" section on the 

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



1363743 - '(DA0005)... no default driver specified state: IM002' and 'RFC 00101 Error INF' errors when refreshing a deskI report in InfoView
1202263 - Error: "No server was available to process request. Please try again later. (Error: RFC 00101) (Error: INF)"
1336210 - when refreshing Desktop Intelligence report in InfoView "No server was available to process request. Please try again later. (Error: RFC 00101) (Error: INF)"
1423194 - "No Server was available to process the request. Please try again later. (Error: RFC 00101) (Error: INF)" when refreshing a DeskI document in InfoView
1200315 - No server was available to process the request.Please try again later(Error:RFC 00101)(Error:INF)

Check also:
BUSINESS OBJECTS ERRORS LIST

Wednesday, April 10, 2013

#DATATYPE ERROR in WebI

#DATATYPE ERROR


Environment: WebI BO XI R3.1 SP 4 

You got thi error when you are using a wrong data type . 
For example if  your data is numerical but it is throwing char or date then Business Objects will  expose this error.
Often it  happens, when you mix string and number or string and date/time data types. 
If these data types are mixed, the function returns a string.
As Date/time and number data types cannot be mixed  the results is a #DATATYPE error.


Solution:

In Webi you must create a variable in which you have to convert and cast the data types in order to make them all homogeneous as datatype.

Thursday, April 4, 2013

Error ERR_WIS_30270

 An internal error occured while calling 'getMap' API. (Error : ERR_WIS_30270).

Environment BOE XI R3.1 SP 4

This is a generic error message,

 in our case we had this error while we were applying  some changes to an old WebIntelligence report.

By searching through SAP notes there are about 100's of notes on this error. The problems can range from bugs (as also stated in this thread) to configuration issues with universe to report design.

 IF you are unable to resolve with the latest patch then open a case with the SAP BO.

Solution

In our case we saved the report we re-open it and we made some changes in the query pane and after this it was refreshed correctly.


Other case:


Considering four web intelligence reports, among these, for one report when i click on refresh list of values of a prompt i am getting the error 
"An internal error occored while calling process DPCommands API (Error: ERR_WIS_30270) (Error.INF). 


In order to solve this issue apply following steps

1. Log into the Business Objects CMC
2. Go to the 'Servers' area of the CMC
3. Double-click on the WebIntelligenceProcessingServer server to open the properties
4. Scroll down the page and uncheck the 'Enable Real-time Cache' checkbox
5. Click 'Save and Close'
6. Highlight the WebIntelligenceProcessingServer server which should now have a flag next to it
7. Right-click and select 'Restart server' for the change to take effect
Your server will now have memory available to it and you should find that the error message will not be shown.

Thursday, March 21, 2013

Internal error [ RCIRAS0216 ] (Error: INF ) Please contact your system administrator.

Internal error  [ RCIRAS0216 ] (Error: INF ) Please contact your system administrator.

Environment BOE XI 3.1 Deski report with Zabo
 on Windows 2008 R2 

Case:

We had this exception after changing from Zabo a Deski option on saving the report, we checked the option 'Refresh on opening' the report.
After exporting in the CMS the report on opening it we had the above exception

Solution

We imported the report on Deski,
 choosig the BO system with  (J2EE Portal),
 we save it  again by checking the option 'Refresh on opening' 
and we re-exported it.

After this the issue was resolved.

See also:

Errors list - Solutions