IdM 7.2 SP04 initial load issue

[Former Member]

Hello Expert,

Today i'm installing an SAP IdM 7.2 SP04 ,running on SQL including HCM instance with 3 abap, 3 java and 1 AD. So far i have install the VDS for HCM and made the connection.

All my repository are setup and my HCM system if define as the Master for provisioning, my problem is when i try to run the initial load from any of me system defined i have the following errors

Pass: Messages that occurred before the job was loaded

         warning : mc_get_exec_stat_threshold Failed. SQL: {call mc_get_exec_stat_threshold(?)}

                        com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'mc_get_exec_stat_threshold'.

Pass: Create Account Attribute 

          error : SQL Update failed. SQL:execute mxi_schema_create_attr_ns

          error : com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to int.

          error : putNextEntry failed storingNo_DeltaKey

Pass: Create System Privilege

          error : putNextEntry failed storingPRIV:SYSTEM:BPP_NW

                    Exception from Modify operation:com.sap.idm.ic.ToPassException: ToIDStore.modEntry failed updating entry 'PRIV:SYSTEM:BPP_NW'. IDStore returned error message: "No such attribute" when fetching entry

Pass: Create ABAP Account Privilege

         error : Exception from Modify operation:com.sap.idm.ic.ToPassException: ToIDStore.modEntry failed updating entry 'PRIV:BPP_NW:ONLY'. IDStore returned error message: "No such attribute" when fetching entry

I make it short, but for the rest of the action it's the same error mentioned above.

I tried to found out over teh market place but nothing helped me, if you have some suggestion it will be nice.

Thank you

[Former Member · Accepted solution]

Hi,

1.  Make sure that "automatically create attributes" is turned on in your ID store

2.  Make sure you have imported the SAP Provisioning framework before running any initial loads.

Regards,

Chris

[Former Member · Accepted solution]

Hello Chris,

Thanks for your answer,  the "automatically create attribute" on my ID Store "enterprise_people" is checked and the provisioning framework has been imported too.

I have deleted the framework and re-imported but there is no change.

Did i miss a step ?

- Create the repositories

- Check the auto create att. in ID store

- Import the  Framework for the ID store

- Create the inital load job for each of repositories

- Run the job initial load

Thank for your answer

[Former Member · Accepted solution]

Solved, i figure it out

[former_member2987 · Accepted solution]

Ruter,

What was the answer?

[Former Member · Accepted solution]

Hello Matt,

The problem was from the attribute in my Global Constants SAP_MASTER_IDS_ID, the system was not able to handle it with the right number of ID Store.

So to solve it i have removed the constant entry, recreate it, stop/start the dispatcher and re-launch the initial load.

Williams