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

Posted by kalinga@progress on 25-Mar-2014 02:09

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)

Rollbase - Forum

All Replies

Posted by Sharavan Kumar on 09-Apr-2014 06:06

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

Posted by Jean Richert on 09-Apr-2014 06:06

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

Posted by Miguel Saez on 10-Apr-2014 14:51

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.

This thread is closed