Problem in Data loading from R/3 to BW system

[Former Member]

Hi All,

I am facing issue in data loading from R/3 to BW system.

We are scheduling the job in BW system by RSA1 tcode. The job is not triggering in R/3 system.

This gives me error as some transactional RFC error, Please check the Dumps as well for more information.

Let me know for any queries.

Regards,

Hemalatha G

[Ranjith418]

Hello Hemalatha,

Did you check the source system connection via rsa1? did you maintain the partner profile and port number in we20 and we21? please check table rsbasidoc for the source system. in this table the entry must be active and also in we20 the partner profile must be in active status.

Thanks,
Ranjith

[Reagan]

Hello

The problem is with the call to the Source System from the BW system.

I suggest you to get the RFC connection fixed first.

Maintain the host-name (FQDN) and the IP address of the Source System in the BW server hosts file.

Check whether you can get a successful ping from the BW machine.

If the host-name (also FQDN) in the RFC is not working then check whether the RFC is successful with the IP address in the Target Host field under Technical Settings.

Lastly make sure the User maintained in the RFC has proper authorizations.

Good Luck

Cheers

RB

[former_member185239]

Hi Avadhesh,

You need to check the hosts file entry , if it is not there

<IP>  dcntsvr3<xxx.com>   dcntsvr3

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi All,

i have checked the BW system trace files  in  work directory , trace files are showing following error

dev_rfc shows as::

======> CPIC-CALL: 'ThSAPOCMINIT' : cmRc=20 thRc=497

Unable to determine host address: NiHostToAddr failed

ABAP Programm: SAPLSMON (Transaction: ST06)

Called function module: GET_CPU_VIRT_AIX

User: GIRI (Client: 300)

Destination: dcntsvr3_N01_11 (Handle: 7, DtConId: 5136EB2CCC2955F2E10000000A8F0185, DtConCnt: 1, ConvId: ,{5136EB2C-CC29-55F2-E100-00000A8F0185})

EPP RootContextId: 80144FF8AACA1EE2A1C584DCE38C4E9D, ConnectionId: 00000000000000000000000000000000, ConnectionCnt: 0

EPP TransactionId: 5136EB18CC2955F2E10000000A8F0185

Error RFCIO_ERROR_SYSERROR in abrfcpic.c : 2612

CPIC-CALL: 'ThSAPOCMINIT' : cmRc=20 thRc=497

Unable to determine host address: NiHostToAddr failed

HOST =dcntsvr3

SERV =sapdp11

Let me know if am i have to add any parameters in any files

Regards

Giri

[JPReyes]

Unable to determine host address: NiHostToAddr failed

Well, can you reach the host "dcntsvr3", is it registered on the hosts file?

Regards, Juan

[Former Member]

Hi,

Can you  check via TCODE SMMS   > what is the value for the rdisp/mshost (MS server name)?

SAP Note 18679 suggests that error messages like "Unable to determine host address: NiHostToAddr failed..." are caused due to local names are too long.

Rgds,

Sachin

[Reagan]

Hello

Have you checked the TRFC logs as suggested in the error ?

Use Tx SM58 and check the logs.

Cheers

RB