RE: [How To] Load data from a database to the Data Lake

Mike:

I defined a Location, download and installed jar and configured for a Postgres connection. Note: I had to update the pg_hba.conf file to allow specific IP connections to the database.

c:Program FilesInforIONEnterpriseConnectorin>StartAllHosts.cmd

Active code page: 65001

Starting Grid

Host DESKTOP-P3A6JFL started

ION Grid Bootstrap and Grid Admin UI respond

I created a Postgres database, dowloaded Postgres sql scripts from ION service and built the I/O tables

The location confirms my lappy as host

However, when I define a Database Connection based on what appears to be a health location, the jdbc connection fails. I am using the same credentials the Grid is using with success.

I would presume that the Host connection is reached through the Location.

Do I need an additional IP address in my pg_hba.conf ?

Find more posts tagged with

ION Connect

Comments

Legacy Contributor

Hey there -

When you go to ION Desk > Enterprise Locations, what's the status column read as for your new location? If the EC was able to successfully establish connection and communicate with Infor OS in the cloud, then you should see an OK. If it's blank, then I don't believe it's managed to establish connectivity while if it's in ERROR, there could be a health or configuration issue that's terminated or preventing connection.

Have you checked to ensure firewall access isn't preventing any issues from the host side? EC uses common HTTPS ports but if you're encountering further issues, you can dig into the Enterprise Connector logs in the installation directory or log a support incident to help investigate.

Thanks

Legacy Contributor

Mike:

The Infor Application Connection point Test is "OK" but when I use the Connection point (and therefore location) in a Data Flow I received a jdbc exception

Error Reason

Could not open JDBC Connection for transaction; nested exception is java.lang.RuntimeException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)

I opened an Extreme incident. It was recommend that I downgrade to Postgres 10. I opted to uninstall 11 and the Infor ION Grid, then a fresh install of Postgres 10 and ION Grid. Grid install ran fine, but the Enterprise Connector failed to start so I located the "Take Location" button and reset the location key of the existing location, and the EC started. I repeated the steps of creating a Postgress database, and ran the 1.0 postgres.sql script to generate the cor tables, validated the the Infor Applicaiton connection test, then returned to my Data Flow.

My Data Flow has 2 Applicatoin Nodes: Mingle to Enterprise Connector; Mingle sends a Sync.SecurityUserMaster

I then reactivated my Data flow...and the JDBC exceptoin returns. Is anyone using Postgress 10 or 11 ? Do you know wich Postgress JDBC driver is pacakged with ION Grid ?

Legacy Contributor

Mike:

There are 3 different drivers in play here....grid application Enterprise Connector and Messaging Service use inconsistent drivers , then the runtime is considerably higher. According to Postgress If you are using Java 8 or newer then you should use the JDBC 4.2 version. The application drivers appear to be lagging. I will consider escalating this matter to the community and see if there are others running Postgress 10 or 11.

c:Program FilesInforIONEnterpriseConnectorgridapplicationsIONEnterpriseConnectorappdatalib

11/13/2019 06:47 AM 587,064 postgresql-9.3-1100-jdbc41.jar

c:Program FilesInforIONEnterpriseConnectorgridapplicationsIONMessagingServiceappdatalib

11/13/2019 06:47 AM 648,601 postgresql-9.4.1208.jar

c:Program FilesInforIONEnterpriseConnector
untimes2.0.20190823-102958driverspostgresql

08/22/2019 02:04 AM 825,943 postgresql-42.2.5.jar

Legacy Contributor

Moved this over to the Connect forums.

I'm a little confused on what you're trying to accomplish

Are you going through the Data Lake exercise? If so, you don't actually need to run the I/O box scripts. Those are used for standard ION integrations for pub/sub integrations.

AnySQL reads data directly from the tables in your database by inheriting your connectivity details at the connection point level.

Noted on the driver versions - I'll send it over for our Connect product manager to review.

Legacy Contributor

I'm using Postgres 10 and I've the similar issue with below error. Not been able to establish a working connection point so far with this database in my laptop.

Message: Adapter test connection failed: java.lang.RuntimeException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)

Copyright © 2025 Infor. All rights reserved.