Bug 1263564 - Oracle11gR2: can't get metadata on specified dataset (missing right parenthesis)
Oracle11gR2: can't get metadata on specified dataset (missing right parenthesis)
Status: VERIFIED
Product: JBoss BPMS Platform 6
Classification: JBoss
Component: Business Central (Show other bugs)
6.2.0
Unspecified Unspecified
urgent Severity urgent
: ER4
: 6.2.0
Assigned To: David Gutierrez
Jan Hrcek
: TestBlocker
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2015-09-16 03:58 EDT by Jan Hrcek
Modified: 2015-10-22 01:06 EDT (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
Server.log (877.83 KB, text/plain)
2015-09-16 03:58 EDT, Jan Hrcek
no flags Details

  None (edit)
Description Jan Hrcek 2015-09-16 03:58:56 EDT
Created attachment 1073914 [details]
Server.log

Description of problem:
When business-central is deployed on Oracle11gR2, modal dialog appears after entering task list:
"DataSet with UUID [ jbpmHumanTasks ] error: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHumanTasksWithUser"
------------------------------
Checking server.log (see attachment for details) reveals the root cause:
01:54:14,868 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-11) SELECT * FROM (SELECT Q.*, ROWNUM RN FROM (SELECT * FROM (SELECT T.ACTIVATIONTIME, T.ACTUALOWNER, T.CREATEDBY, T.CREATEDON, T.DEPLOYMENTID, T.DESCRIPTION, T.DUEDATE, T.NAME, T.PARENTID, T.PRIORITY, T.PROCESSID, T.PROCESSINSTANCEID, T.PROCESSSESSIONID, T.STATUS, T.TASKID, T.WORKITEMID, OE.ID OEID FROM AUDITTASKIMPL T, PEOPLEASSIGNMENTS_BAS BAS, ORGANIZATIONALENTITY OE WHERE T.ID = BAS.TASK_ID AND BAS.ENTITY_ID = OE.ID) "dbSQL" FETCH FIRST 1 ROWS ONLY) Q) WHERE RN <= 1
...
caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
--------------------------------
These 2 dataset lookup errors repeat more than 1000 times in the attached server.log attached. Careful ! make sure to search for both strings "jbpmProcessInstances" and "jbpmHumanTasksWithUser" in the log. I truncated the server.log to only show first few instances of each error.



Version-Release number of selected component (if applicable):
kie-wb 6.3.x snapshot from 16th september

How reproducible:
Always

Steps to Reproduce:
1. Deploy business central with Oracle 11gR2 as a specified data set.
2. Enter task list and observe the modal with exception


Actual results:
Modal with exception displayed on entering task list, no data displayed in the task list

Expected results:
No errors shown
Comment 2 Jan Hrcek 2015-10-22 01:06:34 EDT
The issue is gone. Good job!
Verified with BPM Suite 6.2.0 ER4.

Note You need to log in before you can comment on or make changes to this bug.