• Rob Goldiez
  • NEWBIE
  • 10 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 4
    Questions
  • 11
    Replies
I'm getting the platform error described here when a trigger I have is being executed by a community member.  
https://success.salesforce.com/issues_view?id=a1p30000000E19wAAC

Apex error is below.  This trigger works fine from the salesforce web interface.  My understanding from the issue referenced at the above link is that ORA-00904 is a platform issue.

---------------------
Sandbox

Apex script unhandled trigger exception by user/organization: 00561000000Kj0n/00D4B000000CpdH
Source organization: 00D61000000agdX (null)
notifyChatterComments: execution of AfterInsert

caused by: System.UnexpectedException: common.exception.SfdcSqlException: ORA-00904: "T"."COMMUNITY_NICKNAME": invalid identifier


select /*FkJoin*/ "Id",
"Name",
"CommunityNickname"
from (select /*+ ordered use_hash(t) */
ids.num "ids_num",
t.entity_id "Id",
case when substr(t.entity_id,1,3) in ('003','00Q', '005') then trim(t.first_name || ' ' || t.last_name) when substr(t.entity_id,1,3) in ('01p','01q') then t.developer_name else nvl(t.name,trim(t.first_name || ' ' || t.last_name)) end "Name",
t.community_nickname "CommunityNickname"
from (select * from table(cast(? as id_num_array))) ids,
     (select /*+ ordered use_nl(nd) index(nd pkname_denorm) */
     nd.entity_id ids_num,
     nd.organization_id organization_id,
     nd.entity_id entity_id,
     nd.record_type_id,
     nd.name AS name,
          nd.first_name first_name,
     nd.last_name last_name,
     nd.middle_name middle_name,
     nd.preferred_address preferred_address,
     nd.suffix suffix,
     nd.deleted deleted,
     nd.active active,
     nd.archived archived,
     nullif(substr(nd.entity_id,1,3), '000'),
     nd.alias alias,
     nd.email email,
     nd.title title,
     nd.phone phone,
     nd.user_role_id user_role_id,
     nd.profile_id profile_id,
     nd.namespace_prefix namespace_prefix,
     nd.developer_name developer_name,
     nd.table_enum_or_id table_enum_or_id,
     nd.subtype subtype
     from (select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.name_denorm nd
     where (tmp.id = nd.entity_id)
     and (nd.organization_id = '00D4B000000CpdH')
     and (nd.entity_id != '000000000000000')
     and (nd.deleted = '0')
     UNION ALL
     (select /*+ ordered use_nl(t) index(t pkdashboard_component)) */
     t.dashboard_component_id ids_num,
     t.organization_id organization_id,
     t.dashboard_component_id entity_id,
     '' record_type_id,
     NVL(DECODE(t.component_type, 10, t.metric, t.title), 'Untitled Component') AS name,
     '' first_name,
     '' last_name,
     '' middle_name,
     '' preferred_address,
     '' suffix,
     '0' deleted,
     '1' active,
     '0' archived,
     nullif(substr(t.dashboard_component_id,1,3), '000'),
     '' alias,
     '' email,
     '' title,
     '' phone,
     '' user_role_id,
     '' profile_id,
     '' namespace_prefix,
     '' developer_name,
     '' table_enum_or_id,
     '' subtype
     from
(select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.dashboard_component t
     where (tmp.id = t.dashboard_component_id)
     and (substr(tmp.id,1,3) = '01a')
     and (t.organization_id = '00D4B000000CpdH')
)     UNION ALL
     (select /*+ ordered use_nl(t) index(t pkactivity)) */
     t.activity_id ids_num,
     t.organization_id organization_id,
     t.activity_id entity_id,
     '' record_type_id,
     t.subject AS name,
     '' first_name,
     '' last_name,
     '' middle_name,
     '' preferred_address,
     '' suffix,
     t.deleted deleted,
     '1' active,
     '0' archived,
     nullif(substr(t.activity_id,1,3), '000'),
     '' alias,
     '' email,
     '' title,
     '' phone,
     '' user_role_id,
     '' profile_id,
     '' namespace_prefix,
     '' developer_name,
     '' table_enum_or_id,
     '' subtype
     from
(select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.activity t
     where (tmp.id = t.activity_id)
     and (substr(tmp.id,1,3) = '00T')
     and (t.organization_id = '00D4B000000CpdH')
     and (t.deleted = '0'))     UNION ALL
     (select /*+ ordered use_nl(t) index(t pkactivity)) */
     t.activity_id ids_num,
     t.organization_id organization_id,
     t.activity_id entity_id,
     '' record_type_id,
     t.subject AS name,
     '' first_name,
     '' last_name,
     '' middle_name,
     '' preferred_address,
     '' suffix,
     t.deleted deleted,
     '1' active,
     '0' archived,
     nullif(substr(t.activity_id,1,3), '000'),
     '' alias,
     '' email,
     '' title,
     '' phone,
     '' user_role_id,
     '' profile_id,
     '' namespace_prefix,
     '' developer_name,
     '' table_enum_or_id,
     '' subtype
     from
(select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.activity t
     where (tmp.id = t.activity_id)
     and (substr(tmp.id,1,3) = '00U')
     and (t.organization_id = '00D4B000000CpdH')
     and (t.deleted = '0'))) t
where (ids.id = t.entity_id)
and (t.organization_id = '00D4B000000CpdH')
and (t.deleted = '0'))
order by "ids_num" asc nulls first

Trigger.notifyChatterComments: line 20, column 1
 
Is there any support for subscribing to a push topic (from a streaming api) with the mobile (iOS) SDK?  
We have a customer community setup and login is working fine for our customers.  Can we configure the community (or internal profiles) so that our employees (i.e., full salesforce CRM users) can login with their salesforce credentials to the community login page?

The specific scenario is that we are working on is a native iOS app for our customers to access community data and we'd like our employees to be able to use the same native app and not offer the ability for users to select where they want to login.  Right now, I have the app setup to point to the community login URL for oauth access.
I'm experiencing a strange problem that cropped up yesterday morning.  I am suddenly getting a 'page not found' error when trying to access my community in my sandbox org.  I have not changed any of the custom URL settings in weeks and was accessing and using the sandbox community the very night before without issue.

Sandbox: https://sandbox-hirebotics.cs51.force.com/ (<-- page not found error)

Production:  https://robots.hirebotics.com (<-- works fine)

After three phone calls / go-to-meetings with salesforce support they can't figure out what's going on.  Their latest guess is that my product custom URL in sandbox (which is copied into sandbox upon a refresh, which I haven't done in a week) is set to "in development".  But they can't tell me why that's a problem now nor how to change that, assuming that's the problem.  They suggested I post here.  See below.
Custom URL in Sandbox

Now, I also tried spinning out another developers sandbox from my working production org and I'm seeing the exact same problem accessing the login page hosted from this new dev org.

Note that the error page below is being served from my org as the email us link connects to my email address.
Community Error Page

Also, both my sandbox and dev sandbox are hosted on CS51, if that's relevant.

Any idea what's going on?  
 
I'm getting the platform error described here when a trigger I have is being executed by a community member.  
https://success.salesforce.com/issues_view?id=a1p30000000E19wAAC

Apex error is below.  This trigger works fine from the salesforce web interface.  My understanding from the issue referenced at the above link is that ORA-00904 is a platform issue.

---------------------
Sandbox

Apex script unhandled trigger exception by user/organization: 00561000000Kj0n/00D4B000000CpdH
Source organization: 00D61000000agdX (null)
notifyChatterComments: execution of AfterInsert

caused by: System.UnexpectedException: common.exception.SfdcSqlException: ORA-00904: "T"."COMMUNITY_NICKNAME": invalid identifier


select /*FkJoin*/ "Id",
"Name",
"CommunityNickname"
from (select /*+ ordered use_hash(t) */
ids.num "ids_num",
t.entity_id "Id",
case when substr(t.entity_id,1,3) in ('003','00Q', '005') then trim(t.first_name || ' ' || t.last_name) when substr(t.entity_id,1,3) in ('01p','01q') then t.developer_name else nvl(t.name,trim(t.first_name || ' ' || t.last_name)) end "Name",
t.community_nickname "CommunityNickname"
from (select * from table(cast(? as id_num_array))) ids,
     (select /*+ ordered use_nl(nd) index(nd pkname_denorm) */
     nd.entity_id ids_num,
     nd.organization_id organization_id,
     nd.entity_id entity_id,
     nd.record_type_id,
     nd.name AS name,
          nd.first_name first_name,
     nd.last_name last_name,
     nd.middle_name middle_name,
     nd.preferred_address preferred_address,
     nd.suffix suffix,
     nd.deleted deleted,
     nd.active active,
     nd.archived archived,
     nullif(substr(nd.entity_id,1,3), '000'),
     nd.alias alias,
     nd.email email,
     nd.title title,
     nd.phone phone,
     nd.user_role_id user_role_id,
     nd.profile_id profile_id,
     nd.namespace_prefix namespace_prefix,
     nd.developer_name developer_name,
     nd.table_enum_or_id table_enum_or_id,
     nd.subtype subtype
     from (select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.name_denorm nd
     where (tmp.id = nd.entity_id)
     and (nd.organization_id = '00D4B000000CpdH')
     and (nd.entity_id != '000000000000000')
     and (nd.deleted = '0')
     UNION ALL
     (select /*+ ordered use_nl(t) index(t pkdashboard_component)) */
     t.dashboard_component_id ids_num,
     t.organization_id organization_id,
     t.dashboard_component_id entity_id,
     '' record_type_id,
     NVL(DECODE(t.component_type, 10, t.metric, t.title), 'Untitled Component') AS name,
     '' first_name,
     '' last_name,
     '' middle_name,
     '' preferred_address,
     '' suffix,
     '0' deleted,
     '1' active,
     '0' archived,
     nullif(substr(t.dashboard_component_id,1,3), '000'),
     '' alias,
     '' email,
     '' title,
     '' phone,
     '' user_role_id,
     '' profile_id,
     '' namespace_prefix,
     '' developer_name,
     '' table_enum_or_id,
     '' subtype
     from
(select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.dashboard_component t
     where (tmp.id = t.dashboard_component_id)
     and (substr(tmp.id,1,3) = '01a')
     and (t.organization_id = '00D4B000000CpdH')
)     UNION ALL
     (select /*+ ordered use_nl(t) index(t pkactivity)) */
     t.activity_id ids_num,
     t.organization_id organization_id,
     t.activity_id entity_id,
     '' record_type_id,
     t.subject AS name,
     '' first_name,
     '' last_name,
     '' middle_name,
     '' preferred_address,
     '' suffix,
     t.deleted deleted,
     '1' active,
     '0' archived,
     nullif(substr(t.activity_id,1,3), '000'),
     '' alias,
     '' email,
     '' title,
     '' phone,
     '' user_role_id,
     '' profile_id,
     '' namespace_prefix,
     '' developer_name,
     '' table_enum_or_id,
     '' subtype
     from
(select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.activity t
     where (tmp.id = t.activity_id)
     and (substr(tmp.id,1,3) = '00T')
     and (t.organization_id = '00D4B000000CpdH')
     and (t.deleted = '0'))     UNION ALL
     (select /*+ ordered use_nl(t) index(t pkactivity)) */
     t.activity_id ids_num,
     t.organization_id organization_id,
     t.activity_id entity_id,
     '' record_type_id,
     t.subject AS name,
     '' first_name,
     '' last_name,
     '' middle_name,
     '' preferred_address,
     '' suffix,
     t.deleted deleted,
     '1' active,
     '0' archived,
     nullif(substr(t.activity_id,1,3), '000'),
     '' alias,
     '' email,
     '' title,
     '' phone,
     '' user_role_id,
     '' profile_id,
     '' namespace_prefix,
     '' developer_name,
     '' table_enum_or_id,
     '' subtype
     from
(select * from table(cast(? AS ID_NUM_ARRAY))) tmp,
          core.activity t
     where (tmp.id = t.activity_id)
     and (substr(tmp.id,1,3) = '00U')
     and (t.organization_id = '00D4B000000CpdH')
     and (t.deleted = '0'))) t
where (ids.id = t.entity_id)
and (t.organization_id = '00D4B000000CpdH')
and (t.deleted = '0'))
order by "ids_num" asc nulls first

Trigger.notifyChatterComments: line 20, column 1
 
We have a customer community setup and login is working fine for our customers.  Can we configure the community (or internal profiles) so that our employees (i.e., full salesforce CRM users) can login with their salesforce credentials to the community login page?

The specific scenario is that we are working on is a native iOS app for our customers to access community data and we'd like our employees to be able to use the same native app and not offer the ability for users to select where they want to login.  Right now, I have the app setup to point to the community login URL for oauth access.
I'm experiencing a strange problem that cropped up yesterday morning.  I am suddenly getting a 'page not found' error when trying to access my community in my sandbox org.  I have not changed any of the custom URL settings in weeks and was accessing and using the sandbox community the very night before without issue.

Sandbox: https://sandbox-hirebotics.cs51.force.com/ (<-- page not found error)

Production:  https://robots.hirebotics.com (<-- works fine)

After three phone calls / go-to-meetings with salesforce support they can't figure out what's going on.  Their latest guess is that my product custom URL in sandbox (which is copied into sandbox upon a refresh, which I haven't done in a week) is set to "in development".  But they can't tell me why that's a problem now nor how to change that, assuming that's the problem.  They suggested I post here.  See below.
Custom URL in Sandbox

Now, I also tried spinning out another developers sandbox from my working production org and I'm seeing the exact same problem accessing the login page hosted from this new dev org.

Note that the error page below is being served from my org as the email us link connects to my email address.
Community Error Page

Also, both my sandbox and dev sandbox are hosted on CS51, if that's relevant.

Any idea what's going on?  
 
Hi All,

I am very new to salesforce platform, though in short span of time, I have started liking it very much. Currently, the challenge I am facing to implement a custom URL for a community which I have created in my developer org. The custom URL I have bought it is named as " www.mehandimakeup.com and the full domain URL I have on salesforce for community is : https://mything-developer-edition.ap2.force.com/mycommunity

The custom I URL I have bought is from godaddy and I tried putting following entry as cname record but it is not accepting.

https://mything-developer-edition.ap2.force.com/mycommunity.00D28000000ea7JEAQ.live.siteforce.com


I would really appreciate your help a step by step guidance to implement it. 

Looking forward to your response.

Regards,
Sanjay
Can someone please help me understand why does Salesforce add a extra '/s/' to the Community URL?
We recently created an community using templates and whenever we try to access it, we notice that an '/s/' gets appended to the URL. Do we know why??

Example: Say if my community URL is https://mydomain.force.com/MyCommunity. Whenever I try to access this community, Salesforce adds an a /s/ at the end i.e https://mydomain.force.com/MyCommunity/s/
We are developing an application that runs on Heroku that uses the username/password flow to authenticate into our Salesforce instance.  When running on Winter 16 we were using the username/password OAuth flow and passing the personal security token so that we could use the Enforce IP restrictions in the connected app.  The application has had no issues logging into either sandbox or production environments until the upgrade to Spring 16 in Sandbox.  Since the upgrade we have been unable to log into sandbox using the original flow as programmed in the app.  We initially attempted to resolve the issue by resetting the personal security token but that had no effect on the error we are receiving, "invalid_grant - Authentication failure".  We have found a workaround to keep us developing which is to relax the ip restrictions and remove the personal security token from the login flow but this is only a temporary fix and not what we would like to deploy into production.

Also, we did switch the app over to point to production to verify that we are not having any issues there and it works fine; production is still on Winter 16.

Any idea what changed in the username/password OAuth flow with the upgrade to Spring 16?  I cannot find anything in the release notes that points to what the issue may be.