Solutions

Changing the default size limit for files returned by the GetFileField and UpdateFileField Web service and JSON calls



ID:    S142607
Published:    21 August 2018
Updated:    22 August 2018

Product(s)

  • SBM
 

Description

The total size of  the response that is returned by the GetFileField and UpdateFileField calls is determined by the FileFieldTotalSizeMax_MB global system setting in the code. The default value is 50MB.

 

This is set for performance reasons and should only be increased with caution.

Resolution

To change this value, add a new entry to the TS_SYSTEMSETTINGS table for FileFieldTotalSizeMax_MB.

 1. Allocate a new TS_ID for the new Setting record to be added by updating the TS_LASTIDS table.
UPDATE TS_LASTIDS SET TS_LASTID = TS_LASTID + 1 WHERE TS_TABLEID = 56;
2. The TS_ID returned from the following SQL command should be used for the new Setting record.
SELECT TS_LASTID FROM TS_LASTIDS WHERE TS_TABLEID = 56;
3. In the TS_SYSTEMSETTINGS table, add a new record for that TS_ID using TS_NAME= FileFieldTotalSizeMax_MB and set the LONGVALUE and LONGDEFAULT to the maximum number of MBs that you want the GetFileField call to return.
4. Save your database changes.
6. Restart IIS.

Applies To

SBM 11.4.1

Rate this Solution

Find Answers

Type a question or describe what you are looking for below

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs