User are faing issue in run the report

2693347 · May 2, 2018 7:42AM

Hi All,

I am facing issue that i never saw that before and i need your help,

When the ran the analytics report in OBIEE and simultaneously i am check the log for this query in Administration-->Mannage Session.And between 1 to 2 mins i can see in the log report will show finished ,but when i came back to front end its keep on running, and when i refresh the browser then i can see the data .

I hope you all understand what i am talking about. Anyone face this issue before

Thanks,

Shashi

[Deleted User] · May 2, 2018 8:08AM

Which exact version of OBIEE? Which exact version of which browser?

Also: I guess you are talking about "analyses" and not "reports". "Reports" are BI Publisher objects and not OBIEE objects.

2693347 · May 2, 2018 8:57AM

Thanks for replying Christian,

Yes i am running analyses and Below is the OBIEE and browser version i am using.

OBIEE Version--Oracle Business Intelligence 11.1.1.7.150120

IE 11- Version 11.0.49

Google Crome--Version 65.0.3325.181 (Official Build) (64-bit)

Fire Fox--Version 65.0.3325.181 (Official Build) (64-bit).

Most of the time we are using Google Crome.

Adam Wickes · May 2, 2018 9:29AM

Hi,

Can you please start your analysis and take note of the time.

Remain in the analysis window and take note of the exact time it finishes.
After it has finished, open manage sessions, find the session log and copy/paste the contents into here (please remember to remove any information you don't want the internet to know).
If you have access to a DBA in your organisation, you may also like to ask them to check what and when things are happening at their end.

Also, can I take from what you're saying that you have to refresh the page before data is shown?
What happens if you click "results" while in the analysis and just wait for it to finish?
If it doesn't finish, is it specific to that query? What happens if you select a single field that you know should return within seconds? Does it appear instantly or suffer from the same issue.

Thanks,
Adam

2693347 · May 2, 2018 11:24AM

ID	User	Refs	Status	Time	Action	Last Accessed	Statement	Information	Records
16362	U6064766	1	Finished	1m 15s	Close View Log	5/2/2018 10:13:40 AM GMT-05:00	OBIEE Query	Type=Report Report=/users/u6064766/GLDETAIL1	9941

Hi Adam,

Above is the detail of the analyses i ran ,you can see its finished in 1m 15 s ,but in analyses it is keep on running.

I am running the report from MyFolder and click on open and it will keep on running until i refresh the page.

I hope you got the info what you need .

Thanks,

Shashi

Srinivas Malyala-Oracle · May 2, 2018 11:31AM

Are there any HTML tags ? or javascripts in narrative view try removing them first and see how results are showing.

Then keep adding your html/script related things and see where it is failing.

Adam Wickes · May 2, 2018 7:13PM

Hi Shashi,

Can you click on "view log" and post the details in here. (remember to remove anything you don't want us to see).

Thanks,
Adam

2693347 · May 3, 2018 4:14AM

we are not using any HTML or Javascript in the report.Simple report which contain 8 column and data user looking for is for one year.

2693347 · May 3, 2018 4:22AM

Below is the details of the log of the query.

[2018-05-03T03:16:42.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-0] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:3] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] ############################################## [[

-------------------- SQL Request, logical request hash:

c6d7b943

SET VARIABLE QUERY_SRC_CD='Report',SAW_SRC_PATH='/users/u6064766/GLDETAIL1';SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11, s_12, s_13, s_14, s_15, s_16, s_17, s_18, s_19 FROM (

SELECT

0 s_0,

"Financials - TR GL Detail"."- Details"."Document Date" s_1,

"Financials - TR GL Detail"."- Details"."Fiscal Year" s_2,

"Financials - TR GL Detail"."- Details"."Posting Date" s_3,

"Financials - TR GL Detail"."- Details"."Posting Period" s_4,

"Financials - TR GL Detail"."- Details"."TR Doc Header Txt" s_5,

"Financials - TR GL Detail"."- Details"."TR Item Txt" s_6,

"Financials - TR GL Detail"."Company"."Company Name" s_7,

"Financials - TR GL Detail"."Cost Center"."Cost Center Code" s_8,

"Financials - TR GL Detail"."Cost Center"."Cost Center Desc" s_9,

"Financials - TR GL Detail"."Doc Type"."Doc type code" s_10,

"Financials - TR GL Detail"."GL Account D"."GL Account Desc" s_11,

"Financials - TR GL Detail"."GL Account D"."GL Account Num" s_12,

"Financials - TR GL Detail"."Period"."Cal Year" s_13,

"Financials - TR GL Detail"."Profit Center"."Profit Center Desc" s_14,

"Financials - TR GL Detail"."Profit Center"."Profit Center Num" s_15,

ifnull("Financials - TR GL Detail"."- Balances"."Doc Amt (USD)",0) s_16,

ifnull("Financials - TR GL Detail"."- Balances"."Loc Amt (USD)",0) s_17,

REPORT_AGGREGATE(ifnull("Financials - TR GL Detail"."- Balances"."Doc Amt (USD)",0) BY ) s_18,

REPORT_AGGREGATE(ifnull("Financials - TR GL Detail"."- Balances"."Loc Amt (USD)",0) BY ) s_19

FROM "Financials - TR GL Detail"

WHERE

(("Period"."Cal Year" = 2017) AND ("Period"."Cal Month" = 1) AND ("GL Account"."Hier2 Name" = 'NET INCOME') AND ("GL Account"."Hier1 Name" = 'ZIFP') AND ("GL Account"."Tr Leaf" = 'True') AND ("GL Account D"."GL Account Num" IN ('0045100000', '0062650001', '0062360001', '0069130007', '0061520002', '0069950000', '0063110001', '0061220027', '0050200000', '0061160003', '0068100000', '0070560000', '0077100000')))

) djm ORDER BY 1, 3 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS LAST, 16 ASC NULLS LAST, 15 ASC NULLS LAST, 9 ASC NULLS LAST, 10 ASC NULLS LAST, 7 ASC NULLS LAST, 11 ASC NULLS LAST, 2 ASC NULLS LAST, 6 ASC NULLS LAST, 8 ASC NULLS LAST, 14 ASC NULLS LAST, 13 ASC NULLS LAST, 12 ASC NULLS LAST

FETCH FIRST 1000000 ROWS ONLY

]]

[2018-05-03T03:16:42.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-23] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:3] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- General Query Info: [[

Repository: Star, Subject Area: TR Core, Presentation: Financials - TR GL Detail

]]

[2018-05-03T03:16:42.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-18] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:5] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Sending query to database named TROVE (id: <<6507918>>), connection pool named Connection Pool, logical request hash c6d7b943, physical request hash fcd12a23: [[

select /*+ opt_param('_optimizer_cost_based_transformation','OFF') */ sum(T843245.OTHER_LOC_AMT / nullif( T843087.EXCH_RATE, 0)) as c1,

sum(T843245.OTHER_DOC_AMT / nullif( T843084.EXCH_RATE, 0)) as c2,

T843245.TR_ITEM_TXT as c3,

T843245.TR_DOC_HEADER_TXT as c4,

T843245.TR_POSTING_PERIOD as c5,

T843245.TR_FISCAL_YEAR as c6,

T843245.TR_DOCUMENT_DATE as c7,

T928780.CALENDAR_DATE as c8,

T830175.TR_COMPANY_NAME as c9,

T829923.COST_CENTER_VAL_CODE as c10,

T829923.TR_COST_CENTER_DESC as c11,

T927392.DOC_TYPE_CODE as c12,

T843251.TR_GL_ACCOUNT_DESC as c13,

T843251.TR_GL_ACCOUNT_NUM as c14,

T830030.CAL_YEAR as c15,

T830728.PROFIT_CENTER_DESC as c16,

T830728.PROFIT_CENTER_NUM as c17,

T830175.ROW_WID as c18

from

TROVE_DW.WC_PROFIT_CENTER_DHV T830728 /* DIM_WC_PROFIT_CENTER_DH */ ,

TROVE_DW.WC_GL_ACCOUNT_DHV T830953 /* DIM_W_GL_ACCOUNT_DH */ ,

TROVE_DW.WC_COST_CENTER_DV T829923 /* DIM_W_COST_CENTER_D */ ,

TROVE_DW.WC_DAY_DV T830030 /* DIM_W_DAY_D */ ,

TROVE_DW.WC_INT_ORG_DV T830175 /* DIM_W_INT_ORG_D */ ,

TROVE_DW.WC_PROFIT_CENTER_DV T830541 /* DIM_W_PROFIT_CENTER_D */ ,

(

TROVE_DW.WC_GL_OTHER_FV2 T843245 /* FACT_WC_GL_OTHER_V */ left outer join TROVE_DW.WC_EXCH_RATE_V T843084 /* DIM_DOC_WC_EXCH_RATE_V */ On T843084.TR_CURRENCY_WID = T843245.TR_DOC_EXCH_RATE_WID) left outer join TROVE_DW.WC_EXCH_RATE_V T843087 /* DIM_LOC_WC_EXCH_RATE_V */ On T843087.TR_CURRENCY_WID = T843245.TR_LOC_EXCH_RATE_WID,

TROVE_DW.WC_GL_ACCOUNT_V T843251 /* DIM_WC_GL_ACCOUNT_V */ ,

TROVE_DW.WC_DOC_TYPE_DV T927392 /* DIM_WC_DOC_TYPE_DV */ ,

TROVE_DW.WC_DAY_DV T928780 /* DIM_WC_DAY_DV for Posting Date */

where ( T830541.DATASOURCE_NUM_ID = T830728.DATASOURCE_NUM_ID and T829923.ROW_WID = T843245.COST_CENTER_WID and T830030.ROW_WID = T843245.MCAL_CAL_WID and T830175.ROW_WID = T843245.COMPANY_ORG_WID and T830541.INTEGRATION_ID = T830728.INTEGRATION_ID and T830541.ROW_WID = T843245.PROFIT_CENTER_WID and T843245.DOC_TYPE_WID = T927392.ROW_WID and T843245.GL_ACCOUNT_WID = T843251.ROW_WID and T830953.DATASOURCE_NUM_ID = T843251.DATASOURCE_NUM_ID and T830953.INTEGRATION_ID = T843251.INTEGRATION_ID and T830030.CAL_MONTH = 1 and T830030.CAL_YEAR = 2017 and T830728.TR_LEAF = 'True' and T830953.HIER1_NAME = 'ZIFP' and T830953.HIER2_NAME = 'NET INCOME' and T830953.TR_LEAF = 'True' and T843245.POSTED_ON_DT_WID = T928780.ROW_WID and 2010 < T830030.CAL_YEAR and (T843251.TR_GL_ACCOUNT_NUM in ('0045100000', '0050200000', '0061160003', '0061220027', '0061520002', '0062360001', '0062650001', '0063110001', '0068100000', '0069130007', '0069950000', '0070560000', '0077100000')) )

group by T829923.COST_CENTER_VAL_CODE, T829923.TR_COST_CENTER_DESC, T830030.CAL_YEAR, T830175.ROW_WID, T830175.TR_COMPANY_NAME, T830728.PROFIT_CENTER_DESC, T830728.PROFIT_CENTER_NUM, T843245.TR_FISCAL_YEAR, T843245.TR_POSTING_PERIOD, T843245.TR_DOC_HEADER_TXT, T843245.TR_ITEM_TXT, T843245.TR_DOCUMENT_DATE, T843251.TR_GL_ACCOUNT_DESC, T843251.TR_GL_ACCOUNT_NUM, T927392.DOC_TYPE_CODE, T928780.CALENDAR_DATE

order by c7, c6, c8, c5, c4, c3, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18

]]

[2018-05-03T03:18:25.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-34] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:6:95] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Query Status: Successful Completion [[

]]

[2018-05-03T03:18:25.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-26] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:6:95] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Rows 9941, bytes 77619328 retrieved from database query id: <<6507918>> [[

]]

[2018-05-03T03:18:25.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-28] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:6:95] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Physical query response time 101 (seconds), id <<6507918>> [[

]]

[2018-05-03T03:18:25.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-29] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:6:95] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Physical Query Summary Stats: Number of physical queries 1, Cumulative time 101, DB-connect time 0 (seconds) [[

]]

[2018-05-03T03:18:25.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-24] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:6:95] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Rows returned to Client 9941 [[

]]

[2018-05-03T03:18:25.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-33] [] [ecid: 31671a36494b61f7:8237f0b:1630f3e6cb0:-8000-000000000002520f,0:1:14:6:95] [tid: 49af0940] [requestid: 82cf0008] [sessionid: 82cf0000] [username: U6064766] -------------------- Logical Query Summary Stats: Elapsed time 103, Response time 102, Compilation time 0 (seconds) [[

]]

Adam Wickes · May 3, 2018 4:33AM

Thanks Shashi.

Just to confirm that the results are never shown on the screen until you refresh?

Have you checked Chrome developer tools to see if there are any console errors?

Is it happening on all analyses or just one? If only one, have you tried to re-create it?

2693347 · May 3, 2018 7:30AM

Below are the answer of your questions.

1) Yes until i refresh the page data is not showing,once i refresh the browser ,report is start rendering slowly and show the data.

2) i did not see any console error while running the report.

3)I have check for the 2 reports which are from different subject area.Yes i have try to recreate it but after adding few columns i seen the same behavior.

I tried to run the report by giving the display limit as 100 in the analyses, and i noticed that sometime it works and sometime not.

Thanks,

Shashi

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

User are faing issue in run the report

Answers