Forum Stats

  • 3,852,013 Users
  • 2,264,055 Discussions
  • 7,904,945 Comments

Discussions

look like sqlcl apex export don't work well with apex22.1

zakiH
zakiH Member Posts: 10 Red Ribbon
edited Jun 9, 2022 7:10AM in SQLcl

i use to export all workspace applications with following sqlcl command

SQL>apex export -workspaceid 4290342503119881 -expACLAssignments 

but since apex22.1

SQL>apex export -workspaceid 4290342503119881 -expACLAssignments 

APEX: Unable to process request. Verify specified options:
ORA-00942: table or view does not exist

now i can only export one application

  • is it a bug or am i missing something ?
User_CJB2Y

Best Answers

  • user12097829
    user12097829 Member Posts: 15 Blue Ribbon

    Hi,

    got the following answer from Oracle support:

    Note that the issue has been identified as the product defect and a Bug 34337982 - ORA-00942 WHILE TRYING TO EXPORT THE APEX WORKSPACE has been filed for the same.

    The bug is currently under review and will keep you posted with the updates.

    The root cause is due to the reason that view is not shipped any more beginning from the Apex 22.1 as the Web Sheets are deprecated.

    Regards,

    Tobi

  • user12097829
    user12097829 Member Posts: 15 Blue Ribbon
    Answer ✓

    Hi,

    we got the following update from Oracle support:

    Bug update

    =============

    Potential fix to be released by SQLCL_22.3 ( Target)

    Regards,

    Tobi

    zakiH

Answers

  • user12097829
    user12097829 Member Posts: 15 Blue Ribbon

    Hi,

    I've the same problem with our APEX 22.1.

    Exporting single applications works without problems, but "apex export -workspaceid ????" results in ORA-00942.

    Regards,

    Tobi

  • user12097829
    user12097829 Member Posts: 15 Blue Ribbon

    Hi,

    got the following answer from Oracle support:

    Note that the issue has been identified as the product defect and a Bug 34337982 - ORA-00942 WHILE TRYING TO EXPORT THE APEX WORKSPACE has been filed for the same.

    The bug is currently under review and will keep you posted with the updates.

    The root cause is due to the reason that view is not shipped any more beginning from the Apex 22.1 as the Web Sheets are deprecated.

    Regards,

    Tobi

  • starsols
    starsols Member Posts: 3 Red Ribbon

    Hi , had this issue too and when running export using the java export tool it gave the sql stmt that failed and was able to identify the view APEX_WS_APPLICATIONS is missing in Apex 22.1. wasted a lot of time to get to this.


    This is a hack but works for me until ORacle give a permanent fix. You need access to an APEX_210200 or earlier schema that contains the missing table.

    connect as SYS and create a dummy table as follows

    and public synonym and grants

    create public synonym APEX_WS_APPLICATIONS for APEX_220100.APEX_WS_APPLICATIONS;

    grant select on APEX_220100.APEX_WS_APPLICATIONS to public;


    CREATE table APEX_220100.APEX_WS_APPLICATIONS

    AS select

      w.short_name        workspace,

      a.id            application_id,

      a.security_group_id     workspace_id,

      a.name           application_name,

      a.OWNER,

      a.DESCRIPTION,

      a.STATUS,

      a.LOGIN_URL,

      a.LOGOUT_URL,

      a.HOME_PAGE_ID,

      a.page_style,

      a.custom_css,

      a.show_reset_passwd_yn,

      a.allow_sql_yn,

      a.allow_public_access_yn,

      a.login_page_message,

      a.AUTH_ID,

      a.ACL_TYPE,

      a.DATE_FORMAT,

      a.language,

      a.territory,

      a.LOGO_TYPE,

      a.LOGO_TEXT,

      a.LOGO_TEXT_ATTRIBUTES,

      sys.dbms_lob.getlength(a.LOGO_IMAGE) logo_image_size,

      a.LOGO_IMAGE_FILENAME,

      a.LOGO_IMAGE_MIMETYPE,

      a.LOGO_IMAGE_CHARSET,

      a.LOGO_IMAGE_LAST_UPDATE,

      a.LOGO_IMAGE_ATTRIBUTES,

      a.LOGO_FILEPATH,

      a.LOGO_FILEPATH_ATTRIBUTES,

      a.email_from,

      a.created_on,

      a.created_by,

      a.updated_on,

      a.updated_by

    from APEX_210200.wwv_flow_ws_applications a,

       APEX_220100.wwv_flow_companies    w,

       APEX_220100.wwv_flow_company_schemas s,

       APEX_220100.wwv_flow_current_sgid  sgid

    where 1 =-1;   

  • user12097829
    user12097829 Member Posts: 15 Blue Ribbon
    Answer ✓

    Hi,

    we got the following update from Oracle support:

    Bug update

    =============

    Potential fix to be released by SQLCL_22.3 ( Target)

    Regards,

    Tobi

    zakiH