Forum Stats

  • 3,813,983 Users
  • 2,258,800 Discussions
  • 7,892,461 Comments

Discussions

Unable to export the MSAD users through importexport utility - Repost

arulp
arulp Member Posts: 41
edited Jul 8, 2011 2:32PM in EPM System Infrastructure
When i run the CSSExport importexport.properties utility i receive the following error. Any ideas/suggestions will greatly help me

Trace...
2011-06-15 07:13:43,697 Attempting an export operation
2011-06-15 07:13:45,400 Attempting a CSV export operation
2011-06-15 07:14:56,632 Export : Exporting users...
2011-06-15 07:14:56,788 Export : Exception encountered
2011-06-15 07:14:56,788 Export : Root cause : null
null
Aborting program...

Here is how my importexport.properties file would look like

importexport.css=http://...com:58080/interop/framework/getCSSConfigFile
importexport.cmshost=Sharedservices server name 9.3.1
importexport.cmsport=58080
importexport.username=admin
importexport.password=password
importexport.enable.console.traces=true
importexport.trace.events.file=D:/.../trace.log
importexport.errors.log.file=D:/..../errors.log
importexport.locale=en
importexport.ssl_enabled=false
export.fileformat=csv
export.file=D:/...../export.xml
export.internal.identities=true
export.native.user.passwords=true
export.provisioning.all=true
export.delegated.lists=false
export.user.filter=*@MSAD-1
#export.group.filter=*@MSAD-1
#export.role.filter=*
export.producttype=*
#export.provisioning.apps=(HUB=Global Roles)
#export.projectnames=HUB
#export.applicationnames=Global Roles

Thanks
Ap

Answers

  • 552406
    552406 Member Posts: 194
    Hi,

    Run the SyncOpenLDAP utility which will Sync All users / Groups on OpenLDAP database.

    Then try to run the Shared Services CSSImport /Export utility.

    Hope this help.

    Regards,

    Manmohan Sharma
  • arulp
    arulp Member Posts: 41
    Manmohan, Thanks for your response !

    I did the sync ldap. But I always get the null error. I could not find any detailed error messages anywhere

    D:\>CSSExport importexport.propertie
    s
    null
    Aborting program...
  • In your importexport.props file, try changing the export.user.filter field back to *@Native Directory. The css tool is going to try and dump the entire contents of whatever directory provider is named here, as defined in Shared Services; if you have MSAD hooked up to HSS and named MSAD-1, the css tool is going to literally try and export every user in Active Directory that Shared Services has the ability to find. If that's what you're trying to do, and it's a large domain, you could well be running the css tool out of memory, in which case you can add -Xms and -Xmx arguments to the Java command in cssexport.bat. From a Hyperion standpoint, though, that's not really that useful -- it won't give you any provisioning info, native users, etc. It will literally just copy the AD contents to an XML file. If you're trying to get provisioning and user data for AD users, just export everything from *@NativeDirectory and use whatever your favorite text editor is to strip out any unnecessary users (it's very simple to do when you read the structure of the XML file). Good luck!
  • GaneshN-Oracle
    GaneshN-Oracle Member Posts: 1 Employee
    In the import export properties using '*' instead of '*@MSAD-1'.
    Default is '*@NativeDirectory'
    replace export.user.filter=*@MSAD-1 by export.user.filter=*
This discussion has been closed.