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!
.png "sasikanth"){kind=avatar}
