Question Re: Import/Export Errors in Technology Q&A

Import/Export Errors

Former Member — Tue, 21 Aug 2012 11:37:52 GMT

Hi Experts,

We have installed IDM 7.2. We are trying to import the IDM UI jobs and tasks to Management console. But getting an error which says "Import/Export failed with errors". and the log looks like below.

The log is not very helpful to identify the error. Could anyone help on how to resolve this issue.

Regards,

Krishna.

Re: Import/Export Errors

Former Member — Tue, 21 Aug 2012 14:08:06 GMT

Hi,

You're right, the log is not very helpful, if you want a better log, go to the Import_Start.bat file (.sh) if you're on unix, and adjust command. Comment out the currently active import command and uncomment this one...

REM --- Use this to write the result of an import process to a out file. NOTE!! A new import process can not be started, if the ImXport.log is still open in a text editor.

REM "D:\sapjvm_6\jre\bin\java.exe" -Xms128m -Xmx512m -DDSE_HOME="D:\usr\sap\IdM\Identity Center" com.sap.idm.ic.syncutil.Import %DSEJ_HANDLE% OPERATION=%OPERATION% STARTID=%START_ID% JDBC_DRIVER=%JDBC_DRIVER% JDBC_URL=%JDBC_URL% "LOGFILE=%LOGFILE%" INIFILE=%INIFILE%> "D:\usr\sap\IdM\Identity Center\Import.out" 2>&1

REM goto cleanup

If it does end up being a memory problem, try adjusting the memory paraemter -Xmx512m. Trying 1024 first, and then 2048. You can also try adjusting the other memory parameter, but when i had this problem, just changing -Xmx fixed it.

Good luck!

Regards,

Chris Snyder

Re: Import/Export Errors

Former Member — Tue, 21 Aug 2012 14:38:27 GMT

Hello Chris,

Thanks for your valuable suggestion. But we have installed it on Windows server 2008 R2. Can you suggest how to fix this on windows ?

Regards,

Krishna.

Re: Import/Export Errors

former_member2987 — Tue, 21 Aug 2012 14:57:14 GMT

Krishna,

If you look in Chris' reply you will see that he refers to both the .bat (Windows) and .sh (UNIX/LINUX) files.

Hope this helps,

Matt

Re: Import/Export Errors

Former Member — Wed, 22 Aug 2012 05:23:13 GMT

Hello Matt & Chris,

I have tried the suggestion given above. But it was of no use. Still getting the following error

Could not initialize the Identity Synchronization tool

Please help.

Thanks,

Krish.

Re: Import/Export Errors

former_member2987 — Wed, 22 Aug 2012 13:56:11 GMT

Krishna,

I'd suggest reviewing the installation documentation. I think you missed a step somewhere.

Matt

Re: Import/Export Errors

Former Member — Tue, 18 Sep 2012 21:30:42 GMT

Hi Chris

We got the similar error as well installing IDM 7.2 MSSQL 2008 R2 Enterprise. The database server is centrally managed, using dynamic ports, JDBC 3 with AS JAVA 7,0

Where could be the error lies? We can try your suggestion changing -xmx, and see if it will work.

What value did you assign then? Thanks

Re: Import/Export Errors

Former Member — Tue, 18 Sep 2012 21:36:39 GMT

Hi Chris

you mentioned uncomment this out in "Import_Start", as far as I understood it, this file "Import_Start" is being regenerated from the Import_Template. Shouldn't it be that this needs to be uncomment this on "Import_Template" instead in "Import_Start"

What could be the reason why it is doing this? Thanks

REM --- Use this to write the result of an import process to a out file. NOTE!! A new import process can not be started, if the ImXport.log is still open in a text editor.

REM goto cleanup

Btw, I've checked the "Import_Start" file and this is what I've got below so to uncomment it will result to this, is this correct:

Use this to write the result of an import process to a out file. NOTE!! A new import process can not be started, if the ImXport.log is still open in a text editor.

REM "C:\Program Files (x86)\Java\jre6\bin\java.exe" -Xms128m -Xmx512m -DDSE_HOME="C:\usr\sap\IdM\Identity Center" com.sap.idm.ic.syncutil.Import %DSEJ_HANDLE% OPERATION=%OPERATION% STARTID=%START_ID% JDBC_DRIVER=%JDBC_DRIVER% JDBC_URL=%JDBC_URL% "LOGFILE=%LOGFILE%" INIFILE=%INIFILE%> "C:\usr\sap\IdM\Identity Center\Import.out" 2>&1

REM goto cleanup

Re: Import/Export Errors

Former Member — Wed, 19 Sep 2012 07:20:11 GMT

Krishna, did you use sapjvm6?

Re: Import/Export Errors

Former Member — Wed, 19 Sep 2012 09:54:05 GMT

Hi Matt

have you got any idea why it is coming up this error message. We tried to change it as Chris suggested and below is the changes on our import_Template.bat

Would appreciate any help. Thanks

Re: Import/Export Errors

Former Member — Wed, 19 Sep 2012 13:16:01 GMT

Tin,

Yes we are using sapjvm6

Regards,

Krishna.

Re: Import/Export Errors

Former Member — Wed, 19 Sep 2012 14:03:46 GMT

Krishna did you get a message first which says: couldn't create connection to the database?

What message did you get first before displaying the log file?

Re: Import/Export Errors

former_member2987 — Wed, 19 Sep 2012 15:11:46 GMT

See my comments in my other post.

Quick recap,

Check Database user rights

Check Keys.ini

Check NW Admin set up.

Re: Import/Export Errors

Former Member — Wed, 19 Sep 2012 15:25:01 GMT

Krishna, did you resolve it your issue importing the tasks?

Re: Import/Export Errors

Former Member — Wed, 19 Sep 2012 15:25:32 GMT

Matt thanks will check those and see if they are OK

Re: Import/Export Errors

Former Member — Thu, 20 Sep 2012 07:01:08 GMT

Tin,

When we tried to import the jobs/tasks on cient machine ( MMC installed on a desktop other that server), we are getting the same error as you mentioned above " Couldn't create connection to the database"

But when we tried to import on the server machine, we were getting error " Import/export exited with errors, pls check the logs" . For this , we have rasied a OSS with SAP, but awaiting reply.

You try once importing the jobs/tasks on the server machine.

Regards,

Krishna.

Re: Import/Export Errors

Former Member — Thu, 20 Sep 2012 07:02:36 GMT

Tin,

We still have the issue while importing.

Exporting works fine in my case.

Regards,

Krishna.

Re: Import/Export Errors

Former Member — Thu, 20 Sep 2012 07:05:30 GMT

Tin,

The error logs generated doesnt help much to unerstand the actual cause of the issue. So, by commenting out and uncommenting the lines what Chris has suggested, When import is tried, the details log is created to a file ( import.out) , which gives some clue for the cause of the issue. You can refer to the SAP NOTE 1436169. which might help you.

Thanks,

Krishna.

Re: Import/Export Errors

Former Member — Tue, 25 Sep 2012 10:31:18 GMT

Hi Matt

We found out some interesting result.

What we have discovered is the problem is related to the inability of the idm system to match the encrypted JDBC URL with that held in the SQL database. We have tried to modify the varvalue in the database directly associated with the JDBC URL And the RT Connection string but they seem to be fixed.

If we manually modify the import_start file (which is the manually putting the encrypted value of the JDBC URL from the SQL database to the import_start file) and run this from the command prompt changing the JDBC URL in the import_start.bat to either the RT user connection string or the admin user connection string it then works. - the import wizard will open

But if we try from the MMC and import it there, the error will pop-up.

Any suggestion why is this happening?

Thanks

Re: Import/Export Errors

Former Member — Tue, 25 Sep 2012 10:59:28 GMT

No Tin,

We still hv the issue. Did you find any solution ? If Yes, pls do share

Thanks,

Krishna.