IdM 7.2 SP9 Systemcopie error by update to_date function

[Former Member]

Hi,

I want to do a system copy from my SAP IdM 7.2 SP9 with the "SAP NetWeaver Identity ManagementSystems Copy Export File - System Copy Jobs" tools from SDN.

In step 6, I go a lot of issue like this

INSERT INTO MXI_LINK(MCUNIQUEID,MCADDEDTIME,MCASSIGNEDDIRECT,MCASSIGNEDDYNAMICGROUP,MCASSIGNEDINHERITCOUNT,MCASSIGNEDMASTERPRIVILEGE,MCASSIGNER,MCATTRID,MCAUDITID,MCCHANGENUMBER,MCCONTEXTAUTO,MCCONTEXTCATEGORY,MCDIRTY,MCDISABLED,MCEXECSTATE,MCEXECSTATEHIERARCHY,MCLINKSTATE,MCLINKTYPE,MCMISSINGCONDITIONALCONTEXT,MCMODIFYTIME,MCNOTALLOWEDFOR,MCORPHAN,MCOTHERENTRYTYPE,MCOTHERMSKEY,MCSODVIOLATION,MCTHISENTRYTYPE,MCTHISMSKEY,MCUNSUPPORTEDCONTEXTTYPE,MCCHECKLINK,MCCONTEXTSTR1,MCCONTEXTSTR2,MCDELREQUESTID,MCDIRVALIDFROM,MCDIRVALIDTO,MCGROUPGUID,MCLASTAUDIT,MCMODIFY,MCMODIFYNEWVALIDFROM,MCMODIFYNEWVALIDTO,MCMODIFYREASON,MCMODIFYVALIDITY,MCPROCESSINFO,MCREASON,MCREPOSITORY,MCREQUESTID,MCVALIDFROM,MCVALIDTO)
 VALUES (173,to_date('2013-05-27 16:05:21.0', 'YYYY-MM-DD HH24:MI:SS'),1,0,0,0,-3,624,0,10207344,0,0,0,0,1025,1025,2,0,0,to_date('2014-03-24 13:34:12.0', 'YYYY-MM-DD HH24:MI:SS'),0,0,64,157,0,64,267,0,to_date('', 'YYYY-MM-DD HH24:MI:SS'),N'',N'','',to_date('', 'YYYY-MM-DD HH24:MI:SS'),to_date('', 'YYYY-MM-DD HH24:MI:SS'),'',0,to_date('', 'YYYY-MM-DD HH24:MI:SS'),to_date('', 'YYYY-MM-DD HH24:MI:SS'),to_date('', 'YYYY-MM-DD HH24:MI:SS'),N'',to_date('', 'YYYY-MM-DD HH24:MI:SS'),N'',N'',10,'',to_date('', 'YYYY-MM-DD HH24:MI:SS'),to_date('', 'YYYY-MM-DD HH24:MI:SS'))

- Exception:java.lang.Throwable: ORA-01830: date format picture ends before converting entire input string

The problem is, that the task read a date feld as "2013-05-26 17:05:21.0" (and not "2013-05-26 17:05:21). I don't understand, why my dispatcher execute the select statement with result with milliseconds from the source database.

My environment is Oracle 11.2.0.4.

Does anybody knows this issue?

Best regards,
Jan

[ole_k_rosberg · Accepted solution]

Hi Jan,

When source db and target db is the same, you should use a db copy tool.

Anyway, the problem is possibly in the scripts creating the copy jobs (Step 4 and 5)

Both these have a script called AddPasses.

You could try to modify these scripts like this:

Change

<mx:value>to_date('%" + ColName + "%', 'YYYY-MM-DD HH24:MI:SS')</mx:value>

to

<mx:value>to_date(substr('%" + ColName + "%', 1, 19), 'YYYY-MM-DD HH24:MI:SS')</mx:value>

There are 5 occurences of this in the step 4 and 3 in step 5.

The rerun the whole process.

Regards,

Ole k.