JDBC Adapter - Error getting receiver system

[Former Member]

Hi,

I am trying a scenarion in JDBC adapter with SQL Server database. After configuring the scenarion I get the following error in RWB.

<b>Error Message:</b>

Transmitting the message to endpoint http://sapep:50000/sap/xi/engine?type=entry using connection AFW failed, due to: Received HTTP response code 404 : Not Found.

I have installed JDBC driver in SAP XI system and also configured it in SDM.

Is there a way(Like some JDBC log.) to findout where it is failing?

In JDBC receiver channel i have defined connection as bellow

Connection : jdbc:microsoft:sqlserver://sapep:1433;DatabaseName=SAPXI

My server name is "sapep"

Please advice.

Thanks,

Sri.

[bhavesh_kantilal]

Hi Sri,

Can you go to the RWB--> ADAPTER mintoring and give us the exact error shown by your JDBC adapter.

Meanwhile, also have a look at this note, 546612

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

The message which I get from Adapter Engine monitoring is as bellow. This is a file to JDBC scenario

Time Stamp Status Description

2006-04-04 13:26:31 Success Channel file2xi_jdbctest: Send binary file "D:\usr\sap\QN7\DVEBMGS00\work\XiPattern2\address.xml". Size 217 with QoS EO

2006-04-04 13:26:32 Success Application attempting to send an XI message asynchronously using connection AFW.

2006-04-04 13:26:32 Success Trying to put the message into the send queue.

2006-04-04 13:26:32 Success The application sent the message asynchronously using connection AFW. Returning to application.

2006-04-04 13:26:32 Success Message successfully put into the queue.

2006-04-04 13:26:32 Success File "D:\usr\sap\QN7\DVEBMGS00\work\XiPattern2\address.xml" deleted after processing

2006-04-04 13:26:32 Success The message was successfully retrieved from the send queue.

2006-04-04 13:26:32 Success The message status set to DLNG.

2006-04-04 13:26:32 Error Transmitting the message to endpoint http://sapep:50000/sap/xi/engine?type=entry using connection AFW failed, due to: Received HTTP response code 404 : Not Found.

2006-04-04 13:26:33 Success The asynchronous message was successfully scheduled to be delivered at Tue Apr 04 13:31:32 GMT+05:30 2006.

2006-04-04 13:31:33 Success The message status set to WAIT.

Thanks,

Sri.

[bhavesh_kantilal]

hi Sri,

This is the error log of your FILE adapter. looks like there is some problem even when the file is being passed to the Integration Engine.

Is there any entry in your SXMB_MONI?? Is your file being picked up?

What is the log of your JDBC adapter showing in RWB--> ADAPTER MONITORING.

Regards,

Bhavesh

[former_member187339]

Hi,

Check the URL http://sapep:50000/sap/xi/engine?type=entry

Is everything correct?

Regards

Suraj

[Former Member]

Hi Suraj,

I checked the URL in browser

URL http://sapep:50000/sap/xi/engine?type=entry

It is not working and dispaly messge "404 Not Found"

The requested resource does not exist.

Details: Go to main page of this application!

How to fix this?

Bhavesh,

File adapter is working fine, because I am able to transfer message for some other scenarion using file adapter and IDoc adapter.

Thanks,

Sri.

[bhavesh_kantilal]

Hi Sri,

After your File Adapter picks up the file, it is passed to the Integration Engine. I dont think this is happening in your case and that is why the URL not found error is occuring.

Can you go to SXMB_MONI and check if the file is actually being processed by XI. Check if it is picked and passed by the adapter to XI's integration engine.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

I am not able to see the message in SXMB_MONI->Monitor for Processed XML Message.

But for other scenario I am able to see the messeages though I am using same file adapter.

What may be wrong with this scenario?

Thanks,

Sri.

[bhavesh_kantilal]

Hi Sri,

Try configuring a new sender file adapter, a new sender agreement for this scenraio of yours.

ASFAIK, the same adapter cannot be used in different sender agreements and i think that is why your message is not even reaching the integration engine, as you would ve defined a sender agreement for the adapter for the earlier scenarios you tried.

Regards,

Bhavesh

PS Mark points for useful answers

[Former Member]

Hi Bhavesh,

You are right. There is some problem with sender file adapter. But how to fix this?

I have tried with a file to file scenario and facing that same problem. But receiver file adapter is working fine.

Please suggest.

Thanks,

Sri.

[bhavesh_kantilal]

Hi Sri,

Try to create a new Sender Interface, Interface Mapping, new file adapter , sender agreement and check if it works.

Regards,

Bhavesh

[Former Member]

Hi,

I found sqlserver is running on port 1433. Still XI is not able to reach SQL Server system. I have also tried connecting SQL Server from simple java program and it is working fine with same connection string. Is there a way to findout which process is failing in XI?

Thanks,

Sri.

[Former Member]

Hi Sudharshan,

Could you tell me how to findout SQL Server port which need to be specified in Connection.

Thanks,

Sri.

[bhavesh_kantilal]

hi,

you will have to look into your Database to find out the port on which it is running. This cannot be done from XI

Regards,

Bhavesh

[Former Member]

Hi sri,

Check the end point url. I am afraid port is not right.

Regards,

Sudharshan.