Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
this script work fine daily for reload the dashboard but sometime its shows error and im not ale to understand how to find this error . plz suggest what reason can happen to failed this script some time .
i attached and script error snap and here logs too-
3/23/2016 6:00:00 AM: Execution started.
3/23/2016 6:00:00 AM: QlikView Version:11.20.12577.0
3/23/2016 6:00:00 AM: CPU Target x64
3/23/2016 6:00:00 AM: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)
3/23/2016 6:00:00 AM: Wow64 mode Not using Wow64
3/23/2016 6:00:00 AM: MDAC Version 6.1.7601.17514
3/23/2016 6:00:00 AM: MDAC Full Install Version 6.1.7601.17514
3/23/2016 6:00:00 AM: PreferredCompression 2
3/23/2016 6:00:00 AM: EnableParallelReload 1
3/23/2016 6:00:00 AM: ParallelizeQvdLoads 1
3/23/2016 6:00:00 AM: AutoSaveAfterReload 0
3/23/2016 6:00:00 AM: BackupBeforeReload 0
3/23/2016 6:00:00 AM: EnableFlushLog 0
3/23/2016 6:00:00 AM: SaveInfoWhenSavingFile 0
3/23/2016 6:00:00 AM: UserLogfileCharset 1200
3/23/2016 6:00:00 AM: OdbcLoginTimeout -1
3/23/2016 6:00:00 AM: OdbcConnectionTimeout -1
3/23/2016 6:00:00 AM: ScriptWantsDbWrite false
3/23/2016 6:00:00 AM: ScriptWantsExe false
3/23/2016 6:00:00 AM: LogFile CodePage Used: 1200
3/23/2016 6:00:00 AM: Reload Executed By QLIKVIEW-SRV\anil.kumar
3/23/2016 6:00:00 AM: Process Executing: QlikView Desktop
3/23/2016 6:00:00 AM: Process ID: 564
3/23/2016 6:00:00 AM: 0002 SET ThousandSep=','
3/23/2016 6:00:00 AM: 0003 SET DecimalSep='.'
3/23/2016 6:00:00 AM: 0004 SET MoneyThousandSep=','
3/23/2016 6:00:00 AM: 0005 SET MoneyDecimalSep='.'
3/23/2016 6:00:00 AM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
3/23/2016 6:00:00 AM: 0007 SET TimeFormat='h:mm:ss TT'
3/23/2016 6:00:00 AM: 0008 SET DateFormat='M/D/YYYY'
3/23/2016 6:00:00 AM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
3/23/2016 6:00:00 AM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
3/23/2016 6:00:00 AM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
3/23/2016 6:00:00 AM: 0015 ODBC CONNECT*UserId*Password*
chk with ur database connection string once.
It doesn't look like Qlikview error, seems like ODBC connection is not able to listen to Oracle DB. You can check with Oracle DBA, something appears to be wrong from Oracle DB side.
Edit -
Some description of error code ORA-12541 here -
or Check the credentials of the Application pool account used for the application. In our case we had changed the password for the service account and had not updated the same in the application pool which was causing the issue.
or any file path chk once.