Answer

PROBLEM

Daily Fax Usage Reports does not show the correct number of incoming faxes. It claims that the number of incoming faxes is 0 for any days selected (although some inbound faxes are archived successfully in the SQL database).

ENVIRONMENT

• GFI FaxMaker SR1 or higher
• Microsoft SQL Server

SOLUTION

In Micosoft SQL Studio, alter the table definition for fm_faxin:

1. Go to Tools > Options > Designers
2. Uncheck option Prevent saving changes that require table re-creation
3. Change type of column result from nchar(255) to nvarchar(255)
   • Note: Values for + nchar are fixed-length, which will reserve storage space for number of characters you specify even if you don't use up all that space, whereas + nvarchar are variable-length, which will only use up spaces for the characters you store. It will not reserve storage like nchar.
4. After the table alteration, run the following script to remove the extra spaces from the result column:

UPDATE fm_faxin

SET result = "SUCCESS"

WHERE result LIKE "%SUCCESS"

CAUSE

The column result of the table fm_faxin is fixed length.