Data Load Error File

If data loads generate errors, the file dataload.txt is placed in a folder Integration Server creates for the load under the products/Essbase/eis/server/loadinfo directory. The dataload.txt file lists rejected dimensions and members and error message codes to identify data load problems.

The folder Integration Server creates in the loadinfo directory is in the following format:

<application_database_timestamp_sessionnumber>

If you performed a data load for the MyTBC application and MyTBC_DB database at 10 P.M. on May 1, 2003, the folder is named:

MyTBC_MyTBC_DB_2003_May_1_10_00_pm_<sessionnumber>

In the case of data load failure, open the dataload.txt file located in the folder described previously and review the error codes.

These are the most common error codes:

Message Number

Message

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.

Figure 1, Example from dataload.txt File shows three records from the dataload.txt file with the error code 3303.

Figure 1. Example from dataload.txt File

Sample error lines from dataload.txt file.