Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIA 7.9.6.4 out of box reports show no data after initial full load

User_INLWQJul 10 2014 — edited Jul 31 2014

Hi gurus,

we installed and configured OBIA 7.9.6.4 for financial, supply chain (SCM) and HR analytics and then ran full loads (individually first for financial analytics, then for SCM and finally for HR)

Once load completes successfully for each module, then we checked corresponding module out of box reports in the front end. And during each check we observered that the reports show no data,(we just see the generic "No results" message for each report irrespective of the prompt selections)

Assuming that the problem is with the data load, we ran full loads multiple times and again ending up with the same.

Is this because the confirmed dimensions are not loaded properly ? or due to incorrect domain value csv file specifications ?

our environment:  ebs is 12.1.3, obiee is 11.1.1.7, obia is 7.9.6.4, informatica is 9.0.1 hotfix2, dac is 11g, datawarehouse db is 11.2.0.4

appreciate your inputs.

Regards,


Comments

SureshM-Oracle

Are you triggering import via Batch or through manual process?

Does the process logs shows two ODI process that gets execute one after another?

What version of FDMEE are you in?

athlon007

Hello,

The import is triggered manually

The process logs shows different ODI process numbers.

FDMEE version 11.1.2.4.210

Thanks alot for helping

Roman

SureshM-Oracle

Is it a distributed environment? If yes, do you have multiple FDMEE servers?

I would advise to raise an SR with Oracle Support at this point in time to review your environment and provide you the solution.

athlon007
Answer

Hello,

In case somebody else runs into this issue it was the following:

Since Upgrading to Windows 10 our FDMEE import from a Staging table never stopped, it just kept reimporting after the validation step.

Solution was to amend the timeout setting in our Load Balance from 5min to 10min.

Hope this may help somebody else once.

Cheers

Marked as Answer by athlon007 · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2014
Added on Jul 10 2014
4 comments
1,681 views