• State Not Answered
  • Replies 5 replies
  • Subscribers 582 subscribers
  • Views 156 views
  • Users 0 members are here
Options
Related

DBF file handling Question - data flow Clients - Servers to a corporate file server with Plant Scada 2023R2 Update 9

Alan

Version = Plant Scada 2023R2 Update 9

my project has a database i am finding has become "intermittently" unstable possibly after recent upgrade from Citect SCADA 2018 to 2023R2 or some security updates pushed out by IT Dept or Microsoft.

what i am noticing is slow performance in read/writes to this database file. Note the code is 7 + years and has not been modified so has proven very reliable to now.

i am trying to understand the data flow and where the issue is. 

when operators make a change to the process, a cicode file writes this change or reads from the  *.dbf file that resides on the "Corporate file Server" in a folder.

the folder and file is mapped as a network drive on the SCADA server. in devices "file name" field  \\Servername\database_folder\MyDB.dbf (example only) is the path to the location on the corporate File server

for the above configuration i would like some explanation of the data flow for this.

QUESTION when an operator makes the change from either SCADA Client A, B or C is the data written to the corporate server directly or via the SCADA server?

  • SCADA Client > Corporate Server

                                    OR

  • SCADA Client > SCADA Server > Corporate Server

 i am unsure of what the corrective action was as i tried many things (restart SCADA, reboot all SCADA machines, recompile, pack etc) one or more of these rectified the issue.

Parents
  • 0 in reply to Alan

     ,

    For my understanding, the dataflow should be from SCADA Client to Corporate Server as these clients read or/and write custom data directly to the dbf database on the remote file server. Troubleshooting the performance is a little bit hard. You should start with enabling the following parameter in the citect.ini file for each client (file CicodeProfile.csv will be generated  in .\logs folder when the client is restarted or shutdown after the parameter is enabled). Also try to use Wireshark to capture the traffics between a client and the file server if you are familiar with this tool. Hope you could find some useful info from these log files. Hope this would help.

    [Code]ProfilerEnabled

Reply
  • 0 in reply to Alan

     ,

    For my understanding, the dataflow should be from SCADA Client to Corporate Server as these clients read or/and write custom data directly to the dbf database on the remote file server. Troubleshooting the performance is a little bit hard. You should start with enabling the following parameter in the citect.ini file for each client (file CicodeProfile.csv will be generated  in .\logs folder when the client is restarted or shutdown after the parameter is enabled). Also try to use Wireshark to capture the traffics between a client and the file server if you are familiar with this tool. Hope you could find some useful info from these log files. Hope this would help.

    [Code]ProfilerEnabled

Children
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.