Salesforce Developer Community

Sukhpreet Lotey 6
NEWBIE
10 Points
Member since 2016

Chatter

Feed
0

Best Answers
1

Likes Received
0

Likes Given
2

Questions
4

Replies

Too many SOQL queries on tests

Hi all,

Some tests are failing on my production org with error "Too many SOQL queries" but the tests passed on my sandbox which is a week behind from the prod site. So I started by looking at a particular test to find out where the problem lies by printing out the 'Queries Used' at different steps on the apex test code on both prod and sandbox. Interestingly I found out that an additional trigger was running on the production site which I am still trying to figure out why. The log has has something like:

I am thinking maybe the problem might be here but cannot find a Workflow with 'ParentFieldUpdate'. Does anyone know what this could be?

Here are logs from both Prod and sandbox:

Production site:

11:10:07.496 (6909806810)|WF_FLOW_ACTION_BEGIN|09LG0000000PCDO
11:10:07.911 (6911029804)|FLOW_CREATE_INTERVIEW_BEGIN|00D170000000PkK|300G00000004rE5|301G0000000L7a7
11:10:07.911 (6911063628)|FLOW_CREATE_INTERVIEW_END|60139cd58510b6d5bf552215d318157529ae4ce-36f2|Dispatch Changing Original Date Rejected or Approved
11:10:07.912 (6912430672)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:07.912 (6912482534)|FLOW_START_INTERVIEW_BEGIN|60139cd58510b6d5bf552215d318157529ae4ce-36f2|Dispatch Changing Original Date Rejected or Approved
11:10:07.912 (6918343468)|FLOW_START_INTERVIEW_END|60139cd58510b6d5bf552215d318157529ae4ce-36f2|Dispatch Changing Original Date Rejected or Approved
11:10:07.912 (6918354094)|FLOW_START_INTERVIEWS_END|1
11:10:07.496 (6919402559)|WF_FLOW_ACTION_END|09LG0000000PCDO
11:10:07.496 (6919433785)|WF_FLOW_ACTION_BEGIN|09LG0000000L0gi
11:10:07.921 (6921194785)|FLOW_CREATE_INTERVIEW_BEGIN|00D170000000PkK|300G00000004rGf|301G0000000PSvD
11:10:07.921 (6921236499)|FLOW_CREATE_INTERVIEW_END|60149cd58510b6d5bf552215d318157529ae4ce-36f1|Dispatch Currency Update
11:10:07.937 (6937772081)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:07.937 (6937808252)|FLOW_START_INTERVIEW_BEGIN|60149cd58510b6d5bf552215d318157529ae4ce-36f1|Dispatch Currency Update
11:10:07.937 (6943548977)|FLOW_START_INTERVIEW_END|60149cd58510b6d5bf552215d318157529ae4ce-36f1|Dispatch Currency Update
11:10:07.937 (6943565494)|FLOW_START_INTERVIEWS_END|1
11:10:07.496 (6945020472)|WF_FLOW_ACTION_END|09LG0000000L0gi
11:10:07.496 (6945063573)|WF_TIME_TRIGGERS_BEGIN
11:10:07.496 (6958320240)|WF_ACTIONS_END| Field Update: 4; Flow Trigger: 11;
11:10:07.496 (6958337061)|CODE_UNIT_FINISHED|Workflow:01IG0000002KhwC
11:10:07.496 (6961000790)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:ParentFieldUpdate
11:10:07.496 (6961075944)|CODE_UNIT_FINISHED|Workflow:ParentFieldUpdate
11:10:07.496 (6964374035)|CODE_UNIT_STARTED|[EXTERNAL]|01qG0000000ipuf|AccountInformation on Charter trigger event BeforeUpdate for [a0r1700000Ax2xv]
11:10:07.496 (6978114250)|CODE_UNIT_FINISHED|AccountInformation on Charter trigger event BeforeUpdate for [a0r1700000Ax2xv]

Sandbox Log:

11:10:37.169 (6329081903)|WF_FLOW_ACTION_BEGIN|09LG0000000PCDO
11:10:37.330 (6330127573)|FLOW_CREATE_INTERVIEW_BEGIN|00D5B0000008dN8|300G00000004rE5|301G0000000L7a7
11:10:37.330 (6330173276)|FLOW_CREATE_INTERVIEW_END|6801c8b955c758d717542ec848f215752990e82-26e7|Dispatch Changing Original Date Rejected or Approved
11:10:37.331 (6331284858)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:37.331 (6331309489)|FLOW_START_INTERVIEW_BEGIN|6801c8b955c758d717542ec848f215752990e82-26e7|Dispatch Changing Original Date Rejected or Approved
11:10:37.331 (6337066765)|FLOW_START_INTERVIEW_END|6801c8b955c758d717542ec848f215752990e82-26e7|Dispatch Changing Original Date Rejected or Approved
11:10:37.331 (6337076824)|FLOW_START_INTERVIEWS_END|1
11:10:37.169 (6337700220)|WF_FLOW_ACTION_END|09LG0000000PCDO
11:10:37.169 (6337729438)|WF_FLOW_ACTION_BEGIN|09LG0000000L0gi
11:10:37.338 (6338676531)|FLOW_CREATE_INTERVIEW_BEGIN|00D5B0000008dN8|300G00000004rGf|301G0000000PSvD
11:10:37.338 (6338722496)|FLOW_CREATE_INTERVIEW_END|6802c8b955c758d717542ec848f215752990e82-26e6|Dispatch Currency Update
11:10:37.339 (6339831759)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:37.339 (6339856397)|FLOW_START_INTERVIEW_BEGIN|6802c8b955c758d717542ec848f215752990e82-26e6|Dispatch Currency Update
11:10:37.339 (6345584914)|FLOW_START_INTERVIEW_END|6802c8b955c758d717542ec848f215752990e82-26e6|Dispatch Currency Update
11:10:37.339 (6345594699)|FLOW_START_INTERVIEWS_END|1
11:10:37.169 (6346176796)|WF_FLOW_ACTION_END|09LG0000000L0gi
11:10:37.169 (6346220593)|WF_TIME_TRIGGERS_BEGIN
11:10:37.169 (6359597915)|WF_ACTIONS_END| Field Update: 4; Flow Trigger: 11;
11:10:37.169 (6359606075)|CODE_UNIT_FINISHED|Workflow:01IG0000002KhwC
11:10:37.169 (6361377923)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:ParentFieldUpdate
11:10:37.169 (6361471398)|CODE_UNIT_FINISHED|Workflow:ParentFieldUpdate
11:10:37.169 (6363663867)|USER_DEBUG|[57]|DEBUG|-UpdateRelatedDispatch Queries4: 50

Here you can notice on the list line that additional trigger spawns whereas on the sandbox it does not run.

Sukhpreet Lotey 6
September 23, 2016
Like
1

3 replies

How to open an attachment URL within Salesforce1 app?

I am trying to create a UI design where a button click would open up a record's attached pdf file. Although I am able to do this using javascript as follows:

var attachmentUrl = '/servlet/servlet.FileDownload?file=00Q633030006G9k';
window.open(attachmentUrl)

but it opens as a downloadable file in mobile. I need to use the built-in salesforce preview to show this file.

Sukhpreet Lotey 6
February 17, 2016
Like
0

3 replies

Too many SOQL queries on tests

I am thinking maybe the problem might be here but cannot find a Workflow with 'ParentFieldUpdate'. Does anyone know what this could be?

Here are logs from both Prod and sandbox:

Production site:

11:10:07.496 (6909806810)|WF_FLOW_ACTION_BEGIN|09LG0000000PCDO
11:10:07.911 (6911029804)|FLOW_CREATE_INTERVIEW_BEGIN|00D170000000PkK|300G00000004rE5|301G0000000L7a7
11:10:07.911 (6911063628)|FLOW_CREATE_INTERVIEW_END|60139cd58510b6d5bf552215d318157529ae4ce-36f2|Dispatch Changing Original Date Rejected or Approved
11:10:07.912 (6912430672)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:07.912 (6912482534)|FLOW_START_INTERVIEW_BEGIN|60139cd58510b6d5bf552215d318157529ae4ce-36f2|Dispatch Changing Original Date Rejected or Approved
11:10:07.912 (6918343468)|FLOW_START_INTERVIEW_END|60139cd58510b6d5bf552215d318157529ae4ce-36f2|Dispatch Changing Original Date Rejected or Approved
11:10:07.912 (6918354094)|FLOW_START_INTERVIEWS_END|1
11:10:07.496 (6919402559)|WF_FLOW_ACTION_END|09LG0000000PCDO
11:10:07.496 (6919433785)|WF_FLOW_ACTION_BEGIN|09LG0000000L0gi
11:10:07.921 (6921194785)|FLOW_CREATE_INTERVIEW_BEGIN|00D170000000PkK|300G00000004rGf|301G0000000PSvD
11:10:07.921 (6921236499)|FLOW_CREATE_INTERVIEW_END|60149cd58510b6d5bf552215d318157529ae4ce-36f1|Dispatch Currency Update
11:10:07.937 (6937772081)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:07.937 (6937808252)|FLOW_START_INTERVIEW_BEGIN|60149cd58510b6d5bf552215d318157529ae4ce-36f1|Dispatch Currency Update
11:10:07.937 (6943548977)|FLOW_START_INTERVIEW_END|60149cd58510b6d5bf552215d318157529ae4ce-36f1|Dispatch Currency Update
11:10:07.937 (6943565494)|FLOW_START_INTERVIEWS_END|1
11:10:07.496 (6945020472)|WF_FLOW_ACTION_END|09LG0000000L0gi
11:10:07.496 (6945063573)|WF_TIME_TRIGGERS_BEGIN
11:10:07.496 (6958320240)|WF_ACTIONS_END| Field Update: 4; Flow Trigger: 11;
11:10:07.496 (6958337061)|CODE_UNIT_FINISHED|Workflow:01IG0000002KhwC
11:10:07.496 (6961000790)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:ParentFieldUpdate
11:10:07.496 (6961075944)|CODE_UNIT_FINISHED|Workflow:ParentFieldUpdate
11:10:07.496 (6964374035)|CODE_UNIT_STARTED|[EXTERNAL]|01qG0000000ipuf|AccountInformation on Charter trigger event BeforeUpdate for [a0r1700000Ax2xv]
11:10:07.496 (6978114250)|CODE_UNIT_FINISHED|AccountInformation on Charter trigger event BeforeUpdate for [a0r1700000Ax2xv]

Sandbox Log:

11:10:37.169 (6329081903)|WF_FLOW_ACTION_BEGIN|09LG0000000PCDO
11:10:37.330 (6330127573)|FLOW_CREATE_INTERVIEW_BEGIN|00D5B0000008dN8|300G00000004rE5|301G0000000L7a7
11:10:37.330 (6330173276)|FLOW_CREATE_INTERVIEW_END|6801c8b955c758d717542ec848f215752990e82-26e7|Dispatch Changing Original Date Rejected or Approved
11:10:37.331 (6331284858)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:37.331 (6331309489)|FLOW_START_INTERVIEW_BEGIN|6801c8b955c758d717542ec848f215752990e82-26e7|Dispatch Changing Original Date Rejected or Approved
11:10:37.331 (6337066765)|FLOW_START_INTERVIEW_END|6801c8b955c758d717542ec848f215752990e82-26e7|Dispatch Changing Original Date Rejected or Approved
11:10:37.331 (6337076824)|FLOW_START_INTERVIEWS_END|1
11:10:37.169 (6337700220)|WF_FLOW_ACTION_END|09LG0000000PCDO
11:10:37.169 (6337729438)|WF_FLOW_ACTION_BEGIN|09LG0000000L0gi
11:10:37.338 (6338676531)|FLOW_CREATE_INTERVIEW_BEGIN|00D5B0000008dN8|300G00000004rGf|301G0000000PSvD
11:10:37.338 (6338722496)|FLOW_CREATE_INTERVIEW_END|6802c8b955c758d717542ec848f215752990e82-26e6|Dispatch Currency Update
11:10:37.339 (6339831759)|FLOW_START_INTERVIEWS_BEGIN|1
11:10:37.339 (6339856397)|FLOW_START_INTERVIEW_BEGIN|6802c8b955c758d717542ec848f215752990e82-26e6|Dispatch Currency Update
11:10:37.339 (6345584914)|FLOW_START_INTERVIEW_END|6802c8b955c758d717542ec848f215752990e82-26e6|Dispatch Currency Update
11:10:37.339 (6345594699)|FLOW_START_INTERVIEWS_END|1
11:10:37.169 (6346176796)|WF_FLOW_ACTION_END|09LG0000000L0gi
11:10:37.169 (6346220593)|WF_TIME_TRIGGERS_BEGIN
11:10:37.169 (6359597915)|WF_ACTIONS_END| Field Update: 4; Flow Trigger: 11;
11:10:37.169 (6359606075)|CODE_UNIT_FINISHED|Workflow:01IG0000002KhwC
11:10:37.169 (6361377923)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:ParentFieldUpdate
11:10:37.169 (6361471398)|CODE_UNIT_FINISHED|Workflow:ParentFieldUpdate
11:10:37.169 (6363663867)|USER_DEBUG|[57]|DEBUG|-UpdateRelatedDispatch Queries4: 50

Here you can notice on the list line that additional trigger spawns whereas on the sandbox it does not run.

Sukhpreet Lotey 6
September 23, 2016
Like
1

6 replies

Add VisualForce page or Lightning Component into Lightning Dashboard

Do we have any way to add VisualForce page or Lightning Component into Lightning Dashboard.

We have line charts with 5 data series which has been build using VF page. NOw we are looking to include same into Lightning Dashboard.

Vikas U Mishra
February 23, 2017
Like
0

3 replies

How to open an attachment URL within Salesforce1 app?

I am trying to create a UI design where a button click would open up a record's attached pdf file. Although I am able to do this using javascript as follows:

var attachmentUrl = '/servlet/servlet.FileDownload?file=00Q633030006G9k';
window.open(attachmentUrl)

but it opens as a downloadable file in mobile. I need to use the built-in salesforce preview to show this file.

Sukhpreet Lotey 6
February 17, 2016
Like
0

6 replies

Items To Approve in visualforce page

is it possible to put the Items to Approve component from Home Tab to a visualforce page? how?

sp13
February 21, 2014
Like
1

3 replies

INSUFFICIENT_ACCESS_OR_READONLY

I get error message after installing my manage package.... when I tried to insert a record to the Custom Object from public site which use authenticated licenses it gives me...

Insert failed. First exception on row 0; first error: INSUFFICIENT_ACCESS_OR_READONLY, user does not have access to use approval assignment email template:

I ve search a little and Iam sure that:

*I ve cloned the profile (Authenticated)

*Related object is available for Customer portal so I gave the Modify All permission for cloned profile

*Also I have checked the sharing model and the related object has public read/write

*Related controller does not include "with sharing " keyword.

Any solution for this ???

Meantime this functionality works without any problem in package org and also all the conditions same...Problem is the org where I ve downloaded the package.

Ulas Kutuk
August 30, 2012
Like
0