Forum Post: System Error (Syntax Error in formula)

  • Thread starter Thread starter kalinga@progress
  • Start date Start date
Status
Not open for further replies.
K

kalinga@progress

Guest
Hi Community, Good day We're having this weird problem, and I have checked all possible formula field that may have caused this error to appear but to no avail. I have listed here the things I have done to try to isolate the bug, if you have an idea about this error or have this encountered before please let me know, as I ran out of idea what to do. This error only shows up on a particular single object, see bullets below for complete behavior of the bug. Persistent Error Shows up on every edit and delete (Creation works fine), See figure 1 for the said error The erratic object has its portal user enabled, and so everytime we try to login on portal page we get the same error, see figure 2. It also sometimes fires this error " com.rb.util.db.a429: Thread 42869 already has running transaction. If you are using custom triggers please make sure you follow Rollbase guidelines. " Things I did to try isolate the problem. I disabled all triggers as in all triggers and all related triggers from other object. Reviewed every formula line per line in that certain object, and everyone is correct and doesn't have the pattern of what was the error is showing. Install the app to a new zone. Run the built in debug of triggers, this debug captures process of creation only, the edit and delete shows blank. See the debug info on create event below the images. I really have no idea what should I do next, please help and thanks in advance Kim Michael Running ON_BEFORE_CREATE on Error (ID=260946) Finished ON_BEFORE_CREATE on Error (ID=260946) Running ON_AFTER_CREATE on catherine (ID=260946) Checking trigger: Create Game Wallet (ID=253376) Running Create Game Wallet on Player: catherine (ID=260946) Checking trigger: Update Main Wallet (ID=253377) Running Update Main Wallet on Player: catherine (ID=260946) Player catherine (ID=260946): Changing Main Wallet value to Checking trigger: Attach Default Risk Level (ID=253378) Running Attach Default Risk Level on Player: catherine (ID=260946) Player catherine (ID=260946): Creating relationship with Risk Level: IDs=258044 Checking trigger: Attach Default VIP Level (ID=253379) Running Attach Default VIP Level on Player: catherine (ID=260946) Player catherine (ID=260946): Creating relationship with VIP Level: IDs=258043 Checking trigger: Update Maximum Deposit (ID=253380) Running Update Maximum Deposit on Player: catherine (ID=260946) Player catherine (ID=260946): Changing Maximum Deposit value to 1000000.0 Checking trigger: Update Maximum Withdrawal (ID=253381) Running Update Maximum Withdrawal on Player: catherine (ID=260946) Player catherine (ID=260946): Changing Maximum Withdrawal value to 1.0E9 Checking trigger: Update Max Daily Aggregate - Deposit (ID=253382) Running Update Max Daily Aggregate - Deposit on Player: catherine (ID=260946) Player catherine (ID=260946): Changing Maximum Daily Aggregate value to 100000.0 Checking trigger: Update Max Daily Aggregate - Withdrawal (ID=253383) Running Update Max Daily Aggregate - Withdrawal on Player: catherine (ID=260946) Player catherine (ID=260946): Changing Maximum Daily Aggregate value to 1000.0 Checking trigger: Attach Affiliate (ID=253384) Running Attach Affiliate on Player: catherine (ID=260946) Player catherine (ID=260946): No need to create relationship affiliate - player1: formula returned null Attach Affiliate has NOT ran Checking trigger: Attach to Lead Record using Mobile (ID=253385) Running Attach to Lead Record using Mobile on Player: catherine (ID=260946) Player catherine (ID=260946): No need to create relationship leads - player1: formula returned null Attach to Lead Record using Mobile has NOT ran Checking trigger: Attach to Lead Record using Email (ID=253386) Running Attach to Lead Record using Email on Player: catherine (ID=260946) Player catherine (ID=260946): No need to create relationship leads - player1: formula returned null Attach to Lead Record using Email has NOT ran Checking trigger: Run Status Change Trigger in Leads (ID=253387) Running Run Status Change Trigger in Leads on Player: catherine (ID=260946) Run Status Change Trigger in Leads has NOT ran Checking trigger: Set status to Online (ID=253388) Running Set status to Online on Player: catherine (ID=260946) Player catherine (ID=260946): Changing Status value to 253227 Finished ON_AFTER_CREATE on catherine (ID=260946)

Continue reading...
 
Status
Not open for further replies.
Back
Top