If a transaction group calls a procedure name “xyz” from SQL server, but there are no IP address in the SP and no match name in the OPC-UA devices under gateway configure section in our production application inherited from previous employee.
Can someone show me how to identify the correct device entry?
Thanks in advance!
Hi,
I’m sorry, I don’t quite know what you’re asking. You’re trying to figure out what’s driving the data that is being passed to the stored procedure?
So you have transaction group, and that group has an item, set to target one of the procedure’s parameters. There are several possibilities for the type of item it is, but it’s likely either a tag reference (going to one of the defined tags), or a direct opc item (which is like a tag, but just defined in the group). If you double click on the item, you should see either the path that it links to, or the settings for OPC Server and OPC item path.
If it’s a tag reference, go track down that tag in the tag browser. Ultimately, if you can find the OPC Server name and OPC Item Path, you should be able to get an idea of where it’s coming from. If it’s our opc server, the item path will start with the device name. If you go to Devices in the gateway and look at that device, you would be able to see its IP address.
Hope that helps a bit,
Also, I moved this to “Design Help”, as “Knowledge Base” is really meant for how-to articles (though it’s gotten a bit cluttered lately, so I don’t blame you.)
Regards,