You need to sign in to do that
Don't have an account?
Need help with new trigger not working..old one still fires?
Okay we have an external program that makes a soap connection and then updates the Account Object. We were getting the
System.Exception: Too many SOQL queries: 101 error
So I changed the code to be bulk and use a map. Anyway, I have the new code in Production and we are still getting this error, on the same line accessing the same outside class method. My code does everything in the trigger and doesn't even access the method anymore, beyond that the line number it says the error is on is a comment line in my trigger. I have been messing with this for about a week... HELP!!!
Also, I have pushed this to production twice and it is valid and active.
Thank you!
Please post some code. Unless this is a know bug you will never get a response without some code to put it in context...
here is the current code, I blew the rest away... as far as I know
here is the error from the XML result of the push:
Class.Accounts.SetState: line 5, column 31
Trigger.AccountUpdateState: line 9, column 4</Message>
<StatusCode>CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY</StatusCode>
</SyncError>
</Errors>
<UserID>0</UserID>
<DealerID>945</DealerID>
<MS_SF_UpsertType>1</MS_SF_UpsertType>
<CreatedDate>9/7/2011</CreatedDate>
</SyncResults>
<SyncResults>
<MS_SF_SyncID>0</MS_SF_SyncID>
<Created>false</Created>
<Success>false</Success>
<Errors>
<SyncError>
<Fields />
<Message>AccountUpdateState: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 101
Thank you!
I would be willing to bet that a workflow or something is causing recursive updates.....
When you get the error, how many records are you updating, 1, 5, 100?
I
Sorry Starz26, I was unavailable. The .Net program updates 200 records at a time right now. Another thing, on Firday I disabled this trigger, so there are no triggers on the Account object. Yet we still get the same error? It blows my mind. I'll ask my administrator about the workflow though, thank you! Any other thoughts would be greatly appreciated!