topic Re: Error: Database connection failed with RedShift ODBCPostgreSQL30 in QlikView https://community.qlik.com/t5/QlikView/Error-Database-connection-failed-with-RedShift-ODBCPostgreSQL30/m-p/754246#M437938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please first try with little data like 5000 rows...</P><P></P><P>then increase.</P><P></P><P>Dont't forget to make the right indexes in the database.</P><P></P><P>And of course use all the pdf's available.</P><P></P><P>Regards</P><P></P><P>André Gomes</P></BODY></HTML> Thu, 08 Jan 2015 16:38:09 GMT agomes1971 2015-01-08T16:38:09Z Error: Database connection failed with RedShift ODBCPostgreSQL30 https://community.qlik.com/t5/QlikView/Error-Database-connection-failed-with-RedShift-ODBCPostgreSQL30/m-p/754245#M437937 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using the Direct Discovery feature of QlikView and to be very frank it has hell lot of issues associated with it. Recently I faced an issue where in QlikView application throws an error saying : Error: Database Connection Failed when ever it is idle for sometime</P><P></P><P>This Issue gets fixed the moment I reload the file as doing so triggers the Connect statement( ODBC Connect to PostgreSQL30;</P><P>It is not possible to refresh the file on production server every now and then</P><P></P><P>Has anyone faced the similar issue , any help will be highly appreciated</P><P></P><P><A href="https://community.qlik.com/qlik-users/15823">swuehl</A> <A href="https://community.qlik.com/message/220369">swuehl, John, Miguel, Rob, Kaushik, Erich, Karl, Michael, Oleg</A></P></BODY></HTML> Thu, 08 Jan 2015 11:44:44 GMT https://community.qlik.com/t5/QlikView/Error-Database-connection-failed-with-RedShift-ODBCPostgreSQL30/m-p/754245#M437937 2015-01-08T11:44:44Z Re: Error: Database connection failed with RedShift ODBCPostgreSQL30 https://community.qlik.com/t5/QlikView/Error-Database-connection-failed-with-RedShift-ODBCPostgreSQL30/m-p/754246#M437938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please first try with little data like 5000 rows...</P><P></P><P>then increase.</P><P></P><P>Dont't forget to make the right indexes in the database.</P><P></P><P>And of course use all the pdf's available.</P><P></P><P>Regards</P><P></P><P>André Gomes</P></BODY></HTML> Thu, 08 Jan 2015 16:38:09 GMT https://community.qlik.com/t5/QlikView/Error-Database-connection-failed-with-RedShift-ODBCPostgreSQL30/m-p/754246#M437938 agomes1971 2015-01-08T16:38:09Z