Posts Categorized: Administration

XI 3.1 Issue with Excel Data Provider

Posted by & filed under Administration.

Problem A Webi document has a query based on Excel (Excel data source). The document can be refreshed in Web Intelligence Rich Client, but it fails in Infoview with WIS 30270 error. The following errors appear in the log: ExtensionFactoryImpl.cpp:201:void __thiscall WICDZExt::ExtensionFactoryImpl::createRemoteExtension(const class WICDZExt::ExtensionDescriptor &,struct WICDZExt::IExtension **): TraceLog message 24650 2014/10/17 09:02:31.474|>>|E| |13916|15036| |||||||||||||||ExtensionFactoryImpl::createRemoteExtension has […]

XI 3.1 OpenDocument URLs for copy-paste

Posted by & filed under Administration.

Here are some simple templates for OpenDocument links http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&iDocID=00000 http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=AAAAAAAAAAAAAAA http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sPath=[Folder],[Subfolder]&sDocName=Document http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=AAAAAAAAAAAAAAA&sInstance=Last ="<a target='_blank' href='" +"../../opendoc/openDocument.jsp?sType=wid&sDocName=" + URLEncode("Document") +"&lsSPrompt:="+UserResponse("Prompt:") +"'>"+Text +"</a>"  

SQL Anywhere iSQL

Posted by & filed under Administration.

Starting from BusinessObjects XI SP5, SAP Sybase SQL Anywhere is used as default database for BusinessObjects system databases (CMS and Audit). This post describes basics how to connect to the system databases using iSQL.

How to add new SQLAnywhere database

Posted by & filed under Administration.

Starting from BusinessObjects XI SP5, SAP Sybase SQL Anywhere is used as default database for BusinessObjects system databases (CMS and Audit). This post describes steps how to add a new database and provides some information about SQLAnywhere tools.

Problem with OpenDocument inside IFrame in Internet Explorer

Posted by & filed under Administration.

Symptoms It is not possible to login to BusinessObjects using Internet Explorer when the report is embedded into another web page using IFRAME and OpenDocument link. <iframe width=100% height=100% src="http://SERVERNAME:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sDocName=Balance+Sheet"> You get the login screen but nothing happens when you try to login (you are staying on the same page). The OpenDocument link works when […]

BusinessObjects Enterprise XI 3.1 – Supported Platforms

Posted by & filed under Administration.

Links BusinessObjects Enterprise XI 3.1 SP3 for Windows – Supported Platforms BusinessObjects Enterprise XI 3.1 SP5 for Windows – Supported Platforms BusinessObjects Enterprise XI 3.1 SP3 for Linux – Supported Platforms BusinessObjects Enterprise XI 3.1 SP5 for Linux – Supported Platforms Search on SAP Supported Browsers BOE XI 3.1 SP3 Supported Browsers BOE XI 3.1 […]

Removing the Failed Instances Manually From the Database

Posted by & filed under Administration.

The error in BO XI 3.1 SP3 causes millions of failed instances generated (SAP note 1448881 "Multiple instances spawned after daylight savings time change"). If the problem is not solved timely, the BO is getting slow, services is starting to fail often. It is usually possible to remove the instances programmically (SAP note 1568718 "How […]

CMS operation timed out after 9 minutes

Posted by & filed under Administration.

The error "CMS operation timed out after 9 minutes" (see below) means that the BO was not able to complete a query to a CMS database. This could be the case when the CMS database became too large (e.g. if the system is affected by the issue described on the SAP note 1448881). A workaround is […]

Undocumented parameters of BIAR Command Line Tool

Posted by & filed under Administration.

There are a number of undocumented parameters of BIAR Command Line Tool. You might find some of them interesting. Documented Parameter Default Comment yes action  null importXML/exportXML yes userName  null yes password  null yes CMS  null yes authentication  null yes includeSecurity  true yes exportBiarLocation  null yes exportDependencies  false yes importBiarLocation  null yes exportQuery yes exportQueriesTotal […]