Jco connection creation for plan modeler on BI 7.0

[former_member201054]

If I open plan modeler RSPLAN on BI 7.0 I am getting u201CJco connection not availableu201D message so I tried to create the connection from webdynpro content administrator.from there I could see all the connections in red colour

BI_MODELDATA

BI_METADATA

WD_ALV_MODELDATA_DEST

WD_ALV_METADATA_DEST

So I have chosen u201Ccreate u201Coption of the above connections to establish Jc0 .please let me know what parameters to be given for each settings.

For example we take BI_METADATA ,

General data:

Name : BI_METADATA

Client u2013 xxx ( should we have to give BI client no here ,by default it shows 000)

J2ee cluster :

Default :hostname ( no doubt)

Connection type:

Dictionary melta data( chosen by default u2013 no doubt)

Application data:

Message server :SID hostname (no doubt)

System name

Logon group:

User authentication 😕

Username : **** ( should I have to give the user name of BI client)

Password

Confirm password :

Please carify the above doubts and help me out to resolve the issue Plan modeler

Once I set the connection of each should I have to restart JAVA engine,

I would appreciate all your help and suggestion

[Former Member · Accepted solution]

Hi,

Yap give your backend system client and also in the user field give the usr who has sap_all and sap_new authorizations.

The client should be the client which you have added as the backend system.

Regards,

Vamshi.

[former_member201054 · Accepted solution]

how can we know which is our BACKEND system(client).If its not there how to configure it.In BI only one client is possible .shall I assign it ?

Thanks in advance

[former_member201054 · Accepted solution]

I checked the SLD connection.Its working fine.If I try to create jco destination to the existing BI_METADATA ,still it goes to red colour eventhogh I give the new parameters.

How to make this jco destination to green color and test the connection.

Thanks in advance

[Former Member · Accepted solution]

Hi,

While creating the metadata connection you got to select "dictionary metadata option" in the connection type, then in user methid filed you have to give the uid and pwd this id should be exsisting in the backend system with sap_all authorization.And when you create a jco connection for application data you have to select the user method as ticket(after configuring SSO).

Regards,

Vamshi.

[Former Member · Accepted solution]

try to do BI portal intergration using note 917950 these jco will be automaticall get created

if you want to maintain maually giv BI7 details since your RSPLAN should work

Samrat

[former_member682089]

Hello Daniel,

Please go to Visual Admin(VA),

Server -> Services -> SLD data supplier.

Choose CIM setting Tab and select the following Application and close VA.

1.sap.com/tc_lmwebadmin_mainframewd/webdynpro/public/lib/

sap.com_tclm_webadminmainframe~wd.jar

2.sap.com/tc_lmwebadmin_sldwd/webdynpro/public/lib/

sap.com_tclm_webadminsld~wd.jar

then try again.

Regards,

Sandeep Nayak

[former_member201054]

I created the jc0 destinations successfully and activated the service mysonctl in SICF .

If I do login its gives the message RFC_ERROR_PROGRAM (password missing ).

Shall I go to ahead to enable the mentioned functions in Visual admin SLD data supplier.

I would appreciate all your help and suggestion