Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1108627

Summary: Dashbuilder not able to connect to Oracle on WAS
Product: [Retired] JBoss BPMS Platform 6 Reporter: David Gutierrez <dgutierr>
Component: BAMAssignee: David Gutierrez <dgutierr>
Status: CLOSED CURRENTRELEASE QA Contact: Radovan Synek <rsynek>
Severity: high Docs Contact:
Priority: high    
Version: 6.0.2CC: kverlaen, rrajasek, rsynek
Target Milestone: CR1   
Target Release: 6.0.2   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 19:49:55 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
WAS log none

Description David Gutierrez 2014-06-12 10:43:09 UTC
Created attachment 908066 [details]
WAS log

Description of problem:

Dashbuilder is not able to connect to Oracle. So if you try to login an error is displayed on the browser. An exception is printed on the server log as well. See the attached log.

"Error 500: com.ibm.websphere.servlet.session.UnauthorizedSessionRequestException: SESN0008E: A user authenticated as anonymous has attempted to access a session owned by user:defaultWIMFileBasedRealm/uid=testadmin,o=defaultWIMFileBasedRealm."

Version-Release number of selected component (if applicable):

BPMS 6.0.2 ER3 on WAS 8.5 over Oracle 11g.

How reproducible:

Just deploy the WARs and start the app and try to login.

Comment 2 David Gutierrez 2014-06-12 14:58:00 UTC
This is a known issue on WAS: http://www-01.ibm.com/support/docview.wss?uid=swg21409335

Github commit (master): https://github.com/droolsjbpm/dashboard-builder/commit/e55cbc4c46047de038d139554da177bf3729b80c

Github commit (6.0.x): https://github.com/droolsjbpm/dashboard-builder/commit/660b96373cdf7ccd0d573ba57b852bd9ef832b5e

Github commit (6.1.x): https://github.com/droolsjbpm/dashboard-builder/commit/f6d91b54d72ea4db553943126d98ef17918a9844


The fix basically adds the required code to deal with the com.ibm.ws.rsadapter.jdbc.WSJdbcConnection wrapper class that WAS creates to handle the native Oracle connection.

As a side effect, the fix causes the following message to be printed in the WAS log multiple times: "00000099 WSCallHelper  I   Calling getNativeConnection"

To disable it: Servers>Server types>WAS app servers>server1>Change log details levels - set warn for this class com.ibm.websphere.rsadapter.WSCallHelper

Comment 3 Radovan Synek 2014-06-20 11:44:55 UTC
Verified with BPMS-6.0.2.CR2