I am executing a SQL table lookup in a BizTalk Server 2004 map using
the DB functoids. Whenever the table entry doesn't exist, nothing
results. No error. It just maps a blank to the field. I am using
Covast Accelerator and I figured that OK, a paired EDI field missing 1
of it's paired values (N103 and N104 elements in EDI document) should
fail the map. I guessed wrong. It doesn't.

How do I fail a map that does not retrieve a value on a DB lookup.

There is a DB ERROR return functoid but it is described to be used for
connection failure and the documentation still doesn't tell you how or
when or why to use it.

Any help is greatly appreciated.

[ Post a follow-up to this message ]

Orchestration instead of setup will be the right place for this question.
--------------------
From: sanderbj@yahoo.com (Julie S.)
Newsgroups: microsoft.public.biztalk.setup
Subject: BizTalk Server 2004 DB Lookup
Date: 22 Sep 2004 13:53:20 -0700
Organization: http://groups.google.com
Lines: 14
Message-ID: <9400a78c.0409221253.41ac8139@posting.google.com>
NNTP-Posting-Host: 66.73.121.9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1095886400 13590 127.0.0.1 (22 Sep 2004
20:53:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 22 Sep 2004 20:53:20 +0000 (UTC)
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews1.google.com!no
t-for-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.setup:4635
X-Tomcat-NG: microsoft.public.biztalk.setup

I am executing a SQL table lookup in a BizTalk Server 2004 map using
the DB functoids. Whenever the table entry doesn't exist, nothing
results. No error. It just maps a blank to the field. I am using
Covast Accelerator and I figured that OK, a paired EDI field missing 1
of it's paired values (N103 and N104 elements in EDI document) should
fail the map. I guessed wrong. It doesn't.

How do I fail a map that does not retrieve a value on a DB lookup.

There is a DB ERROR return functoid but it is described to be used for
connection failure and the documentation still doesn't tell you how or
when or why to use it.

Any help is greatly appreciated.


Thanks,
Gong

[ Post a follow-up to this message ]