Store DATE in QVD

schmimla21 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I`m quite new to QV/QS and I have a problem regarding a DATE-COLUMN:

Background: I have an Oracle Database (11) from where I want to unload specific Data into QVD-Files via QV. Everything worked fine until I wanted to unload a Column with Oracle-Datatype DATE. In the qvw-logfile "QVX_UNEXPECTED_END_OF_DATA:" is shown. A few rows are transferred into the QVD, but the execution of the script ends with the error message, that there was an error while reading via OLEDB. So I guess, that QV is somehow not able to process specific rows of the Data.

This is how I try to unload and save the data:

MY_TABLE:
SQL SELECT
time_timestamp as sometime
FROM MY_DATABASE."MY_TABLE"
STORE MY_TABLE into \\share\MY_TABLE.qvd (qvd);;

NLA Parameters of the Oracle Database:

NLS_DATE_FORMAT = DD.MM.RR

NLS_TIME_FORMAT = HH24:MI:SSXFF

NLS_TIMESTAMP_FORMAT = DD.MM.RR HH24:MI:SSXFF

SET-Parameters in QV:

SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

Is there somebody who has an idea, what causes the troube? Thank you very much in advance!

topic Re: Store DATE in QVD in QlikView

Store DATE in QVD

Re: Store DATE in QVD