Notes, Limitations, and Fixed Issues

Limitation:  If a user name consists of multi-byte characters (in a language supported by XS, for example: Japanese), you cannot add a picture to the Dashboard frame.

15936

Limitation: Dashboard Filter - If the string in any Dashboard filter includes a comma, the filter uses the string up only up to the comma and does not use the whole string. The strings correspond to dimension values.

Workaround: Make sure the dimension values in your data do not include strings.

16331

16358

(old CR number: 168682)

16360

16401

User Management - If you update a Role, check that it is OK, log out, and enter XS with a user that is assigned the updated Role, the application does not "remember" the updated role.

Workaround: 

1. Close the browser.
2. Wait for the default 10 minutes cache refresh.
3. Re-open the browser and log on again

Limitation: Importing Excel files with empty cells in the last row causes an error in the ETL process.

The following error is issued: com.hp.dwh adapters.fbi.common.exception.ExtractorException: Java.lang.RuntimeException: ERROS: couldn't extract the field:"Comment(Extract Column: Comment)" from Excel file

Workaround: Make sure that the Excel files you intend to import do not include empty cells in their last row.

Limitation: In Chrome, in the Studio, due to a (Smart)GWT limitation, when you create a Breakdown KPI or Metric in the Active KPIs tree, the scroll bar auto-scrolls up to the top of list of Breakdowns when you change the focus from the Breakdown menu to the Breakdown dimension menu, and makes it difficult to select the option.

Workaround: Use the keyboard to perform your selection.

Limitation: In Java 7u51, the default behavior for the high security level changed, causing the display of security warnings each time the XS application runs Java code.

Reason:

The following changes to Security Slider were included in release (7u51):

• Block Self-Signed and Unsigned applets on High Security Setting
• Require Permissions Attribute for High Security Setting
• Warn users of missing Permissions Attributes for Medium Security Setting

Resolution:

1. To verify that your version of Java is 7u51, open the Java Control Panel, click the Java tab, click the User tab, and check that the latest the Product number is 1.7.0.51.
2. To prevent the display of security warnings, open the Java Control Panel, click the Security tab, move the security slider to Medium.

20503

Error message: Internet Explorer has modified this page to help prevent cross-site scripting

IE may give this warning when you open and refresh reports too many times.

Workaround:

1. In IE , click Tools > Internet Options.
2. Click the Security tab, select Internet zone, and click the Custom level button.
3. Scroll down to the Enable XS Filter option in the Scripting section .
4. Select Disable and click OK.
5. Select Trusted sites in the Security tab, and click the Custom level button.
6. Repeat step 3 and step 4.

Limitation: If any CAP fails, during activation, with an unexpected error such as network connection loss, insufficient disk space, server shutdown, or other.

Workaround:

Manually remove all external tables relevant to the failed CAP.

1. Write a join query on table [CAP_CONTENT_ITEM] and table2 [CAP_CONTENT_PACK] and Filter by [CAP_CONTENT_PACK].[NAME]=’<CAP_name>’ and [CAP_CONTENT_ITEM].[TYPE] = ‘DATA’, to list all the table names.

2. Manually drop each table in the list, one-by-one, in the external schema of the Target database.

Limitation: Slow data extraction due to SM lack of an index

The current latest SM database lacks the necessary index on the sysmotime field. This causes the performance to slow down on delta load Extraction job for getting INCIDENT and INTERACTION entities.

23462 ***

Internet Explorer

The FLN window does not work well in Internet Explorer 10.00 and higher.

The problem is due to the jspdf.js third party Uint8Array.

Workaround:

• In Internet Explorer 10, open the developer mode (F12 Developer Tool), click the Browser Mode tab, select IE10, click the Document mode tab, and select Standards.
• In Internet Explorer 11, open the developer mode (F12 Developer Tool), click the Document mode icon, and select 10.

10.00

10.10

Limitation: Do not replace source model files in Content Pack folders with temporary source model files

If the Content Pack was previously activated, the source model files in the folder are used by the ETL when it runs. If you replaced source model files in the Content Pack with temporary source model files, the temporary files will be used by the ETL.

23844 ***

Limitation: With Windows 7, a Dashboard page that includes a component with an Xcelsius report does not display when using IE11.

Workaround: Use the IE10, Chrome, or Firefox browsers to view Xcelsius reports in Windows 7.

Important: If a KPI has 2 Breakdowns and the 2 Breakdowns are either in the same table or are in joined tables, and the user does not have permission to view the entities under one Breakdown, the user will still view the forbidden data under the other breakdown.

For example: KPI User has the following Breakdowns:

• User > ORG > Team
• User > Team > ORG

The logic between Breakdowns at the same level is OR, while the logic at the level of the KPI Breakdown and the Breakdown of a KPI Breakdown is AND.

If the user does not have permission to view the ORG Breakdown, but has permission for Team, he can view the ORG data under the Team Breakdown.

Workaround: Depending on the data you want the user to view, your KPI tree should be either User > ORG > Team or User > Team > ORG, but not both.

CSA & CO (10.10)/VPV (10.00) - Canceled subscriptions do not appear in the Resource Usage and Utilization report

The Data Warehouse catches only slow dimension changes. If the subscription was canceled the same day it was opened, it is not recorded.

Workaround: Run the ETL once a day.

CSA & CO (10.10)/VPV (10.00) - Disk/CPU/Mem Usage info in Resource and Utilization reports do not keep the history allocation values

If you changed the allocation values of the disk/CPU/memory of a VM, the Resource and Utilization reports of the day before the change and of the day after the change both show the new value. The historical value is not shown in the report.

Duplicated days in the PERIOD table in ITBA 10.10

After upgrading from ITBA 10.00 to ITBA 10.10, the days are duplicated in the PERIOD table in ITBA 10.10. To fix the issue, use the DWH-Period-Regenerator-Tool.zip tool located at https://hpln.hpe.com/node/10214/otherfiles/?dir=29610

Upgrade: The KPI library is not updated after Upgrade

If your ITBA is 10.00 and the Content Packs version is CP001, CP002, or CP003, the KPI library is not upgraded after you upgrade to ITBA 10.10.

Workaround: After upgrading to ITBA 10.10, you must upgrade the KPI library using the DW-KPI-Library-Import-Tool.

To upgrade the KPI library:

1. Download the DW-KPI-Library-Import-Tool from HPLN (https://hpln.hpe.com/group/it-business-analytics, click Resources, and click 5.Tools, and save it in your Linux target directory.
2. Unzip the tool file .
3. To execute the script, run the contentPackTool.sh -A command. Make sure you are using the ITBA installation user and not the root user to execute.
4. After completion, log on to ITBA to check the upgraded KPI Library.

DCS - ETL fails at DCS step while connecting to an MS SQL data source that is case-sensitive.

Connecting to an MS SQL data source (for example AM or SM) that is case-sensitive, if the column name or the table name in the source data model is not the same as the name in the DB, the ETL fails at the DCS step.

For example: with the AM datasource, ITBA defines the column name for column lCountryId in the amLocation table is lCountryId out of the box. If the column name is LCOUNTRYID in the source MSSQL DB which is case-sensitive, then ETL fails at the DCS step.

SM - SM 7.11/9.2/9.3 DBDict data source cannot be activated after upgraded to ITBA 10.10

Workaround: After upgrade to ITBA 10.10, in the ITBA application:

1. Click ADMIN > Data Management >  Connect Data Source.
2. Click EditSettings for the relevant instance.
3. In the Data Source Wizard, select the correct SM Version and save it.
4. Activate the instance again.

Important Note: Integration with CSA

The BOE server is required by the CSA Content Pack to OOTB report will not be displayed, so that means BOE installation is not optional , it’s just optional for particular OOTB Content Pack

Studio - In Calculation Monitoring note the following:

Limitation: When generating an AWS report, the.csv zip files can not be found.

Workaround: Follow the following steps before running the ETL:

1. Go to $HPBA_HOME/ContentPacks/AWS/EXTRACTOR/extractor-aws.
2. Open the settings.properties file.
3. Change the value of targetPrefix from "-aws-billing-detailed-line-items-with-resources-and-tags-" to "-aws-billing-detailed-line-items-with-resources-and-tags-AISPL-".