Log Archive Upload leaves files as .uploading. (NETIQKB70854)

  • 7770854
  • 31-Dec-2007
  • 08-Aug-2008

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.

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