We have the oracle 9i as the datasource and connected to Qlikview through the OLEDB Connectivity.
We have an oracle sql statement in the edit script which is running sucessfully sometimes and getting failed sometimes. There is no issues with Sql Statement and with the connectivity.As the error in the log file shows Script error no error. If i am running the same sql statement in any other front end tool it is working fine without throwing error(Not even once error has occured). I am getting the error only in Qlikview that to not all the times.but very few times.I have already posted the issue once. And waiting for experts advice.
but I saw it happened with me, i open another ODBC and deleted this one after 5 min then click on Select button and qlikview ask for the obbc connection. However my Oracle ODBC was on its place and i have not saved the script after opening or deleting second odbc.
Logically they are not possible but in real scenario they happens.
In your case it seems like network reset issue, that means network got reset between resulting qlikview throw error.
i am also facing the same issue where i am connected to Oracle database but it doesn't fetch any records, just remain as it is " Displaying Connected in the Script after the Connection String", whereas in the Existing Environment its working fine. We are in the Migration Project.