0 Replies Latest reply on Dec 22, 2018 4:23 PM by jeharr

    Java AQ error from application ORA-00932: expected SYS.AQ$_JMS_MESSAGE got SYS.AQ$_JMS_MESSAGE after upgrading database from 11.2.0.4 to 12.2.0.1

    jeharr

      We upgraded the database from 11.2.0.4 to 12.2.0.1 and applied the latest PSU fro m October 2018. No errors during the upgrade. Everything is working OK except my AQ table gets this error. It worked fine unde 11.2.0.4. We dropped the Queue table and recreated it from the database server so all the SYS objects would be under 12.2.

       

      Still get this error.  How can I fix it?

       

      2018-10-31 16:02:36,671 [http-bio-8970-exec-31] DEBUG com.xxxx.icsd.files.service.UploadServiceImp- fileID=52e3c4e32b2a461ab277970cc4b446ce, md5Hash=C206D446055C921F2C65945378334F7D 

      Enqueing message: FileQueueMessage [host=xxxxxxapd1.corp.acxiom.net, fileId=52e3c4e32b2a461ab277970cc4b446ce, service=ICS] 

      org.springframework.jms.UncategorizedJmsException: Uncategorized exception occured during JMS processing; nested exception is oracle.jms.AQjmsException: ORA-00604: error occurred at recursive SQL level 1 

      ORA-00932: inconsistent datatypes: expected SYS.AQ$_JMS_MESSAGE got SYS.AQ$_JMS_MESSAGE 

       

        at org.springframework.jms.support.JmsUtils.convertJmsAccessException(JmsUtils.java:316) 

        at org.springframework.jms.support.JmsAccessor.convertJmsAccessException(JmsAccessor.java:169) 

        at org.springframework.jms.core.JmsTemplate.execute(JmsTemplate.java:494) 

        at org.springframework.jms.core.JmsTemplate.send(JmsTemplate.java:577) 

        at org.springframework.jms.core.JmsTemplate.convertAndSend(JmsTemplate.java:665)

      icsdir@xxxxxxxx:/u01/icsdir> java -cp .:/u01/icsdir/lib/testlib/ojdbc8.jar JDBCInfo thin xxxxdbd1 1521 XXXXTEST icsdxxxx icsdxxxx 

       

      Database 

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

      Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 

       

      JDBC 

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

      Oracle JDBC driver: 12.2.0.1.0 

       

      Connection URL 

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

      jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=xxxxxxxxx))(CONNECT_DATA=(SID=TEST))) 

       

      JVM 

      === 

      Oracle Corporation 

      Java HotSpot(TM) 64-Bit Server VM 

      25.60-b23 

      1.8.0_60 

       

      LOCALE 

      =========== 

      en_US 

       

      BOOTSTRAP (sun.boot.class.path) 

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

        /u01/app/userapps/jdk1.8.0_60/jre/lib/resources.jar:/u01/app/userapps/jdk1.8.0_60/jre/lib/rt.jar:/u01/app/userapps/jdk1.8.0_60/jre/lib/sunrsasign.jar:/u01/app/userapps/jdk1.8.0_60/jre/lib/jsse.jar:/u01/app/userapps/jdk1.8.0_60/jre/lib/jce.jar:/u01/app/userapps/jdk1.8.0_60/jre/lib/charsets.jar:/u01/app/userapps/jdk1.8.0_60/jre/lib/jfr.jar:/u01/app/userapps/jdk1.8.0_60/jre/classes

       

      EXTENSION PACKAGES (java.ext.dirs) 

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

      /u01/app/userapps/jdk1.8.0_60/jre/lib/ext:/usr/java/packages/lib/ext 

       

      /u01/app/userapps/jdk1.8.0_60/jre/lib/ext: 

        meta-index 

        jaccess.jar 

        dnsns.jar 

        localedata.jar 

        sunec.jar 

        sunpkcs11.jar 

        sunjce_provider.jar 

        cldrdata.jar 

        zipfs.jar 

        nashorn.jar 

        jfxrt.jar 

      /usr/java/packages/lib/ext: 

       

      CLASSPATH 

      ========= 

      /u01/icsdir/lib/testlib/ojdbc8.jar 

       

      LIBRARYPATH 

      =========== 

      /lib 

      /usr/lib 

      /usr/local/lib 

      /u01/app/oracle/product/11.2.0.4/lib 

      /usr/java/packages/lib/amd64 

      /usr/lib64 

      /lib64 

      /lib 

      /usr/lib