Unable to connect to SAP BW server Incomplete logon data.. (WIS 10901)

[Former Member]

Hello,

As you all know, this is very familiar error and I have went thru all the forums in the SDN and SAP OSS notes but still unable to fix the issue and hoping you experts can help me in fixing this.

Environment - Win 2008 R2, BOBJ Xi 3.1 FP 3.6, oracle 11

We have configured WinAD and working for InfoView however when we refresh the WEBI Report we are getting the error as below.

In CMC-->Authentication --> SAP --> enabled SNC, provided the service name and also in Windows AD -- provided the right SPN in Authentication option.

We are using SPN name called SERVICEBO in CMC Authentication and user with same name has been created in SAP and added SNC and assigned roles. Role Import able to import the roles in SAP Authentication.

when we refresh the WEBI Report we are getting the error as below.

com.businessobjects.rebean.wi.ServerException: A database error occured. The database error text is: Unable to connect to SAP BW server Incomplete logon data.. (WIS 10901)

at com.businessobjects.rebean.wi.REFactory.createSimpleServerException(Unknown Source)

at com.businessobjects.wp.om.OMFactory.createServerException(Unknown Source)

at com.businessobjects.rebean.wi.occa.OccaDocumentComAdapter.handleDocLoadError(Unknown Source)

at com.businessobjects.rebean.wi.occa.OccaDocumentComAdapter.documentLoadingError(Unknown Source)

at com.businessobjects.wp.xml.XMLLovLoader.load(Unknown Source)

at com.businessobjects.rebean.wi.occa.OccaDocumentComAdapter.getListOfValues(Unknown Source)

at com.businessobjects.rebean.wi.LovImpl.getBatchNames(Unknown Source)

at com.businessobjects.adv_ivcdzview.Prompts.getBatchLOV(Unknown Source)

at org.apache.jsp.viewers.cdz_005fadv.processRefreshLOV_jsp._jspService(processRefreshLOV_jsp.java:355)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.businessobjects.webutil.websessiontimeout.WebSessionTimeoutFilter.doFilter(WebSessionTimeoutFilter.java:161)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.businessobjects.adv_ivcdzview.SetCharacterEncodingFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

Please suggest what can be done.

[IngoH · Accepted solution]

Hi,

you mentioned that you have configured SNC but I would like to clarify a couple of items on the SNC configuration here:

- when you talk about the SNC configuration are you referring to a client side SNC authentication or a server side SNC authentication ?

- which parts have been configured on the BW Server ?

- which parts have been configured on the SAP BUsinessObjects server ?

- has the SAP Authentication for the BW system been configured and roles / users have been imported on the SAP BusinessObjects server ?

regards

Ingo Hilgefort

[Former Member · Accepted solution]

Hi Ingo,

Thanks for replying.

when you talk about the SNC configuration are you referring to a client side SNC authentication or a server side SNC authentication ?

Client Side SNC authentication

- which parts have been configured on the BW Server ?

created service USER in BWP and assigned the SNC SERVICENAME in SNC tab in SU01 and also assigned the roles

- which parts have been configured on the SAP BUsinessObjects server ?

in Authentication Tab --> SAP --> user id with SNC name and enable SNC in SNC tab with gsskrb5.dll path followed by SCN servicename

- has the SAP Authentication for the BW system been configured and roles / users have been imported on the SAP BusinessObjects server ?

Yes,

Now, after setting the SNC servicename in Entitlement system, when I goto ROLE Import am getting error "Incomplete Logon Data".

Please throw some light...

Thanks in Advance,

Yoga

[Former Member · Accepted solution]

Is your SIA's running under SERVICE user name ?

[Former Member · Accepted solution]

I changed SIA and tomcat username to service user. Now i dont see error "Incomplete logon data" in entitlement system but reports still throwing same error.

[Former Member · Accepted solution]

Looks like your service principal name is not able to contact backend BW system. Please check SNC0 t-code in BW.

[IngoH · Accepted solution]

Hi,

when you talk about the SNC configuration are you referring to a client side SNC authentication or a server side SNC authentication ?

Client Side SNC authentication

>> just to make sure, so we are talking about a THICK CLIENT (Windows) authentication with SNC Software installed on the client and you want to use the authentication in a browser ?

Now, after setting the SNC servicename in Entitlement system, when I goto ROLE Import am getting error "Incomplete Logon Data".

>>> So this is the CMC and this would not be CLIENT SIDE SNC. this would be server side SNC.

Could you outline the workflow that you trying to achieve that involves the SNC authentication ?

thanks

Ingo

[Former Member · Accepted solution]

Updated SNC0 still same issue.

@Ingo, we are using client side authentication KERBEROS SNC.

[Former Member · Accepted solution]

Did you update SNC0 t-code with BOBJ hostname and respective SPN ?

Check this note

1446067 - How to configure Server Side SNC for Business Objects XI 3.1 using Kerberos / Windows AD

[Former Member · Accepted solution]

Thank You very much for the note, BOBJ hostname  and SPN in SNC0 t-code fixed the issue and Thank You for the note.