4 Replies Latest reply on Aug 26, 2021 4:47 AM by Rajan Rath

    Erro ORA-00933 - Administrator

    Rafael Ferreira New Member

      Hello, good afternoon.

       

      We have found an error that logs in the Informatica Administrator log after logging into the PowerCenter Designer and opening an existing Project folder, at which time PowerCenter loads created/inserted objects for that Project.

       

      The step-by-step* for error reproduction is as follows:

       

      - Open Informatica PowerCenter Designer;

      - Log in;

      - Open (two clicks or 'right click' and Connect) a Project folder.

       

      * Screens attached.

       

      After performing this procedure, the following error is displayed in the Informatica Administrator log:

       

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

      serviceType: RS

      service: PC_REP

      severity: ERROR

      timestamp: 08/10/2021 16:23:25.562 PM

      clientNode: node01_etl

      threadName: 22466061584128

      pid: 2650

      messageCode: OBJM_54542

      message:

      ORA-00933: SQL command not properly ended

      Database driver error...

      Function Name : Execute

      SQL Stmt : SELECT OPB_WIDGET_INST.INSTANCE_NAME, OPB_WIDGET_INST.WIDGET_ID, OPB_WIDGET_INST.WIDGET_TYPE, OPB_WIDGET_INST.INSTANCE_ID, OPB_WIDGET_INST.COMMENTS, OPB_WIDGET.LAST_SAVED, OPB_WIDGET.IS_REUSABLE, OPB_WIDGET_INST.MAPPING_ID, OPB_WIDGET_INST.VERSION_NUMBER, OPB_WIDGET_INST.REF_VERSION_NUMBER, OPB_WIDGET.VERSION_NUMBER, OPB_WIDGET.IS_VISIBLE, OPB_WIDGET.TEMPLATE_ID, OPB_WIDGET.VERSION_STATUS, OPB_MAPPING.VERSION_STATUS,OPB_WIDGET.SUBJECT_ID, OPB_MAPPING.SUBJECT_ID FROM OPB_WIDGET_INST, OPB_WIDGET, OPB_MAPPING WHERE OPB_WIDGET_INST.MAPPING_ID = OPB_MAPPING.MAPPING_ID AND OPB_MAPPING.SUBJECT_ID = ? AND OPB_MAPPING.SUBJECT_ID = OPB_WIDGET.SUBJECT_IDAND OPB_MAPPING.REF_WIDGET_ID = 0 AND OPB_WIDGET.WIDGET_ID = OPB_WIDGET_INST.WIDGET_ID AND OPB_WIDGET.WIDGET_TYPE = OPB_WIDGET_INST.WIDGET_TYPE AND OPB_WIDGET_INST.VERSION_NUMBER = OPB_MAPPING.VERSION_NUMBER AND (OPB_MAPPING.IS_VISIBLE = 1 OR (OPB_MAPPING.IS_VISIBLE = 2 AND OPB_MAPPING.CHECKOUT_USER_ID = ?)) AND (OPB_WIDGET.IS_VISIBLE = 1 OR (OPB_WIDGET.IS_VISIBLE = 2 AND OPB_WIDGET.CHECKOUT_USER_ID = ?)) ORDER BY OPB_WIDGET_INST.MAPPING_ID, OPB_WIDGET_INST.VERSION_NUMBER DESC, OPB_WIDGET_INST.INSTANCE_ID, OPB_WIDGET_INST.WIDGET_ID, OPB_WIDGET.IS_VISIBLE DESC

      Oracle Fatal Error

      Database driver error...

      Function Name : Execute

      SQL Stmt : SELECT OPB_WIDGET_INST.INSTANCE_NAME, OPB_WIDGET_INST.WIDGET_ID, OPB_WIDGET_INST.WIDGET_TYPE, OPB_WIDGET_INST.INSTANCE_ID, OPB_WIDGET_INST.COMMENTS, OPB_WIDGET.LAST_SAVED, OPB_WIDGET.IS_REUSABLE, OPB_WIDGET_INST.MAPPING_ID, OPB_WIDGET_INST.VERSION_NUMBER, OPB_WIDGET_INST.REF_VERSION_NUMBER, OPB_WIDGET.VERSION_NUMBER, OPB_WIDGET.IS_VISIBLE, OPB_WIDGET.TEMPLATE_ID, OPB_WIDGET.VERSION_STATUS, OPB_MAPPING.VERSION_STATUS,OPB_WIDGET.SUBJECT_ID, OPB_MAPPING.SUBJECT_ID FROM OPB_WIDGET_INST, OPB_WIDGET, OPB_MAPPING WHERE OPB_WIDGET_INST.MAPPING_ID = OPB_MAPPING.MAPPING_ID AND OPB_MAPPING.SUBJECT_ID = ? AND OPB_MAPPING.SUBJECT_ID = OPB_WIDGET.SUBJECT_IDAND OPB_MAPPING.REF_WIDGET_ID = 0 AND OPB_WIDGET.WIDGET_ID = OPB_WIDGET_INST.WIDGET_ID AND OPB_WIDGET.WIDGET_TYPE = OPB_WIDGET_INST.WIDGET_TYPE AND OPB_WIDGET_INST.VERSION_NUMBER = OPB_MAPPING.VERSION_NUMBER AND (OPB_MAPPING.IS_VISIBLE = 1 OR (OPB_MAPPING.IS_VISIBLE = 2 AND OPB_MAPPING.CHECKOUT_USER_ID = ?)) AND (OPB_WIDGET.IS_VISIBLE = 1 OR (OPB_WIDGET.IS_VISIBLE = 2 AND OPB_WIDGET.CHECKOUT_USER_ID = ?)) ORDER BY OPB_WIDGET_INST.MAPPING_ID, OPB_WIDGET_INST.VERSION_NUMBER DESC, OPB_WIDGET_INST.INSTANCE_ID, OPB_WIDGET_INST.WIDGET_ID, OPB_WIDGET.IS_VISIBLE DESC

      Oracle Fatal Error

       

       

      We noticed that the error in the above query is in the excerpt ‘AND OPB_MAPPING.SUBJECT_ID = OPB_WIDGET.SUBJECT_IDAND OPB_MAPPING.REF_WIDGET_ID = 0’. If we observe, one space is missing before the second ‘AND’.

       

      Information about our environment:

       

      Informatica PowerCenter - Version 10.4.1 Build: 195 - Jun 15, 2020

       

      Databases involved and version information:

      PowerCenter: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

       

      The operating system involved:

       

      Operating System: Red Hat Enterprise Linux Server 7.6 (Maipo)

      CPE OS Name: cpe:/o:redhat:enterprise_linux:7.6:GA:server

      Kernel: Linux 3.10.0-957.1.3.el7.x86_64

      Architecture: x86-64