cancel
Showing results for 
Search instead for 
Did you mean: 

RSA1 error during insert in port table

Former Member
0 Kudos

Hi All,

I have installed new BW 7.31 server on (Windows/Oracle 11g) and while creating source system in RSA1 we got the below error.

I am trying to create a source system with ECC6.

" Error during insert in port table"

Please help to resolve.

Thanks,

R

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi R,

You need to synchronize both (OLTP and OLAP) port in ediport.

se16 -> tablename "EDIPORT" ->execute (check the last number. In OLTP it was A000000002 and in OLAP A000000008. I must take the highest. For me the next will be 9)

then

txcode SNUM -> object: ediport -> change -> number of Range -> Status

here you will put the next number on both systems. for example in my case the last was 8 (A000000008 = current number 😎 and I put 9 in CURRENT NUMBER.

Hope it helps.

Cheers

Nuno

Former Member
0 Kudos

Hi all,

I tried the note Note 110849 - "Error during insert in port table" (create source system) which is not helping me.

RFC's are working fine from both the ends.

WE20 and WE21 there are no entries created for ecc6 and bw system, I tried manually creating the entries also , that is also not working.

Please suggest.

Thanks

Former Member
0 Kudos

Hi,

   PLease try to open the client in both ECC as well as BW system.

Delete all the RFC's  in both the systems.

Check what is the entry in the RSADMINA table in BW system.

I faced this issue and I opened the clients in both the system and created the source system.

You can also try this way.

Please check and provide your feedback..

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi Maria,

below is the entries in my RSADMINA table

CUSTOMIZID      BW

BW USER         ALEREMOTE

DEBUG USER

BEX REQUEST

DBSYSDEPGLOBL

DBSYSDEPREAD

HIERREL

MONFILLED

IDOCLASTNBR     23
ISLASTNBR       0
TSLASTNBR       0
MONARCHNBR      0

XPRADONE

BWMANDT         100
ODSMAXTASKS     0
ODSMINPAKSIZE   0
ODSACTTIMEOUT   0

ENQ PROT ON

ODSSERVGROUP

BWMANDTRFC

TPBWMANDTRFC    RSTPRFC_CLIENT_100

I have given all the client entries as modifiable in scc4 and se06

plz help to resolve this.

Former Member
0 Kudos

Hi,

Please confirm whether you have opened the client in ECC as well.

As well as please make sure that the users ALEREMOTE as well as BWUSER has sap_all and sap_new profile .

Thanks and Regards,

Vimal

Former Member
0 Kudos

Dear R.A

Can you change the user type of ALEREMOTE to Dialog and check what is the error message appearing.

former_member185239
Active Contributor
0 Kudos

Hi R A,

1. You need to create Logical system for BW on ECC.

2. You need to create the logical system for ECC on BW.

3. Open the client on BW (change it to modifiable state).

4. Now run the transaction RSA1 and perform the activity.

To check the EDIPORT table , you can run the transaction OYSM.

Click on Number Range and then Interval.

Check the entry out there.

Kindly paste the error.

Also follow the sapnote suggested by Shahnas s and vimal.

With regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi,

In addition to above suggestion, you can also look into the below note.

Note 325525 - Copying and renaming systems in a BW environment

Please check the link as well http://scn.sap.com/thread/17521

Thanks and Regards,

Vimal

Former Member
0 Kudos

Make sure the source system is in modifiable state,,,

Also set logical system for the system in BI

Also

Note 110849 - "Error during insert in port table" (create source system)