Need help with SAP BI configure

[sjfigatner]

I want to use the boncode connector but find there are issues with the launchpad (BI) portion of SAP BusinessObjects Enterprise. I am hoping someone out there has already found a solution to this...

[Bilal-S]

@sjfigatner
I know that there are a few BusinessObjects users out there but I do not track this actively.
Can you help me understand what problem you are seeing specifically?

[sjfigatner]

when clicking on a link, nothing is happening. If I go to 8080 no issues. I don't think the issue is trapped in the code. Hence my call for assistance. SAP refuses to support tomcat using SSL even though they supply it.

[sjfigatner]

The more I look into this, I believe the issue is an internal setting in the SAP BI.

[Bilal-S]

I know BO is a very quirky setup.
You need to setup a wildcard mapping for the SAP path.

The only thing I remember is that BusinessObject path mappings were non-standard and it needed a mapping prefix in IIS. This is needed since IIS and Tomcat work with different path references in this case.

The easiest way to double check this type of stuff is to turn off HTTP headers altogether and see the raw Tomcat output.

If you see no activity you have something not-configured correctly. You may bee to configure AJP secret if your Tomcat is a newer version. This can result in white screen that look like no activity.

A few basic questions to understand what you are facing:

How did you set this up.
Use the Boncode installer? Did you choose a global install or site specific one?
Are all services on the same server?
What version of tomcat?

Similarly, did you modify any files yourself? E.g. Tomcat's server.xml and BonCodeAJP13.setting file?

What does your AJP line look like in tomcat's server.xml?
What is the BonCode setting file look like?

Best,
Bilal

[sjfigatner]

Tomcat 9
and yes the BOE is across two (2) servers
and I do have the wildcard set for boncode and the install was global

localhost 8009 True True False True 50000 HTTP_X_FORWARDED_FOR

[sjfigatner]

<Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" relaxedQueryChars="[,]" redirectPort="8443" compression="on" URIEncoding="UTF-8" compressionMinSize="2048" noCompressionUserAgents="gozilla, traviata" compressableMimeType="text/html,text/xml,text/plain,text/css,text/javascript,text/json,application/javascript,application/json"/> <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" maxThreads="1000" keepAliveTimeout="-1" connectionTimeout="121000" packetSize="65536" URIEncoding="UTF-8" enableLookups="false"/> <Settings> <Server>localhost</Server> <Port>8009</Port> <EnableRemoteAdmin>True</EnableRemoteAdmin> <EnableHeaderDataSupport>True</EnableHeaderDataSupport> <ForceSecureSession>False</ForceSecureSession> <AllowEmptyHeaders>True</AllowEmptyHeaders> <FlushThresholdTicks>50000</FlushThresholdTicks> <ResolveRemoteAddrFrom>HTTP_X_FORWARDED_FOR</ResolveRemoteAddrFrom> </Settings>

[sjfigatner]

I am getting a 403 on:
POST http://qw3boeweb1vp/BOE/portal/2003041129/InfoViewAppActions/ajaxUre/ajaxRequest HTTP/1.1
Host: qw3boeweb1vp
Connection: keep-alive
Content-Length: 389
X-Requested-With: XMLHttpRequest
CSRF_TOKEN_COOKIE: MDAwRDhhYWtXOFBkMUVQM1Y4TTMSHa1MxYGdHWUw1NTAAN
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
Accept: /
Origin: http://qw3boeweb1vp
Referer: http://qw3boeweb1vp/BOE/portal/2003041129/InfoViewAppActions/jsp/InfoView_Listing/infoviewListing.faces?cafWebSesInit=true&bttoken=MDAwRD5pSllBX0JSQjNeWWBBQzVbbTlmOTJMVV1VPzAEQ&bttoken=MDAwRD5pSllBX0JSQjNeWWBBQzVbbTlmOTJMVV1VPzAEQ&appKind=InfoView&service=%2FInfoView%2Fcommon%2FappService.do&loc=en&pvl=en_US&ctx=standalone&actId=4727&objIds=12&containerId=&pref=maxOpageU%3D35%3BmaxOpageUt%3D200%3BmaxOpageC%3D10%3Btz%3DAmerica%2FNew_York%3BmUnit%3Dinch%3BshowFilters%3Dtrue%3BsmtpFrom%3Dtrue%3BpromptForUnsavedData%3Dtrue%3B
Accept-Encoding: gzip, deflate
Accept-Language: en-US,en;q=0.9
Cookie: JSESSIONID=AE455D1E0A1053C9AD6998D89ED60F71; CMCPLATFORMSVC_COOKIE_CMS=QW3BOEWEB1VP%3A6400; CMCCE_SAPSys=; CMCCE_SAPCnt=; CMCPLATFORMSVC_COOKIE_USR=z000%3DEK%5DZEPCMGBKD4%5EKRS%4000%40%23%2444; CMCPLATFORMSVC_COOKIE_AUTH=secEnterprise; developer_samples_app_lastaps=qw3boeweb1vp; developer_samples_app_lastaut=secEnterprise; InfoViewPLATFORMSVC_COOKIE_CMS=QW3BOEWEB1VP%3A6400; InfoViewCE_SAPSys=; InfoViewCE_SAPCnt=; InfoViewPLATFORMSVC_COOKIE_USR=z000%3DEK%5DZEPCMGBKD4%5EKRS%4000%40%23%2444; InfoViewPLATFORMSVC_COOKIE_AUTH=secEnterprise; developer_samples_app_lastusr=Administrator; OpenDocumentPLATFORMSVC_COOKIE_CMS=QW3BOEWEB1VP%3A6400; OpenDocumentCE_SAPSys=; OpenDocumentCE_SAPCnt=; OpenDocumentPLATFORMSVC_COOKIE_USR=z000ABF%5DeI%5EBK%3DHJBjXKXQAUKbW%3E0%40%23%2444; OpenDocumentPLATFORMSVC_COOKIE_AUTH=secEnterprise; InfoViewPLATFORMSVC_COOKIE_TOKEN=QW3BOEWEB1VP.columbus.local%3A6400%40289149Jf7G7GRz9VoATVx8b7cVYeRbrPIAMGMx5289147JyFWo4c0pqrPio5wcTgZ1RMS0bbr86mkj; IS_BING_APP=false

ureId=/BOE/portal/2003041129/InfoViewAppActions/jsp/InfoView_Listing/infoviewListing.faces_ListingURE_InfoViewListing3&bttoken=MDAwRD5pSllBX0JSQjNeWWBBQzVbbTlmOTJMVV1VPzAEQ&action=navigationViewNavigate&id=179637_23&navigationViewId=accordionNavigationView_drawer1&nodeSelection=&com.businessobjects.client.concurrent.sessionCounter=2&com.businessobjects.client.concurrent.requestCounter=0

[sjfigatner]

It appears to be a permission issue .
"You do not have permission to view this directory or page using the credentials that you supplied."
do you think this is a tomcat issue?
any idea how to correct it?

[Bilal-S]

403 are probably because you did not configure a security key.
Tomcat changed its security requirements to turn on a shared secret by default. This would also explain your white screen.

You can either turn this of on Tomcat AJP line: `requiredSecret="false" or supply a secret:

Search 403 error in documentation or search docs for RequestSecret:
http://www.boncode.net/connector/webdocs/Tomcat_Connector.htm

Also I would normally recommend you use:

• FlushThresholdBytes instead of FlushThresholdTicks this seems to cause less issues.
• EnableHeaderDataSupport should not be needed unless you use mod_cfml_valve on Tomcat

[Bilal-S]

No activity.
Will reopen if we have more info.
Closing for now.