The Temp File Service database, the tenant previously specified in the 5_tempfs.json file, must be updated to the most recent database schema. To do this, execute the following command from a command line interface, with [path to 5_tempfs.json] replaced with the full path to the 5_tempfs.json file:
TempFileService.Configuration.exe database update --json-config "[path to5_tempfs.json]"
For example, if the API Server was installed in the default directory, the command is:
TempFileService.Configuration.exe database update --json-config "C:\Program Files\Hyland\ApiServer\config\5_tempfs.json"
If you use Oracle database, the use of quoted identifiers will cause all identifiers to be case sensitive. This means that the hsitempfile user must be created as "hsitempfile", including the double quotation marks, or the migration will not recognize it. To create a user, use following commands:
CREATE USER "hsitempfile" IDENTIFIED BY "hsitempfile"; GRANT UNLIMITED TABLESPACE TO "hsitempfile"; GRANT CREATE SESSION TO "hsitempfile"; GRANT CREATE TABLE TO "hsitempfile"; GRANT SELECT_CATALOG_ROLE TO "hsitempfile"; GRANT ALTER ANY TABLE TO "hsitempfile"; GRANT DROP ANY TABLE TO "hsitempfile"; GRANT CREATE SEQUENCE, SELECT ANY SEQUENCE TO "hsitempfile"; GRANT CREATE TRIGGER TO "hsitempfile";