Solved

Internet Address is not valid

Posted on 2013-02-07
12
1,796 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 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

770 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