JDBC Synchronous call using BPM

[Former Member]

Guys,

Scenario is like this.

1. Initiator is file adopter

2. JDBC select (Synchronous call) select data from 1 DB table

3. Copy response into some FTP system as a file.

File Initiator is working fine Synchronous call is giving the error.

I have created the Message Interfaces

1. Synchronous abstract (JDBC_select)

2. Asynchronous abstract (JDBC_Select)

I have done the 2 mappings like

1. File Initiator as source and JDBC_Select as target,

(I am passing all constants values to JDBC_select like action='SELECT' table='tablename' and keys as well)

JDBC_Select structure i have created as

<Root>

<selectStatement1>

<action>

<tablename>

<access>

<c1>

<c2>

<key>

<c1>

2. JDBC_response as source to Target_FILE as target.

Response structure is like this

<root>

<row>

<c1> </c1>

<c2>...</c2>

</row>

</root>

I have created the BPM by using

--> transformation and send steps.

Can any body send me the Blogs for this scenario .

Thanks

M

[moorthy · Accepted solution]

Hi Murali,

Check this blog for the reference-/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

In your case, it is better to have mapping outside the BPM.

Regards,

moorthy

[Former Member · Accepted solution]

Moorthy,

I have created Receiver Determination , Interface Determinations and Receiver Agreements too.

when I am trying to see messages in SXMB_MONI it is geving error message like "Send Message Synchronously Error", can any body tell me what is reason for this error.

when I test in configuration using test tool, it is giving "receiver determination not found"

Thanks

M

Message was edited by: Murali Babu Pallabothula

[moorthy · Accepted solution]

HI,

<i>when I test in configuration using test tool, it is giving "receiver determination not found"</i>

>>>>>>>

You have BPM here- So you need to have following Receiver Determinations

1) File to Integration Process

2) Integration Process to JDBC

3) Integration process to File

<i>Send Message Synchronously Error"</i>

>>> Where are you getting this error ? Are you able to see the BPM triggered? If so go to Workflow log (i.e SXMB_MONI->PE->Menu->Technical Details) and check for the log..

What are the steps executed in the BPM ?

In BPM, in Send step, did you use Send Step Sychronous mode..Check these

Regards,

Moorthy

[Former Member · Accepted solution]

Moorthy,

Thanks for your quick response

I have created the 3 receiver determinations,

3 interface determinations and

2 Receiver agreements

(File to BPM,

BPM to SQL Server server (JDBC Receiver and

BPM to File system )

I went to SXMB_MONI -> PE -> it took me to workflow log screen there it shows 2 messages.

1. mapping done which is file initiator (success)

2. Send Message Synchronously Error (Error).

<b>BPM Steps</b>

START -> RECEIVE (ASYN) -> TRANSFORMATION -> SEND(SYN, POINTING TO JDBC) -> TRANSFORMATION -> SEND -> STOP.

Moorthy this is kind of urgent scenario can you please help in this what are other steps i have to maintain.

Thanks

M

[bhavesh_kantilal · Accepted solution]

Murali,

Can you check the follwoing in the Send Synchrnous Step,

1. You can defined an ABSTRCT SYSNCHRNOUS interface for Send Synchronous SYNCHRONOUS Interface in the BPM.

2. The interface used for sending and receiving the response are ABSTRACT ASYNCHRNOUS.

Also, you can use this blog as a template /people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

And do the transfomartions otuside the BPM itself. Except for the RFC / JDBC change, everything else is the same , and so it will help you solve your problem.

Regards,

Bhavesh

[udo_martens · Accepted solution]

Hi Murali,

of course your second send step (to file) has to be asynchronous as well as the interfaces for that. Plz control that and delete as Venka recommended all work items in SWWL.

This errors occurs when you dont define exception branches for possible runtime errors. The process cant end itself and every new message get routed to the corrupt process.

Regards,

Udo

[Former Member · Accepted solution]

Udo / Venkat,

I just entered item number in SWWL and deleted, is that the way or any other way to delete those work items.

still it shows same error and my second step asynchronous only.

is there any problem with synchronous step..

thanks

M

[moorthy · Accepted solution]

Hi,

As i suggestes earlier itself, just do the mapping outside the bpm..

SO your BPM steps will be

1) Recieve File message

2) Send the file message (Synchrnously) (Outside the BPM this message is mapped with JDBC input and JDBC response is mapped with some response message type)

3) Send the received message to the file asynchronously..

These steps you need to do . nothing else...

Also cross check, your First Send Step is Synchronous..( in the SEnd step properties)

REgards,

Moorthy

Message was edited by: Krishna Moorthy P

[Former Member · Accepted solution]

Moorthy,

I have tryed that way also (outside BPM)

When I am creating the interface determination I am unable to get the mapping programs in my drop down(F4 help),

can you please give me the steps how can i create the message interface, message mapping , mapping interface and configurations steps ..

b'coz this is the first time I am doing the BPM .

<b>Objects</b>

<u>Message Interface</u>

- JDBC_Request_asyn_ab

- JDBC_Request_asyn_ob

- JDBC_Response_asyn_ab

- JDBC_Response_asyn_ib

- JDBC_syn_ab

- Proce_Initiator_asyn_ab

- Target_file_asyn_ab

<u>Message Mapping.</u>

- Proc_Ini_JDBC_Select (source: Process_init target: JDBC_Request)

- Response_Target (Source: JDBC_Response, Target: Target_file)

Can you please let me know what ever I have done is correct?, is there any thing I needs to change..

Thanks

M

Message was edited by: Murali Babu Pallabothula

[moorthy · Accepted solution]

Hi,

Data Types -

1) File Input

2) JDBC Req

3) JDBC Response

4) File Response of similar type of JDBC Response.. ( This you can avoid also..let it be for first time)

Message Types

4 for each data type

Message Interfaces

1) Async, Outbound, Interface, to receieve the file

2) Async, Inbound , Interface to send the file from XI

3) Async, Absract , Interface of type File message type to recieve the message in the BPM

4) Sync, Abstract Interface with Req message type as File Request, and Response Message type as a file Response

5) Sync , Inbound interface for JDBC with Input message type as a JDBC Request and Output Message type as a JDBC Response

Message Mapping:

1)Mapping between File Req to the JDBC req

2) JDBC Response to File Response

Interface mapping:

1) Sender Interface as a Sync,Abstract Interface created for the file type and target interface as Synchrnous JDBC interface.

Use corresponding mapping for Req and Resp..

Then BPM , as mentioned in my ealier post.. Transformation step is done outside the BPM..

Hope this helps,

Regards,

Moorthy

[Former Member · Accepted solution]

Moorthy,

Thank you for your help.

While creating the receiver determination which interface i have to select.

Can you please give configuration steps too..

Thanks

M

[moorthy · Accepted solution]

Hi,

Receiver Determination :

1) File Sender (Outbound Interface) inbound is File Abstract Interface( no need of mapping) to BPM

2) File Abs sender from BPM to JDBC Reciever (sync) interface with Mapping

3) FileResp abs from BPM to File system target wih Inbound Async file interface..without mapping

Regards,

Moorthy

[Former Member · Accepted solution]

Moorthy,

As per your previous mail do I need to create 4 message interfaces for each messagetype/datatype.

I am bit confused..

<u>For file.</u>

1) Async, Outbound

2) Async, Inbound

3) Async, Absract

4) Sync, Abstract

5) Sync , Inbound

<u>JDBC_Request</u>

1) Async, Outbound

2) Async, Inbound

3) Async, Absract

4) Sync, Abstract

5) Sync , Inbound

<u>JDBC_Response</u>

1) Async, Outbound

2) Async, Inbound

3) Async, Absract

4) Sync, Abstract

5) Sync , Inbound

<u>File_Respose</u>

1) Async, Outbound

2) Async, Inbound

3) Async, Absract

4) Sync, Abstract

5) Sync , Inbound

Thanks

M

[moorthy · Accepted solution]

As I mentioned earlier, you have 4 data types. So 4 message types.

Regd. Interfaces, I have clerly mentioned..

~moorthy

[Former Member · Accepted solution]

Moorthy,

yes your right..

it's my mistake

I am bit doubt on first 4 message interfaces

while creating message interfaces which message type i have to select?.

Message Interfaces

1) Async, Outbound, Interface, to receieve the file "File Input"

2) Async, Inbound , Interface to send the file from XI "JDBC_reques"

3) Async, Absract , Interface of type File message type to recieve the message in the BPM "?"

4) Sync, Abstract Interface with Req message type as File Request, and Response Message type as a file Response "?"

Can you please clarify this...

Thanks for your help..

M

Message was edited by: Murali Babu Pallabothula

Message was edited by: Murali Babu Pallabothula

[moorthy · Accepted solution]

Message Interfaces

1) Async, Outbound, Interface, to receieve the file "File Input" (File Message Type)

2) Async, Inbound , Interface to send the file from XI "JDBC_reques" ( Here no, you should have one message type that will be sent to file from the BPM . It is your JDBC Response i.e one message type which will be sent to the File in the last step..you can create one message type for this. As mentioned in step4

3) Async, Absract , Interface of type File message type to recieve the message in the BPM "?" (Same message type as 1)

4) Sync, Abstract Interface with Req message type as File Request, and Response Message type as a file Response "?" (Here I just told you to create one Message type which is similar to the JDBC Response. For this you can just copy the JDBC Response message type and save as FileResponse or etc.. this will be sent to file in the last step..)

5) One more message interface i.e Sync, Inbound for the JDBC Req and JDBC Response..

Regards,

Moorthy

[Former Member · Accepted solution]

Moorthy,

<u>Message Types</u>

1) File_Input

2) JDBC_Req

3) JDBC_ Response

4) Target_File

<u>Message Interfaces</u>

1) Async_Outbound,

- File_Input

2) Async_Inbound

- Target_File

3) Async_Absract

- File_Input

4) Sync_Abstract

- Target_File (Output Message)

- JDBC_Response (Input Message)

5) Sync_Inbound

- JDBC_Request (Input Message)

- JDBC_Response (Output Message)

<u>Message Mapping</u>

1)Mapping1

- File_Input as a Source

- JDBC_Reqest as Target(Here I am passing all constants values like action, tablename , accessfields and keyfields)

2)Mapping2

- JDBC_Response

- Target_file (Target file structure as same JDBC_Response structure)

<u>Interface Mapping</u>

Interface Mapping 1

- Sync_Abstract (source Interface)

- Sync_Inbound (Target Interface)

Here is my doubt I am not getting Mapping program in the dropdown (F4 help), it is problem with my source and target?.

What are the source and target for second interface mapping.

Thank you for helping me alot on this..

M

[moorthy · Accepted solution]

4) Sync_Abstract

- Target_File (Output Message)

- JDBC_Response (Input Message)

This is incorrect.. It should be Input messaga should be FileInput and Output message should be File Target..

CHange this,activate and then check it.

Regards,

Moorthy

[Former Member · Accepted solution]

Moorthy,

I have changed message interface below menction

4) Sync_Abstract

- Target_File (Output Message)

- File_input (Input Message)

Still there is something is wrong in this...

I am not getting the "mapping program"

if possible can you please give your phone no or can you reach me at 248-943-4239..

B'coz this is kind of urgent scenario..

Thanks

M

Message was edited by: Murali Babu Pallabothula

[Former Member · Accepted solution]

Moorthy,

Thank you very much finaly it is working fine..

Thanks

M

[Former Member · Accepted solution]

Hi Boss,

I have the same type scenario that is file initiates the bpm that invokes the Webservice.the file data goes into bpm as the input data of the webservice and webservice gives the response and then the web-service response is mapped to

idoc and finally posted to R/3.

The interface sI created:

1.outbound Async -

---

>for file

2. Abstract async----

---

>bpm reciever step.

3.Abstract sync----

---

>bpm sync send step.

4.inbound sync -

---

>for the webservice to recieve the reqst and to send the response to Abstract sync

5.Abstract async----

---

>to send the data out of BPM

6.inbound async----

---

for idoc

created 3 communication channel.

1.file adapter: sender

2.SOAP adapter: Recv

3.IDOC adapter: Recv

created 3 reciever determination

Business process instance in ID

reciever agreement(2)

interface determaination

But getting a problem in BPM.

I think the scenario is logically correct as I have seen your previous suggestio.

But getting the problem in BPM's sync step.and the SOAP rec channel is also inactive.in BPM workflow I can see the recv step is getting file req data but after that in the sync send step

its stuck up.getting error.

Please sir suggest me.

[Former Member]

Hi,

I had similar kind of error. This error may also occur even if the BPM is correct.

Delete the already existing "Work Items" by using the transaction "swwl". This solved my problem. May be this can help you.

Regards,

P.Venkat