Error when accessing Oracle Datasource Subscription

Aspose.Cells Product Family
1

I get the following error when a SSRS subscription is run, if the report has an Oracle Datasource.

There is not a probelm with subscription with SQL Datasources.

HELP

2

Hi,

Thanks for considering Aspose.

We will check and get back to you soon.

Thank you.

3

Hi jtpurvis,

Please post rdl file here. We will check it.

Please try direct export data from SSRS.

4

This report uses an Oracle datasource, the parameter name convention is major syntax change vs. a SQL server datasource

5

Hi jtpurvis,
Please try using Aspose.Cells Renderer or built-in html renderer and oracle datasource to run
your report directly from SSRS web console ,not as a SSRS subscription.
If it doesn’t work ,please post error message.
Because your report works fine with SQL server but fail with oracle datasource ,so I doubt whether there is something wrong in your report definition file.
In the case of using oracle as datasource, please pay attention to:
1. SQL syntax
2. SQL parameters binding
For example:
Oracle: WEREH (DAR.DAR_ID = (:DAR_ID))
sql server: WHERE (DAR.DAR_ID = @DAR_ID)
3. Query Parameters
For example:
Oracle:
sql server:
4 Report parameters
For example:
Oracle:
sql server:


Thank you.

6

Report renders correctly, but the subscription fails with the above message. I am asking for your assistance, due to the failure being in ACTXT

Not sure why this extension is being called even if the default Excel renderer in used in report

7

Hi,jtpurvis,

Pleasee see the reply at <A href="https://forum.aspose.com/t/90436</A>. </P> <P>Thank you.</P> <P> </P> <P> </P>