8 Replies Latest reply: Feb 23, 2017 5:53 PM by Shaun Lombard RSS

    Reload now fails but manual load works

    Shaun Lombard

      Hi all,

       

      I have a Qlik Sense app that loads fine when run through data load editor, but fails when I do a "reload now" through QMC.

       

      The script log indicates that there is a problem with the connection to the database and to check Username and Password. I know the Username and Password are correct because I am using them in the manual load. The database I am connecting to is the QSR (postgreSQL repository).

      My data connection definition is as follows:

      Capture.JPG 

      I have tried updating the password in the above data connection directly but it made no difference.

      The load script is as follows:

      LIB CONNECT TO 'QSR';

       

      LOAD ID,

        Name;

      [CustomPropertyDefinitions]:

      SELECT "ID",

        "Name"

      FROM "public"."CustomPropertyDefinitions"

      WHERE "Deleted" = 'False';

       

      The script log is as follows:

      2017-02-17 11:54:47      Reload Executed By            UserDirectory=INTERNAL; UserId=sa_scheduler

      2017-02-17 11:54:47      Process Executing             Qlik Sense Server

      ...

      2017-02-17 11:54:47 0049 *** CONNECT TO ***

      2017-02-17 11:54:48 0051 LOAD ID,

      2017-02-17 11:54:48 0052 Name

      2017-02-17 11:54:48 0054 [CustomPropertyDefinitions]:

      2017-02-17 11:54:48 0055 SELECT "ID",

      2017-02-17 11:54:48 0056 "Name"

      2017-02-17 11:54:48 0057 FROM "public"."CustomPropertyDefinitions"

      2017-02-17 11:54:48 0058 WHERE "Deleted" = 'False'

      2017-02-17 11:54:48 0059 and "Name" = 'ORG'

      2017-02-17 11:54:49      Error: Unable to connect to database:

      2017-02-17 11:54:49          Error message:

      2017-02-17 11:54:49      Please check the values for Username‚ Password‚ Host and other properties.

       

      Does anyone no of any issues with connecting to PostgreSQL when running as a task?