PCo Query gives two Rows for Tag

[former_member203984]

Hi All,

I am using SAP MII 15.0 SP4. I am trying to fetch the live values from Kepware using SAP Plant Connectivity.

For few tags I am getting the Value's in two rows. How can I avoid that values?

Please help out.

sample OP from PCo Query:

<?xml version="1.0" encoding="UTF-8"?><Rowsets CachedTime="" DateCreated="2015-08-08T17:12:16" EndDate="2015-08-08T17:12:16" StartDate="2015-08-08T16:12:16" Version="15.0 SP4 Patch 1 (May 4, 2015)">

    <Rowset>

        <Columns>

            <Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/>

            <Column Description="HD Paused Stop LH1" MaxRange="0" MinRange="0" Name="PAUSE_STN_01_LH" SQLDataType="16" SourceColumn="PAUSE_STN_01_LH"/>

            <Column Description="FP Paused Stop LH1" MaxRange="0" MinRange="0" Name="PAUSE_STN_01_LH" SQLDataType="16" SourceColumn="PAUSE_STN_01_LH"/>

        </Columns>

        <Row>

            <DateTime>2015-08-08T17:12:16</DateTime>

            <PAUSE_STN_01_LH>0</PAUSE_STN_01_LH>

            <PAUSE_STN_01_LH>NA</PAUSE_STN_01_LH>

        </Row>

        <Row>

            <DateTime>2015-08-08T17:12:16</DateTime>

            <PAUSE_STN_01_LH>NA</PAUSE_STN_01_LH>

            <PAUSE_STN_01_LH>0</PAUSE_STN_01_LH>

        </Row>

    </Rowset>

</Rowsets>

Regards

G.Partheeban

[former_member512453]

Hi Parti ,

In PCo Query if you choose current mode for tag retrieve query , due to time delay/ difference  of tags in shop floor level will be getting the values across the timestamp.

Mean while you can try work around with below steps

1)select mode - tag aggregate query

2)In  date range tab  you can select the duration units as you need

3)In tag Aggregate query tab - select aggregates as min or max for the particular time line .

Else  can be handled via transaction.

Regards,

Adhikesh

[former_member203984]

Hi All,

Can anyone help on this?

Regards

G.Partheeban

[austin_jacob]

Hi Partheeban,

Just to understand it more

1)Is the PCO Agent an OPC DA or OPC HDA?

2)Are you using Tag Retrieve Mode and Current View?

Regards,

Austin

[former_member203984]

Hi Austin,

I am using OPC DA agent. Also I am using "TagRetrieveQuery" and "Current" View.

Attached the same.

Regards

G.Partheeban