The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Looking for debugging advice
I've been given a task to debug an error that happens when we confirm a month, and I'm not sure what some of the messages are telling me.
When I run Confirmation, I get an error in a dialog box...
Error like this indicates something is wrong with the intersection. Specified member in particular. Check silly stuff first, such as spelling. Try to paste the intersection into the database > data records too see if it returns something (my guess it will return an error, similar, that you posted already).
Here is the error I see when I run the Confirm step.
Does that help any?
When I look at the status after the confirmation, I see a table of 8 rules. The CashFlow Check failed because the values are out of balance. I'm guessing that one of the next two checks is what failed and generated that error, but I don't know how to determine which rule produced the error message. I don't know what the red vs the orange status means. I also don't know why the last three checks didn't even run. Is there a way to manually run a single rule to see what results it generates?
I pasted the error information from the details behind the Confirm task in the Task History (but the moderator rejected the reply). Let me try again with less detail. I'm especially curious what the line numbers refer to. The rules that I think are running don't have 600+ lines of code.
Description: Unable to execute formula.
Error Time: 12/7/2021 4:23:24 PM
Error Level: Error[snip]
----------------------------------------
Exception Type: XFException
Thread Id: 102
Source code: ConfirmationEngineWcf.cs, line 133, method ExecuteConfirmation----------------------------------------
Exception Type: XFException
Thread Id: 102
Source code: ConfirmationEngineWcf.cs, line 369, method ExecuteRuleFormula----------------------------------------
Exception Type: XFException
Thread Id: 102
Source code: FormulaAssembly.cs, line 93, method Execute----------------------------------------
Exception Type: XFException
Thread Id: 102
Message: Unable to execute formula.
Source code: XFFormulaAssemblyCompilerDotNetFw.cs, line 84, method Execute----------------------------------------
Exception Type: XFException
Thread Id: 102
Source code: line 0, method Main----------------------------------------
Exception Type: XFException
Thread Id: 102
Source code: DataApi.cs, line 588, method InternalGetDataCellUsingScript----------------------------------------
Exception Type: XFException
Thread Id: 102
Message: Invalid script 'A#Facilities_Allocation:F#None:O#Forms:I#None:U1#None:U2#1:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None' near 'Facilities_Allocation'.
Source code: DataApi.cs, line 608, method InternalGetDataCellUsingScriptStack Trace: [snip]
Error like this indicates something is wrong with the intersection. Specified member in particular. Check silly stuff first, such as spelling. Try to paste the intersection into the database > data records too see if it returns something (my guess it will return an error, similar, that you posted already).
Thanks much!
I didn't know about the Database -> Data Records screen, and this will help a lot.