Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

javascript error on page of MS SQL Reporting Services - Datasource.aspx?createnew

Hi All,

 Still trying to learn SQL Server reporting services and having some trouble.

 I'm trying to create a new datasource (using the /reports virtual directory, not via visual studio)

 I created one before with no problems,

  Now on that page I get an javascript page and the familiar ! error sybol at the bottom left of IE

  The error is line 388 char 3 error: Object expected Code:0 Url   https://www.mysite.com/Reports/Pages/DataSources.aspx?CreateNew=True...

  Line 388 is pointless, becuase when I view source I get a file with 294 lines. (maybe it's including the contents of the external javascripts?)

  - Anyhow,

    After I installed RS, I had to move it to a differnent website (didn't need it on default) - that worked almost fine, except I got a few errors that seemed to be related to the lack of an SSL certificate - So I created one with cert server and installed it on IIS - I think its' around then that it stopped working, but hard to say, I've done a lot over the past 3 days.

  If this has ever happened to you, please post a reply, even if you don't have the answer so I can guage how common this is.

Thanks,
Jack

0
fruhj
Asked:
fruhj
  • 4
  • 2
1 Solution
 
simon_kirkCommented:
Bit of narrowing down...
Do other reports on your site work ok?
Is the issue just on creation of a datasource via Report Manager?

Check this article for non-default IIS site setup:

Moving Reporting Services' Virtual Directories
http://www.sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
0
 
fruhjAuthor Commented:
Hey Simon,

  It seems to be just the datasource.aspx page. Reports are showing fine and the other screens I've accessed via the /reports virtual directory all seem fine as well (they render to IE fine with no javascript errors)

I've got a test server here (without the error) I think I'll do an MD5 checksum on the folders and compare it to an MD5 of the problem server to verify that the files are the same - then at least we can rule out the aspx and js files as the problem.
0
 
fruhjAuthor Commented:
Hi Again Simon,

I did the MD5 and all files are the same, minus 2 config files that were mentioned in the article.

I noticed something else today that might help:

I can't add a new folder - the ok button doesnt do anything - leads me to think it's not getting the javascript file or something.
However that' the case testing from the new site I have setup (copied the folders per your article)

On the original "default web site", I am able to add a folder.
Both point to the same RS code - so it must be something different - maybe permissions setup, maybe config file, maybe the .net include files aren't in the new site I setup (I tried a test aspx page and it works, but it didn't use any client side javascript for validation - so maybe I'm missing that on my new site?)

Ok Simon, thanks again, if you think of anything else, please let me know!

- Jack
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
fruhjAuthor Commented:
Hey Simon, that was it!

How F**ing Stupid of me!

I thought I followed your article, and obviously I missed the last step - copying the asp_net client.

(I never got the error message about not finding the js file from IE or I'm sure I'd figured this one out sooner)

Anyhow Simon, once again thanks for all your help on this question and questions you've helped me out in the past with!

- Jack
0
 
fruhjAuthor Commented:
Follow up message for someone reading this in the PAQ

I had a problem with reporting services on a new site I had created.

Many of the problems were related to client side buttons not working.

It turned out to be a missing javascript file on the new site I created.

ASP.net uses a .js file for it's client side javascript code - used in things like validation, etc...

I had created a new site, and aspx files were working, so I forgot all about the js file.

I copied the folder: aspnet_client from another site off my machine (the default site to be exact) into the site I had used for Reporting services.

This fixed the problem.

Hopefully this paq can help someone else!
0
 
simon_kirkCommented:
Glad I could be of help
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now