Data Load Error Messages 1003000 to 1003048

This document describes data load error messages and information messages. The discussions of error messages include possible causes and possible solutions for each problem, with links to the Analytic Services Database Administrator's Guide and the Analytic Services Technical Reference for more information on how to fix errors.

Click an error message number to view information about that error message.

1003000 1003023 1003040
1003001 1003024 1003041
1003003 1003025 1003048
1003004 1003027

 

1003005 1003028

 

1003006 1003029

 

1003007 1003030

 

1003008 1003031

 

1003010 1003032

 

1003011 1003034

 

1003012 1003035

 

1003013 1003036

 

1003014 1003037

 

1003015 1003038

 

1003022 1003039

 


1003000 Unknown Item itemName in Data Load, number Records Completed

Possible Problems

Analytic Services encountered a field in the data source that it did not recognize.

Possible Solutions

Examine the data load log for any other messages that may help to identify the problem.

Make sure that the data source is valid. If no records loaded, either the first record is invalid or the entire data source is invalid.

Make sure that the record that caused the data load to fail is valid.

If you are using a rules file, make sure that the rules file is valid.

If you are using ESSCMD, make sure that the ESSCMD syntax is valid.

See Also

1003034


1003001 Duplicate Members From Same Dimension On Data Record, number Records Completed

Possible Problems

Analytic Services encountered more than one member from a dimension in a single record. Analytic Services will not load this record and will skip to the next record.

Possible Solutions

Make sure that the data source is valid.

If you are using a rules file, make sure that the rules file is valid.

If you are using ESSCMD, make sure that the ESSCMD syntax is valid.

If you are using Integration Services, try the following steps:

See Also

1003015


1003003 Unable to Continue Data Load After Item itemName, number Records Completed

Possible Problems

Analytic Services aborted the data load. This error message usually occurs after other error messages that describe why the data load failed.

Possible Solutions


1003004 Incorrect Number of Column Members in Symmetric File After recordNumber Records Completed

Possible Problems

Analytic Services encountered either more or fewer columns than it expected while reading the data source.

Possible Solutions

Make sure that the data source is valid.

See Also

1003005


1003005 Incorrect Number of Column Members in Asymmetric File After recordNumber Records Completed

Possible Problems

Analytic Services encountered either more or fewer columns than it expected while reading the data source.

Possible Solutions

Make sure that the data source is valid.

See Also

1003004


1003006 Unknown Text File Type After recordNumber Records Completed

Possible Problems

Analytic Services did not recognize the text file.

Possible Solutions

Make sure that the text file is valid.

If more than one record loaded, make sure that ranges in the data source are correctly formatted.


1003007 Data value numericValue Encountered Before All Dimensions Selected

Possible Problems

Analytic Services encountered a numeric data value in the data source before all dimensions were specified.

Possible Solutions

Make sure that the data source is valid.


1003008 With Data Value numericValue, Too Many Values In Row, number Records Completed

Possible Problems

Analytic Services encountered more numeric data fields in the record than it can map to the database.

Possible Solutions

Make sure that the data source is valid.

Make sure that the rules file is valid.


1003010 Data Value numericValue Does Not Match #Missing Value in Database, number Records Completed

Possible Problems

Analytic Services encountered a problem when it tried to validate the database against the data source to see if both contain the same values.

Possible Solutions

See Also

1003011
1003012

1003013


1003011 Data Value numericValue Does Not Match #Invalid Value in Database, number Records Completed

Possible Problems

Analytic Services encountered a problem when it tried to validate the database against the data source to see if both contain the same values.

Possible Solutions

See Also

1003010
1003012

1003013


1003012 Data Value numericValue Is Greater Than Value in Database, number Records Completed

Possible Problems

Analytic Services encountered a problem when it tried to validate the database against the data source to see if both contain the same values.

Possible Solutions

See Also

1003010
1003011

1003013


1003013 Data Value numericValue Is Less Than Value in Database, number Records Completed

Possible Problems

Analytic Services encountered a problem when it tried to validate the database against the data source to see if both contain the same values.

Possible Solutions

See Also

1003010
1003011

1003012


1003014 Unknown Member memberName in Data Load, number Records Completed

Possible Problems

Analytic Services did not recognize the member name.

Possible Solutions

Make sure that the data source is valid.

Make sure that the rules file is valid.

Make sure that the member name is valid.

If you are using ESSCMD, make sure that the ESSCMD syntax is valid.

If you are using Analytic Services Integration Services, make sure that the following conditions are met.


1003015 Member memberName is from the same dimension as members defined in Header Name, number Records Completed

Possible Problems

Analytic Services aborted the load because two different members were specified for the same dimension. One member from the dimension was specified in the header record and another member from the same dimension was specified in a record in the data source.

Possible Solutions

Make sure that the data source is valid.

If you are using a rules file, make sure that the rules file is valid.

See Also

1003001


1003022 Unable to Open Data File

Possible Problems

Analytic Services cannot open the data file.

Possible Solutions

Make sure Analytic Services can find the data file.

Make sure Analytic Services can use the data file.

If you are using ESSCMD, make sure that you are using the IMPORT command correctly. When you issue the IMPORT command, you have four options to choose the location of the data file.

See Also

1003027
1003030


1003023 You have insufficient access privileges to perform a lock on this database

Possible Problems

You did not have the necessary permissions to lock the database so that you can load data.

Possible Solutions

Contact your Analytic Services System Administrator.

If you are a System Administrator, grant yourself the correct permissions.


1003024 Data Load Elapsed time : number seconds

This information message states how long it took Analytic Services to load a data source. There is nothing wrong.


1003025 DATAERRORLIMIT reached numberOfRecords. Rejected records will no longer be logged

Possible Problems

The error log was full. This means that you have too many error messages to fit in the data load or dimension build error log or that you are rejecting too many records to fit in the log.

Possible Solutions

Fix the errors in the data load or dimension build error log and restart the data load.

Change the maximum number of records allowed in the data load or dimension build error log.

  1. If you do not have an $ARBORPATH/bin/ essbase.cfg file on the server computer, create one using a text editor.
  2. Add or increase the DATAERRORLIMIT setting in the $ARBORPATH/bin/essbase.cfg file.
  3. Stop and restart Analytic Server.
  4. Restart the data load.

1003027 Unable to open file

Possible Problems

Analytic Services cannot open the file.

Possible Solutions

Make sure Analytic Services can find the file.

Make sure Analytic Services can use the file.

If you are using ESSCMD, make sure that you are using the IMPORT command correctly. When you issue the IMPORT command, you have four options to choose the location of the file.

See Also

1003022
1003030


1003028 File fileName is password protected and could not be read

Possible Problems

Analytic Services did not have the necessary operating system privileges to open the file you are trying to load.

Possible Solutions

Make sure that you have read privileges for the file. Consult the operating system documentation for more information.


1003029 Encountered formatting error in spreadsheet file fileName

Possible Problems

Analytic Services encountered a formatting error in the file.

Possible Solutions

Open the file outside of Analytic Services and make sure that the file is valid.


1003030 Unable to load file fileName; see server logfile for details

Possible Problems

Analytic Services cannot read the file.

Possible Solutions

Make sure Analytic Services can find the file.

Make sure Analytic Services can use the file.

If you are using ESSCMD, make sure that you are using the IMPORT command correctly. When you issue the IMPORT command, you have four options to choose the location of the file.

See Also

1003027
1003022


1003031 Commit at record recordNumber during arithmetic data load

This information message states that Analytic Services saved the record to the Analytic Services database. There is nothing wrong.


1003032 Input line too long near record recordNumber

Possible Problems

Analytic Services encountered a record that was too long to process. Analytic Services cannot process records that contain more than 32,000 characters.

Possible Solutions

Make sure that all records are separated by a carriage return.

Make sure that no single record contains more than 32,000 characters.


1003034 Invalid member memberName in data column

Possible Problems

Analytic Services encountered a non-numeric value in the in data column. Data columns must contain numeric values only.

Possible Solutions

Make that sure that the data source is valid.

Make sure that the record that caused the data load to fail is valid.

If you are using a rules file, make sure that the rules file is valid.

See Also

1003000


1003035 No data values modified by load of this data file

This information message states that Analytic Services did not change any of the values in the Analytic Services database as a result of the data load. There is nothing wrong.


1003036 Cannot load data. Member name too long: memberName

Possible Problems

Analytic Services encountered a member name that was too long.

Possible Solutions

Make sure that the member name is valid.


1003037 Data Load Updated numberOfCells cells

This information message states that Analytic Services updated the indicated number of cells in the database. There is nothing wrong.


1003038 Dataload queue overflow on node nodeNumber

Contact Hyperion Technical Support.


1003039 Cannot load data. Implied shared member memberName does not have a real child

Possible Problems

Analytic Services cannot load data into the selected member because the member is shared. Shared members cannot contain data.

Possible Solutions

Make sure that the member is not shared. Members are shared under the following conditions:


1003040 Parallel dataload enabled: number block prepare threads, number write threads.

This information message states that parallel data load is enabled. There is nothing wrong.


1003041 Data Unlock Elapsed Time : number seconds

This information message states the time required to unlock all the locks after the Unlock command is issued in the Spreadsheet Add-in.


1003048 Loading Unicode-encoded data to non-Unicode mode application is not supported

Possible Problems

You have attempted to load unicode-encoded data to a non-unicode application.

Possible Solutions

Verify that you have migrated your application to unicode mode.