+ Start a Discussion
venkateshvenkatesh 

Log Details could not figure out

Hi,

       I have the Log file here for workflow run.  I could not figure out the line which are mentioned in red color. Since my SOQL are queried through Account and Opportunity objects. But I am not going to query on any User Object. But still log shows about user. I wonder how it could be possible.Also I am getting SOQL limit exception and my workflow will remove from Queue. Please have a look and suggest me the solution if any.

 

20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:ConnectCom__Workflow__c
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 5 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:ConnectCom__Rule__c
20090710115046.088:(ConnectCom): SOQL query with 2 rows finished in 4 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:Account
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 2 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 2 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 2 ms
20090710115046.088:(ConnectCom): SOQL query with 2 rows finished in 4 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:Account
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 2 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 2 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 1 ms
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 5 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:Opportunity
20090710115046.088:(ConnectCom): SOQL query with 0 rows finished in 9 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:Account
20090710115046.088:(ConnectCom): SOQL query with 2 rows finished in 13 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:Account
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 3 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 1 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 2 ms
20090710115046.088:(ConnectCom): SelectLoop:LIST:SOBJECT:User
20090710115046.088:(ConnectCom): SOQL query with 1 row finished in 1 ms

 

 Please let me know the details if any one knows about this SOQL problem

 

Thanks inadvance.

 

Message Edited by venkatesh on 07-10-2009 05:24 AM
wesnoltewesnolte

Hey

 

Putting System.Debug() messages into your code can help you pinpoint what's going on in the logs.

 

Cheers,

Wes