Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am getting this information, whenever a job is getting failed and even if i run the job manually, the task is getting failed. Can anyone help me?
| |||||||
I have tried restarting the qlikview server component, distribution component and under status>services, all the services are running. Don't know how to resolve the issue.
Did they update the Oracle client/drivers as well? They may have deleted/overwritten a custom TNSNAMES.ORA file, in which all available Oracle databases are specified with their aliases (the identifier you use in your CONNECT statement).
I hope you have a backup copy. Install it over the default one, and try to reload again, preferably in your Desktop.
You will need to enable Generate Logfile on the documents settings of your QVW, and view the log file to see the cause of the reload error.
Hi,
Check your log file and in line the reload is failed also manually stop all qlikview services and restart again this then please reload and check reload status.
Hope this helps
Thanks & Regards
Hi Colin Albert, thanks for your suggestion. Our server has been patched today. Do you think will there be anything on that which is causing this task failures?
Thank You.
I doubt the patch would cause the error, you need to look at the reload log as this will give the cause of the failure.
As Colin Albert has said the best bet is to get the log file out of QlikView and post that here.
However, given the failure is almost instant when it gets to reloading the document that fails the log file may not get created. Things that can cause near instant failures are the file missing (eg. it has been renamed or deleted since the reload task was created) or that there is Section Access on the document and the service account that is running the reload can not open the file.
Both of these things should send a sensible error message to the Server log file - but it is worth checking.
If the reload works okay on the Desktop but not the server, check you are not using mapped drives (eg. Q:\) as these will only be known on the desktop, go for UNC paths when possible (eg. \\servername\share\ ).
Hope that helps.
Steve
I am getting this error message.Does it mean a database connection problem?
Error: SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
Hi,
Might be it will be database error need to check and also your TNS listener of the oracle database is not configure correctly please check with oracle administrator person that it is configure correctly or not and then check reload.
Hope this helps
Thanks & Regards
Remember when the job is being run on the server, it may be connecting to the database under the login of the QSS service account.
Did they update the Oracle client/drivers as well? They may have deleted/overwritten a custom TNSNAMES.ORA file, in which all available Oracle databases are specified with their aliases (the identifier you use in your CONNECT statement).
I hope you have a backup copy. Install it over the default one, and try to reload again, preferably in your Desktop.