Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Oracle source- Import Mode - schedule refresh timeout

Hi,   I have 8 tables in my model and i am using Import mode. My datasource is oracle and i gave timeout as 3600 minutes. My datset size is 16 MB. Below are the tables and the count.  Schedule ref...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Have you configured a gateway for it? Can you provide more detailed error messages?

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes  I have installed standard Gateway and using the gateway to refresh it.

     

    Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}}

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I have installed standard gateway and using that gateway refresh schedule is configured.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

       

      If you are using the ODBC connector, there is currently a problem. Please try using the Oralce connector, or use the Personal Edition Gateway.

       

      Hope it helps!

       

      Best regards,
      Community Support Team_ Scott Chang

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I am using Oracle connector to connect. From database I chose Oracle databse and from ther i am giving the servername and query along with timeout vlaue of 3600.

        Actually I have other reports which is using the same orale source and refresh is sucessful using the standard gateway. Only this report i am getting timeout error