"public_network_connection" table not synchronizing

[DCIM_Support]

Hi,

I’m having synchronizing issues with the “public_network_connection” table.. I conducted several successful tests of changing the “state_flag” column to “changed”  for several devices in the “public_configuration_item” and “public_port_configuration” tables. No issues associating devices or creating/changing/removing port configurations on each device., but the cable connections are not syncing in the network connection table. I have been tasked with automating cable connections in a very large data center with more than 20,000 cables at each site. In approximately two years, this is the second time in two months this has happened.

I’ve made thousands of additions, changes, and removals with this table in the past with no issues, and I haven’t changed how I do anything.

I’m curious if this issue has been seen before? The other two tables are working fine, so it doesn’t appear to be an overall database issue. Perhaps something is locking the “public_network_connection” table? Here is a brief background of our environment: We have roughly 15,000 devices in the “public_configuration_item” table, over 30,000 records in the “public_port_configuration” table, and roughly 30,000 records in the network connection table. We are using an internal PostgreSQL database instance running on the same server as Data Center Operation. The server itself has maximum required specs.

Any reason as to why the network connection table would suddenly stop syncing properly? Any help would be greatly appreciated.

(CID:126172817)

[DCIM_Support]

Hi Thomas

What version of DCO are you using?

(CID:126173270)

[DCIM_Support]

Hi Thomas,

It is most likely (a tip from etl developer) they/devices are not associated yet, both source (device with start point) and target (device with end point) must have been associated first, otherwise they will not be sync'ed.

Kind regards

(CID:126173372)

[DCIM_Support]

Well, I ran several tests of changing a device's status to "changed" to see if would switch back to "synced", and that was a success.. I also changed several port names, as well as adding an removing a port in the "public_port_configuration" table, and that was a success as well. So those tables appear to still work..

(CID:126173509)

[DCIM_Support]

An update to above is that I thought the devices lost their association, so I changed the "state_flag" column to "changed" in the port configuration table to see if they would switch back to "synced", and 98% changed back to "synced"

(CID:126173526)

[DCIM_Support]

Hi Thomas,
Would it be possible to share screen captures illustrating the issue & also showing the affected/relevant network connection/port configuration and 'not synced' problem. (if possible, please mask sensitive info such as IP add.), thanks.

Kind regards

(CID:126173802)

[DCIM_Support]

Hi, thanks again for your response. Here are three screen captures showing a sample of connections in the "new" state.

(CID:126174475)

[DCIM_Support]

Hi Thomas,

Many thanks for the images, but unfortunately they do not show what might be the issue. So I was wondering if it is possible to ask for more details that could be shared with me (safely via =S= box).

1- DCO screen shots illustrating (only for not sync'ed devices):

 a- Start & End devices, that are associated (and please confirm that they are associated)

 b- Synchronization of the ETL devices (In Planning Device Association mode, -> ETL Integration, right click on the etl device(s) and then select 'Synchronize external data')

2- DCO server logs (can be downloaded from webmin interface -> Struxure DC Operation > Download Log Files > Download log files)

3- DCO backup file

I will send you an invite to my =S= box shortly so the data (if possible) can share safely with me, thanks.

By the way, I was wondering if this ETL job is developed & implemented by =S= ?

Kind regards

(CID:126175361)

[DCIM_Support]

We decided to recreate the import database by removing it>creating a new one>re-associating the devices.

It would be nice to know the root cause, and the logs might hold the clue; however, we decided to the timeliest solution is to just "recreate" it. We'll be forced to take a more in-depth look at it if it happens again.

Thank again

(CID:126176663)

[DCIM_Support]

Hi Thomas,

Okay, many thanks for the update.

Kind regards

(CID:126177071)

[DCIM_Support]

Hi Ed,

We are using version: 8.0.3-66536-08cb94

(CID:126173504)

[DCIM_Support]

It appears that only the "public_network_connection" table has stopped working. I actually changed the "state_flag" column value to "changed" for ALL of the records in the "public_port_configuration" table, and 98% changed back to "synced."

(CID:126173515)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.