The database you try to connect to can't be found. That could be because you specified the wrong database (the SID in oracle speak), or the database is not available, or perhaps a network problem is causing this problem. Check with your database administrator that your oledb connect string is correct and that a connection to the database can be established from the Qlikview server.
First, make sure that you can reload in QV Desktop on the Server machine - to confirm that the Oracle client is installed and configured.
If it works, the problem most likely is with the QV services user. In QV Desktop, you reload and connect to the database as yourself. When Server runs reload, the services user connects to the database. There could be lack of access permissions.
let DB_SCORE='[Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=consult2;Data Source=ITS_PROD;Extended Properties=""] (XPassword is blablabla);';
Hmm, I had this exact problem with Oracle long ago. It was QV 8.50, if I remeber correctly. Spent hours and hours on phone with QlikTech Support. Eventually decided to use scheduled reload by QV desktop instead of Server reload. But currently using QV 11 and 11.2 with Oracle without any issues.
No idea. That's why you need to check if it's possible at all to connect to the database from the server where you installed Qlikview Server. Perhaps the database isn't listed in the tnsnames.ora file. It's impossible to tell from here what's wrong. Perhaps your Oracle DBA can help you troubleshoot this issue.
.png "abeyphilip"){kind=avatar}
