BI System errors when executing any queries

[Former Member]

HI,

We are getting the following error message when executing any query from a BI System. Please advise. The SSO parameters

were configured connrectly as noted below in the default profile. Please read the below error message and advise

login/accept_sso2_ticket = 1

login/create_sso2_ticket = 2

Error message:

Issuer of SSO ticket is not authorized

com.sap.mw.jco.JCO$Exception: (103) RFC_ERROR_LOGON_FAILURE: Issuer of SSO ticket is not authorized

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:516)

at com.sap.mw.jco.MiddlewareJRfc$Client.connect(MiddlewareJRfc.java:1086)

at com.sap.mw.jco.JCO$Client.connect(JCO.java:3256)

at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.connectWithJCO(SAPCFConnectorManagedConnection.java:429)

at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.establishInitialConnection(SAPCFConnectorManagedConnection.java:204)

[Former Member]

Below is the status when i run "RSPOR_SETUP" report in SE38. Also, which JCO RFC's should I be checking?

Status for Step 1 - Create RFC Destination in J2EE Engine

Error in WAS configuration...

Status 1: Create RFC Destination In J2EE Engine Okay

Status 2: Create RFC Destination for Portal Gateway host is not identical ()

Status 3: Maintain Portal Server Settings for Portal URL Prefix (ABAP) must have domain (profile parameter icm/host_name_full)

Domain of URL Prefix (ABAP) and URL Prefix (Portal) must be identical

Status 4: Maintain Single Sign-On in BI Okay

Status 5: Export BI Certificate from BI BIQ_certificate.crt is not existing.

Status 6: Import BI Certificate into Portal Existence of BI certificate in Portal cannot be checked automatically.

Status 7: Create BI Sytem in Portal Existence of BI System in Portal cannot be checked automatically.

Status 8: Configure User Management in Portal Configuration of User Management in Portal cannot be checked automatically.

Status 9: Export Portal Certificate from Portal Okay

Status 10: Import Portal Certificate into BI Okay

Status 11: Set Up Repository Manager for BI in Portal Setup of Repository Manager for BI in Portal cannot be checked automatically.

Status 12: Maintain User Assignment in Portal System failure during call of function module RSWR_RFC_SERVICE_TEST

Status 13: Import SAP NetWeaver Plug-In into BI Okay

Entries for Step 1 - Create RFC Destination in J2EE Engine

SAP J2EE Visual Administrator

<SID> / Server<#> / Services / Jco RFC Provider / RFC Destination

Program ID: BI-QA-DB1_PORTAL_BIQ

Gateway host: BI-QA-APP1

SAP Router string might be required for Gateway host

Gateway service: sapgw00 (3300; sapgw... is defined in c:\windows\system32\drivers\etc\services or /etc/services)

Number of processes (1..20): 20

Application server host: BI-QA-APP1

SAP Router string might be required for Application server host

System number: 00

Client: 200

Language: EN

User: xxxxxxx

Password: ********

Checks for Step 1 - Create RFC Destination in J2EE Engine

1. Check existance of RFC Destination on J2EE-Engine

The existance of the RFC Destination on J2EE-Engine could not be checked directly.

It could be checked, if the RFC connection in step 2 could be established.

2. Validation check for SAP BI User and Password

No check with password <...>.

[Former Member]

Hi,

No one has responded back to my previous message. The problem still seems to exist. JCO RFC's is working fine but users are

still unable to execute any queires in BI system. The Same error message

Issuer of SSO ticket is not authorized

com.sap.mw.jco.JCO$Exception: (103) RFC_ERROR_LOGON_FAILURE: Issuer of SSO ticket is not authorized

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:516)

at com.sap.mw.jco.MiddlewareJRfc$Client.connect(MiddlewareJRfc.java:1086)

at com.sap.mw.jco.JCO$Client.connect(JCO.java:3256)

at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.connectWithJCO(SAPCFConnectorManagedConnection.java:429)

at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.establishInitialConnection(SAPCFConnectorManagedConnection.java:204)

[...]

[peter_dzurov]

I think you have wrongly configured SSO.

Check Note 888687 - BEx Web Java: Analysis of communication/logon problems

[sunny_pahuja2]

Hi,

> Issuer of SSO ticket is not authorized

> com.sap.mw.jco.JCO$Exception: (103) RFC_ERROR_LOGON_FAILURE: Issuer of SSO ticket is not authorized

> at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:516)

Have you checked whether JCO RFC's are working fine or not ?

Thanks

Sunny

[Diggeshhjoshi]

Hi Thareq,

Check out both of these:

Note 888687 - BEx Web Java: Analysis of communication/logon problems

Link: [/message/8185978#8185978 [original link is broken]]

- Digesh Joshi