The select statement of the table DD03L is really heavy and can take long time to execute. There are two parameters you can use to increase the execution time. Put a string like ;TimeOutBatch=1800;TimeOutFetch=3600; in the connection string. You can change the values as you like. They are in seconds.
You can read more about 'Connection string parameters' in the manual.
If the statement fails the reason can often be found in the log for job /QTQVC/READ_DATA in transaction SM37 in the SAP system.
Hi again Sarah,
We have discovered that there is an issue with the parsing of this select statement. It occurred in connection with changes of the SQL connector in release 5.80 SR4. It will be fixed in the next connector release. In the meantime you can easily change it yourself. Change INTTYPE <> '' to INTTYPE <> ' ' (put a blank character between the single quotation marks) in the select statement like:
SELECT FIELDNAME KEYFLAG TABNAME CHECKTABLE ROLLNAME POSITION FROM DD03L where AS4LOCAL = 'A' AND INTTYPE <> ' '