Skip to Content

Alert KF Not working and giving SQL error?

Hello All,

I have configured Below Alert KF and while pulling this into Planning view I am getting below SQL error.

alert.jpg (127.6 kB)
error.jpg (57.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Oct 31, 2019 at 02:03 PM

    1) Your formula does not catch it correctly, try this (might need some rework, but you should be able to catch my meaning)

    IF(
    (ISNULL("CEDUNCONSTRCONSFCST@MTHPRODLOCCUST") OR "CEDUNCONSTRCONSFCST@MTHPRODLOCCUST" = 0) AND (ISNULL("CEDUNCONSTRCONSFCSTPC@MTHPRODLOCCUST") OR "CEDUNCONSTRCONSFCSTPC@MTHPRODLOCCUST" = 0),
    99999,
    IF(
    ABS("CEDUNCONSTRCONSFCST@MTHPRODLOCCUST" - "CEDUNCONSTRCONSFCSTPC@MTHPRODLOCCUST") / (("CEDUNCONSTRCONSFCST@MTHPRODLOCCUST" + "CEDUNCONSTRCONSFCSTPC@MTHPRODLOCCUST") / 2) > 0.5,
    1, 0 )
    )

    2) You still did not share the VALUES of the input KF, as described in my last reply. I will not reply any more without the values :-)

    3) Can you please re-post a proper full screenshot of the config of your input KF's? The last screenshots from them looked a bit weird because in the header it stated it was the input KF, but the formula had seem to be from the target KF.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2019 at 08:32 PM

    i cannot see the values of your two input kr, but if both are either 0 or NULL it would fail because you do not catch devision by zero

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2019 at 09:10 PM

    I meant the value if the input, not the configuration

    You have a formula where you do not catch how to treat deviding by zero which would lead to infinite result and hence throw error

    So, is in your example the sume of both input kf = 0?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2019 at 09:17 PM

    it may

    You can check by log on without immediately pull the resulting kf, and only check the input

    However, you beed to adjust your formula in any case, so just build in an if clause checking for sum of the input equalingbzero and setting a specific result in that case, else result is your initial formula

    Than try again

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 31, 2019 at 09:22 AM

    Hi Rahul

    you must ALWAYS catch devisions by zero in your formula, as this can always lead to issues. Not sure if that is the root cause for your case as I dont have the full picture of the values.

    But you can always pull the values by creating a planning view that ONLY contains the input KF, or by using the master data workbooks and within that the planning combination view.

    Before you reply, make sure that you

    1) have corrected the formula

    2) in case you still get an error provide a screenshot of the input values as described above

    If you dont provide that, any further analysis will not be possible

    Yours, Irmi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.