I am relatively new to webMethods, started playing with it about a month ago. I have a test situation setup with 2 integration servers and a broker server.
Integration server A has a service that is watching a table in a DB for inserts, on insert some information is published to my broker and than Integration Server B is suppose to take that information and drop it into another database.
Everything seems to be working except I can’t figure out how the Adapter Service that will be doing the insert on Server B is suppose to reference the elements in the document. If I set the expression column to put in static data everything works fine. On IS B I keep getting the error message
[ADA.1.316] Cannot execute the SQL statement “INSERT INTO TESTMK.dbo.TestTable(keyVal, Value) VALUES (%AddNewMachine.Docs:NewMachineNotificationPublishDocument/agentGuidStr%, %AddNewMachine.Docs:NewMachineNotificationPublishDocument/displayName%)”. "
%AddNewMachine.Docs:NewMachineNotificationPublishDocument/agentGuidStr%, % is my attempt to reference the strings in the document.
Thanks in advance for your help