No more Records to process

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

No more Records to process - Oracle Adapter

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> No more Records to process - Oracle Adapter

Page: [1]

Message

<< Older Topic Newer Topic >>

No more Records to process - Oracle Adapter - 8 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

Hi,

I have a situation where there are no more data to be processed from a table, how could i handle this situation since when i try to find a field value from that data (which is not there) by

strDecidingFactor = SQLResponseMsg(PropertySchema.EXAMSTATUSID);

here name is a string variable and gets the value from a tables field called ExamStatusId which i have promoted. now in the orchestration when it comes into this expression it hangs and does nothing. I have made an XML file before this situation for both NO records to process and for some records to process.

XML file for no records to process:
<?xml version="1.0" encoding="utf-8" ?>
- <ReceiveResponse xmlns="http://Receive/SendQRad">
- <Operation1>
- <RadPacsSendQueue>
<Select />
</RadPacsSendQueue>
</Operation1>
</ReceiveResponse>

-------------------------------------------------------------------------
XML file when there are some records in the database for processing:
<?xml version="1.0" encoding="utf-8" ?>
- <ReceiveResponse xmlns="http://Receive/SendQRad">
- <Operation1>
- <RadPacsSendQueue>
- <Select>
- <Record>
<URN>45</URN>
<TABLENAME>EXAMREPORT</TABLENAME>
<PATIENTMPI>675390</PATIENTMPI>
<PATIENTUNITNUMBER>074-18-91</PATIENTUNITNUMBER>
VISITID>RV000369</VISITID>
<VISITLOCATION>RAD</VISITLOCATION>
<<EXAMSTATUSID>D</EXAMSTATUSID>
<REPORTID>89</REPORTID>
<RADIOLOGISTID>IMRA</RADIOLOGISTID>
< </Record>
</Select>
</RadPacsSendQueue>
</Operation1>
</ReceiveResponse>

Post #: 1

RE: No more Records to process - Oracle Adapter - 9 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

First use a Decision shape using the XPath method to check for the existence of the field. If it is null, then do not access the value.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 2

RE: No more Records to process - Oracle Adapter - 9 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

Thanks Pieter,
Now the problem is that i am not playing with an XML document therefore cant just use XPath as such.
When i use this propertyschema which is null it returns an XLANG's exception, can i just catch this exception inside the expression editor or do something so that the instance does not terminate after throwing an unhandled exception.

------------------------------------------------------
Uncaught exception terminated service Receive.Orchestration_1(f9cf1c03-bceb-8514-4136-f7fa9986d11c), instance fea07569-3612-41eb-ad65-9255ba16f229
There is no value associated with the property 'Receive.PropertySchema.EXAMSTATUSID' in the message.

Exception type: MissingPropertyException
Source: Microsoft.XLANGs.BizTalk.Engine
Target Site: System.Object GetPropertyValueThrows(System.Type)

(in reply to shamir.ali)

Post #: 3

RE: No more Records to process - Oracle Adapter - 10 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Unless you are using some special binary handling in your orch, the document will always be xml.

You can catch the exception and simply set the value to a default.

The other alternative would be to use a .NET Component that does the retrievasl for you. If ythe value is null, you can simply return a default from the .NET Component.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 4