Issue in importing package in IDM 8.0

[saurabh_sharma19]

Hello Experts,

I am facing issue in re importing package after upgrade from 8.0.0 to 8.0.1.

This issue is not in particular to a specific package.Getting the same error for all packages.

To check this issue further have created a new Identity Store and try to import the package but getting the same error .

Need help to understand this issue.

[former_member187331]

Actually GA was planned for the end of this month, but I think the Devs can give you a more precise date.

Greetings, Aydin

[todor_boyadzhiev]

Hi

It will be a bit later than that but stay tuned. We are cooking it.

Regards,

Todor

[todor_boyadzhiev]

Hi Saurabh,

can you please provide us with more logs about this issue.

It might be caused by multiple reasons but we need to know more in order to help you out.

Regards

Todor

[saurabh_sharma19]

Hi Todor ,

Thanks for your reply!!

When we are trying to import the package we are getting below pop up and once we click OK no other logs come .

Can you please tell me where I can check the logs / other details about this issue in my system.

[former_member187331]

Hello Saurabh,

we had the same issue with our 7.2 content.
In IdM 8 you should double-check your logs: the one in Eclipse and the one in ASJava.

Login into your NWA -> search for Log Viewer -> View (in Action Bar) -> Open View -> Developer Traces.

We could fix a similar bug by deleting all task specific attributes (references on Tasks for example) in IdM 7.2, export the IS and reimport in 8.0.

In SP2 this issue should be resolved by the developers.

Greetings, Aydin

[saurabh_sharma19]

Hi Aydin ,

Thanks for your reply!!

We are getting below error message in the Developer Traces .

"SQL error occurred on connection ***INTBMVSE1D:MXMC_db:MXMC_admin_u: code={0,number,integer}, state="S00062", message="Could not find stored procedure 'mc_FixTaskGroups'.";
SQL statement is "{call mc_FixTaskGroups(?)}".

I checked in database and didnt find this store procedure"mc_FixTaskGroups".

Regards,

Saurabh

[former_member187331]

Hello Saurabh,

did you update/install the mxmc-schema? Which version is your install schema?

**i think mc_FixTaskGroups was added in SP2, I had issues installing it because it was published with a syntax-error (using + instead of || in Oracle)**

Greetings, Aydin

[saurabh_sharma19]

Hi Aydin,

Thanks for your reply .

Yes we have recently upgraded mxmc-schema .

Current Version :8.0.1-SQL-2015-12-21

Database Schema Version: 1601

Regards,

Saurabh

[former_member187331]

Hello Saurabh,

this is strange. I cant find mc_FixTaskGroups in Schema version 1601. There should be no references to it in SP1, so maybe you are mixing the service packs maybe?

We are currently beta-testing SP2 and at Schema version 1654 there is a proc called FixTaskGroups.
**HIGHLY EXPERIMENTAL** You could add this to your 5D-create-procs.sql to get it working **/HIGHLY EXPERIMENTAL**

prompt mc_FixTaskGroups
CREATE OR REPLACE PROCEDURE mc_FixTaskGroups (pkg number)
IS
    task number(10);
    current_task number(10);
    parent number(10);
    folder number(10);
    log_text varchar2(80);
    CURSOR tasks IS
        SELECT TASKID FROM MXP_TASKS WHERE TASKGROUP IS NULL AND TASKTYPE = 1 AND ACTIONTYPE IN (-1, -2) AND WAITBEFORE = 0 AND WAITAFTER = 0 AND MCPACKAGEID = pkg;


    BEGIN

        OPEN tasks;
        LOOP
            FETCH tasks INTO task;
            EXIT WHEN tasks%NOTFOUND;

            BEGIN
                SELECT TASKREF INTO parent FROM MXP_TASKLNK WHERE TASKLNK = task;
                EXCEPTION WHEN no_data_found THEN
                    parent := NULL;
            END;

            IF parent IS NULL THEN
                BEGIN
                    log_text := 'Folder not found for task: ' || TO_CHAR(task);
                    mc_write_syslog(log_text, '', 2, '', 0);
                    CONTINUE;
                END;
            ELSE
                BEGIN
                    BEGIN
                        SELECT TASKGROUP INTO folder FROM MXP_TASKS WHERE TASKID = parent AND MCPACKAGEID = pkg;
                        EXCEPTION WHEN no_data_found THEN
                            folder := NULL;
                    END;
                    WHILE folder IS NULL
                    LOOP
                        current_task := parent;

                        BEGIN
                            SELECT TASKREF INTO parent FROM MXP_TASKLNK WHERE TASKLNK = current_task;
                            EXCEPTION WHEN no_data_found THEN
                                parent := NULL;
                        END;

                        IF parent IS NULL THEN
                            log_text := 'Folder not found for task: ' || TO_CHAR(task);
                            mc_write_syslog(log_text, '', 2, '', 0);
                            EXIT;
                        ELSE
                            BEGIN
                                SELECT TASKGROUP INTO folder FROM MXP_TASKS WHERE TASKID = parent AND MCPACKAGEID = pkg;
                                EXCEPTION WHEN no_data_found THEN
                                    folder := NULL;
                            END;
                        END IF;
                    END LOOP;
                END;
            END IF;

            IF folder IS NOT NULL THEN
                UPDATE MXP_TASKS SET TASKGROUP = folder WHERE TASKID = task;
            END IF;
        END LOOP;
        CLOSE tasks;
    END;
/


GRANT  EXECUTE ON &&PROC. mc_FixTaskGroups  TO &&PREFIX._admin_role;
/

Better if you wait for SP2 for it, but maybe this solution works out for you too.

Greetings, Aydin

[saurabh_sharma19]

Hello Aydin,

Do we have a tentative date for SP2 release?

Regards,

Saurabh

[todor_boyadzhiev]

Hey Saurabh,

This stored procedure is introduced in SP1, that means that there is something wrong with your database update.

It seems you have the newest devstudio rest deployed but your Designtime is older.

Please use the latest patch for SP1. It contains this stored procedure. When you run the mxm-update with the latest patch for SP1 - Designtime. you would get the things working.

Regards

Todor

[saurabh_sharma19]

Hi Todor,

Thanks for your reply!!.

We have reverted our changes and will start the upgrade process again.

Will keep your suggestion is mind while running the mxmc-update .

Regards,

Saurabh