TDV SQL Support for SAP Dates
By default, the SAP application data service throws an exception and aborts a query if erroneous dates are returned from the SAP system.
To override SAP date behavior
1. Uncomment the following line in the product.properties file:
sap.handle.erroneous.date=USE_DEFAULT sap.handle.erroneous.date.default=99991231
2. To enable the properties, edit product.properties at:
<TDV _install_dir>\apps\dlm\app_ds_sap\conf\product.properties
3. The date format is YYYYMMDD. If no default date is specified, the date will be 19000101. If the specified default date is invalid, an exception is generated.