Query using History, History Event and Current mode

[Former Member]

Hello All,

When I query ihistorian using Interactive SQL for the defined period I can see the data returned in rows with timestamp and tag value.

When I queried iHistorian database using xMII for the same tag and period using History, History Event and Current mode I got empty rows.

Why xMII query gives this kind of results.Why I am not able to see the data whem it is available in iHistorian?

Thanks in Advance

Raman

[jcgood25]

Is it possible that you have a data quality issue and the blanks are for invalid records? In your SQL query return the quality fields and see if any of the records are marked as invalid.

Regards,

Jeremy

[Former Member]

What version of iHistorian are you connecting to?

What UDS are you using?

Martin.

[Former Member]

UDS version is 2.5.0.4 and GE Fanuc iHistorian.

Is it possible that this problem is due to some configuration in iHistorian??

[jcgood25]

Did you ever resolve this situation?

Regards,

Jeremy

[Former Member]

Jeremy,

Sorry for not closing this thread before.

I got the solution to the problem.

In this case we found out that connection between SAP xMII and iHistorian was ok but the OPC connection between shopfloor and iHistorian failed.

Because of this even when xMII connection was ok and Instance of UDS connector was running fine we were not able to see any data records.

After the OPC connection from Shop floor to iHistorian was resumed, we got the data.

Thanks for all your inputs.