Script Error in server

yadav_anil782 — Wed, 23 Mar 2016 05:01:20 GMT

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*

Re: Script Error in server

Chanty4u — Wed, 23 Mar 2016 05:03:55 GMT

chk with ur database connection string once.

Re: Script Error in server

Digvijay_Singh — Wed, 23 Mar 2016 05:04:31 GMT

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 -

ORA-12541: TNS: no listener

Re: Script Error in server

Chanty4u — Wed, 23 Mar 2016 05:06:33 GMT

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.

Re: Script Error in server

avinashelite — Wed, 23 Mar 2016 05:11:49 GMT

check this

Resolved ORA-12541: TNS no listener error | IT Blogger Tips

topic Re: Script Error in server in QlikView

Script Error in server

Re: Script Error in server

Re: Script Error in server

Re: Script Error in server

Re: Script Error in server