Post reply

Run report error

  • July 13, 2022 at 10:01 am

    #4062643

    I use SQLserver 2016 , when I run the report from Oracle , it use SQL server reporting service , it pops the below error when run the report , would advise what is wrong , how to fix it ? thanks for help.

     

    "An error has occurred during report processing. (rsProcessingAborted)

    An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)"

     

     

  • July 13, 2022 at 10:19 am

    #4062647

    What edition of SQL Server are you using?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 13, 2022 at 1:50 pm

    #4062761

    Thom A wrote:

    What edition of SQL Server are you using?

     

    SQL server 2016

  • July 13, 2022 at 2:03 pm

    #4062769

    patrick chan wrote:

    Thom A wrote:

    What edition of SQL Server are you using?

    SQL server 2016

    That's the version, I'm asking what Edition. Express, Standard, Enterprise, Web, Developer, Evaluation?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 14, 2022 at 7:30 am

    #4063134

    Standard Edition (64-bit) on Windows Server 2016 Standard 6.3

  • July 14, 2022 at 11:39 am

    #4063233

    Hmm, that's that idea out the window then. I was expecting you to say Express, which only supports data sources to the localhost; trying to connect an Oracle Instance on SSRS on SQL Server Express with Advanced Services would likely yield the above error. I think 2016 Standard supports Oracle data sources though.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply