Mssing OLAP connections in the Designer
If you are missing OLAP connections with predefined password in the Designer as of Lumira 2.3:
Slow performance with embedded IE browser in Design Studio/Lumira client tool following update to Windows 10 Fall Creators Update 1709 or higher
"Design Studio" and "Lumira Designer" client tool used for Dashboard Design, both use an embedded IE browser, when building the report in the Design tool.
The embedded browser relies on a Microsoft windows library used for rasterization called d3d10warp.dll.
After an upgrade of the Windows Operating System from Windows 10 1703 to Windows 1709/1803, the performance when manipulating components in the embedded browser has degraded dramatically. The Designer becomes unusable in this case.
This performance issue has been isolated to a change in an operating system driver d3d10warp.dll.
In Windows 10 from 1703 the driver version is d3d10warp.dll 10.0.15063.1155. In Windows 10 1709 the driver version is d3d10warp.dll 10.0.16299.309.
We have reported this to Microsoft, who are currently working to resolve the issue.
Following Microsoft's recommendation, if you encounter this issue, after a Windows 10 1709 update, please report the issue to Microsoft.
In your problem report, please include the following description:
"Slow performance with embedded IE browser after upgrading Windows 10 from 1703 (d3d10warp.dll 10.0.15063.1155) to 1709 (d3d10warp.dll 10.0.16299.309 and higher)"
This SCN article will be update as we receive updates and progress reports from Microsoft on this issue.
Scheduled Fix Date
The fix for this issue is currently being tested by Microsoft.
As the issue impacts more than one release, these are the currently planned release dates:
For 1709 (RS3) targeting the third week of February. (19.2.) This has been released.
For 1803 (RS4) targeting the third week of February. (19.2) This has been released.
For 1809 (RS5) targeting March 1st. (1.3.) To be released.
The fix will be rolled out as an automatic update. It will not require additional action (other than having automatic-update enabled) by the user.
The fixes will be accompanied by relevant Knowledge Base articles as required, for example see https://support.microsoft.com/en-us/help/4480976.
The KB numbers below are the planned numbers at present. These may change on release. This page will be updated to reflect any changes.
For 1709 (RS3) see KB 4487021
For 1803 (RS4) see KB 4487029
For 1809 (RS5) KB 4482887
This issue has been documented in SAP Note 2738289.
This page describes the procedure customers should follow when experiencing issues with SAP BusinessObjects Design Studio.
|Check whether you have installed the newest Design Studio release according to SAP Note 1760372.|
Read the release limitations notes related to your Design Studio version:
|If the error occurs only when connected to BI Platform (and not in local mode), read SAP Note 1894504 in addition.|
|If the error occurs only when connected to SAP NetWeaver (and not in local mode), read SAP Note 1894594 in addition.|
|If the error occurs only when connected to SAP HANA (and not in local mode), read SAP Note 2154859 in addition.|
|Read the Administrator Guide: SAP BusinessObjects Design Studio, especially the configuration and troubleshooting sections.|
Designer Version in DS_Support.zip
Download BIP Lumx and run in local mode
These images explain how to download a LUMX from BIP so that it runs in local Designer mode i.e. without any login to BIP. This is important in support in order to avoid any influence of BIP settings (be it user specific, or connection specific stuff) on the scenario.
- Run the Designer logged into BIP and export the app(s) from the LUMX via a Support ZIP
- Open the Support ZIP and copy the LUMX into the Lumira Documents folder
- Restart your Designer and skip the logon to BIP. Open the app from the Local Documents folder NOT from (Offline) BI Plattform...
Map all BIP connection to SAPLOGON / Designer Hana connections like so:
Starting the GA template via Execute Locally with Parameters
To reproduce issues in the Designer it is sometimes necessary to start a Generic Analysis template with its parameters specifying the data source properties:
XSYSTEM, XQUERY, XTYPE
On BIP the XSYSTEM has this syntax cuid:<cuid>
But executing locally in LUMX mode it works the following way:
At first add your connection to the LUMX document. Then go to the On-Startup handler e.g. and add a DS_1.assignDataSource. Press Ctrl-Space to get the completeion dialog and chose the connection chooser. Then select the newly added connection.
Finally you will see an index in this example "2" which represents this connection.
Then choose Execute Locally and append the follwing to this URL:
Test Web Service and Restful Service
In case you face issue with login (Lumira Designer is using Web Service) or creating LUMX document (Lumira Designer is using Restful WS) you can easily test the 2 URLs in Chrome. The results should look like this: Use Chrome to achieve the same output.
The restful URL must show this kind of XML when correctly configured:
And the web service URL must show this message if correctly configured:
Create Fiddler of Designer WebService and Restful WebService calls
Open your SapLumiraDesigner.ini and add the 4 +2 bold lines at the same position:
Then start Fiddler and afterward the Lumira Designer. Be aware that the password is part of the Fiddler. You can just delete the items recorded during login in Fiddler or search for the Password and delete all matching lines.
The final Fiddler should contains:
A) Web Service URLs
B) Restful Web Service URLs
Failed to create remote document (404)
com.sap.ip.bi.zen.connectivity.ConnectivityException: Failed to create remote document "test_lumira"
Caused by: com.sap.ip.bi.zen.connectivity.ConnectivityException: org.apache.http.client.ClientProtocolException: Unexpected response status: 404
Caused by: org.apache.http.client.ClientProtocolException: Unexpected response status: 404
Verify that in CMC that the "Restful web service" application's host name is the Lumira server host
Fix Layout after Migration to SAPUI5 m Mode
You are missing members when using context menu
The No. 1 candidate is the new setting of the context menu that came with 1.6 SP x.
Be aware that there is a know bug that returns MaxNumber - 1 members only, e.g. 99 instead of default 100.
Design Tool Installation - SAPSetup Guide
The design tool installation is done with the SAPSetup Wizard. For more information, see chapter "Installation" in the Administrator Guide: SAP BusinessObjects Design Studio.
For more information about the SAPSetup Wizard, see the SAPSetup Guide:
Start the design tool installer with the following parameter:
The SAPSetup Guide is available in the extractFolder.
Problems During Startup
- If the Design Studio/Lumira client does not start, perform the following steps:
- Uninstall the Design Studio/Lumira client and delete the whole installation directory in case there is something left: C:\Program Files (x86)\SAP BusinessObjects\Design Studio
- Rename the following two folders:
C:\Users\xxx\Analysis-config or LumiraDesigner-config
C:\Users\xxx\Analysis-workspace or LumiraDesigner-workspace
- Reinstall the Design Studio client.
- If you encounter problems during startup, switch off the Antivirus temporarily, then test with an administrator user. If this works, you can find missing rights with the help of the SysInternals AccessChk tool:
accesschk -s <yourUser> "C:\Program Files\SAP BusinessObjects\Design Studio"or
accesschk -s <yourUser> "C:\Program Files (x86)\SAP BusinessObjects\Design Studio"Make sure that for all files and folders you have at least read permissions. Additionally you can use the -n option to "Show only objects that have no access". Please compare the output of a working user and a non-working user.
If Design Studio shows the splashscreen for a short time, but the application does not come up (or the application comes up with a completely broken user interface), and the error log contains an entry like the following:
java.lang.ExceptionInInitializerError: JCo initialization failed with java.lang.UnsatisfiedLinkError: <some path...>\sapjco3.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform
then a conflicting sapjco3.dll exists on your system, which took precedence over the Design Studio packaged DLL. The solution is to append the following line to SapDesignStudio.ini:
followed by a line break. This sets the java.library.path system property to the empty String, eliminating external effects caused by the Windows PATH variable.
- If during startup a popup with "Failed to create Java Virtual Machine" appears, your VM might have run out of memory.
Try to reduce the memory settings step by step:
- Change the parameter -Xmx in the file SapDesignStudio.ini in the Design Studio installation directory, e.g. from "-Xmx1024m" to "-Xmx768m".
- Restart Design Studio.
This value had to be increased with Design Studio 1.2 SP01 from 512 to 1024 (Xms from 128 to 256, MaxPermSize from 384 to 512). Consider switching to a 64 Bit OS in case of insufficient memory.
- If the design tool displays a "Collecting Garbage" error message, then a reduction of the two memory values mentioned above can also help.
SSLException creating document (DS >= 2.0)
In case you face an error
Caused by javax.net.ssl.SSLException: hostname in certificate didn't match: ....
Solution: please verify your WACS URL in the CMC.
Instantiating Data Sources
If you encounter errors instantiating data sources, please check your etc/services file on the server or desktop (local mode).
Hints in the trace file are:
Connect to message server host failed.
SAP HANA Hierarchies
You have issues / crashes with a hierarchy defined in SAP HANA Studio: Note that not all HANA hierarchy features are supported in Design Studio. For more information, see SAP Note 2038663.
SAP HANA HTTP Connections (Design Studio 1.5)
You use Design Studio 1.5 and consuming SAP HANA HTTP data sources gives the following error message: SQL Error : insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:3290. This indicates that there are additional privileges required for the SAP HANA user. For more information, see SAP Note 2141541.
You use Design Studio 1.5 and consuming SAP HANA HTTP data sources causes HTTP error 404 or 403. Make sure that the Info Access Service is imported on your SAP HANA server. For more information, see Importing the Info Access Service.
To create HTTP Traces of the INA protocol with Fiddler (Note 1766704) change the following preferences in the Design Studio client:
Note: If Fiddler does not show any traces with Lumira then you can add the 2 proxy lines the Designer's or Discovery's INI file after this existing line:
If you are not allowed to change the INI because you are not administrator, then you do the following.
Make a copy of Designer or Discovery INI file which from the installation folder into a directory where you are allowed to edit it, e.g. Desktop.
Then add the above lines at the end of the INI file and save.
Finally create shortcut to Designer or Discovery Executable and add this parameter in the properties:
IMPORTANT: youj have to use Execute Locally to use the INA client implementation in the Designer firing the HTTP requests to the server through Fiddler. If you run the application on BIP then the BIP Lumira Addon will fire the HTTP requests and you will not record them on the client.
Now start at first Fiddler (otherwise nothing works) and then the new shortcut.
In Fiddler you can filter for /ina/ requests like this:
Then your recording should look like this:
In case Fiddler does not show any requests or only Tunnel requests containing /ina/ in the URL and your INA connection you are using HTTPS, then try the following:
In case all these efforts do not help and you still have tunnel requests, a look into the Fiddler log might reveal the root cause. So if you are an expert with HTTPS you might know a workaround. In case not you have to enable HTTP temporarily and gather the Fiddler traces with HTTP.
Note 2242449 explains how to analyze issues with the INA protocol and how to prepare message for the INA / MDS team:
Create a trace according to the last chapter in the attached PDF:
Retrieve Connection Properties via Query Builder
When you analyze the HTTP communication of the Designer with Fiddler via INI parameter:
you can figure out the SELECT queries that are sent to the platform for retrieving all connection properties.
In case of problems this can be done with the Query BUilder as well.
Be aware that the Design Studio Designer fetches all connections immediately after login with 1 HTTP request but Lumira Designer fetches them when you open the Add Connection dialog, i.e. when they are shown to the end user. Another difference with Lumira is that it fetches only the connections for the current selected folder (for performance reason).
Fiddler will show the SELECT statements and they will look like this (in this example Lumira Designer 2.1):
Then start the query build tool (For details about the tool https://blogs.sap.com/2013/06/17/businessobjects-query-builder-basics/)
Now copy/paste the SELECT statement from the above XML and submit it.
The CUID in the statement is the CUID of the folder where the problematic OLAP connection resides in. You can look up each CUID in BI launchpad.
The query in this example is:
The result looks like this:
If you are looking for the properties of a specific OLAP connection you can lookup the CUID of the connection and then fire this statement replacing the CUID with yours:
No Local Connections Available
If no local connections are shown in the Design Studio client, this can be caused by not finding the saplogon.ini file. If the INI file is stored in a "non-standard" location or is stored in a virtual application, you can specifiy the location by adding these two lines to SapDesignStudio.ini:
<path to your ini file copy>
IMPORTANT: Add them directly before the -vmargs line. Note that there must be a line break separating the argument from its value. If the path denotes a folder, the file name inside that folder must be "saplogon.ini". The path can also directly point to a file. In this case, you can choose the file name individually.
For trouble shooting please analyze the Debug logs like this:
Single Sign-On (SSO) Problems
If you have issues with SSO using SNC with the design tool, read chapter "Authentication and Single Sign-On in Local Mode" in the Administrator Guide: SAP BusinessObjects Design Studio.
For Kerberos configuration please also read these notes / KBAs:
1769179 - How to configure KERBEROS login on Business Intelligence Platform (with Java test program)
SSO to BW in Designer fails as of Designer 2.2
This issue is caused by the combination of SNC setting for a BW system in CMC and the usage of SSO for an OLAP connection to the same system.
Workaround 1: switch off temporarily SSO and use a hardcoded user password
Workaround 2: switch off SNC for this system
HTTPS / SSL
Read the following notes
1807142 - How to enable HTTPS/SSL Designer against BIP
2154860 - Troubleshooting HTTPS / SSL issues with Design Studio
If you have codepage issues in applications on BI platform and SAP NetWeaver at runtime (wrong characters being displayed at runtime, filters on members with non-ASCII characters in their name not working), see SAP Note 2216929.
BIAL Script Validation Errors
If you encounter BIAL Script validation errors, read SAP Note 2079054.
"No More Handles" Error Analysis
If you get the error "SWTError: No more handles", proceed as follows:
- Start your task manager and click on the Processes tab.
- Choose menu item View/Select Columns.
- In the Select Process Page Columns dialog box, select Handles, User Objects and GDI Objects and click OK.
Sort the process list by Image name and select the design tool process SapDesignStudio.exe (with Design Studio >= 1.4 observe the corresponding javaw.exe process).
Work with your design tool for a while and execute at least each step once. Then write down the handles number and observe whether you can find steps after which the handles always grow with a significant amount.
Normally handles are allocated and after finishing a certain step e.g. by closing of windows, dialogs, applications they are released again with a short delay. But if the number grows when repeating a step 5-10 times always in more or less the same magnitude, then this might indicate an error.
- Start Internet Explorer, press Alt-X and choose Internet Options.
- Close the design tool and all Internet Explorer processes.
Issues With Preview and/or Execute Locally
If the preview in the design tool and "Execute locally" do not show any analysis application but instead an empty page or errors like "This page can't be displayed", proceed as follows:
- Disable Antivirus and Firewall temporarily.
- Choose Execute locally and copy/paste the URL into a different Web browser like Chrome or Firefox and test the application with this browser.
- Install a VM with a new Windows OS and design tool installation and compare this with the non-working system.
- Try different ports: You can configure them in the design tool on the Preferences page under Embedded Web Server.
- Analyze the ports of the design tool:
For example, you can use the Sysinternals TCPView to look at the local ports that are used by the internal Web Server (jetty) inside the design tool.
Here is the port used by the design tool (can be changed on the Preferences page):
And here TCPView shows that the design tool is LISTENING on port 7777.
Furthermore make sure that your IE is configured in a way that it does run in IE mode 11:
As the preview inside the Designer is also an IE control it can have the same limitations as the standalone Internet Explorer. Choose execute locally and run the application in IE and the press F12 and verify the mode. Important you have to use the localhost URL to achieve the same scenario as in the preview.
The Enterprise Mode feature might cause issues here:
Analysis Applications With MIME Objects
Depending on which platform and release version you use, note the following:
Design Studio >= 1.3 in BI Platform Mode
- For CSS and images, use the Open CSS or Open Image dialog of the design tool's property sheet.
- For other MIME types like TTF, use the Open CSS dialog:
- Click the Upload Local CSS button.
- In the file selector, enter e.g. *.ttf after the file name and select your MIME object.
Note: Other extensions than CSS will not appear at all in the Open CSS dialog. MIMES without path used in a CSS must be uploaded to the same folder as the CSS.
Design Studio <= 1.5 in SAP NetWeaver Mode
You need to upload all MIME objects manually in the ABAP Workbench of the BW system.
Note: MIME objects without path used in a CSS must be uploaded to the same folder as the CSS.
For more information, see "Uploading Images to the MIME Repository" in the Administrator Guide. SAP BusinessObjects Design Studio based on SAP NetWeaver at http://help.sap.com/boall > English > all products: Design Studio.
Design Studio >= 1.5 in SAP NetWeaver Mode
Depending on the SAP NetWeaver release version, there are different ways to upload the images:
- You upload the images in the design tool.
For more information, see chapters "Image" or "Button" in the Application Designer Guide: Designing Analysis Applications, under Help > Help Contents in the design tool.
For more information about the required SAP NetWeaver release versions for direct upload in the design tool, see SAP Note 2111546.
You upload the images in the ABAP Workbench of the BW system. For more information, see "Uploading Images to the MIME Repository" in the Administrator Guide. SAP BusinessObjects Design Studio based on SAP NetWeaver at http://help.sap.com/boall > English > all products: Design Studio.
Design Studio <= 1.5: How To Find Out Which MIME Objects Are Used In Your Application:
- Create your analysis applictaion in local mode.
- Choose Application > Open Repository Folder.
- Open the XML file content.biapp in your application folder with a text editor.
- Search the file for CSS and images.
- Check if the CSS files reference other MIME objects like fonts.
For example, NEW_DESIGN_FONT.css used in the templates of the design tool references SAP-icons.ttf and SAP-icons.eot.
Design Studio >= 1.5: How To Find Out Which MIME Objects Are Used In Your Application:
With Design Studio >= 1.5, when exporting analysis applications in the Export Application dialog box, the system analyzes the selected application and auto-detects all MIME objects referenced by the application (including MIME objects referenced by script coding). For more information, see chapter "Exporting Analysis Applications" under "Advanced Design Tasks" in the Application Designer Guide: Designing Analysis Applications, under Help > Help Contents in the design tool.
SDK component is not updated in the Designer or Platform
Make sure that you are using the a version number with a "qualifier" as the last part of the number, e.g.
This guarantees, that Eclipse during generation process replaces the qualifier place holder with an increasing version number.
This can be found in the feature.xml as well as in the manifest.mf.
Further info can be found in the SDK docu:
Designer is slow
Symptom: an extremely slow startup.
Please check whether your task manager Details tab show similar heavy load on Windows Defender MsMpEng.exe process:
If the majority of CPU consumption is SapDesignStudioVm.exe then please do the following tests:
- disable temporarily Antivirus and Firewall
Restart the Designer and verify whether it has an effect. If this has an effect contact your Antivirus or Firewall vendor.
- If not, Install a new Windows on a VM e.g. and before installing any other software install the Designer and test again This worked fine inside SAP network.
- If this works fine then add additional software like security products one by one and test after each installation again
- If your data source has an initial view configured, and changes to the data source in the backend (BW or HANA system) are not reflected in your application or even make the application crash at runtime, read SAP Note 2154750.
- BI Platform mode only: If after the import of an application containing Universe-based data sources the data source fails to initialize even though you mapped the Universe in the import wizard correctly, read SAP Note 2286208.
- If you have performance related issues, read SAP Note 1931691.
- If the design tool crashes, read SAP Note 2021164.
- As of Design Studio 1.4, there is an issue with SAP JVM and Kerberos. For more information, see SAP Note 1769179.
- In case of 60s timeouts against Hana data sources of see Support for SAP HANA System
- In case of timeouts (com.sap.ip.bi.zen.connectivity.ConnectivityException: Read timed out ) against BIP in the Designer read note 2125471
SAP Note 1773751: Design Studio - Support Note for Client
Use this structure to help you compose your contributions for WIKI and at the same time will ensure spelling and grammar.
Disable predefined user/password authentication for OLAP connections by default