How can I open a workbook that seems corrupted anyway?

Question:

How can I open a workbook that seems corrupted anyway?

 

Answer:

When a formula of a workbook gets corrupted (e.g. manual formula editing on the database level or a failed database migration), a workbook becomes inaccessible and you will see the message "Oops, an error occurred'. In this situation, try the following setting in the fileconf/default.properties:

system.property.formula.strict-parsing=false

and restart Datameer application.
After this try to reopen your workbook again.

 

Setting strict-parsing to false results in ignoring the remaining part of a formula once an invalid character or token is detected during formula parsing. This affects validity of the result! You should re-enable strict-parsing as soon as you have fixed the incorrect formula.