This discussion is archived
0 Replies Latest reply: Nov 12, 2013 10:28 AM 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 Newbie
Currently Being Moderated

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