How to fetch data using IDOCs in Real time JOB

dataservices sap-erp-bw
1

Hi Guru’s,

I’m first time fetching data from IDOCs using Real time Job.

I have created SAP Datastore and import IDOCs and Created Real time job ,my target is SQL server. When I try to execute job from Designer then I 'm getting error --“The file name is missing for the IDoc or XML file source”

I have also configured Client Interface and Real-Time Service in management console.
In Client Interface showing “Waiting for IDOCs” and having green symbol.
In Real-Time service configure I have configure the Real time job with default Startup timeout 300,Queuing timeout 400,Processing timeout 200 ,Recycle request count max 10000 bcoz I did not have any idea about time set.

in real-time services, job showing green symbol having status “Services Started”. but data is not loaded in table …I do not understand where is the problem…

I have follow the same step that’s mentioned in below link-
loading... | SAP Help Portal.

pls guide me and send me the right step so that I can achieve my target.

:box:

rajeev_khokhar1 :india: (BOB member since 2011-01-19)

2

HI Guru’s,

I didn’t received any reply from your side!!

Now, I have makes complete connection but When IDOCs process start from SAP and I start my Real-time service then I received this error
“Broker Client is no longer connected to the Broker Host AGLSAPSBXARDDB1:4000”

Pls-2 give me the solution where is the problem -in sap side or BODS side and I hope you should have some solution

I’m doing wait for your response.

Werner Daehn -Sir,I aspect some solution from your side 8)

rajeev_khokhar1 :india: (BOB member since 2011-01-19)

3

I have your question on my radar, but no immediate idea…

I am also unclear on where the failure happens, so my next step would be to look for the realtime job log, the realtime service log, the RFC IDOC Client statistic page. Is the IDOC even received?

Werner Daehn :de: (BOB member since 2004-12-17)

4

Thanks’ Werner for your Quick Responce!!!

Yes- I received IDOC and Error log file showing “Empty file received.”
When IDOC is start from SAP system ,Job generate the New trace Logs, but in MONITOR LOG showing 0, 0,0,… count and after this getting above mention error-"Broker Client is no longer connected to the Broker Host AGLSAPSBXARDDB1:4000" But When IDOCs Instance is executing from SAP syatem ,Access Server re-start on every execution…

1)I had tryied to ping access server port and other port from where we are expecting request. all are fine.
2)Set RFC connection in Admin console,that is also fine
3)checked access server,it is properly started without any warning.

for more details I have attached Trace log,Error and monitor log information.!!
trace_log.png
ERROR_MSG.png
monitor_log.png

rajeev_khokhar1 :india: (BOB member since 2011-01-19)

5

Hi,

I’m doing wait for your Expert responce !!! :!:

rajeev_khokhar1 :india: (BOB member since 2011-01-19)

6

I know, I know. I had a first look at it already.

Werner Daehn :de: (BOB member since 2004-12-17)

7

Thanks’ Werner!!! :wave:

I have found the solutions of this problem.
Actually ,you know BODS job server is not UNCODE and SAP RFC function module is Unicode so we had required to make the SAP RFC UN-Unicode form.

there is a one Unicode option in RFC function module .so just click on it.
Now my Run time job is executing successfully.

rajeev_khokhar1 :india: (BOB member since 2011-01-19)

8

Excellent. I would have never thought about that.

Werner Daehn :de: (BOB member since 2004-12-17)

9

Sorry for posting in this old thread, but it looks like I am running into the same problem as Rajeev.

Rajeev, could you explain your solution a little more? I am not sure where you are making the UniCode change at.

Thanks,
Tim

tim_pank :us: (BOB member since 2011-10-12)