Forum Stats

  • 3,838,754 Users
  • 2,262,398 Discussions
  • 7,900,750 Comments

Discussions

OAC Subject Area Issue

Dir_Pal
Dir_Pal Member Posts: 153 Red Ribbon

Hi Experts, @Gianni Ceresa

I have 1 fact table and 5 dimensions and in that one is from different database.

if I pull 1 fact table and 3 dimension from 1 database and 1 from different database works perfect.

but If I pull 1 fact and 4 dimension from 1 database and 1 from different database it throws out an error

. Code: 12061. [nQSError: 12061] Communication error connecting to remote end point.

Please have your service administrator review this error

Best Answer

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,649 Gold Crown


    a) Please don't @ people directly to get your question answered. Forum participation is voluntary and not remunerated. If you want somebody to do your work, then hire them and pay them.

    b) A DB communication error is much more of a basic issue that you need to fix before modeling things together. Does the second DB connection work on its own? Can you actually read and analyze data coming from that source? Does it use the correct connectivity information? etc etc.

    Fix the basics and the rest will work.

  • Dir_Pal
    Dir_Pal Member Posts: 153 Red Ribbon
    Answer ✓

    My Bad at tagging a particular person sorry about that. I will think about hiring a person Thanks for you valuable suggestion.

    If you have seen my question I clearly stated its working individually

    "if I pull 1 fact table and 3 dimension from 1 database and 1 from different database works perfect." that states that it is working.

    if Its a basic issue I would have resolved the issue without any issue. So if u have any advance solution do let me know.

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,640 Blue Diamond

    The thing is that there is still a lot of info missing to have a full picture of the context of your setup.

    And BI Server errors code aren't as documented and universally known as an Oracle database ORA error, so no idea if I even ever saw a "nQSError 12061".

  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,649 Gold Crown

    If the queries run on their own then your model is at fault. As Gianni said we can't know what you did in detail. How did you federate your data? How did you model things precisely? What did exactly you do on the physical level? What exactly did you do on the logical level?

    Also: I doubt the current "accepted answer" is an actual answer for this thread.