Forum Stats

  • 3,783,611 Users
  • 2,254,809 Discussions
  • 7,880,485 Comments

Discussions

11.1.1.4 Shared Services Users migration success but unable to see users

910964
910964 Member Posts: 15
edited Jan 31, 2012 7:50AM in EPM System Infrastructure
Hi All,
I have executed LCM migration from 11.1.1.4 exported Native Directory user/groups/roles from shared services to file system.And edited the .csv files and executed the Utillity.bat.It showed the migration is success but unable to see the users/groups/roles.
log file:
2012-01-23 01:57:54,899 INFO - Executing package file - D:/OracleHyperion/common/import_export/msr/PKG_5.xml
2012-01-23 01:57:56,344 INFO - Reading HSS URL from command line
2012-01-23 01:57:56,344 INFO - HSS URL could not be read from command line. Reading from registry.
2012-01-23 01:57:59,174 INFO - Audit Client has been created for the server http://livq8webhy02.r1-core.r1.net:28080/interop/Audit
2012-01-23 01:58:00,373 INFO - Client Enable Status false
2012-01-23 01:58:00,729 INFO - Client Enable Status false
2012-01-23 01:58:06,228 INFO - Audit Client has been created for the server http://livq8webhy02.r1-core.r1.net:28080/interop/Audit
2012-01-23 01:58:10,501 INFO - Export Successful- /Native Directory/Users
2012-01-23 01:58:11,200 INFO - Export Successful- /Native Directory/Groups
2012-01-23 01:58:11,874 INFO - Export Successful- /Native Directory/Roles
2012-01-23 01:58:12,520 INFO - Export Successful- /Native Directory/Delegated Lists
2012-01-23 01:58:13,700 INFO - Export Successful- /Native Directory/Assigned Roles/Reporting and Analysis/Reporting and Analysis
2012-01-23 01:58:14,638 INFO - Export Successful- /Native Directory/Assigned Roles/Foundation/Shared Services
2012-01-23 01:58:15,818 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/TESTAPP1
2012-01-23 01:58:16,774 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/TESTAPP
2012-01-23 01:58:17,809 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/SAMPLEAPP
2012-01-23 01:58:18,783 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/QACFGIT
2012-01-23 01:58:19,727 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/FSGQA
2012-01-23 01:58:20,715 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/FSGCCR
2012-01-23 01:58:21,700 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/CFGRPTG
2012-01-23 01:58:22,693 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/CFGCC
2012-01-23 01:58:23,662 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/AHPROD3
2012-01-23 01:58:24,781 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/AHPROD2
2012-01-23 01:58:25,771 INFO - Export Successful- /Native Directory/Assigned Roles/Default Application Group/AHEXP
2012-01-23 01:58:26,965 INFO - Migration Status - Success

please suggest me where can i find all the users/groups/roles?

Edited by: 907961 on Jan 24, 2012 1:07 AM

Best Answer

  • User741275-Oracle
    User741275-Oracle Member Posts: 2
    Accepted Answer
    Can you check the SharedServices_Security_Client.log file which you can find it under the LCM utility directory or in temp directory (%TEMP% or /var/tmp or /var/temp). Do you see any subset of the users/groups/roles that you intended to import or you don't see any of them? If this log file is not helping in narrowing down the problem, You can change the log level to DEBUG in Shared Services UI for the security and restart Shared Services and then re-run the import.

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    The log indicates that an export was run, how about the import?

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 910964
    910964 Member Posts: 15
    sorry i loaded the exported file,
    please find the import file lcm/log:
    -----------------------------------
    2012-01-23 08:20:32,170 INFO - Executing package file - D:\lcm\lcmdefinition.xml
    2012-01-23 08:20:32,576 INFO - Reading HSS URL from command line
    2012-01-23 08:20:32,577 INFO - HSS URL could not be read from command line. Reading from registry.
    2012-01-23 08:20:34,744 INFO - Audit Client has been created for the server http://livq8webhy02.r1-core.r1..net:28080/interop/Audit
    2012-01-23 08:20:36,202 INFO - Client Enable Status false
    2012-01-23 08:20:36,530 INFO - Client Enable Status false
    2012-01-23 08:20:50,210 INFO - Message after RemoteMigration execution - Success. Shared Services log file is in - D:\OracleHyperion\common\utilities\LCM\9.5.0.0\logs\LCM_2012_01_23_08_20_31_0.log.
    2012-01-23 08:20:50,296 INFO - ESTIMATE REPORT IS COPIED INTO FILE - D:\OracleHyperion\common\utilities\LCM\9.5.0.0\reports\estimate_01_23_2012_08_20_50_274_AM.txt

    report:(lcm/report)
    ----------
    ERROR MESSAGES - 0

    TASK SEQUENCE NUMBER - 0
    TASK IDENTIFIER - 1
    EXECUTION - USING HSS FILE SYSTEM
    SOURCE DETAILS -
    FILTER DETAILS -
    FILTER PARAMETERS :- ARTIFACT PATH = /Native Directory,NAME PATTERN = *,START DATE = ,END DATE = ,MODIFIED BY = null,IS RECURSIVE = true,ARTIFACT TYPE =
    CONNECTION DETAILS :
    NAME = FileSystem-Connection2
    TYPE = FileSystem
    HSS CONNECTION = MyHSS-Connection1
    APPLICATION RESOURCE DETAILS -
    PRODUCT NAME -
    PRODUCT CODE -
    PRODUCT VERSION -
    LCM CONNECTION STRING - file:/D:/lcm/qanew1

    TARGET DETAILS -
    CONNECTION DETAILS :
    NAME = AppConnection1
    TYPE = Application
    HSS CONNECTION = MyHSS-Connection1
    APPLICATION RESOURCE DETAILS -
    PLUGIN TYPE - web
    APPLICATION ID - 1111
    APPLICATION NAME - Shared Services
    PRODUCT NAME - HUB-9.5.0
    PRODUCT CODE - HUB
    PRODUCT VERSION - 9.5.0
    PROJECT NAME - Foundation
    LCM CONNECTION STRING -
    PRODUCT RESOURCE DETAILS -
    SYSTEM PROPERTIES -
    NAME = GroupingSupport, VALUE = false
    NAME = MetadataForFolderSupport, VALUE = false


    ARTIFACTS TO BE MIGRATED GROUPED BY ARTIFACT TYPE -
    TASK WITH SEQUENCE NUMBER - 0

    ARTIFACT TYPE - folder
    ARTIFACT PATH, ALIAS PATH, ARTIFACT ID
    /Native Directory | /Native Directory | Native Directory
    /Native Directory/Assigned Roles | /Native Directory/Assigned Roles | Assigned Roles
    /Native Directory/Assigned Roles/Foundation | /Native Directory/Assigned Roles/Foundation | Foundation
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | HFM 11.1.1.4 Project
    /Native Directory/Assigned Roles/Reporting and Analysis | /Native Directory/Assigned Roles/Reporting and Analysis | Reporting and Analysis

    ARTIFACT TYPE - Aggregated Roles
    ARTIFACT PATH, ALIAS PATH, DISPLAY NAME, ARTIFACT ID, ARTIFACT SIZE
    /Native Directory | /Native Directory | Roles | Roles.csv | -1

    ARTIFACT TYPE - Delegated Lists
    ARTIFACT PATH, ALIAS PATH, DISPLAY NAME, ARTIFACT ID, ARTIFACT SIZE
    /Native Directory | /Native Directory | Delegated Lists | Delegated Lists.csv | -1

    ARTIFACT TYPE - Groups
    ARTIFACT PATH, ALIAS PATH, DISPLAY NAME, ARTIFACT ID, ARTIFACT SIZE
    /Native Directory | /Native Directory | Groups | Groups.csv | -1

    ARTIFACT TYPE - Users
    ARTIFACT PATH, ALIAS PATH, DISPLAY NAME, ARTIFACT ID, ARTIFACT SIZE
    /Native Directory | /Native Directory | Users | Users.csv | -1

    ARTIFACT TYPE - Assigned Roles
    ARTIFACT PATH, ALIAS PATH, DISPLAY NAME, ARTIFACT ID, ARTIFACT SIZE
    /Native Directory/Assigned Roles/Foundation | /Native Directory/Assigned Roles/Foundation | Shared Services | Shared Services.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | AHEXP | AHEXP.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | AHPROD2 | AHPROD2.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | AHPROD3 | AHPROD3.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | CFGCC | CFGCC.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | CFGRPTG | CFGRPTG.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | FSGCCR | FSGCCR.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | FSGQA | FSGQA.csv | -1
    /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | /Native Directory/Assigned Roles/HFM 11.1.1.4 Project | QACFGIT | QACFGIT.csv | -1
    /Native Directory/Assigned Roles/Reporting and Analysis | /Native Directory/Assigned Roles/Reporting and Analysis | Reporting and Analysis | Reporting and Analysis.csv | -1


    REPORT FOR - TASK WITH SEQUENCE NUMBER - 0
    TOTAL FOLDER COUNT - 5
    TOTAL RESOURCE COUNT - 14
    UNKNOWN SIZED ARTIFACT COUNT - 14
    TOTAL ARTIFACT SIZE (EXCLUDING UNKNOWN SIZED ARTIFACTS) - 0.0 bytes
  • User741275-Oracle
    User741275-Oracle Member Posts: 2
    Accepted Answer
    Can you check the SharedServices_Security_Client.log file which you can find it under the LCM utility directory or in temp directory (%TEMP% or /var/tmp or /var/temp). Do you see any subset of the users/groups/roles that you intended to import or you don't see any of them? If this log file is not helping in narrowing down the problem, You can change the log level to DEBUG in Shared Services UI for the security and restart Shared Services and then re-run the import.
  • 910964
    910964 Member Posts: 15
    edited Jan 30, 2012 2:37AM
    Hi see the below info in Shared Services Security_Clinet_log.file when i import the file using CSSImport.bat

    1-27 07:48:00,856 INFO [main] CSS is initialized as client. The default logger properties will be loaded com.hyperion.css.CSSSystem.<init>(Unknown Source)
    2012-01-27 07:48:00,860 INFO [main] CSS Log file will be generated at C:\Users\hfmadmin\AppData\Local\Temp\2\SharedServices_Security_Client.log com.hyperion.css.CSSSystem.<init>(Unknown Source)
    2012-01-27 07:48:00,862 INFO [main] Configure CSS with URL for CSS.xml com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source)
    2012-01-27 07:48:00,863 INFO [main] Intializing CSS from url: file:D:/OracleHyperion/deployments/WebLogic9/SharedServices9/config/CSS.xml com.hyperion.css.common.configuration.CSSConfigurationManager.getConfiguration(Unknown Source)
    2012-01-27 07:48:01,135 INFO [main] URL constructed out of values in the configuration file:ldap://livd8rpthy02.r1-core.net:28089/dc=css,dc=hyperion,dc=com com.hyperion.css.common.configuration.CSSConfigurationImplXML.initConfiguration(Unknown Source)
    2012-01-27 07:48:01,939 WARN [main] Invalid Security Agent Mode null configured. Defaulting to Custom Http Header option with value HTTP_HypLogin. - Reset the SSO configuration using the Admin Console. com.hyperion.css.spi.CSSManager.initSecurityAgent(Unknown Source)
    2012-01-27 07:48:02,372 DEBUG [main]
    Summary :
    Processed successfully 0 user(s), unsuccessfully 0 user(s).
    Processed successfully 0 group(s), unsuccessfully 0 group(s).
    Processed successfully 0 group relationship(s), unsuccessfully 0 group relationship(s).
    Processed successfully 0 role(s), unsuccessfully 0 role(s).
    Processed successfully 0 role relationship(s), unsuccessfully 0 role relationship(s).
    Processed successfully 0 application(s), unsuccessfully 0 application(s).
    Processed successfully 0 delegated list(s), unsuccessfully 0 delegated list(s). com.hyperion.css.exchange.CommandUtility.switchPatternAndPrint(Unknown Source)
    2012-01-27 07:48:02,374 DEBUG [main] The css.xml file used is file:D:/OracleHyperion/deployments/WebLogic9/SharedServices9/config/CSS.xml
    The data file used is D:\OracleHyperion\common\utilities\CSSImportExportUtility\cssimportexport\importexport\import.csv
    The error log file used is D:\OracleHyperion\common\utilities\CSSImportExportUtility\cssimportexport\importexport\1327668480406_errors.log
    The trace log file used is D:\OracleHyperion\common\utilities\CSSImportExportUtility\cssimportexport\importexport\trace.log
    The failed entries file used is D:\OracleHyperion\common\utilities\CSSImportExportUtility\importexport\1327668480406_failed.csv
    com.hyperion.css.exchange.CommandUtility.switchPatternAndPrint(Unknown Source)


    Shared service security aduit log files


    2012-01-27 07:48:02,170 [main] INFO com.hyperion.audit.client.runtime.AuditRuntime - Audit Client has been created for the server http://livdrpthy02.r1-core.net:28080/interop/Audit
    2012-01-27 07:48:03,422 [pinging] WARN com.hyperion.audit.client.manager.AuditCltManager - Warning: Not a Valid State Change 2012-01-27 07:48:02,170 [main] INFO com.hyperion.audit.client.runtime.AuditRuntime - Audit Client has been created for the server http://livd8rpthy02.r1-core.net:28080/interop/Audit
    2012-01-27 07:48:03,422 [pinging] WARN com.hyperion.audit.client.manager.AuditCltManager - Warning: Not a Valid State Change


    Command Prompt:

    D:\OracleHyperion\common\utilities\CSSImportExportUtility\cssimportexport\import
    export>CSSImport.bat importexport.properties
    Trace...
    2012-01-27 07:48:00,507 Attempting a import operation
    log4j:WARN No appenders could be found for logger (com.hyperion.css.common.CSSLo
    gger).
    log4j:WARN Please initialize the log4j system properly.

    Summary :
    Processed successfully 0 user(s), unsuccessfully 0 user(s).
    Processed successfully 0 group(s), unsuccessfully 0 group(s).
    Processed successfully 0 group relationship(s), unsuccessfully 0 group r
    elationship(s).
    Processed successfully 0 role(s), unsuccessfully 0 role(s).
    Processed successfully 0 role relationship(s), unsuccessfully 0 role rel
    ationship(s).
    Processed successfully 0 application(s), unsuccessfully 0 application(s)
    .
    Processed successfully 0 delegated list(s), unsuccessfully 0 delegated l
    ist(s).
    The css.xml file used is file:D:/OracleHyperion/deployments/WebLogic9/Sh
    aredServices9/config/CSS.xml
    The data file used is D:\OracleHyperion\common\utilities\CSSImportExport
    Utility\cssimportexport\importexport\import.csv
    The error log file used is D:\OracleHyperion\common\utilities\CSSImportE
    xportUtility\cssimportexport\importexport\1327668480406_errors.log
    The trace log file used is D:\OracleHyperion\common\utilities\CSSImportE
    xportUtility\cssimportexport\importexport\trace.log
    The failed entries file used is D:\OracleHyperion\common\utilities\CSSIm
    portExportUtility\importexport\1327668480406_failed.csv


    Please advice me

    Edited by: 907961 on Jan 29, 2012 11:37 PM
  • Did you check the D:/OracleHyperion/deployments/WebLogic9/SharedServices9/config/CSS.xml has the correct entries? May be you can try and export the CSS file from HSS GUI and then replace with the one in this location and try again?
  • 910964
    910964 Member Posts: 15
    Solved the issue imported the users,groups using CSSImportExportUtillity

    Thanks to you all
This discussion has been closed.