0 Replies Latest reply: Nov 12, 2013 12:28 PM by jlanghurst RSS

    EA3 - SQL Developer EA 4.0.0.13 errors on EBS IBY_EXT_BANK_ACCOUNTS but 3.2.09 does not

    jlanghurst

      Hello,

      I am using SQL Developer recent release EA 4.0.0.3.2.09 build main 12.84 (and another user on EA 4.0.0.13 build main 13.30) run into this error when query IBY_EXT_BANK_ACCOUNTS in Oracle EBS R12
      ORA-29275: partial multibyte character
      29275. 00000 - "partial multibyte character"
      *Cause: The requested read operation could not complete because a partial
        multibyte character was found at the end of the input.
      *Action: Ensure that the complete multibyte character is sent from the
        remote server and retry the operation. Or read the partial
        multibyte character as RAW.

      The issue appears to be this one:
      ORA-29275: Partial Multibyte Character Querying IBY_EXT_BANK_ACCOUNTS (Doc ID 806024.1)

      However, prior versions of SQL Developer (eg 3.2.09) work fine with the same query so this appears to be a regression in the new version of SQL Developer? I am using the OCI/thick drivers (and the 3.2.09 user is not).

      Query
      select * from apps.IBY_EXT_BANK_ACCOUNTS;

      Jay

      Error Codes
      ---------------------------------------------------
      ORA-29275

      Problem Category/Subcategory
      ---------------------------------------------------
      Oracle SQL Developer Worksheet

      Uploaded Files
      ---------------------------------------------------


      Template Question Responses
      ---------------------------------------------------
      1) ### Client platform/os/version ### _DT-SQLWO_
      Windows 7 professional SP1 64 bit

      2) ### Server platform/os/version ###
      Redhat 4.4.6-3
      Linux XXX.XXXXX.XXX 2.6.39-200.24.1.el6uek.x86_64 #1 SMP Sat Jun 23 02:39:07 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
      Linux version 2.6.39-200.24.1.el6uek.x86_64 (mockbuild@ca-build44.us.oracle.com) (gcc version 4.4.6 20110731 (Red Hat 4.4.6-3) (GCC) ) #1 SMP Sat Jun 23 02:39:07 EDT 2012


      3) ### Database version ###
      11g (11.2.0.3)

      4) ### Java version ###
      java version "1.7.0_25"
      Java(TM) SE Runtime Environment (build 1.7.0_25-b17)
      Java HotSpot(TM) 64-Bit Server VM (build 23.25-b01, mixed mode)

      5) ### Error Messages ###
      ORA-29275: partial multibyte character
      29275. 00000 - "partial multibyte character"
      *Cause: The requested read operation could not complete because a partial
        multibyte character was found at the end of the input.
      *Action: Ensure that the complete multibyte character is sent from the
        remote server and retry the operation. Or read the partial
        multibyte character as RAW.

      6) ### Failing statement ###
      select * from apps.IBY_EXT_BANK_ACCOUNTS;

      7) ### frequency of the error ###
      Always

      8) ### Reproducible in sqlplus ###
      Yes