Error Message on the Connector Log:

•  QVX_PIPE_ERROR: Not a legal OleAut date

Behavior:

• Using Qlik SAP Connector 6.x version

• Using SQL Connector to extract

• They have dates to extract between 0001-01-01 and 0099-12-31

The problem lays on the limitation in the .Net Framework on using the DateTime.ToOADate Method()

The said method has a limitation with minimum value of January 01, 0100, thus dates between January 01, 0001 and December 31, 0099 is not possible to load.

For further information visit the link from Microsoft:
https://msdn.microsoft.com/query/dev12.query?appId=Dev12IDEF1&l=EN-US&k=k(System.DateTime.ToOADate);k(TargetFrameworkMoniker-.NETFramework,Version%3Dv4.5.2);k(DevLang-csharp)&rd=true
 

Resolution Steps:

• Upgrade the Qlik SAP Connector to the latest version (as at this writing its 6.3.2) - please check from the download site