| Applies To | |||
| Product(s): | eB Web | ||
| Version(s): | 15.03.02.261 | ||
| Environment: | N/A | ||
| Area: | File | ||
| Subarea: | N/A | ||
| Original Author: | Bentley Technical Support Group | ||
Problem
In the Web UI, I attempt to checkout an Excel file, and it fails. The error states:
I'm sorry, there was a problem downloading the file",an error occurred during the transfer. Server Message:'Could not lock the file 'c:\eBCheckout\' (Some of the requireed values were not specified. Cannot insert the value NULL into column 'machine_name',table 'eBProd.dbo.checkout_files';column does not allow nulls. INSERT fails.
Solution
This issue relates to http://support.microsoft.com/kb/323308
In short: IE does not allow you to download Excel files via SSL if the server specifies a no caching header. The web server specifies no caching because otherwise IE won’t always fetch the right file. This is a bug in IE. After following the instruction in the KB article, the checkout now works as expected.
Internet Explorer 7 and Internet Explorer 8
To resolve this issue in Internet Explorer 7 and in Internet Explorer 8, follow these steps:
1. Start Registry Editor.
2. For a per-computer setting, locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings
3. On the Edit menu, click Add Value.
4. To override the directive for HTTPS connections, add the following registry value:
"BypassSSLNoCacheCheck"=Dword:00000001
To override the directive for HTTP connections, add the following registry value:
"BypassHTTPNoCacheCheck"=Dword:00000001
5. Quit Registry Editor.
See Also
External Links
Bentley Technical Support KnowledgeBase
Comments or Corrections?
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!