Sqlt_data_x_x_x for tag history has been renamed but my scripts still reference the old table name

Ignition
,
1

My SQL express is full so i decided to delete the table “sqlt_data_1_2021_04”. I let ignition automatically create a new one named (sqlt_data_1_20210429).

But my scripts still use the old table name. Here is the error:

Traceback (most recent call last):
  File "<event:propertyChange>", line 7, in <module>
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Invalid object name 'sqlt_data_1_2021_04'.

	caused by GatewayException: Invalid object name 'sqlt_data_1_2021_04'.
	caused by SQLServerException: Invalid object name 'sqlt_data_1_2021_04'.

Ignition v8.1.2 (b2021020311)
Java: Azul Systems, Inc. 11.0.9

How can I make my scripts use the new table?

2

There’s another table you need to remove the reference in as well, I don’t remember it’s name, but look through the other sqlxxx ones

1 Like
3

Found it!
Image 1

What should I do with this? Delete the table contents and let ignition create a new contents?

1 Like
4

Think so, make note of the rows you delete first though in case you need to put them back

5

I delete all the rows and restarted the gateway it now works! Thank you nminchin.

1 Like