cancel
Showing results for 
Search instead for 
Did you mean: 

IDM Error RDS - F:Could not insert into table MXP_TASKPARAMETERS

former_member184114
Active Contributor
0 Kudos

Dears,

I am following RDS 7.2 and trying to import the .mcc files accompanied with it. I have successfully imported the .mcc files for Identity Store Schema and Job Folder. However, when I tried to import .mcc for Provisioning Folder, I got below error:

01.01.2017 17:11:13 :W:Insert failed for columns: MCTASKID,MCKEY,MCVALUE,MCTYPE values:[6081, MX_APPROVERS, , 14]
01.01.2017 17:11:13 :F:Could not insert into table MXP_TASKPARAMETERS
01.01.2017 17:11:13 :I:Rolling back

Can anybody please help me resolve this issue?

Regards,

Faisal

former_member2987
Active Contributor
0 Kudos

Hi Faisal,

When something like this happens to me, I usually re-run mxmc-update. The other thing to do is make sure that all of your components (Designtime / Runtime) are up-to-date and match. This is a big issue where these types of errors are concerned.

Also check with your DBA and make sure none of the rights on the mxmc users have been changed (one of the things re-running mxmc-update fixes)

Regards,

Matt

former_member184114
Active Contributor
0 Kudos

Matt,

Thanks for your reply.

I had raised a message with SAP and have been asked to upgrade it to SP#4. It is in progress, will update on this once done.

Regards,

Faisal

former_member2987
Active Contributor
0 Kudos

Faisal,

Well, you'll certainly need to do a schema update then 🙂

Trying to remember, are you using 7.2 or 8?

Matt

former_member184114
Active Contributor
0 Kudos

Matt,

I have upgraded IDM SP to SP#4 and re-ran imports. This went successfully.

I am on IDM 7.2, SP#4

former_member2987
Active Contributor
0 Kudos

Faisal,

I'd suggest going with the latest SP available to you, in that case. Lots of good things post SP4. 🙂

Matt

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184114
Active Contributor
0 Kudos

Can anybody please advise me on this please?

Regards