Environment
Security Manager 6.0
Situation
The file to be uploaded is located on the LAS server under the Log_Archive directory | CubeExport folder. The name of the file stuck in the uploading process will be a date with a string of numbers on the end, for example 20071231_131011_2248.uploading.
Data from that file will be missing from the summary and trend analysis reports.
Data from that file will be missing from the summary and trend analysis reports.
Resolution
Go to the LAS server | Log_ Archive directory | CubeExport folder and rename the .uploading files to .completed. The next scheduled upload will process and upload it.
Cause
This issue results from a rollback after a bulk copy error. Using 'named pipes' and not TCP/IP for connectivity is normally very slow, we don't support it. So there is a pretty good chance that the fundemental cause for this issue is the use of named pipes for connectivity instead of TCP/IP. When the upload fails and the cleanup procedure is trying to clean up and make it ready for another upload (remove the temporary table and rename the file to .completed), this throws an exception. Because of this the '.uploading' file does not get renamed to '.completed' again and hence it will never get uploaded.
Additional Information
Formerly known as NETIQKB70854