BIEE12 SQOSPMarkMultiTargetSupport.cpp, line 2436. [[ [nQSError: 43119] Query Failed: ]]

Question

Dear Experts

In mi BIEE 12c i received this message error:

==

[2016-04-11T11:53:58.777-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:3] [sik: ssi] [tid: 9b9e9700] [messageid: USER-0] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] ############################################## [[

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

20331bfb

SET VARIABLE OBIS_REFRESH_CACHE=1,QUERY_SRC_CD='Report';SELECT

0 s_0,

"CGC"."Períod - U"."Month" s_1,

SORTKEY("CGC"."Períod - U"."Month") s_2,

"CGC"."Result Net - U"."VLR OR" s_3,

"CGC"."Result Net - U"."VLR R" s_4,

AGO("CGC"."Result Net - U"."VLR R","CGC"."Períod - U"."D TimeDim"."Ano",1) s_5

FROM "CGC"

ORDER BY 3 ASC NULLS LAST, 2 ASC NULLS LAST

FETCH FIRST 65001 ROWS ONLY

]]

[2016-04-11T11:53:58.777-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:3] [sik: ssi] [tid: 9b9e9700] [messageid: USER-74] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- Logical query limits: max query time(user, system, session) = (0, 0, 0); max rows(system, session) = (0, 0)

[2016-04-11T11:53:58.777-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:3] [sik: ssi] [tid: 9b9e9700] [messageid: USER-23] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- General Query Info: [[

Repository: ssi, Subject Area: CGC, Presentation: CGC

]]

[2016-04-11T11:53:58.780-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:3] [sik: ssi] [tid: 9b9e9700] [messageid: USER-2] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- Logical Request (before navigation): [[

RqList [1,2]

0 as c1 GB,

D Time.Month as c2 GB,

D Time.N° Month as c3 GB,

VLR OR:[DAggr(FactIC.VLR OR by [ D Time.Month, D Time.N° Month] )] as c4 GB,

VLR R:[DAggr(FactIC.VLR R by [ D Time.Month, D Time.N° Month] )] as c5 GB,

Ago(VLR R:[DAggr(FactIC.VLR R by [ D Time.Month, D Time.N° Month] )], [Level Ano], 1) as c6 GB

OrderBy: c3 asc NULLS LAST, c3 asc NULLS LAST

]]

[2016-04-11T11:53:58.783-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:5] [sik: ssi] [tid: 9b9e9700] [messageid: USER-53] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- List of attributes and their LTS sources: [[

Column VLR R:[DAggr(FactIC.VLR R by [ D Time.Month, D Time.N° Month] )] rendered via fact LTS [Logical table sources (Priority=0, SystemGenerated=False): FactIC.FactIC]

]]

[2016-04-11T11:53:58.785-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:5] [sik: ssi] [tid: 9b9e9700] [messageid: USER-48] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- The logical query block failed to hit or seed the cache in subrequest level due to [[

only one subrequest

]]

[2016-04-11T11:53:58.785-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:5] [sik: ssi] [tid: 9b9e9700] [messageid: USER-53] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- List of attributes and their LTS sources: [[

Select: D Time.Month: Logical table sources (Priority=0, SystemGenerated=False): D Time.D Time

Select: D Time.N° Month: Logical table sources (Priority=0, SystemGenerated=False): D Time.D Time

Select: D Time.Ano: Logical table sources (Priority=0, SystemGenerated=False): D Time.D Time

]]

[2016-04-11T11:53:58.789-03:00] [OBIS] [TRACE:6] [] [] [ecid: f4c7de0f-3e84-4cc2-9252-b37752569007-0000024b,0:1:1:5] [sik: ssi] [tid: 9b9e9700] [messageid: USER-34] [requestid: fa72001d] [sessionid: fa720000] [username: weblogic] -------------------- Query Status: [nQSError: 46008] Internal error: File server/Query/Optimizer/SmartScheduler/PhysicalRequestGenerator/Src/SQOSPMarkMultiTargetSupport.cpp, line 2436. [[

[nQSError: 43119] Query Failed:

]]

==

I search support.oracle.com but nothing exists contains SQOSPMarkMultiTargetSupport.cpp

Any idea or any sugestion for search references for this problem?

Thanks,

327788734 · Answer

RMoff,

I already have a SR (because we pay for it), but the four days we do not have answers.

Just 1 hour before I made up this post, I was informed that the bug is 23,252,854.

Thanks anyway, his support without being paid is usually more effective than paid.

Thank you!!!

rmoff · Answer

Any idea or any sugestion for search references for this problem?

If the tool is throwing an internal error, and there's no hit on My Oracle Support, then raise an SR. That's what you pay your support money for.

SriniVEERAVALLI · Answer

Can you confirm these?

1. Using rpd van you view the data for any of table?

2. Are you able to run any other report?

3. Is there any data for weblogic user from Session variables