Itgenase294: The connection requires Invantive application authentication, but that is not supported

Questions (nl)
, , ,
1

When loading Supabase PostgreSQL via Invantive Credentials Server on Invantive Cloud, I receive the following error message:

09:13:27.193 itgenlom019: itgenase294: Could not connect to the database 'acme\acme-exact-online-acme'.
09:13:27.210 Error itgenase294: Could not connect to the database 'acme\acme-exact-online-acme'.
The connection requires Invantive application authentication, but that is not supported.
Switch to database authentication or use a different connector. Database authentication can be configured in your settings*.xml file.
09:13:27.215 Prompt itgencun002: Show details? Prompt? [y/N]

The settings*.xml is:

<?xml version="1.0" encoding="utf-8"?>
<settings version="5">
  <group name="acme">
    <connection name="acme-exact-online-acme" authentication="Application" >
      <credentials
       order="10"
        database="acme-exact-online-acme"
        datacontainers="*"
        userLogonCodeMode="Hidden"
        passwordMode="Hidden"
        defaultUserLogonCode="john.doe@acme.eu"
        defaultPassword="secret"
       />
    </connection>
  </group>
</settings>

The Exact Online connection is established, but PostgreSQL returns the error. Connection string:

Server=aws-0-eu-central-1.pooler.supabase.com;Port=5432;Database=postgres;SslMode=Require;Trust Server Certificate=true
2

This database connection uses “Application” authentication mode. This is a historical facility for use with Invantive Producer on Oracle RDBMS. However, in this case, the data containers are entered through the Invantive Credentials Server instead of through a direct definition, and then it is checked whether the database connection is addressed correctly.

An analyst will study the problem.

As a workaround, it is advised not to request specifically PostgreSQL through the Invantive Credentials Server. This can be done by specifying only the necessary data containers, as shown, for example, in:

...
    <connection 
     name="sample" 
     authentication="Database"
    >
      <!-- 
           Connect to Exact Online data container with token received via
           Invantive Credentials Server. 
      -->
      <credentials
       order="10"
       database="database-url-segment"
       datacontainers="eol"
       userLogonCodeMode="Hidden"
       passwordMode="Hidden"
       defaultUserLogonCode="john.doe.service.user@acme.eu"
       defaultPassword="secret"
      />
      <!-- 
           Connect to Supabase with local definition. 
      -->
      <database
       order="20"
       alias="pg"
       provider="PostgreSql"
       userLogonCodeMode="Hidden"
       passwordMode="Hidden"
       connectionString="Server=1.2.3.4;Port=12345;Database=getmyreport;User Id=user;Password=secret;Trust Server Certificate=true;SSL Mode=Require;Include Error Detail=true"
       AllowConnectionStringRewrite="false"
      />
    </connection>
...
3

Deze vraag is automatisch gesloten na 1 week inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.