You need to sign in to do that
Don't have an account?
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.
Hey
Putting System.Debug() messages into your code can help you pinpoint what's going on in the logs.
Cheers,
Wes