Skip to main content
January 29, 2020
Question

Guest user cannot send document.

  • January 29, 2020
  • 1 reply
  • 914 views

Hi,

We are using v18.38.8 of Adobe Sign currently in Salesforce and faceing the below error:

12:19:10.368 (9499408020)|SOQL_EXECUTE_BEGIN|[1759]|Aggregations:0|SELECT Id, Name, Account__c, Automatic_Reminders__c, Contract__c, Data_Mapping__c, Merge_Mapping__c, Auto_Send__c, Days_Until_Expiration__c, Default__c, Email_Copy_To__c, Hosted_Signing__c, Language__c, Master_Object_Type__c, Message__c, Name__c, Opportunity__c, Password__c, Preview_Position__c, Sender_User__c, Sign_Password__c, Signature_Order__c, Signature_Flow__c, Signature_Type__c, View_Password__c, External_Signers_Verification_Method__c, Internal_Signers_Verification_Method__c, Sender_Signs_Only__c, Post_Sign_Redirect_URL__c, Post_Sign_Redirect_Delay__c, Sign_Internal_Password__c, Sign_External_Password__c FROM Agreement_Template__c WHERE Id = :tmpVar1
12:19:10.368 (9515710804)|SOQL_EXECUTE_END|[1759]|Rows:1
12:19:10.368 (9516615324)|SOQL_EXECUTE_BEGIN|[1768]|Aggregations:0|SELECT Id, Type__c, Constant_Value__c, Field_Value__c, Agreement_Field__c FROM Field_Template__c WHERE Agreement_Template__c = :tmpVar1
12:19:10.368 (9524527643)|SOQL_EXECUTE_END|[1768]|Rows:1
12:19:10.368 (9525978433)|SOQL_EXECUTE_BEGIN|[1774]|Aggregations:0|SELECT Id, Agreement_Template__c, Type__c, Recipient_Type__c, Recipient_Role__c, Contact_Recipient__c, User_Recipient__c, Lead_Recipient__c, Email_Recipient__c, Index__c, Recipient_Field__c, Opportunity_Contact_Role__c, Account_Contact_Role__c, Variable_Name__c, Do_Not_Create_Empty__c, Signer_Verification_Method__c, Password__c, Phone_Verification_Country_Code__c, Phone_Verification_Phone_Number__c, Group_Recipient__c, Uniform_Index__c, Recipient_Message__c FROM Recipient_Template__c WHERE Agreement_Template__c = :tmpVar1 ORDER BY Index__c ASC NULLS FIRST
12:19:10.368 (9535645623)|SOQL_EXECUTE_END|[1774]|Rows:1
12:19:10.368 (9536774588)|SOQL_EXECUTE_BEGIN|[1783]|Aggregations:0|SELECT Id, Agreement_Template__c, Type__c, Attachment_Selection_Type__c, Attachment_Selection_Field__c, Index__c, Attachment_Document__c, Quote_Document_Selection_Type__c, Quote_Document_Selection_Field__c, Quote_Selection_Type__c, Quote_Selection_Field__c, Variable_Name__c, Master_Source_Type__c FROM Attachment_Template__c WHERE Agreement_Template__c = :tmpVar1 ORDER BY Index__c ASC NULLS FIRST
12:19:10.368 (9545336516)|SOQL_EXECUTE_END|[1783]|Rows:1
12:19:10.368 (9546317400)|SOQL_EXECUTE_BEGIN|[1791]|Aggregations:0|SELECT Id, Agreement_Template__c, Index__c, Document_Keys__c FROM Layer_Template__c WHERE Agreement_Template__c = :tmpVar1 ORDER BY Index__c ASC NULLS FIRST
12:19:10.368 (9552040420)|SOQL_EXECUTE_END|[1791]|Rows:0
12:19:10.368 (9555031110)|SOQL_EXECUTE_BEGIN|[1847]|Aggregations:0|SELECT e.id, e.signer_email__c from CM_Document__c e where Id = 'a1O2i0000018633EAA'
12:19:10.368 (9569940132)|SOQL_EXECUTE_END|[1847]|Rows:1
12:19:10.368 (9607711962)|SOQL_EXECUTE_BEGIN|[214]|Aggregations:0|SELECT Id, Email, FirstName, LastName, ProfileId, EchoSign_Email_Verified__c, Title, Phone, CompanyName FROM User WHERE Id = :tmpVar1
12:19:10.368 (9620781467)|SOQL_EXECUTE_END|[214]|Rows:0
12:19:10.368 (9621283934)|SYSTEM_MODE_EXIT|true
12:19:10.368 (9621316278)|SYSTEM_MODE_EXIT|false
12:19:10.368 (9621533915)|FATAL_ERROR|System.QueryException: List has no rows for assignment to SObject

Class.echosign_dev1.AgreementTemplateProcessor.verifyUser: line 214, column 1
Class.echosign_dev1.AgreementTemplateProcessor.loadLibraryTemplates: line 185, column 1
Class.echosign_dev1.AgreementTemplateProcessor.load: line 79, column 1
Class.echosign_dev1.AgreementTemplateService.load: line 31, column 1
Class.echosign_dev1.AgreementTemplateService.load: line 11, column 1

 

 

This is not working only in the case of Guest User in Salesforce (other users can send agreement and everything looks fine).

The issue happened after the Spring 20 release was released. I think it can be connected with this release note: https://releasenotes.docs.salesforce.com/en-us/winter20/release-notes/rn_networks_guest_sharing_security_update.htm

We were trying to add more permissions to Guest User profile and share records with him.

As you can see in the logs there was attempt from Adobe package to query a user but it returns 0 rows (comparing to the normal code execution where it returns 1 row).

We have checked if guest user has a possiblity to query user, and yes he can (I added sharing rules to share all user to him).

It is only my suspicion, but it looks like it fails because of that (failing method 'verifyUser').

Do you have any ideas what can I do to fix it? Or maybe there is any way to workaround this error?
Thanks,

M

 

This topic has been closed for replies.

1 reply

Participant
June 16, 2021

Hello Community, Is there any solution for this issue? If anyone has done any workaround and it is working, please share solution.