# Strange behaviour in Factory SQL

**URL:** <https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465>\
**Category:** Archived Topics\
**Created:** [November 22, 2012, 3:36am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465 "2012-11-22T03:36:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![talhajee1](https://avatars.discourse-cdn.com/v4/letter/t/7c8e57/32.png) [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\
**Post date:** [November 22, 2012, 3:36am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465/1 "2012-11-22T03:36:52Z")

</div>

Hi,  
From last couple of months i am observing a strange behaviour in FSQL.In some store procedure groups data from some PLC tags is not coming. All tags are from the same PLC but still this issue appear. If i put same tag in some other group it will show me value. To resolve this issue i restarted my IO server and it start working fine but still not sure that IO server is the cause of this issue.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/14bac0db4cadbb37718ba0164b760157770dd039.jpg)

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [November 26, 2012, 4:37pm UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465/2 "2012-11-26T16:37:47Z")

</div>

A quick way to find out if it is your IO server would be to restart FactorySQL. It would be interesting to find out if FactorySQL connects just fine again.

---

<div class="post-metadata">

**Author:** ![talhajee1](https://avatars.discourse-cdn.com/v4/letter/t/7c8e57/32.png) [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\
**Post date:** [November 29, 2012, 11:12am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465/3 "2012-11-29T11:12:47Z")

</div>

Sorry i didn’t get your point pls elaborate.

---

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [November 29, 2012, 11:55am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465/4 "2012-11-29T11:55:12Z")

</div>

Stop, then restart the FactorySQL service. You can do this at the command line with. You may have to right click the command line shortcut and click “run as administrator”.

```auto
net stop factorysql
```

```auto
net start factorysql
```

If you’re running FSQL as an “application” as opposed to a “service”, try closing the system tray application and frontend then opening it again.

---

<div class="post-metadata">

**Author:** ![talhajee1](https://avatars.discourse-cdn.com/v4/letter/t/7c8e57/32.png) [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\
**Post date:** [December 5, 2012, 3:25am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465/5 "2012-12-05T03:25:46Z")

</div>

Hi,  
I tried to restart factory sql application but it show me the sameresult. i.e. some of the tags are fine and some are with error.

Talha

---

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [December 5, 2012, 6:03am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465/6 "2012-12-05T06:03:00Z")

</div>

Now what happens if FactorySQL keeps running and you force restart your IO server? This may be starting and stopping a service or closing then opening a program, depending on what OPC server you’re running and how it’s configured.