You need to sign in to do that
Don't have an account?
SergeantAgni
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
Hi SergeantAgni,
This is confirmed to be a bug, a fix is pending.
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