Datadirect - Hardware status Excel report generation - "NO DATA" Error
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.
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