Blog - Meta Data Load Errors

Data and Metadata Load Errors in Data Management

  • , Consultant

Data Management introduced the ability to load metadata to Oracle EPM Cloud Services in the 17.11 update. This functionality provides organizations the ability to leverage a user-friendly platform for loading both data and metadata. Equally important, Cloud Data Management (CDM) allows metadata to be transformed using its familiar mapping functionality.

However, though this is an exciting user-friendly option, there could still be errors in exporting both metadata and data exporting to the application, particularly when like mapping is used.

Data Load Errors

For data load errors, the error format is generally the same:

2020-09-21 16:59:43,227 INFO [AIF]: Load data encountered the following errors:

| Error # | Member with error | "Account","Entity","Version","Custom Dimension 1"," Custom Dimension 1"," Custom Dimension 2"," Custom Dimension 3","Scenario","Year","Period",Amount |

The fields are delimited by pipes.

  • The first field is the Error #
  • The second field is the member which supposedly causes the error
  • The third field is the line or record

The order dimensions in the record may vary depending on the application setup. The error is usually preceded by the following message:

Some common errors are below.

Error: 3303

| Error: 3303| Mountains | "A100000","United_States","WIP","Mountains"," East_Coast","USD","Accounting_Source","Actual","FY20","Jan",10000 |

Cause: The member that does not exist in the database.

Fix: The member just needs to be added to the database in the related dimension or remapped to member that does exist.

Error: 3335

| Error: 3335 | A100000 | "A100000","United_States","WIP","Mountains"," East_Coast","USD","Accounting_Source","Actual","FY20","Jan",10000 |

Note: This error identifies the first (e.g. Account) dimension as the member that doesn’t exist in the database, but when you check the account dimension, the member exists.

Cause: The error is actually due to duplicate member in a different dimension. The error does not know which member so it chooses the first in the record, but this may not there is a different member in the string that is not in the defined dimension.

Fix: To fix this you will need to identify the member that does not apply to the dimension, then update the source file or remap to a different member that exists in related dimension.

Other Error codes are below:

Error Number Error Contents
3303 Member not found in database.
3304 Insufficient access to store data.
3333 Bad data value supplied.
3335 Record rejected because of duplicate member names.
3336 Member/Data unknown.
3337 Record rejected because of dimension conflicts with Header Name


Metadata Load Errors

With the metadata load process, there could be various errors that will require troubleshooting and/or remapping.

The metadata load errors are different from data load errors.

Invalid Length:

Accounting_Source_that_is_too_long_for_PBCS_Metadata_And_Needs_to_be_much_shorter_2 |Total_Source| “Accounting_Source_that_is_too_long_for_PBCS_Metadata_And_Needs_to_be_much_shorter_2” is an invalid length

Invalid Parent:

Wed Sep 30 22:02:57 UTC 2020]com.hyperion.planning.InvalidMemberException: The member Mountains does not exist for the specified cube or you do not have access to it

Other general causes:

In general, the characters * “ and , will potentially cause errors in the load, more specifically

  • Descriptions with a character as the first letter in the name (i.e. *DO NOT USE)
  • Descriptions with commas in the name when the source file is comma delimited
  • Descriptions with quotes at the end - PBCS tries to read the row as one string when there are quotes
  • Descriptions that are longer than 80 characters

Contact MindStream Analytics

Want to learn more about Data Management and Oracle EPM Cloud Services? Please complete the form below and we'll get back to you shortly.


Latest testimonial

MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers customers services ranging from software selection and implementation to best practices for financial planning. MindStream will work with customers towards a solution that enhances value and offers more insight into their data. MindStream believes in the power of technology combined with new procedures to give customers better analytic capabilities


Partner SpotLight

Oracle Partner

Oracle

Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost..

Oracle Profile

Share: