Header | |
---|---|
SAP Link | 1478123 |
Version | 7 |
Release Status | Released for Customer |
Released on | 2010-12-17 09:06:04 |
Priority | Recommendations/additional info |
Category | FAQ |
Primary Component | BW-WHM-DST-SRC |
Secondary Components |
Summary |
---|
Symptom Other terms RSA1 , Source system, RSBASIDOC, BDLS, System copy, IDoc, RFC, SM59 Reason and PrerequisitesSolution 1. How to check if the source system connection is proper?
a) Determine the logical system name of the BW and the SAP source system SE16 T000 => Field LOGSYS of the client you are checking b) Check if the BW has a connection to SAP source system and vice versa Connection information is stored in table RSBASIDOC. This table has the assignment of source system to BW. Some of the important fields are: SLOGSYS: Source system (logical system name of source system) RLOGSYS: Receiver system (logical system name of BW system) BIDOCTYP: Basic type TSPREFIX: Transfer structure prefix for a source system There must be exactly one entry in table RSBASIDOC, which exists in fields SLOGSYS, RLOGSYS, BIDOCTYP, TSPREFIX and SRCTYPES which is identical in BW and in the source system. Manual changes in table RSBASIDOC are not allowed! c) Check the RFC destination in the SAP sourcesystem: On the SAP sourcesystem the RFC-Destination has the same name as the logical system name of the BW system. On SAP sourcesystem: SM59 -> Double click on the destination Check the target host: Compare the hostname to the server name of the BW system (SM51) Check the RFC Logon data: Menupath -> Test -> Authorization. In case the maintained user is a DIALOG user you can also perform a remote login. Check if the update user in the BW system has the authorization profile : 'S_BI-WHM_RFC' (Note 150315) On the BW system you can get the name of the SAP sourcesystem RFC-Destination by table RSLOGSYSDEST or function module RSAR_DESTINATION_GET. To check the authorization, select SM59-> Menupath -> Test -> Authorization . In case the maintained user is a DIALOG user you can also perform a remote login. Check if the user in the source system has the authorization profile 'S_BI-WX_RFC' (Note 150315) <LOGSYS > _DIALOG destination is necessary for F4 help in the infopackage or for source system calls from monitor.Maintained user has to be of type DIALOG (check in transaction su01) Check the Partner Type LS parameter setting of transaction WE20 in both systems and search the logical system name in Partner Type LS: BW system: search for the logical system name of the partner system RSRQST ' double click ' receiver port ' double click ' RFC destination ' make sure that this RFC points to the correct source system in sm59 RSINFO RSSEND Source system: search for the logical system name of the BW system RSINFO ' double click ' receiver port ' double click ' RFC destination ' make sure that this RFC points to the correct BW system in sm59 RSSEND ' double click ' receiver port ' double click ' RFC destination ' make sure that this RFC points to the correct BW system in sm59 RSRQST 2. What are the relevant authorizations for background user?
XX. system changeability during creation of sourcesystem connection - Client-independent customizing and repository changes - Changes in the customer namespace - Changes in the local namespace 3. How to correct the error related to IDOC mismatch between source and BW system. 'BI unknown in source system'. 'BI Idoc type<XXXXXX> is not the same as source system'. Note the BIDOCTYP field entry in table RSBASIDOC in BW and in the R3 system, both the system must have same Idoc type. If in the source system the connection is not known and if the BIDOCTYP of the BW is not used for another connection in the sourcesystrem or if the IDoctype is different due to a system copy try to restore the connection between BW and the relevant source system. You can do this by restoring the souresystem by: RSA1 -> Source system <xxxx> Select 'Restore' from context menu. When you were asked if you want to delete the source system during restore procedure, please select delete option; the source system will be rebuilt after the restore. 4. How to disconnect all obsolete links to BW? In the R3 system execute the function module RSAP_BIW_DISCONNECT to disconnect all obsolete BW links. Never execute this function module in a BW system! Go to Transaction SE37 - function module RSAP_BIW_DISCONNECT > Single Test. Parameter I_OLTP_LOGSYS =<SLOGSYS> of RSBASIDOC DO NOT enter a value in the 'RFC target sys' field. If you do, this causes the function module to run in the system specified there. Conditions for the function module: 1.RFC connection to RLOGSYS is ok; check transaction SM59 2. SLOGSYS = logical system name where you execute the function module Never execute this function module in a BW system! 5. User and password Check note 807895 especially for connection with different releases where a BASIS release higher 640 is involved. In that case it is suggested to use a password which is not longer than 8 characters and has no lower case letters. 6. Unicode settings for RFC connection Transaction SM59 -> <LOGSYS> -> go to 'MDMP & Unicode tab' > can only be changed or is relevant in a Unicode system. This setting is irrelevant on the Non-Unicode system. Needed for data distribution within a BW System. Myself connection is created the first time your call the AWB (RSA1). From a technical point of view, the mySelf connection is a just a standard source system connection pointing to itself. Therefore maintenance of target system, client and user is not necessary in transaction sm59. (note 538052). Known issue during transports for export datasources: If only client is maintained or if you maintain only user and password but no client. 7. RSA1 Logon issues When you try to logon to RSA1 you see the error 'Entry in inbound table already exist' The 'Myself' system is created the first time you call the AWB (RSA1). In case of inconsistency the system tries to create entries in the partner profile tables (EDP*) but if there are already entries concerning the partner profile, you will get error such as E0412. Before solving the issue concerning the partner profile, check if an entry exists in table RSBASIDOC for the myself connection.SLOGSYS and RLOGSYS = logical system name of BW Source system SRCTYPE = M In case of a running BW create an OSS message if there is no entry for the myself connection. The myself connection has to be created in debugging because of the usage of the right prefix. In case it is the first time you call RSA1 and no transferstructures exist, you can clean the partner profiles by creating manually an entry in transaction we20 for the logical system name of BW and delete afterwards again. In that case the system will delete existing entries from table EDP* for the myself connection. 8.Restore or creation issues a)Sometimes you get message like 'Source system does not exist'(Message no. RSAR175) Follow the procedure to analyze the issue Check in the source system table T000 or transaction scc4 for the logical system name. Check table RSBASIDOC if the connection is using the logical system name. In order to avoid such errors, please make sure to follow note consulting 886102 when doing system copy or renaming systems. b)Error in source system <LOGSYS > (RSAR502) The main problems, if you get the message 'RSAR502' or/and run time Error 'DYNPRO_SEND_IN_BACKGROUND' are system is not open for changes (see point XX ) or for the background not the correct authorization profile has to bee maintained. (see point XX) The runtime error means that the OLTP systems wanted to send a dynpro, but the output did not work because the user (usually called ALEREMOTE) is no dialog user. If you want to see the message, you can set the remote user temporarily to dialog user.then you can see which message is send by the OLTP system to the BW system. 9.Source system deletion and reconstruction If you delete a source system from context menu of RSA1 from the BW system, restore is not possible. Also all source system dependent objects will be deleted (infopackages, datasources, transferstructure, Those objects will also not be available if you create a new connection. Only possibility in order to avoid manually creation is to create a transport request 'SAVE for SYSTEM Copy' in another system and import that request into BW. Do not forget to maintain RSLOGSYSMAP in the correct way. If the source system does not know BW as there is no entry in RSBASIDOC because e.g. you executed function module RSAP_BIW_DISCONNECT in the source system, restoring via context menu in BW and RSA1 is possible. 10.IDoc issue You may get the error 'IDoc type Zxxxxx could not be found / Basic type Zxxxxxx does not exist' Follow the steps given below
11. System Copy Follow the consulting note given below before doing any system copy or refresh. 886102 System Landscape Copy for SAP NetWeaver BW 1406273 Consulting: BDLS in BW a) System copy term definition Term definition
The operating system and database system are the same for both source and target systems
The operating system or database systemof the target system is different from the source system (also called OS/DB migration) b) System copy scenario terminology Scenario terminology according to consulting note 886102
c) System copy scenario BW landscape scenarios according to note 886102 Scenario A: Both system BW and source system are copied at the same time Scenario B:Only BW is copied Scenario C:Only source system is copied
2. Correction of the RFC connections in both systems 3. BDLS for own system and also in the copied connected system 4. Re-activation of the partner profiles in WE20, WE21
Transport request for system copy (optional, can be created e.g. on productive system or when deleting the sourcesystem after the system copy) Delete all SAP sourcesystems and BW connections in the target BW 2. Reduce number of BTC to 0 in RZ10 3. check RSLOGSYSDEST and change the RFC connection to a non existing host in sm59 5. Run BDLS before RSA1 initially started 6. Create R/3 connections again, adjust RSLOGSYSMAP
2. Reduce number of BTC to 0 in RZ10 3. Delete obsolete RSBASIDOC-entries via RSAP_BIW_DISCONNECT 5. Restore connections in test BW d) BDLS BDLS convert tables that have domains LOGSYS and EDI_PARNUM in a system. Execute BDLS first in test run. After this run you get a list of all tables and how manye ntries are to be converted per table.
a)No records for either the old or the new name -> table skipped b)Records with the old name exist -> conversion goes through c)Records with the new name exist -> table skipped with warning no manual intervention needed, but doublecheck is recommended.In this case the conversion log shows '<<' at the affected tables d)Records with the old and the new name coexist -> records are skipped with warning or error (depending on the flag for existence check, which is always set except in test conversions) you have to analyze the records which hold the old logical name and have their identical counterparts holding the new name. In this case the conversion log shows '<<<<' at the affected tables. BDLS log can be analysed in the application log (transaction SLG1). Select the following parameter:
Information messages in the status line like 'the new logical system name XXX is assigned to the current client YYY' or 'The logical system name XXX already exists' means that the logical system name has already been changed (transaction scc4) . Press 'enter' when this message appears and BDLS should continue with the conversion.
Another Process is Running for Conversion <LOGSYS > -> <LOGSYS > (Message no. B1668 Check if BDLS is still running. If no conversion is running, delete the old conversion protocol by transaction BDLSS or report RBDLSMAP_RESET. Renaming of a productive system is not officially supported! |
Related Notes | |
---|---|
1319517 | Unicode Collection Note |
1087980 | ECC Source systems appearing in BI folder |
886102 | System Landscape Copy for SAP NetWeaver BW |
184971 | Notes on BW source system connections |
161570 | User ALEREMOTE in the BW: Dialog user or system user? |
150315 | BW-Authorizations for Remote-User in BW and OLTP |
140276 | Error in source system assignment |