Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

yadav_anil782
Contributor II

Script Error in server

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*

4 Replies
Chanty4u
Esteemed Contributor III

Re: Script Error in server

chk with ur database connection string once.

Digvijay_Singh
Honored Contributor III

Re: Script Error in server

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

Chanty4u
Esteemed Contributor III

Re: Script Error in server

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