1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Troubleshooting EPM Cloud Issues
  3. Troubleshooting Database Refresh Issues
  4. Resolving Database Refresh Failure Error: Invalid Character 0x19

Resolving Database Refresh Failure Error: Invalid Character 0x19

Database cube refresh operation may fail and display the following error:

Cube refresh failed with Essbase Cube: <CubeName>, Error code: 1060374, 
Message: Error XML Exception: invalid character 0x19 attribute value 'alias'

Cause

This error is caused by the presence of special (control) characters in the member name or member alias within the application.

At times, an upstream integration process may introduce illegal control characters in member aliases. Example, the hexadecimal control character 0x19 is an illegal character per the XML standard and cannot be used in member names and aliases. Upstream systems should remove or filter out such illegal characters from member names and aliases.

Solution

To resolve this error:

  1. Sign in to the application.
  2. On the Home page, select Tools and then Migration.
  3. In Categories, click Core.
  4. Make sure that no artifact is selected in Artifact List: Core.
  5. Expand Global Artifacts and then Common Dimensions.
  6. Export one or more dimensions to a CSV file. Exporting the artifacts to CSV helps you use Microsoft Excel or a text editor to locate the special character that causes this error.

    You can export all standard and attribute dimensions to one file or choose a few dimensions to export. For example, you may select Standard Dimensions to export all standard dimensions.

    1. Select the dimensions that you want to export to review and identify the member or alias name that cause this error.
      Standard dimension selection
    2. Click Export and follow the screen prompt to save the export file.
  7. Download the exported file to a local computer. See these information sources:
  8. Using Microsoft Excel or a text editor, review the CSV file to identify special characters present in artifact names or member aliases.
  9. Repeat steps 6 through 8 to export and review Attribute Dimensions to identify special characters present in artifact names or member aliases.
  10. In the application, remove special characters present in member names and aliases.
  11. Refresh the database to verify that the process finishes without errors.