Solution : https://service.sap.com/sap/support/notes/1404989 (SAP Service marketplace login required)
Key words : 
bwa index fails due, return code 1994            prepare failed, bwa index fails, valid data format, rc=1994            prepareoptimize finished, invalid data reason, database table sdate, invalid data, error code, prepareoptimizeaeandtm failed
Related Notes : 
       
| 1393505 | BWA 7.20: Central Note | 
| 1260249 | BWA 7.00/7.20: List of Error Codes | 
| 883726 | BIA 7.00: Central Note SAP NetWeaver BI accelerator |