Store DATE in QVD

[schmimla21]

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!

[sasikanth]

hi,

refer the below link ,

https://community.qlik.com/t5/QlikView-App-Development/Load-date-from-oracle-Timestamp-Qlikview/td-p...