Exact Synergy

CompressItemAttachments.exe - Background process

Background Job: BLProcess.exe

Introduction

Items management can be used for the version control of a development organization. This allows the organization to store all of their targets in the central e-Synergy database. This has many advantages, all targets are in one place, security can be introduced allowing different people to perform different actions and the relations between targets depending that depend on each other can be made visible.

However storing those item attachments can take up a lot of space. To counter this a background job was created that compresses the item attachments. This background job is CompressItemAttachments.

When you have set up your items so that item attachments can be used, you will see the following screen when you click on Attachments and add the attachements

After running the CompressItemAttachments background job the same screen will look like the screenshot below. Notice that the compressed item attachment sizes have been added to the overview.

The CompressItemAttachments background job can also retrieve version information from the files uploaded as item attachments. The version will then be shown in the overview of the item attachments as can be seen in the screenshot below

Technical Information

The following tables are involved when running CompressItemAttachments.exe:

ItemAttachments (Item attachments)
BacoProcessLog (Log entries from running the background job)

When setting up the CompressItemAttachments background job in either SQL or as Windows Scheduled task there is one specific paramater that can be either added to the command or left out of it. The parameter /DP: can be added to the command to indicate where the attachments should be compressed. This location should be located on a drive that has an amount of free space equal to twice the size of the biggest attachment.

If this parameter isn't added to the command, the background job will use the temporary directory on the server by default. With the parameter added the command will look like this:

C:\Synergy\bin\CompressItemAttachments.exe /S:VORS31266-1 /D:DeltaBike /DP:C:\SynTemp

CompressItemAttachments.exe - Background process

Introduction

Technical Information

Related Topics