Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Internet Address is not valid

Posted on 2013-02-07
12
Medium Priority
?
1,972 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
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.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

715 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