Creating an SQL script by submitting a request to an active instance

If a hotfix requires schema changes and you want to apply them manually, you can generate an SQL script by invoking a web service to connecct to an active instance of Pega Platform. Your database administrator can use this script to manually apply the schema changes.

To invoke a web service to generate an SQL script, do the following steps.

Configure the common properties of the prpcServiceUtils.properties file.

Property name	Value
`pega.rest.server.url`	The URL for the REST service, specified in the following format: `http://` `<hostname>` `:` `<port>` `/` `<context>` `/PRRestService/` `<tenant hash>` For example: `http://myhost:8080/prweb/PRRestService` Include the tenant hash only for multitenant systems.
`pega.rest.username`	The operator name on the target system with access to REST services.
`pega.rest.password`	The password of the specified operator.
`pega.rest.proxy.host`	Optional: The host name of the REST proxy server. Do not use localhost as the host name.
`pega.rest.proxy.port`	Optional: The port for the REST proxy server.
`pega.rest.proxy.username`	Optional: The operator name on the REST proxy server with import and export access.
`pega.rest.proxy.password`	Optional: The password of the REST proxy operator.
`pega.rest.proxy.domain`	Optional: The domain of the REST proxy server.
`pega.rest.proxy.workstation`	Optional: The workstation ID for the REST proxy server.
`pega.rest.response.type`	The REST response type, either `xml` or `json`. The default value is `json`. Rollback, restore point, and update access group operations support only `json`.
`user.temp.dir`	Optional: Enter the full path to the temporary directory. Leave this blank to use the default temporary directory. For more information about temporary directories, see Temporary files and temporary files directories .

Configure the script properties of the prpcServiceUtils.properties file.

Property name	Value
`hotfix.operation`	`generateDDL`
`hotfix.dlFilePath`	Comma-delimited list of hotfix package download (DL) file names and paths.
`hotfix.async`	`true` or `false`. The default value, `true`, executes the hotfix operation asynchronously. The system queues the job and returns a JobID to use to get the job status. A value of `false` executes the operation synchronously.

Save and close the prpcServiceUtils.properties file.

Run the prpcServiceUtils.bat or prpcServiceUtils.sh script with the hotfix option, for example:

prpcServiceUtils.bat hotfix

Optional: Pass one or more arguments:

prpcServiceUtils script argument	Value
`connPropFile`	The full path to the serviceConnection.properties file that includes information for multiple targets.
`poolSize`	The thread pool size. Default is 5.
`requestTimeOut`	How long the system waits for a response before failing with a timeout error. Default is 300 seconds.
`jobIdFile`	The path to the job IDs file that is generated by the asynchronous operation.
`propFile`	The full path to the properties file, to override the default prpcServiceUtils.properties.