Solved

Internet Address is not valid

Posted on 2013-02-07
12
1,717 Views
Last Modified: 2013-02-26
When saving an Excel file back in the database the user receives: The Internet address' http://...xls'  is not valid. Sometimes it works and sometimes, usually, it does not.
See atatchment.
XLS-Not-valid.pdf
0
Comment
Question by:KBAguy
  • 6
  • 5
12 Comments
 
LVL 33

Expert Comment

by:paulmacd
Comment Utility
It seems the saving computer is having trouble finding http://portal.keyfamily.local for some reason.  This is likely a DNS issue, but it's hard to say without knowing more about your network.

Also, I hope nothing in that screenshot is sensitive.
0
 
LVL 9

Expert Comment

by:BobHavertyComh
Comment Utility
The most simple thing to try first is to take your local copy and save it as a different name and load it up to SharePoint. Then, open it and save it back. If that works, then you can delete the original from SharePoint, and rename the new one to the original name, assuming all info in the docs are identical. Sometimes, there's a connection problem when a document had to be recovered on the client machine, while still maintaining an open link to SharePoint.
0
 

Author Comment

by:KBAguy
Comment Utility
Neither solution resolved this issue. However, I had the user reduce the size the Excel file by removing some old history lines and so far the user is reporting NO issues.
0
 
LVL 9

Expert Comment

by:BobHavertyComh
Comment Utility
Are your files bigger than the max upload setting in Central Admin?

By default SharePoint allows a maximum file size of 50MB that can be uploaded.
Application Management >> Web Application General Setting page. If it looks OK, this still might not be a size problem and instead something else and could come back up again. Is it possible that you could have removed something it didn't like in the spreadsheet itself?
0
 

Author Comment

by:KBAguy
Comment Utility
Unfortunately not it. Maximum Upload size is setting at the default of 50MB. The file in question is only 2.48MB.
0
 
LVL 9

Expert Comment

by:BobHavertyComh
Comment Utility
What do you see when you go to your browser and enter the url from the error message minus the file name? Do you see the shared docs library? That's an odd url.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:KBAguy
Comment Utility
Yes I see the Shared Docs Library. It shows the document in question along with several others.
0
 

Author Comment

by:KBAguy
Comment Utility
Even though the file in question was only 2.48MB, the only solution to-date has been to export it out into a new file name, reduce the number of lines and then save in it's reduced file size and add back into the library. They have not had a problem since.
0
 
LVL 9

Expert Comment

by:BobHavertyComh
Comment Utility
Do you have ForeFront AV? It scans files before they are uploaded into SharePoint and it treats them as "containers" so that it can do it's scan. There are settings for maximum container size and maximum scan timeout for ForeFront. I've seen this cause problems before, but your file size looks pretty small to cause this.

Or, maybe SharePoint itself doesn't like those rows for some reason if they violate a Sharepoint list rule in some way. It's possible that by invalid url in the error message, it really means invalid document that it references via it's url. So the url is actually the fully qualified doc name, and that is what is invalid. Have you ever been able to upload this doc with the apparently offending rows? If not, then that has to be your answer. Maybe the rows in question contain a duplicate row with another row that SharePoint doesn't like. You mentioned "history" rows. If you have been able to upload these rows in the past, then a broken link between this doc and SharePoint has occurred and is still left over. I would guess the former, assuming you have literally created a new doc locally, copied the contents of the failing doc into it, and tried uploading it as something that SharePoint has no previous connection to.
0
 

Accepted Solution

by:
KBAguy earned 0 total points
Comment Utility
Per a previous post even though the file in question was only 2.48MB, the only solution to-date has been to export it out into a new file name, reduce the number of lines and then save in it's reduced file size and add back into the library. They have not had a problem since.
0
 
LVL 9

Expert Comment

by:BobHavertyComh
Comment Utility
There were a couple of questions that I asked such as if you were ever able to upload this doc in the past with the currently offending rows, but, if you're happy with your solution, then that's fine.
0
 

Author Closing Comment

by:KBAguy
Comment Utility
It's the only solution that has satisfied the user and I don't currently have the time to pursue this issue any further.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now