Thursday, November 15, 2007

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.

Is the data source corrupt?
Is the data source in the correct location?
Is the data source correctly formatted?
Make sure that the record that caused the data load to fail is valid.

Is a member from each dimension specified in the data source or the rules file?
Is each member name in the record valid?
Is there more than one numeric data field in the record?
Did you try removing the record that caused the data load to fail and running the data load again?
If you are using a rules file, make sure that the rules file is valid.

Is the rules file in the correct location?
Is the rules file set up correctly?
Can you validate the rules file?
If you are using ESSCMD, make sure that the ESSCMD syntax is valid.

Check the error log in the ESSCMD script to determine where the unknown item exists.
Are the parameters enclosed in quotation marks? For example:
IMPORT 2 "ACTUALS" 4 "Y" 2 "ACTUALS" "Y";
Are the parameters correct?
Do the files you are loading exist in the correct locations?
Can you run the data load using Administration Services?

No comments: