OSI PI interface

30 views
Skip to first unread message

Ron Schafer

unread,
Aug 18, 2016, 3:48:48 PM8/18/16
to limewar...@googlegroups.com

Anyone want to chime in and remind me how the pi interface collects data. Its not updating and I seem to have forgotten how it was setup….

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

Ricardo Abech

unread,
Aug 18, 2016, 3:59:44 PM8/18/16
to limewar...@googlegroups.com
Hi Ron,

I got your message from GCS and I asked them to you to run few tests (basically rerun the SystemCheck to produce a new log).

Or can you send me your PI-SERVER folder screenshot in the meantime?
Thanks

--
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.

Dirk Pauwels

unread,
Aug 19, 2016, 4:04:16 AM8/19/16
to limewar...@googlegroups.com

Hi Ron,

 

I can only speak for our version 2.5.1, don’t know how more recent versions are setup. So you might have a different setup.

 

What does your pi device config look like?

 

File/config/osi pi device config

You should see the pi point source(s) you use in your pi tag config and it should be setup with PI FOXAPI or PI FOXOPC depending on what you use. We’ve “lost” this setting a couple of times, after an update etc…. when it shows “none”, ypu won’t get any updates either….

 

Some other checks:

 

In slow_import.bat

There should be a line Update_PI            FOXRAY.DB, make sure it’s not disabled.

 

You should have files “output.pi”  and “output.ready somewhere, check the time stamp. If output.ready is missing, create it.

 

You can  try to run the update manually by running  c:\programs]foxray\bin\ update_PI  foxray.db from the command prompt and see what happens to the output.pi file.

 

There’s also a synch file called IAdmin.txt, all entries should show “=NO” at the end of the line. If there are any “=YES” , replace them by NO.

 

 

Rgds,

 

Dirk Pauwels
DCS/MOC Coordinator
Description: cid:image001.gif@01CCCF8A.820A6EA0
Ketenislaan 1C - Haven 1520
B-9130 Kallo, Belgium

Dirk.P...@lawter.com

tel: +32 3 570 95 97
mob: +32 497 428 300

--

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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.


Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

Ron Schafer

unread,
Aug 19, 2016, 7:48:28 AM8/19/16
to limewar...@googlegroups.com, Corbera, Angel, Ricardo Abech

Thanks Dirk,

device config is set to PI_FOXOPC and not NONE, and not rem’d out in the slow import.bat either. So I created the output.ready in the ..\Pi\Pi-server directory where the All_PI.txt and output Pi file reside and ran the Update_PI  Foxray.db manually and the All_PI.txt updated as expected. The PI database is now in sync. The output.ready is now missing from PI-server directory so it wont run unless I manually create the output.ready file?

 

How does the output.ready file get created? I know on the other interfaces it is created by the machine that does the data collection.

 

 

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

Ricardo Abech

unread,
Aug 19, 2016, 7:50:42 AM8/19/16
to limewar...@googlegroups.com

Hi Ron,

The ready file should be on your Pi server machine and be part of the script that pushes the data over the foxray server.

Make sure you have a output.ready on your pi server on the foxray folder in there and it is part of the script that pushes files over

Thanks


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.

 

Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

--
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.

--
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.

Dirk Pauwels

unread,
Aug 19, 2016, 8:22:52 AM8/19/16
to limewar...@googlegroups.com

Hi Ron,

 

The output.pi and output.ready reside in c:\foxray\ on our pi server.

The batch file pi_foxray  is in the same folder and looks like this:

echo "Starting pi interface to foxray"

cd \foxray

 

d:\pi\adm\ipisql -node YOURPISERVERNAME -t 180 -f \foxray\query.inp > output.pi

echo "" >output.ready

 

ftp -n YOURFOXRAYSERVERNAME < send.ftp

 

Rgds,

 

Dirk Pauwels
DCS/MOC Coordinator
Description: cid:image001.gif@01CCCF8A.820A6EA0
Ketenislaan 1C - Haven 1520
B-9130 Kallo, Belgium

Dirk.P...@lawter.com

tel: +32 3 570 95 97
mob: +32 497 428 300

 

Van: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] Namens Ricardo Abech
Verzonden: vrijdag 19 augustus 2016 13:51
Aan: limewar...@googlegroups.com
Onderwerp: Re: {foxray} RE: OSI PI interface

 

Hi Ron,

The ready file should be on your Pi server machine and be part of the script that pushes the data over the foxray server.

Make sure you have a output.ready on your pi server on the foxray folder in there and it is part of the script that pushes files over

Thanks

On Aug 19, 2016 7:48 AM, "Ron Schafer" <rsch...@bi.whitebirchpaper.com> wrote:

Thanks Dirk,

device config is set to PI_FOXOPC and not NONE, and not rem’d out in the slow import.bat either. So I created the output.ready in the ..\Pi\Pi-server directory where the All_PI.txt and output Pi file reside and ran the Update_PI  Foxray.db manually and the All_PI.txt updated as expected. The PI database is now in sync. The output.ready is now missing from PI-server directory so it wont run unless I manually create the output.ready file?

 

How does the output.ready file get created? I know on the other interfaces it is created by the machine that does the data collection.

 

 

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

From: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] On Behalf Of Dirk Pauwels
Sent: Friday, August 19, 2016 4:03 AM
To: limewar...@googlegroups.com
Subject: {foxray} RE: OSI PI interface

 

Hi Ron,

 

I can only speak for our version 2.5.1, don’t know how more recent versions are setup. So you might have a different setup.

 

What does your pi device config look like?

 

File/config/osi pi device config

You should see the pi point source(s) you use in your pi tag config and it should be setup with PI FOXAPI or PI FOXOPC depending on what you use. We’ve “lost” this setting a couple of times, after an update etc…. when it shows “none”, ypu won’t get any updates either….

 

Some other checks:

 

In slow_import.bat

There should be a line Update_PI            FOXRAY.DB, make sure it’s not disabled.

 

You should have files “output.pi”  and “output.ready somewhere, check the time stamp. If output.ready is missing, create it.

 

You can  try to run the update manually by running  c:\programs]foxray\bin\ update_PI  foxray.db from the command prompt and see what happens to the output.pi file.

 

There’s also a synch file called IAdmin.txt, all entries should show “=NO” at the end of the line. If there are any “=YES” , replace them by NO.

 

 

Rgds,

 

Dirk Pauwels
DCS/MOC Coordinator
Description: cid:image001.gif@01CCCF8A.820A6EA0
Ketenislaan 1C - Haven 1520
B-9130 Kallo, Belgium

Dirk.P...@lawter.com

tel: +32 3 570 95 97
mob: +32 497 428 300

 

Van: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] Namens Ron Schafer
Verzonden: donderdag 18 augustus 2016 21:49
Aan: limewar...@googlegroups.com
Onderwerp: {foxray} OSI PI interface

 

Anyone want to chime in and remind me how the pi interface collects data. Its not updating and I seem to have forgotten how it was setup….

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

 

Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Ron Schafer

unread,
Aug 19, 2016, 10:32:51 AM8/19/16
to limewar...@googlegroups.com

Got it working again, now the alarms table is crashed. What is the my sql  username and password? How do I fix crashed tables?

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

From: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] On Behalf Of Ricardo Abech
Sent: Friday, August 19, 2016 7:51 AM
To: limewar...@googlegroups.com
Subject: Re: {foxray} RE: OSI PI interface

 

Hi Ron,

The ready file should be on your Pi server machine and be part of the script that pushes the data over the foxray server.

Make sure you have a output.ready on your pi server on the foxray folder in there and it is part of the script that pushes files over

Thanks

On Aug 19, 2016 7:48 AM, "Ron Schafer" <rsch...@bi.whitebirchpaper.com> wrote:

Thanks Dirk,

device config is set to PI_FOXOPC and not NONE, and not rem’d out in the slow import.bat either. So I created the output.ready in the ..\Pi\Pi-server directory where the All_PI.txt and output Pi file reside and ran the Update_PI  Foxray.db manually and the All_PI.txt updated as expected. The PI database is now in sync. The output.ready is now missing from PI-server directory so it wont run unless I manually create the output.ready file?

 

How does the output.ready file get created? I know on the other interfaces it is created by the machine that does the data collection.

 

 

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

From: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] On Behalf Of Dirk Pauwels
Sent: Friday, August 19, 2016 4:03 AM
To: limewar...@googlegroups.com
Subject: {foxray} RE: OSI PI interface

 

Hi Ron,

 

I can only speak for our version 2.5.1, don’t know how more recent versions are setup. So you might have a different setup.

 

What does your pi device config look like?

 

File/config/osi pi device config

You should see the pi point source(s) you use in your pi tag config and it should be setup with PI FOXAPI or PI FOXOPC depending on what you use. We’ve “lost” this setting a couple of times, after an update etc…. when it shows “none”, ypu won’t get any updates either….

 

Some other checks:

 

In slow_import.bat

There should be a line Update_PI            FOXRAY.DB, make sure it’s not disabled.

 

You should have files “output.pi”  and “output.ready somewhere, check the time stamp. If output.ready is missing, create it.

 

You can  try to run the update manually by running  c:\programs]foxray\bin\ update_PI  foxray.db from the command prompt and see what happens to the output.pi file.

 

There’s also a synch file called IAdmin.txt, all entries should show “=NO” at the end of the line. If there are any “=YES” , replace them by NO.

 

 

Rgds,

 

Dirk Pauwels
DCS/MOC Coordinator
Description: cid:image001.gif@01CCCF8A.820A6EA0
Ketenislaan 1C - Haven 1520
B-9130 Kallo, Belgium

Dirk.P...@lawter.com

tel: +32 3 570 95 97
mob: +32 497 428 300

 

Van: limewar...@googlegroups.com [mailto:limewar...@googlegroups.com] Namens Ron Schafer
Verzonden: donderdag 18 augustus 2016 21:49
Aan: limewar...@googlegroups.com
Onderwerp: {foxray} OSI PI interface

 

Anyone want to chime in and remind me how the pi interface collects data. Its not updating and I seem to have forgotten how it was setup….

 

 

Ron Schafer

E/I Supervisor

Bear Island Paper WB LLC

10026 Old Ridge Road

Ashland VA, 23005

Office Phone 804-227-4093

Cell Phone 804-241-2784

Fax 804-227-4014

Email: rsch...@bi.whitebirchpaper.com

123

Notice: It’s GOOD to print this e-mail. Paper is a biodegradable, renewable, sustainable product made from trees. Growing and harvesting trees provides jobs for millions of individuals, and managed forests are good for the environment, providing clean air, clean water, wildlife habitat and carbon storage.

 

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

 

Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

--
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-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Dirk Pauwels

unread,
Aug 19, 2016, 12:09:05 PM8/19/16
to limewar...@googlegroups.com

Hi Ron,

 

I’m certainly not an expert but you can repair a mysql table from the mysql functions.

 

Mysql login:

Local host

Port 3306

root

Password depends on who installed it for you.

Have you tried the standard I/A root password?

Ron Schafer

unread,
Aug 19, 2016, 12:10:34 PM8/19/16
to limewar...@googlegroups.com

Yep, finally got into it and did a repair on the alarm table. Im back up and running. Thanks to everyone for the help.

Ricardo Abech

unread,
Aug 19, 2016, 12:14:21 PM8/19/16
to limewar...@googlegroups.com
user should be root. Password depends on the setup. Try the famous Foxboro password

Also, to repair a table use Foxray advanced query and run:

REPAIR TABLE ALARMS

it works for any table name


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.

 

Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

--
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.

--
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.

--
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.

--
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.

 

Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

--
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.

--
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.
Reply all
Reply to author
Forward
0 new messages