Datadirect - Hardware status Excel report generation - "NO DATA" Error

Hi ,
I am generating Hardware status excel report , it is showing "NO DATA" in generated reports , Values fetching from real time OPC values ,history logs not created. Observed that for 1 DI card 16 Channels - 48 real time data fetching found ok. after that if add other cards subsequently to the same report template data is not updating showing '"NO DATA" for the link.
Is there any settings to enable in excel or data direct to get all those real time opc values into excel Excel report or is there is any limitations to fetch real time OPC data values into Excel report interms of number. I am going to fetch hardware status for few IO modules , seems going to be bulk.
creating log configuration for all the IO modules is not possible in present system.
Screenshots attached. 32 bit 800xA 5.1 RevA ,Office version : Microsift Office enterprise 2007.
anybody pls suggest.

regards,

Comments (0) New comment

ASN Rank: 346

Asked 1 year ago

Answer this question Follow

Answers

NO DATA could indicate a problem to add the items to the destination OPC server (AC 800M); make sure all objects contained in the report can deliver "Live data" in Plant Explorer.

I tested turning off the OPC DA Connector service for AC 800M; subsequently, all ABBGetOPCDA() calls for AC 800M properties started to return NO DATA.

I suspect the Consistency Checker Tool to be able to conveniently spot "Live Data Errors" among many objects. Use Plant Explorer's Search Tool to search for the aspect categories you attempt to read (Hardware Unit, Function Block, Control Module, Application, etc.) and drop the results in the checker tool. Or drop your entire Controller or Control Project (if not too large) and check all aspects (which will take a bit longer).

The OPC Update Rate on the Hardware Unit aspects is rather slow, 5000 ms. A large report containing multiple aspects to read may timeout waiting for data; try splitting it up. If a smaller report works better, you've hit a size limit. The OPC read timeout value does not seem adjustable (have tried some...).

You may see more details in a debug file by enable DataDirect Options > Setup Tab > Write Debug File.
C:\Users\username\AppData\Roaming\ABB Industrial IT\Inform IT\DataDirect\tmp\debug.txt

Comments (4) New comment

by Stefan Stromqvist AKS expert

Rank: 1 on 2/18/2020 6:45:04 AM | Like (0) | Report

The debug.txt is not very rich - if you send me an email (firstname.lastname@se.abb.com) I can provide you with a more detailed debug version of the .XLA file running the macros.

by ASN Rank: 346 on 2/18/2020 8:46:30 AM | Like (0) | Report

Thank you stefan . Sure tommorrow i will check & update you.

by Stefan Stromqvist AKS expert

Rank: 1 on 2/18/2020 9:29:02 AM | Like (0) | Report

Geof's answer may be the reason. The OPC DA framework of 800xA expect clients to handle temporary timouts while connecting a data source. The Excel report is a short lived thing, it wants to produce its output and terminate as soon as possible. If the data connection between the computer running the report and the connectivity server computer running the OPC DA Connector service having the source OPC server in hand takes too much time, a temporary "please try again, shortly" code may be returned. This will lead to the NO DATA error Geof is mentioning.

With the enhanced .XLA I have, we can see that code being output in the debug log.

"ABBGetOPCDA - Adding OPC Tag to cache to be queried: [Control Structure]Root/Control Network/Supportline_24x365/Controllers/Controller_1/Hardware/0/11/1:1.Forced: 2/18/2020 6:20:11 PM"
"ABBGetOPCDA - Adding OPC Tag to cache to be queried: [Control Structure]Root/Network 21/AC450 node 51/Extended Process Objects/MB300 AI/51-CPULOAD:VALUE: 2/18/2020 6:20:11 PM"

"ABBGetOPCDA - Querying for value: [Control Structure]Root/Control Network/Supportline_24x365/Controllers/Controller_1/Hardware/0/11/1:1.Forced: 2/18/2020 6:22:30 PM"
"ABBGetOPCDA - Querying for value: [Control Structure]Root/Network 21/AC450 node 51/Extended Process Objects/MB300 AI/51-CPULOAD:VALUE: 2/18/2020 6:22:30 PM"
"1.) Value: Timestamp: 2/18/2020 5:22:30 PM Errors: 180032768"
"2.) Value: 36.4 Timestamp: 2/18/2020 5:22:30 PM Errors: 0"

The rows preceeded by a digit 1, 2, etc is the additional logging I have created.
The error code 180032768 (decimal) becomes more easy to interpret in hexadecimal: ABB1500

With afwerrorlookup, the error message can be unveiled:

S_AFW_OPCDA_OFFLINE
The Data Access server has no connection to a data source provider service (offline until a connection is established).

The above error code will be output if the destination OPC DA Connector server is:
a) "down" (intentionally stopped as I did test before submitting this answer)
b) Rejecting a connection, e.g due to affinity blocking or a wrong IP address somewhere
c) not reachable for other reason

However, before logging, your first goals are:
- check all properties contained in the report to be subscribable
- check all OPC DA Connectors are up and running
(a temporary error like you've reported cannot be explained by a intentionally stopped service or IP address problem)

by ASN Rank: 346 on 2/19/2020 12:27:21 AM | Like (0) | Report

Hi Stefan,
Tried with consitancy check , OPC server and path is ok, the report is genrating from combined aspect and connectivity server, no problem with the OPC connection. I trying to read data from OPC test client , there also hardware status data showing "Bad,Not connected" reading for only 2 to 3 status some time no for all. tried mr. Geof suggestion is not worked . Debug file i will share you.

Add new comment

Stefan Stromqvist AKS expert

Rank: 1

Answered 1 year ago

In these earlier versions of 800xA, there was some issues with AfwCSLib that were present and later corrected. I have attached a document that explains at least one of these issues. If this does not solve your issue, it is advised to open a Support Case with your local support group and have this issue looked into further. It may also be advisable to check the MS Event Viewer log files on the node with DataDirect installed to look for any errors, especially with AfwCSLib. Note that any un-terminated NIC connections, (these should be disabled), will cause issues on an IM node if this is the node in question.

Regards,
Geof Ledin

Comments (2) New comment

Geof Ledin AKS expert

Rank: 36

Answered 1 year ago

DataDirect get spora.txt

Question details

Datadirect - Hardware status Excel report generation - "NO DATA" Error

Answers

Other questions needing answers

Related topics

AKS experts