function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SergeantAgniSergeantAgni 

Oracle Error reported when querying Organization.WebToCaseDefaultOrigin

While querying from Organization I recieve the following fault from Axis which reports Oracle errors on the server:

org.apache.axis.AxisFault: java.sql.SQLException: ORA-00904: "ORGANIZATION"."WEB_TO_CASE_DEFAULT_ORIGIN": invalid identifier
ORA-06512: at "BUILD132R5.CAPICURSOR", line 136
ORA-06512: at line 1

The problem appears to be triggered by any query that includes the Organization field 'WebToCaseDefaultOrigin'.

--Brad

DevAngelDevAngel

Hi SergeantAgni,

This is confirmed to be a bug, a fix is pending.

 

SergeantAgniSergeantAgni

I found two more errors that are similar in nature, though I'm not getting Oracle errors with them.  The field names are found in the describe results, but the invalid_field fault is returned for each of the following fields...

Profile - PermissionsEmailSingle
com.sforce.soap.partner.fault.InvalidFieldFault: INVALID_FIELD: Invalid name: permissionsemailsingle in Profile

User - UserPermissionsMarketingUser
com.sforce.soap.partner.fault.InvalidFieldFault: INVALID_FIELD: Invalid name: userpermissionsmarketinguser in User

--Brad