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

Ruleset not regenerated

Hi All,

I am trying to regenerate the global risk ruleset but the job terminated with a runtime error SAPSQL_ARRAY_INSERT_DUPREC.

it is giving ST22 dump if i generate foreground.

Could you please let me know how can we fix this.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Jul 20, 2016 at 01:38 PM

    Hi Pravin,

    Could you please check the below SAP notes for the dump you facing

    2236171
    2183633

    Regards,
    Khushboo Kapur

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 01:58 PM

    Hi Pravin,

    Can you run the program "GRAC_GENERATE_RULES" in the background and check if you are getting the same error?

    When regenerating the SOD rules for all the Risks it is advisable to run it in the background.

    In case you face any other issue let us know your GRC version and SP level.

    Regards,

    Manju

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Manju,

      Thank you for your reply and help.

      I am getting same error SAPSQL_ARRAY_INSERT_DUPREC when I execute the program "GRAC_GENERATE_RULES" in the background and fore ground.

      Release is V1000 and SP Level is 0013 and Support pack is SAPK-V1013INGRCFNDA.

  • Posted on Jul 20, 2016 at 02:33 PM

    Hello Pravin,

    Please go through below thread. This seems to be similar issue.

    As I understand it is due to duplicate records in your ruleset. Please recheck for any duplicate records and try to run the job again. Hope this helps.

    https://scn.sap.com/thread/2076533

    Regards,

    Surya

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2016 at 09:00 PM

    Hello Pravin,

    upgrade SP..

    if GRC 10 go with SP minimum 20

    for 10.1 go minimum SP 10

    Regards,

    Prasant

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21, 2016 at 01:19 AM

    Hello Pravin N,

    Check if both Logical group and Cross System Group are maintained against the connector group.

    Also, please confirm if you are getting the same dump error when you are running batch risk analysis also. If so, the following note will resolve your issue.

    2152723 - Batch Risk Analysis ending in SAPSQL_ARRAY_INSERT_DUPREC

    Regards,

    Rakesh Ram M

    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.