Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-6226

dashbuilder dataset api ignore default schema

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • jBPM 6.5.0.Final
    • Dashboard Builder
    • NEW
    • NEW
    • Workaround Exists
    • 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;
    • 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

      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

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

              david.magallanes David Gutierrez
              paul.yiu_jira Paul Yiu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: