Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: jBPM 6.5.0.Final
    • Fix Version/s: None
    • Component/s: Dashboard Builder
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      use non-schema owner database account for datasource to start jbpm-console,
      click Task from the menu

      Show
      use non-schema owner database account for datasource to start jbpm-console, click Task from the menu
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      CREATE OR REPLACE TRIGGER jbpm_rw.current_schema_jbpm
      AFTER logon ON jbpm_rw.SCHEMA
      BEGIN
      execute immediate 'ALTER SESSION SET CURRENT_SCHEMA = JBPM';
      END;

      OR

      create or replace synonym PROCESSINSTANCELOG for JBPM.PROCESSINSTANCELOG;
      create or replace synonym AUDITTASKIMPL for JBPM.AUDITTASKIMPL;
      create or replace synonym PEOPLEASSIGNMENTS_POTOWNERS for JBPM.PEOPLEASSIGNMENTS_POTOWNERS;
      create or replace synonym ORGANIZATIONALENTITY for JBPM.ORGANIZATIONALENTITY;
      create or replace synonym PEOPLEASSIGNMENTS_BAS for JBPM.PEOPLEASSIGNMENTS_BAS;

      Show
      CREATE OR REPLACE TRIGGER jbpm_rw.current_schema_jbpm AFTER logon ON jbpm_rw.SCHEMA BEGIN execute immediate 'ALTER SESSION SET CURRENT_SCHEMA = JBPM'; END; OR create or replace synonym PROCESSINSTANCELOG for JBPM.PROCESSINSTANCELOG; create or replace synonym AUDITTASKIMPL for JBPM.AUDITTASKIMPL; create or replace synonym PEOPLEASSIGNMENTS_POTOWNERS for JBPM.PEOPLEASSIGNMENTS_POTOWNERS; create or replace synonym ORGANIZATIONALENTITY for JBPM.ORGANIZATIONALENTITY; create or replace synonym PEOPLEASSIGNMENTS_BAS for JBPM.PEOPLEASSIGNMENTS_BAS;
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      when use schema owner account there have no issue, but when use other account, dashbuilder dataset api ignore default schema attribute in persistence.xml, and report table not found when:

      • List task
      • List proceinstance
      • List jobs
      • Process and task dashboard

        Gliffy Diagrams

          Attachments

          1. Dashboards-ProcessTaskDashboard.txt
            296 kB
          2. Deploy-Jobs.txt
            18 kB
          3. ProcessManagement-ProcessInstance.txt
            19 kB
          4. Tasks.txt
            21 kB

            Activity

              People

              • Assignee:
                davidredhat David Gutierrez
                Reporter:
                paul.yiu Paul Yiu
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: