System Error (Syntax Error in formula) - Forum - Rollbase - Progress Community

System Error (Syntax Error in formula)

 Forum

System Error (Syntax Error in formula)

This question is not answered

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)

All Replies
  • Hi Kim ,

    thanks for providing your observations on this issue . I would like to suggest you to verify the below points

    1)check if object or Record have any dependencies .

    2) Enable audit trail in object definition , to keep track of the transactions being performed on that object .  This may give us some useful information

    3) See if there is any trigger running on any record on creation and using formula fields present in the record ( both transaction might be running parallely , resulting this issue..

    4) If you are using Custom triggers , please check for the syntax errors in that script.

    thanks,

    sharavan

  • Hi Kalinga,

    I saw you posted your question a few days ago.

    I have asked Rollbase specialists to get back to you.

    Sorry for the delay

  • Hi Kim,

    I see in your first screenshot that the error is something like if( - >0) ....., looks like that you do a condition using a field and the value is "-", I don't know if you checked the type of the field and the value which it has, perhaps it is help to you..

    Regards,

    Miguel Angel.