Solved

Internet Address is not valid

Posted on 2013-02-07
12
1,930 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 34

Expert Comment

by:Paul MacDonald
ID: 38864577
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
ID: 38864578
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
ID: 38875781
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 9

Expert Comment

by:BobHavertyComh
ID: 38876066
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
ID: 38876332
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
ID: 38878836
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
 

Author Comment

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

Author Comment

by:KBAguy
ID: 38894981
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
ID: 38896909
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
ID: 38915579
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
ID: 38915678
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
ID: 38929166
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

630 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