Script fail [Oracle Connection]

[victorinable]

Hi,

I was trying to connect to Oracle DB from MVC Editor (Web editor in a MVC4 application) and when I try to create a new DataSource from the Oracle connection, it fails. The message displayed is this one:

Error_Script.PNG (50.87 KiB) Viewed 3424 times

I'm using last release of Reports.Web.

Is this an error?

Thanks in advance.

[Vladimir]

Hello,

We are unable to reproduce the error.
Please try to use the latest prerelease build 2015.1.16 of our product:
http://www.stimulsoft.com/en/downloads/reports-web

If the error is reproduced with the latest version, please send us a sample project.

Thank you.

[victorinable]

Hi Vladimir,

I'll try to do this, but just as a hint, I have to say that there are a lot of objects in this DB. Just to know, there's any limitation on number of objects retrieved?

And just to know, to install the last pre-release, should I just replace the files that are included in the installation folder?

Thanks in advance.

[victorinable]

Hi Vladimir,

I replaced the libraries and still having the same issue even with the latest pre-release build. As I said in the post before, I pressume is a matter of the amount of objects that the database has, and the problem is retrieving them.

I'll pass you the report if needed, but you'll not be able to reproduce as you cannot access my DataBase.

Thanks in advance.

[Vladimir]

Hello,

If the error is not reproduced on small data, therefore it is a problem large database.
Please try to test your report on another browser and inform us about the results. Also, please let us know how soon after the request for the data you receive this error.

Thank you.

[victorinable]

Hi Vladimir,

Yes, that was my first assumption. I've tried by now with Firefox 38.2.0. I'll test with Chrome and IE, Ill measure the time when the error is raised and let you know.

Thanks for the support.

[victorinable]

Hi Vladimir,

benchmark is this one:

Firefox 38.2.0: 15.31Seconds

Firefox_Results.PNG (65.73 KiB) Viewed 3410 times

Chrome 44.0.2403.130 m: 15.01 Seconds

Chrome_Results.PNG (94.58 KiB) Viewed 3410 times

Attached images, on firefox message is raised, in chrome it just get freezed

Thanks!

[Alex K.]

Hello,

In this case you have many objects (tables, views, procedures). And browser is not enough time to process all elements.
Unfortunately, on current moment it is works as is. As a way, you can add data sources by one (Data from Oracle connection).

Please send us a request on support@stimulsoft.com, we will try to find solution for this problem.

Thank you.

[victorinable]

Hi,

I'll make that request for the benefit of all developers. And no, I cannot select them 1 by 1 as the error comes when loading the list of objects.

thanks.

[Alex K.]

Hello,

And no, I cannot select them 1 by 1 as the error comes when loading the list of objects.

Please try to select "Data from Oracle Connection" menu item, not existing connection and then write sql query.

Thank you.