I am trying to get a database connection working so I might set up tag history.
I am using SQL Server. ( I am not a database person)
The connection name is MSSQLServer.
The JDBC driver is Microsoft SQLServer.
The database is local, so the connect URL is jdbc:sqlserver://localhost\SQLExpress:1433.
The user name is Ignition.
Extra Connection Properties are databaseName=msign.
Enabled is checked.
Translator = MSSQL.
Include Schema in Table Name is checked.
Connection Pooling, Connection Testing, and Connection Initialization are default.
Database Connections show the connection as valid.
The SQL Server Management has:
Login = Ignition + password.
Server Roles has ‘public’ checked.
User mapping has the msign database checked. The roles are db datareader, db datawriter, and public checked.
Securables has (My computer name)\SQLEXPRESS as the server.
Explicit permissions are ‘connect SQL’ -Grantor sa, ‘Create any database’ – Grantor sa.
Effective Permissions are ‘CONNECT SQL, CREATE ANY DATABASE, VIEW ANY DATABASE.
Status Grant to database engine, Login Enabled.
Msign database has User and Login name = Ignition. Default schema dbo.
Owned Schemas all unchecked.
Role Member db_datareader and db_datawriter checked.
Securables is empty.
Extended Properties Database msign, Collation SQL_Latin1_General_CP1_CI_AS
History Datasource history Provider status is Running.
The tag is an OPC Integer that has random numbers written by the PLC. I can watch the values change from the Tag Browser in Ignition Designer.
History Enabled = true
Storage Provider = MSSQLServer
Deadband Style = Auto
Deadband Mode = Absolute
Historical Deadband = 15.0
Sample Mode = Periodic
Max Time Between Samples = 10 Seconds
Sample Rate = 5 Seconds
I can run the SQL Query ‘Select Record From dbo.Table_1’ from the Database Query Browser and it returns some stuff from the ‘Record’ column in the msign database
I have two tags, ‘Query Tag’ and ‘Int_1’. Both point to the same register in the PLC. ‘Query Tag’ does not have history enabled, ‘Int_1’ does have history enabled.
I can drag and drop ‘Query Tag’ on an Easy Chart and everyone is happy.
If I drag and drop the ‘Int_1’ on the same chart, I get:
Exception: Error running query:
Tag Density Histogram Query
Range: Tue Jan 14 08:00:00 EST 2020->Tue Jan 14 09:59:59 EST 2020
Paths:
prov:default:/tag:Query Tag
prov:default:/tag:Int_1
@0ms
On: New Main Window.Root Container.Easy Chart
caused by GatewayException: Error executing tag history query. Please verify that the connection is available, and that tag history is being stored to it.
caused by Exception: Error executing tag history query. Please verify that the connection is available, and that tag history is being stored to it.
Ignition v8.0.6 (b2019111216)
Java: Azul Systems, Inc. 11.0.4
Read and Write and enabled. Any suggestions as to where to look?
I can see no tables in the database that are created by Ignition. Does the table have a specific name?