Search This Blog

Loading...

Wednesday, March 26, 2014

Soon: troubleshooting with UMT & Promotion Management

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

Tuesday, March 4, 2014

CCM Error: Visual C++ Runtime library

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.

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 19, 2014

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 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

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!

Thursday, February 6, 2014

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

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'

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 "Web Intelligence Report Server" to open its properties.
- Increase the "Maximum Binary File Size"(Default value=50 MBytes; Maximum value = 65535 MBytes).
- 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