Cant get distinguish field value

Home Page Forums BizTalk 2004 – BizTalk 2010 Cant get distinguish field value

Viewing 1 reply thread
  • Author
    Posts
    • #15113

      I have receive location that generates this stored:

      select fldid,flddate,fldflag from tblUpdateADLog where fldflag = 0 for xml auto,xmldata
      update tblUpdateADLog set fldflag = 1
      insert into tblUpdateADLog (fldflag) values (0)

      I distinguish the fldid field.

      Every 15 sec. interval, BT is executes the stored and new row inserted.
      The only problem is that I can’t get the distinguish fldid value.

      msgIn.tblUpdateADLog.fldid

      \”Im getting: object reference not set to an instance of an object\”
      Im using xmlrecieve as pipeline type.

      Any idea?

    • #15112

      Make sure you are using the Xml Disassembler Pipeline component. The Passs Through will not promote the distinguished field.

      If that doesn’t help, you might want to drop the field inside the schema and read it. Also, make sure you redeploy and restart your hosts.

      If that still doesn’t work, get your message to suspend on the receive side by turning off the Send Port / Orchestration. Then look at the message context properties and see what’s going on.

      Hope this helps.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.