Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Database Connectivity

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

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   It will give you an error.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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 ?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!