I am having a hard time figure out a solution for my problem. I have an orchestration

Where the Inbound port is a Receive location with Scheduler adapter. The Outbound Ports are the ports created from the SQL Binding and Oracle Binding and a FILE adapter to drop the POA Created. When I turn on the scheduler, the application is not running not thrwoing error, not getting in to dehydrated state nor suspended nothing is happening. When I see the tracked message events I just see this

I dont see any action after this, nothing in the event log too.. I am stuck with this since yest, not able to find what is happening... Any help is really appreciated. Thanks

• Edited by vdha Wednesday, August 26, 2015 6:32 PM

Ok ,Can you verify through biztalk admin console what trigger message BizTalk Scheduled Task Adapter  is sending to messagebox  .?

Can you look at the trigger message whether it  is correct one or not.

Thanks

Abhishek

• Edited by Abhishek0127[Abhishek kumar]MVP Wednesday, August 26, 2015 7:19 PM

Hi,

I can see that the for the Oracle port you only got the Receive Event and no send event. Can you check how much retry interval is set on the Oracle port and what operation you are performing on the port?

If the Oracle port is running on a different host then check the logs for that server for any errors.

Rahul

Rahul,

It is running in the same host, I dont see any errors logged and I checked the retry count

I checked the action in SOAP Action header

<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">  <Operation Name="Select" Action="http://Microsoft.LobServices.OracleDB/2007/03/LAW/View/VW_PURCHASE_ORDER/Select" /></BtsActionMapping>

I couldnot figure out what is going wrong.

I did even change the retry count to zero '0' but nothing happening after the

I am stuck

• Edited by vdha 19 hours 44 minutes ago

Abhishek,

The trigger message to the scheduled task adapter is to the SQL Table

<ns0:Select xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/inf_commitment_po"><ns0:Columns>commitment_id,commitment_number,activity,requisition_number,po_number,status,sent_to_xxx,created,created_by,updated,updated_by</ns0:Columns><ns0:Query>where sent_to_xxx = 0</ns0:Query></ns0:Select>

When I see the Tracked Service Instance it shows the orchestration is completed

I dont understand how, what is wrong here

If possible can you send the Orchstration design snapshot so that we can get a better idea of what is the flow of messages.

Rahul

Rahul,

It is running in the same host, I dont see any errors logged and I checked the retry count

I checked the action in SOAP Action header

<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">  <Operation Name="Select" Action="http://Microsoft.LobServices.OracleDB/2007/03/LAW/View/VW_PURCHASE_ORDER/Select" /></BtsActionMapping>

I couldnot figure out what is going wrong.

I did even change the retry count to zero '0' but nothing happening after the

I am stuck

• Edited by vdha Thursday, August 27, 2015 11:19 AM

Hi Vdha

Does the orchestration instance complete - can you check that from AdminConsole Completed Instances?

Looks like the SP instances are getting completed - did you check the SQL/Oracle tables if the data is being inserted?