Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I´m having this error log when I trying to do a query to SAP table.
The script that result to this error is this :
ACTUAL:
LOAD
CHANGE_TSTAMP;
SELECT
Min(CHANGE_TSTAMP) as CHANGE_TSTAMP
FROM BCA_CN_LINK
WHERE OBJECT_TYP LIKE 'BCAA'
AND FUNCTION LIKE '13%'
With this script the error log is
2019-10-07 16:22:42 1 fields found: CHANGE_TSTAMP,
2019-10-07 16:22:42 Error: QVX_UNEXPECTED_END_OF_DATA: Job aborted, check log for Job /QTQVC/READ_DATA in
2019-10-07 16:22:42 Job Overview (transaction SM37)
Making some changes to the script to see if the error is on this side, I did this modification without LIKE sentence
ACTUAL:
FIRST 10
LOAD
OBJECT_ID,
CONTRACT_INT,
OBJECT_TYP,
FUNCTION,
CN_LINK_ID,
CHANGE_TSTAMP
FROM BCA_CN_LINK
WHERE OBJECT_TYP = 'BCAA'
AND CHANGE_TSTAMP > $(vULTIMA_CARGA)
And the result was ok .....so
I like to know if someone had the same problem , if is in the connector or in the SQL query to SAP table.
Thanks
Check the following article, this is our means of collecting the info we need to analyze SAP Connector issues, the key thing here would be the connector log, this is likely where your useful info is being written. There should be something more useful in the actual connector log in this case versus the script log entry.
SAP Connector case requirements
Regards,
Brett