Database Connectivity

Mon, 18 Jul 2011 06:52:39 GMT

What happens when an application is trying to connect to a database and the database server is down ?

Database Connectivity

kaushiknsolanki — Mon, 18 Jul 2011 06:57:03 GMT

Hi,

It will give you an error.

Regards,

Kaushik Solanki

Re: Database Connectivity

Mon, 18 Jul 2011 07:07:05 GMT

7/17/2011 4:46:22 AM:      Execution started.
7/17/2011 4:46:22 AM:      QlikView Version:10.00.8935.7
7/17/2011 4:46:22 AM: 0002  SET ThousandSep=','
7/17/2011 4:46:22 AM: 0003  SET DecimalSep='.'
7/17/2011 4:46:22 AM: 0004  SET MoneyThousandSep=','
7/17/2011 4:46:22 AM: 0005  SET MoneyDecimalSep='.'
7/17/2011 4:46:22 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'
7/17/2011 4:46:22 AM: 0007  SET TimeFormat='h:mm:ss TT'
7/17/2011 4:46:22 AM: 0008  SET DateFormat='M/D/YYYY'
7/17/2011 4:46:22 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
7/17/2011 4:46:22 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
7/17/2011 4:46:22 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
7/17/2011 4:46:22 AM: 0014  CONNECT*Provider*XPassword*
7/17/2011 4:46:22 AM: 0016  LOAD CURRENTDATE
7/17/2011 4:46:22 AM: 0017  FROM D:\Qlik2Finance\Data\RawQVD\NBFC_PARAMETER_M.qvd (qvd)
7/17/2011 4:46:22 AM:           1 fields found: CURRENTDATE, 1 lines fetched
7/17/2011 4:46:22 AM: 0021  let current_date1  =date(peek('CURRENTDATE'),'MM/DD/YYYY')
7/17/2011 4:46:22 AM: 0023  let current_date=if(current_date1=date(today(),'MM/DD/YYYY'),current_date1,if(current_date1=date(monthstart(today()),'MM/DD/YYYY'),current_date1,date((current_date1)+1,'MM/DD/YYYY')))
7/17/2011 4:46:22 AM: 0026  CONNECT*Provider*XPassword*

The log contains no error and execution is stopped. What should be done ? Any exception handling available ?

Database Connectivity

kaushiknsolanki — Mon, 18 Jul 2011 07:11:05 GMT

Hi,

Can you attach the log file here.

Yes there are few variables which stores the errors.

For more on errors look at the help.

Regards,

Kaushik Solanki

topic Database Connectivity in QlikView

Database Connectivity

Database Connectivity

Re: Database Connectivity

Database Connectivity