# Ignition Upgrade & ctg problems

**URL:** <https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742>\
**Category:** Ignition\
**Created:** [December 13, 2011, 5:22pm UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742 "2011-12-13T17:22:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dodonnell999](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dodonnell999](https://forum.inductiveautomation.com/u/Dodonnell999)\
**Post date:** [December 13, 2011, 5:22pm UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742/1 "2011-12-13T17:22:11Z")

</div>

I'm having some problems carrying out an upgrade on a system we have, we have a server running Ignition 7.2.8 with the sql database residing on the same server. I want to make a redunant Ignition 7.3.2 system with two new physical servers with the database residing on a virtual server.  
At present I've done the following:

1. Set up one of my new servers with Ignition 7.3.2
2. Done a backup of the old server and restored it to the new server
3. Set up a new SQL 2005 database and imported the old server data to it ( old server DB was sql 2008 )
4. Pointed new server to new database

## After doing this I'm having trouble running the Click To Graph to display my trend data, I'm getting the following error when I try to open a graph:

Exception: Error running query:  
com.inductiveautomation.factorypmi.application.gateway.TagDensityQuery@1d40346@0ms  
On: CTG\_Graph.Root Container.ctg\_Chart  
caused by GatewayException: Invalid column name 'created'.  
caused by SQLServerException: Invalid column name 'created'.

## Ignition v7.3.2 (b533) Java: Sun Microsystems Inc. 1.6.0\_24

Any advice would be appreciated, I've attached the wrapper file if it helps.  
[wrapper.zip](https://us1.discourse-cdn.com/inductiveautomation/original/1X/153c7ae06310ce05805d3f153c7426f1854d96db.zip) (462 KB)

---

<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:** [December 13, 2011, 11:44pm UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742/2 "2011-12-13T23:44:16Z")

</div>

Can you post a screenshot of the tag pens and db pens datasets of the easy chart?

---

<div class="post-metadata">

**Author:** ![Dodonnell999](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dodonnell999](https://forum.inductiveautomation.com/u/Dodonnell999)\
**Post date:** [December 14, 2011, 4:47pm UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742/3 "2011-12-14T16:47:16Z")

</div>

I’ve attached screen shots as requested.  
I think there’s a bigger problem in that there is no historical data being logged to database.  
Could this be caused by me restoring a 7.2.8 backup onto a 7.3.2 ignition?

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/0da97b1353d0dc123f10b5223132609c14b3a399.PNG)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/95218d6497a460b6d33bd795623e4e31fec442bc.PNG)

---

<div class="post-metadata">

**Author:** ![Dodonnell999](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dodonnell999](https://forum.inductiveautomation.com/u/Dodonnell999)\
**Post date:** [December 14, 2011, 6:56pm UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742/4 "2011-12-14T18:56:25Z")

</div>

I think I may be getting closer to the problem, in that I think the database provided by the client does not give ignition full permissions ( I can’t ALTER a table ). I’ve asked for this to be rectified.

Is it possible that this would cause these problems?

---

<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:** [December 14, 2011, 11:58pm UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-ctg-problems/3742/5 "2011-12-14T23:58:07Z")

</div>

Yes, it is possible Ignition cannot create the SQLTags historian tables. You need CREATE and INSERT, UPDATE, DELETE privileges to your database. Once you have that restart Ignition to see if they get created.