SAP Netweaver Business Intelligence BI / BW

Symptom

The filling of a BWA index fails with error code “1994″
Other terms

BIA, BWA, Explorer, Polestar, filling, indexing, date, invalid data
Reason and Prerequisites

Filling of BWA index fails due to a not valid data format in an attribute of type DATE. You can find the following trace entries in traces of TREXIndexServer:
DateAttributeValue::set(): attribute value is not a date or wrong syntax(6931), value “0919-98-30″
Additional info for previous 6931: index “sid_bi0:sdateen”, attribute “date0″, docid 474, value “0919-98-30″
sid_bi0:sdateen: prepareOptimizeAEandTM failed with rc=1994
prepareOptimize finished for index sid_bi0:sdateen with return code 1994
prepare failed for sid_bi0:sdateenwith rc=1994

In that example the invalid data is in database table SDATE in column DATE0. The format of the data of type date itself maybe invalid or a not defined character is booked in the database table.
Solution

Clean up the data of the info object in your BW.