One database with two different project connection problem

Ignition
,
1

Hello Friends,

I have created two different projects and they are connected to one database. When I run project number 1 in the vision client launcher the database data is reflected in the vision client launcher screen. But, at that time the data was not reflected in the vision client launcher screen while running project number 2.

Connection Diagram

image
image642×507 3.17 KB

2

Your diagram is missing the database connection(s) as defined in the gateway Config | DATABASES | Connections. Presumably both projects use the same connection as there should be no need for a second one.

I think we'd need to understand

  1. How the two projects are querying the database?
  2. If they ever show the same data?
  3. Do the views differ only when one client does an update?
  4. Anything else?
3

Do both projects have their default database set the same? Are you getting any error messages or error overlays?

4

Hello,

I created two different gateways and connected the same database to two different gateways. Retrieve values from the database using queries.

Two separate projects are created for UI purposes. Sometimes data is updated in both projects. But, sometimes the database gets automatically disconnected from the gateway.

5

Sounds like you are exceeding some limit in the database, or overloading it. Is it configured to handle multiple connections from each gateway? (Ignition uses connection pools--typically eight simultaneous connections.)