Ruleset not regenerated

[former_member857987]

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.

[former_member185447]

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

[former_member193066]

Hello Pravin,

upgrade SP..

if GRC 10 go with SP minimum 20

for 10.1 go minimum SP 10

Regards,

Prasant

[surya_appala]

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

[former_member857987]

Hi Surya,

Thank you for your reply.

I have checked the thread 2076533, but it doesn't look relevant to my issue. I am facing the issue in GRC system when I am re-generating the risk ruleset.

Regards,

Pravin

[surya_appala]

Hi Pravin,

Even though the error is in GRC system the nature of Dump "SAPSQL_ARRAY_INSERT_DUPREC" is same. So just want to inform you if in case there are duplicate records in your ruleset.

Regards,

Surya

[Former Member]

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

[former_member857987]

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.

[former_member288983]

Hi Pravin,

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

2236171
2183633

Regards,
Khushboo Kapur