Skip to Content
author's profile photo Former Member
Former Member

Error While Creating a EUP request

Hi All,

Created a BRF Plus Initiator rule and configured in MSMP Workflow Management. While creating a EUP request and when clicked 'Submit' then facing below two errors

1)No active function version found

2)Request submit failed; error in MSMP submit method

Tried to remove the existing rules Via 'GRFNMW_CONFIGURE'. Then again tried to configure this customized rule via MSMP and then tried creating Versions Via 'GRFNMW_GEN_VERSION' Getting an error

'The system tried to insert a data record, even though a data record with the same primary key already existsCX_SY_OPEN_SQL_DB=>D'

Please help me in this regard. This issue is troubling me a lot!!!

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Aug 28, 2013 at 10:39 PM

    Hi Sharat

    How many initiator rules do you have in your configuration for that MSMP Process Id?

    Possibly try to generate from the the MSMP Worflow Management as it might give you more information on the error message when you test/generate.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sharat

      I think you may have misunderstood the "Function Group" if you are referring to transaction GRFNMW_DEV_RULES. There is a field called Application/Function Group Name. If you have chosen Rule Type of BRFPlus, then the name you place there will be created in BRFplus by this program.

      What "documentation" do you have that you are referring to?

      If you choose Generate Options of Generate Rule and Gen Result Work area (BRF+) it will create the decision table structure for you with the columns you need

      For the Line Item - this field is used when the BRFPlus rule is line by line and you want to evaluate/route each line individually. If you want to route the request as a whole, then enter the value asterisk (*)

      The next bit to check (Since you aren't providing screen shots) is the Function Id you entered in the MSMP Initiator Rule. Did you enter the ZName or the actual BRFPlus Id (you have to go into BRF+ and look at the function id name - it will be a heap of numbers/letters).

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 03:50 AM

    Dear Sharat,

    Please check the following

    1. Check if the function that you have created in the BRF+ is active.

    2. Check of the Decision table is Active.

    3. Run the simulation in the BRF+, enter the required field and check if it is giving the desired output.

    4. In the MSMP, Make sure you have selected this Initiator for the particular process ID and then generate the MSMP version. Check for any error.

    Thanks & Regards

    Japneet Singh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Japneeth,

      In the process of activating the function:

      I have tried to change the Function to 'Event Mode' and activated.

      When I went to MSMP and tried adding this Rule, its saying invalid Rule ID.

      Another interesting point is, when the function is deactivated, and when I try to add this rule in MSMP its taking the value and rule is being added.

      But finally version is not getting activated.

      Regards,

      Sharat

  • Posted on Aug 29, 2013 at 08:56 AM

    Hello,

    go to BRF+ select that function, expand it and see it might be inactive..

    application might be active not the funtion, please active that as well.

    Regards,

    Prasant

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Prashanth,

      After trying to generate the version its saying 'Verion cannot be created'. When tried creating Versions Via 'GRFNMW_GEN_VERSION' Getting an error

      'The system tried to insert a data record, even though a data record with the same primary key already existsCX_SY_OPEN_SQL_DB=>D'

      Again struck with the same error. I have implemented all the steps as per your above suggestions

      No Luck!

      Sharat

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2013 at 09:53 AM

    Hi Sharat,

    I would like to advise you to start creating new BRF+ Initiator and consider the points that our experts mentioned earlier in this post.

    I had observed from your screenshots that BRF+ Rule result ("New Account, Change Account, Super User") and MSMP Rule results (“CHANGE ACCOUNT, NEW ACCOUNT. SUPER USER”)were not matching. please check the highlighted areas of attached screenshots.

    The Rule Result in BRF+ must match with MSMP Rule Result.

    Please try and let me know.

    Regards,

    Venugopal


    Screen1.jpg (61.4 kB)
    Screen2.jpg (73.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Venu,


      Thank you for being very much patient and trying to resolve my issue. As per your above mail, I am just copy pasting the rule results in the above scenarios so that mismatch will not happen.


      When trying to generate versions, I am getting the errors


      1)'The system tried to insert a data record, even though a data record with the same primary key already existsCX_SY_OPEN_SQL_DB=>D'


      2) 'no data is maintained in the Tables GRFNMW....'

      I think mistake lies from my side. In the initial days I have removed the existing/default paths and rule results and due to that might be the tables at the data base level are empty. Now when I am trying to activate the default Version, I could not get the default paths.

      Also when trying to activate BC set 'GRC_MSMP_CONFIGURATION' I am facing warnings like 'View V_GRFNMW_APPROVR: VIEW CLUSTER VC_GRFN_MSMP_WORKFLOW does not contain data'

      I think I need to do some basic configuration settings so that these tables will be populated again with the default MSMP configuration.

      Please let me know if this is fine or do you think I have to work on some thing else so as to resolve this issue.

      Regards,
      Sharat

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.