Links to Old Displays - How Long Will They Hang Around?

[Duc M Do]

Foxray experts,

We migrated from DM to FoxView a couple of years ago, and I suppose we're long past the point of no return, so I'm looking at some housekeeping tasks. One is cleaning up the links to the old DM displays.

We've been running parallel reports (DCSImportDisplays) from one Solaris AW51 to Foxray to report on DM graphics as well as from one Windows H91 server to report on FoxView graphics. So for a particular block, we can see something like this in the "Displays" tab:

with the FoxView graphics named with the .fdf extension.

Questions: Once I stop the AW51 from running DCSImportDisplays, how long will it be before the entries for the old DM graphics get deleted from the database? Will they ever? Do I have to something else to rid the database of the links to old DM graphics?

I'm curious because I stopped that script from running on the Solaris AW51 a couple of days ago, therefore Foxray has had a chance to run its daily Import_Displays.exe program twice now, and I still see links to the old DM graphics.

Thanks in advance,

Duc

[Maks Wilde]

Duc,

I believe that if you just stop the collector from running, it will keep the files from the last good collection. This is good because you don't want your displays to go missing in Foxray when your AW is not communicating. 

The way to "wipe clean" your DM database is to send Foxray a new empty file. You can do so by re-directing your display folder in foxray.icc to something like /opt/disp/tmp (which should be blank or have one dummy display if you wish) and running the import again.

Hope this helps,

Maks Wilde

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.
To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxray+unsubscribe@googlegroups.com.
To post to this group, send email to limeware-foxray@googlegroups.com.
Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

--

Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential, and may be privileged. If you are not the intended recipient, you are hereby notified that any review, retransmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, and delete this message and any attachments from your system.

[Duc M Do]

Maks,

> This is good because you don't want your displays to go missing in Foxray when

> your AW is not communicating.

That makes sense. I didn't think about the abnormal situation when an AW stops communicating with the Foxray box.

> ​The way to "wipe clean" your DM database is to send Foxray a new empty file.

Will try that tack.

Thanks!

Duc

[Duc M Do]

Maks and all Foxray experts,

Per Maks's suggestion last week, I modified foxray.icc to point to a dummy directory in ROOTDISPLAY on the DM side, and although the AW has produced 0-byte DM connection reports daily for a week now:

The Displays tab in Foxray still shows connections in both DM and FoxView graphics. What am I missing?

Duc

​

On Thu, May 11, 2017 at 11:56 AM, Maks Wilde <maks...@gmail.com> wrote:

[Maks Wilde]

Duc,

In that case you need to delete them manually (proceed with caution, use at own risk, etc etc):

DELETE FROM DISPLAYLIST WHERE STATION LIKE '04AW01'

DELETE FROM DISPLAYEMBEDDED WHERE STATION LIKE '04AW01'

DELETE FROM DISPLAYS WHERE STATION LIKE '04AW01'

DELETE FROM DISPLAYS_INST WHERE STATION LIKE '04AW01'

DELETE FROM DISPLAYSREF WHERE STATION LIKE '04AW01'

Best Regards,

Maks Wilde

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.
To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxray+unsubscribe@googlegroups.com.
To post to this group, send email to limeware-foxray@googlegroups.com.
Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

[Duc M Do]

Maks,

I assume you issue these SQL directives from the MySQL console?

Duc

​

[Maks Wilde]

Yes, or even easier, from Advanced Query within System Auditor (using an account with admin privileges).

If you would like to preview what these queries will delete, substitute DELETE with SELECT * ...

Maks Wilde

[Duc M Do]

Maks,

Finally got the opportunity to clean out my database using these SQL directives. Works like a charm. (The hint about using 'SELECT *' to preview is perfect!)

Thanks!

Duc