Forum Discussion

chuckbo's avatar
chuckbo
New Contributor III
4 years ago

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, and the title of the Dialog Box is "Extensible Finance." Should I be looking for a confirmation or a business rule with that name? The error text is "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" which I recognize as a ... I forget the term but I think of it as the filter parameters.

But I'm not sure where to look for this. If I scroll down further in the task activity and open the error message to see the details, I see a line that says 
     Source code: ConfirmationEngineWcf.cs, line 133, method ExecuteConfirmation

Is there a rule called ConfirmationEngineWcf that I should be looking for?

Chuck

Finance
  • Koemets's avatar
    Koemets
    4 years ago

    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).

  • RachealCrowder's avatar
    RachealCrowder
    New Contributor III
    4 years ago

    Hi Chuck,

    Based on the details you've provided, the rule in error is not clear.  Perhaps add a screenshot of the error and/or the full text of the error message.  Confirmation Business Rules are generally stored on the Confirmation Rule itself, although, they may be configured to call a rule in the Rule library.  To view the text of the rule, do the following:

    1) Navigate to Application tab

    2) Select Workflow

    3) Select Confirmation Rules

    4) Identify and select the appropriate Rule Group

    5) Identify and select the appropriate Rule

    6) Click the Edit Rule Formula icon to view and edit the rule formula

     

     

  • chuckbo's avatar
    chuckbo
    New Contributor III
    4 years ago

    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?

     

     

    • chuckbo's avatar
      chuckbo
      New Contributor III
      4 years ago

      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 InternalGetDataCellUsingScript

      Stack Trace: [snip]

    • Koemets's avatar
      Koemets
      Contributor
      4 years ago

      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).

      • chuckbo's avatar
        chuckbo
        New Contributor III
        4 years ago

        Thanks much! 

        I didn't know about the Database -> Data Records screen, and this will help a lot.