This documentation supports the 18.08 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Approver fields

This topic contains information about how the Approval Server manages the sizes of approver fields and a utility that is used for this purpose.

Lengths of approver fields

By default, approver names are limited to 255 characters and the list of members in an approval server role is limited to 512 characters. The approval server checks the lengths of the fields listed in the following table at startup, and enforces this length as the maximum limit.


Approver fields checked for maximum length at startup

Field ID

Field name

Form name

12401

Member List

  • AP:Role

13203

Original Approvers

  • AP:Signature
  • AP:PreviewSignatures

13205

Next Approvers

  • AP:Signature
  • AP:PreviewSignatures

13207

Approvers

  • AP:Signature
  • AP:PreviewSignatures
  • AP:PreviewInfo

14511

GNA Approvers

  • AP:Signature

14512

PGNA Approvers

  • AP:Signature

You can increase the length of these fields to the maximum limit permitted by the database (VARCHAR limit) by manually executing a approval server utility. See Approval Change Schema.

Note

In release 7.5.00, the approval server only checks the size of the Approvers field at startup, and enforces this length as the maximum limit for approver names. If the default limits are insufficient, you need to increase the field lengths manually.

VARCHAR limits for special fields on supported databases

Database

VARCHAR limit

Microsoft SQL Server

8000

Note: Even though the VARCHAR limit on SQL Server is 8000 characters, the Approval Change Schema utility sets the field length to 4000 characters to support Unicode.

Oracle

4000

To use longer approver names with previews, make the following changes:

  • For regular previews, increase the length of the Approvers and Original Approvers fields on AP:PreviewSignatures.
  • For real-time previews, increase the length of the Approvers field on AP:PreviewInfo.

Approval Change Schema utility

Administrators can run the Approval Change Schema (chgschema) utility to set the length of approver fields on certain forms to the maximum limit allowed by the database. Approver fields checked for maximum length at startup lists the forms and their approver fields that are affected. To run the chgschema utility manually, see Running the approval utilities.

The syntax for chgschema is as follows:

chgschema
 -x Server
 -u User
[-p Password] [-t TCP Port]
[-r RPC Port] [-a Authentication String]


The following table describes the parameters that administrators need to supply when running the chgschema utility:


Parameters for the chgschema utility

Parameter

Description

-x

(mandatory) Name or IP address of the BMC Remedy AR System server to log into (or localhost, if applicable).

-u

(mandatory) Specify the BMC Remedy AR System user name. This user must belong to an administrator group, otherwise the utility can not be run successfully, and the following error is displayed at the command prompt and written to approval-utils.log:
Admin verification failed: <userName>

-p

(optional) Specify the password for the aforementioned user. Omit this parameter if the user account does not have a password.

-t

(optional) TCP port number of the server being logged into. This parameter is required if the BMC Remedy AR System server is configured to listen on a particular TCP port.

-r

(optional) RPC port number of the server being logged into. This parameter is required if the BMC Remedy AR System server is configured to listen on a particular RPC port.

-a

(optional) Specify the authentication string.

Note

  • The chgschema utility increases the lengths of the approver fields provided that the current lengths are not already set to the maximum VARCHAR limit, or to unrestricted or 0 (zero). In case of the Member List field, if the maximum length supported by the database is less than 512 characters, the current field length is not modified. This ensures that the corresponding data remains intact.
  • After running the utility, you must restart the approval server for the changes to take effect.
Was this page helpful? Yes No Submitting... Thank you

Comments