Voltar
-
Título
Getting “Server name not found” message when using automation to write to Sharepoint -
Descrição
There are several automation tasks in a Windows 7 computer .
One of them saves some Excels to SharePoint for the users to check the Organization Users security settings.
These change according to the Roles assigned to them in SAP.
The task does not finish as it fails with the error "Server name not found"
-
Causa
Sharepoint / System issue .
It looks like that the cause of the problem is that the Windows service that looks up server names, times out after about 8 seconds,
and if you are not connected currently to the Sharepoint server, Windows may time out.
-
Resolução
WORKAROUND 1
Keep any file on the Sharepoint server open for writing.WORKAROUND 2
Map a Drive to the Sharepoint path. Even though Toad does not allow to enter the mapped file name, the issue is still solved.
WORKAROUND 3Change some of the parameters in the Registry under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\NetBT\Parameters:
Change the amount of time that Windows times-out. Note that this will effect you every time you enter a wrong UNC path.
Change the amount of time a Session remains in memory. Note that this will not help if you restart the Computer.
WORKAROUND 4Map the Server in the hosts file
WINDOWS REGISTRY DISCLAIMER
Quest Software does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 “Description of the Microsoft Windows registry” at Microsoft Support. https://support.microsoft.com/en-us/help/256986/windows-registry-information-for-advanced-users