I have a local install of WAS on my laptop using MSSQL 2000. I am trying to integrate local portal into a BI system.
1. I completed SLD configuration of local J2EE
2. As part of local SLD config I specified a BW7 system as data supplier
- entered BW7 host & gateway
- kept default settings for "configure data supplier targets" (i.e: sld/active=TRUE)
3. In Visual composer I successfully triggered SLD data transfer
4. In Visual Composer I specified a JCo RFC Provider to the BW7 system I want to access.
5. If I go to BW7 and goto tcode SMGW -> GOTO -> Logged on client, I see 2 pair of entries for JCo RFC provider
with the following settings
- system type: Registered Server (REGISTER_TP)
- state: connected
- LU name & Host Name = J2EE Host name w/ last 4 characters truncated. Only first 8 characters appear.
- TP Name: 2 entries = SLD_UC & 2 entries = SLD_NUC. So a total of 4 connections. My understanding is that TP Name is supposed to = Registered Server Program
6. In BW7, I have an RFC w/ Registered Server Program setting and program ID = JCo RFC Provider program ID
7. In BW7 RFC & JCo RFC the host & gateway settings are the same, they both refer to the BW7. THIS IS THE PART WHERE I AM UNSURE. I would have thought that the host & gateway settings of BW7 RFC would refer to Local J2EE engine. AND I DON'T KNOW WHAT THE GATEWAY IS FOR LOCAL J2EE.
8. In BW7 when I try to test the RFC, I get errors:
- Logon Connection Error
- program <...> not registered / CPIC-CALL: 'ThSAPOCMINIT' Tran
- ERROR: program <...> not registered
- DETAIL: TP <...> not registered
- COMPONENT: SAP-Gateway
- MODULE: gwr3cpic.c
- RETURN CODE: 679
- SUBRC: 0
- RELEASE: 700
- VERSION: 2
9. I completed step 1 & 2 of RSPOR_SETUP
- Step 1 <Create RFC Destination in J2EE engine> messages:
No Authorization to SMGW
Profile parameter login/create_sso2_ticket is not set to 2
Check of RFC destination <...> with RFC_READ_TCPIP_DESTINATION successful
- Step 2 <Create RFC destination to Portal> messages:
No Connection
Option Send SSO tickets not active (see documentation)
RFC CALL RFC_PING, destination <...> failed with sy-subrc =2
There a little something missing. Hope u gurus can help, lost a weekend over this.