Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!