Skip to Content
avatar image
Former Member

IdM 7.2 SP9 Systemcopie error by update to_date function

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 17, 2015 at 08:00 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 15, 2015 at 11:32 PM

    Hi Jan,

    Which .MCC file did you use?

    Is Oracle your target DB or source DB?

    Kind regards,

    Jai

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2015 at 07:32 AM

    Hi Jannis,

    Could you explain me your question? Do you think, I could copy the IdM tablespace with DB copy tools?

    I hope, that the copy Tools from SDN change some General value, isn't it?

    Best Regards,

    Jan

    Add comment
    10|10000 characters needed characters exceeded

    • I was able to copy the IdM DB at a customer side from Prod to Dev once in a while.

      This was MSSQL, but I don't know why it should not work with ORA too.


      I did not get your question. 

  • avatar image
    Former Member
    Jul 20, 2015 at 08:13 AM

    Thank, that solve my problem

    Add comment
    10|10000 characters needed characters exceeded