Skip to Content
0

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

Jan 01, 2017 at 02:44 PM

52

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

0

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

0

Faisal,

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

Trying to remember, are you using 7.2 or 8?

Matt

0

Matt,

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

I am on IDM 7.2, SP#4

0

Faisal,

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

Matt

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Faisal Khan Jan 02, 2017 at 05:50 AM
0

Can anybody please advise me on this please?

Regards

Share
10 |10000 characters needed characters left characters exceeded