String Tag Types + History Mode - xMII 12.0.1

[Former Member]

Hi all,

I'm really newbie in Tags but i'm with the following problem:

I'm trying to access value from a specified data range in a Tag that returns just string to me, but I can't use the HistoryEvent Mode like I was doing for Tag Queries that return me number, I would like to know how to retrieve "non-current" string data from a Tag Query.

Thanks in advance.

Pedro Sena

www.neoris.com

[salvatore_castro]

Pedro,

Why can't you use HistoryEvent mode?

Sam

[Former Member]

Hi Sam,

I don't know why, but we can't take historical data from String Tags, exclusively String tags, using a Client to InSQL, we can do it, so the InSQL gives us the info, but we can't take this data thought xMII.

Tnx

[salvatore_castro]

Pedro,

What is the DataServer config you are using to connect to InSQL?

Sam

[Former Member]

Sam, is this that you are looking for? :

Connector InSQL

ConnectorID

ConnectorType TAG

DatePrefix '

DateSuffix '

DaysRetention 7

Description ---

Enabled T

InternalDateFormat MM-dd-yyyy HH:mm:ss

JDBCDriver com.inet.tds.TdsDriver

MaxRetryCount 5

Name Alicorp_InSQL

PoolMax 100

PoolSize 1

RetryInterval 60000

ServerPackage com.sap.xmii.Illuminator.connectors.InSQL

ServerURL jdbc:inetdae:aliargsql1:1433?database=Runtime&sql7=true

Timeout 15

UseCount 256

UseOLEDB true

UserName wwAdmin

ValidationQuery SELECT GETDATE()

WaitTime 30

Tnx

[salvatore_castro]

Pedro,

From what I hear around the office, string are not supported via the Tag Query interface since they are handled differently on the InSQL side. Instead you can write the OLEDB sql query against the system to get the information. Create an IDBC SQL Type connection to the system and use your query from SQL Analyzer you mentioned earlier to get the data you need.

Hope this helps.

Sam

[Former Member]

String tags used to work with the InSQL connector in HistoryEvent mode...