This discussion is archived
8 Replies Latest reply: May 24, 2013 8:06 AM by 923301 Branched to a new discussion. RSS

Tracking user in logs

923301 Newbie
Currently Being Moderated
Gurus,
I have this question about tracking users.
Since there are so many log files in hyperion, I was just wondering if someone can help me with this.
What log file would I view to see what user has retrieved a financial report at a specific time in workspace.
We have been having this problem of the print services crashing a lot which is why I am curious to know which user is trying to pull a report or calculation when the reports crash.
For example,

user A retrieves a financial report in workspace, what log would tell me the user A trying to pull the report.
Also if user A is doing a calculation, what log would i view that would tell me the user has run a calculation and the name of calculation.

Thanks
  • 1. Re: Tracking user in logs
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Can depend on version but have a read of the following Oracle support document - "Financial Reporting (FR) - Usage Tracking For Reports And Books [ID 1353965.1]"

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 2. Re: Tracking user in logs
    923301 Newbie
    Currently Being Moderated
    Thanks John,
    I did it and checked the v8_usage_event table in sql developer. It tells the day but it still does not say the exact time. But still it works
    Thanks
  • 3. Re: Tracking user in logs
    Celvin Kattookaran Oracle ACE
    Currently Being Moderated
    Is that an FR report, I don't think FR usage tracking uses any of V8_USAGE* tables.

    It is all in FRLogging.log

    Regards

    Celvin
    http://www.orahyplabs.com
  • 4. Re: Tracking user in logs
    923301 Newbie
    Currently Being Moderated
    Celvin,
    I have been checking that table and I can see the usernames however, the subjectuuid, originatoruuid, etc has those wierd kinds of long names.
    Do you suggest any idea I could check and see what user logged (retrieved) reports at what time?
    tHANKS
  • 5. Re: Tracking user in logs
    Celvin Kattookaran Oracle ACE
    Currently Being Moderated
    I don't see the USAGE table getting populated with FR report usage in 11.1.2.2. However I've these in the FRLogging.log (MIDDLEWARE_HOME/user_projects/domains/domain name/servers/managed server name/logs
    FRLogging.log)

    This entire record is for one report open.

    Starts with retrieveObject
    [2013-05-22T17:25:14.582-04:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JvE8R343n3wb0DMaMF1HbIaJ00005W,0] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: logTimeEnd] PERF: 0000000016     ReportStoreManagerImpl                       retrieveObject(/My Reports/Sample Basic, 2) 
         This one shows which user opened the report.
    [2013-05-22T17:25:16.455-04:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JvE8RW_3n3wb0DMaMF1HbIaJ00005c,0] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: startJob] ----------------------------------------------------------
    [2013-05-22T17:25:16.455-04:00] [EPMServer0] [NOTIFICATION] [00069] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JvE8RW_3n3wb0DMaMF1HbIaJ00005c,0] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: startJob] START: JobId: 3; User: admin; Name: /My Reports/Sample Basic
    [2013-05-22T17:25:16.456-04:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JvE8RW_3n3wb0DMaMF1HbIaJ00005c,0] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: startJob] ----------------------------------------------------------
    This one shows the database connection details
    [2013-05-22T17:25:16.514-04:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: Thread-89] [userId: <anonymous>] [ecid: 0000JvDuacI3n3wb0DMaMF1HbIaJ000000,1:24578] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: endJobSummary] REPORT: [Start:052213 17:25:16.478-0400][End:052213 17:25:16.514-0400][Elapsed:0.036][Host:USPITCKATTOOKA2][JobId:3][User:admin][Name:/My Reports/Sample Basic][InBook:false][UserPOV:{ dsname=Sample Basic server=USPITCKATTOOKA2 app=Sample db=Basic type=Essbase metadata={Measures=Measures,Market=Market,Scenario=Scenario}}]
    This one is the dataquery
    [2013-05-22T17:25:16.544-04:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: Thread-89] [userId: <anonymous>] [ecid: 0000JvDuacI3n3wb0DMaMF1HbIaJ000000,1:24578] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: logTimeEnd] PERF: 000003: 0000000011     DataQuery                                    createAdmQuery     
    [2013-05-22T17:25:16.544-04:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMFR.core] [tid: Thread-89] [userId: <anonymous>] [ecid: 0000JvDuacI3n3wb0DMaMF1HbIaJ000000,1:24578] [SRC_CLASS: com.hyperion.reporting.haradm.EssbaseMDXDataQuery] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: execute] SELECT[[
    {[Year]} 
    DIMENSION PROPERTIES [Year].[MEMBER_ALIAS] , [Year].[MEMBER_UNIQUE_NAME] 
    ON COLUMNS , 
    Hierarchize({ [Product].Children, [Product] }, POST) 
    DIMENSION PROPERTIES [Product].[MEMBER_ALIAS] , [Product].[MEMBER_UNIQUE_NAME] 
    ON ROWS 
    FROM [Sample].[Basic] 
    WHERE ([Measures], [Market], [Scenario])
    ]]
    You can see the time when the user clicked on the report, what query was used in the report, any conditional formatting applied and,...... (all information about that report.

    Regards

    Celvin
    http://www.orahyplabs.com
  • 6. Re: Tracking user in logs
    923301 Newbie
    Currently Being Moderated
    Celvin and John, thanks, you are both great.

    Celvin,
    Thank you very much for the detailed explanation of logs. It has really helped me in comprehending the logs in better ways.
    There are so many logs within hyperion and you know how huge they are so it makes it very difficult to really understand them and look for the errors. Your explanation is really great.
    In fact, is there any Oracle documentation that focuses on the different logs, the path, etc and any guidance in going over the logs and how to rectify the errors.
    Any suggestion, link, etc would be really appreciable.
    Thank you again.
  • 7. Re: Tracking user in logs
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Try the log sections in http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_troubleshooting_1112200/frameset.htm?launch.html

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 8. Re: Tracking user in logs
    923301 Newbie
    Currently Being Moderated
    Thank you very much John,
    I have one more question about Reporting and Print services issue.
    One reason I think we are having this issue might be because that we are using EPM 11.1.2 in Windows 2003 - 32 bit server.
    This is what happens.
    When there are a lot of users --- when users try to pull up reports on members they do not have access to, the report services seem to hang which ultimately cause the reports to freeze. We have talked to Oracle and we have heard that when users try to retrive reports they do not have access to it crashes. For example, if a user has access to D50 for example and if he tries to retrieve D60, the who thing crashes.
    Does it work like that?
    What would be the recommendation to fix it.
    We have checked with the config and all and they look fine. We have worked with heap size as well and still the problem.
    Is there any log or any other file that tells us exactly the system or report crashed?
    Any guide will be helpful.
    Thanks