Database Timeout During Configuration Import - WorkView - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Premier - external - Premier

WorkView
Platform
OnBase
Product
WorkView
Release
Foundation 24.1
License
Premier

When importing a configuration for OnBase Studio that has been previously exported, each table is copied so that a backup is available in case the process fails. This backup process can be slow for large tables, and the process may time out if it exceeds the default time limit. If the process times out, you may receive the following message:

Hyland.Data.Exceptions.OracleDatabaseException: ORA-01013: user requested cancel of current operation

To prevent timing out of the import process, increase the length of time allowed before the database times out. This needs to be configured for the web.config file of the Application Server (for most imports) and for the obstudio.exe.config file of OnBase Studio (for running locally).

To increase the database timeout length for importing configuration files in OnBase Studio:

  1. Locate the web.config file of the OnBase Application Server. The default file location is C:\inetpub\wwwroot\AppServer64.
  2. Open the web.config file in a plain-text editor.
    Note:

    The *.config file should only be edited in a plain-text editor, such as Notepad, or a utility specifically designed to edit XML files. It should not be edited in a binary editor, such as Microsoft Word. Using a binary editor can introduce invalid characters to the file and make it unreadable by the software.

  3. Locate the ConfigurationImport_DatabaseTimeout key within the <appSettings> element.
  4. For the value of ConfigurationImport_DatabaseTimeout, enter the time you would like to allow for the import process in seconds. The default value is 300 seconds.
    For example: <add key="ConfigurationImport_DatabaseTimeout" value="360" />
  5. Save and close the web.config file.
  6. Recycle the application pool for changes to the web.config file to take effect.
  7. Locate the obstudio.exe.config file of OnBase Studio.
  8. Open the obstudio.exe.config file in a plain-text editor.
    Note:

    The *.config file should only be edited in a plain-text editor, such as Notepad, or a utility specifically designed to edit XML files. It should not be edited in a binary editor, such as Microsoft Word. Using a binary editor can introduce invalid characters to the file and make it unreadable by the software.

  9. Locate the ConfigurationImport_DatabaseTimeout key within the <appSettings> element.
  10. For the value of ConfigurationImport_DatabaseTimeout, enter the time you would like to allow for the import process in seconds. The default value is 300 seconds.
    For example: <add key="ConfigurationImport_DatabaseTimeout" value="360" />
  11. Save and close the obstudio.exe.config file.
  12. If OnBase Studio is running, restart OnBase Studio.