Forum Discussion

moritzbartram's avatar
moritzbartram
Frequent Visitor
10 months ago
Solved

Mirrored Oracle Error

Hi everyone,  I'm having trouble to create a mirrored oracle item. I've followed the set-up guide and configured my oracle database accordingly, but get the following error:    The message a...
data engineering
  • moritzbartram's avatar
    moritzbartram
    10 months ago

    Hi v-kpoloju-msft,

     

    thanks again for your reply. I've already been in contact with the fabric support team and they confirmed that the error I'm getting results from the amount of tables ~10000 that are in my database and they cannot be displayed. So this is just a UI error that can be circumvented by creating mirror items via Rest-API. 

    Thanks again for your help! 

    Best regards

moritzbartram's avatar
moritzbartram
Frequent Visitor
10 months ago

Hi v-kpoloju-msft,

 

thanks for your reply! The gateway I'm using work fine for the connection when I try to access the data via a copy activity (within a pipeline), then I can see all my tables and preview my data. 
After inspecting the gateway logs I can see that errors appeared when I tried to set up the mirrored database, but I don't get relevant information out of it. 
The error is: 'Unable to open the Server service performance object. The first four bytes (DWORD) of the Data section contains the status code.'
The gateway version is 3000.282.5. 

I already tried restarting the gateway. Do you have any other idea? 
Thank you!

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
10 months ago

Hi moritzbartram,
Thank you for the in detailed follow-up question.

Since your Oracle connection works fine in the copy activity, that confirms the gateway, and credentials are good, so the issue is likely with the local performance counters on the gateway machine. The log message

“Unable to open the Server service performance object…”
is a Windows-level error that usually appears when performance counters are corrupted or not accessible to the gateway service.

You can try rebuilding them by opening Command Prompt as Administrator and running:

lodctr /R

Then restart the On-premises Data Gateway service and retry the mirror setup.

If the problem persists, make sure the Server service (LanmanServer) is running and the gateway service account has permission to read performance counters. This usually clears the “task was canceled” error when creating the mirrored Oracle item.

Hope this helps. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

  • moritzbartram's avatar
    moritzbartram
    Frequent Visitor
    10 months ago

    Hi v-kpoloju-msft,


    I ran the command, succesfully rebuilt the performance counters and restartet the gateway. Unfortunately the error persists. I updated the gateway, but it also did not work.

    Any other ideas? 
    Thank you!

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      10 months ago

      Hi moritzbartram,

      Thanks for the follow-up question and thanks for trying those steps and for confirming the rebuild and update. Since the error persists, let’s look at a few additional areas that can sometimes cause this issue.

      Since the issue persists after rebuilding counters and updating the gateway, please double-check that your gateway is in standard mode (not personal) and registered in the same region as your Fabric workspace. Also ensure the 64-bit Oracle client version matches your database. If it is still failing, please share the recent gateway log snippet from C:\ProgramData\On-premises data gateway\Gateway*.log so we can review the next steps.

      Hope this helps. Let us know if you have any doubts regarding this. We will be happy to help.

      Thank you.

      • moritzbartram's avatar
        moritzbartram
        Frequent Visitor
        10 months ago

        Hi v-kpoloju-msft,

        thanks for your reply. The gateway is in standard mode and in the same region as my workspace. Also the oracle client version matches my database. Here is the snippet from the gateway error log:

        [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=182040, err=CommunicationObjectAbortedException, rootcauseErrorEventId=0)

         

        I hope this is helpful to you.
        Thank you!