The following table lists the available configuration options, acceptable values, and descriptions of the settings in the SQL-n set of properties found in the SAP Control Center. These settings are also those found in the [SQL-n] section of the Agentry.ini file. When adding such a section the n portion of the section name must match the ID of the corresponding SQL Database system connection definition in the application. If no such system connection exists, the settings in this section will not affect the behavior of the Agentry Server or the application.
| Configuration Setting | Acceptable Values | Description |
|---|---|---|
| name | Text value. Default: null | This setting can contain any text value used to identify the system connection in log files and other areas. This should be set to a unique value especially when working with multiple system connections. |
| sharedConnections | Zero or positive integer value. Default: 0 | This setting specifies the number of connections created by the Server upon startup. If greater than 0, a connection pool is created and data from a single Client may be processed on any of these connections, including multiple different connections during a single transmission. If set to 0, each Client transmission will use a single database connection from start to finish. |
| queryInitFile | Valid file or path and file name to properly formatted query initialization file. Default: sqlBE.ini | This setting specifies the name and location for the query initialization file used by this system connection. This initialization file contains numerous sections related to various Server events when working with a database system connection. The file referenced here is expected to contain all of these sections in the proper format. |
| debug | Boolean value of “true” or “false.” Default: see description. | This setting specifies whether or not the log file referenced in queryDebugFile is generated by the Server. It also enables or disables the creation of the sql.query.user.log file. This setting is false by default for production servers and true for development servers. |
| queryDebugFile | Valid file or path and file name. Default: sql.query.log | This setting specifies the log file generated by the server to contain log messages for the system connection. This includes query results and database generated messages. This file name may be changed when multiple database system connections are in use. The name may include the token %1 to include the text value from the name configuration option in the log file’s name. Example: “%1.sql.query.log” would produce a log file named similar to: “MyDB.sql.query.log” |
| saveQuery | Boolean value of “true” or “false.” Default: see description | This setting specifies whether or not the query being executed is included in the query debug log file. This setting is false by default for production servers and true for development servers. |
| saveResult | Boolean value of “true” or “false.” Default: see description | This setting specifies whether or no the resulting messaging from the database is included in the query debug log file. NOTE: Error messages from the database are always written to the log file. This setting is false by default for production servers and true for development servers. |
| queryConstantsFile | Valid file name or path and file name. Default: see description | This setting specifies the file name and location, relative to the Server, of the query constants file. The default for this setting depends on the type of database selected during installation and will be set to either oracle_sd.ini or sqlserver_sd.ini. |
| preloadQueryInitFile | Boolean value of “true” or “false.” Default: see description | This setting specifies whether query initialization file named in the queryInitFile setting is loaded when the Server starts up, or if it is read by the Server for each new Client connection. If false, changes to the query initialization file will not take affect until the Server is restarted. This setting is false by default for production servers and true for development servers. |
| enableAuthentication | Boolean value of “true” or “false.” Default: true | This value specifies whether or not users are authenticated against the back end system for this system connection. At least one system connection within the application must perform user authentication. |
| enablePreviousUserAuthentication | Boolean value of “true” or “false.” Default: true | This value specifies whether or not previous users are authenticated against the back end system for this system connection. This authentication occurs when a user change occurs on the Client. |
| useUserDBAuthConnection | Boolean value of “true” or “false.” Default: false | This value specifies whether or not the connection used to authenticate the user should be the same one used to process synchronization for that user. If false, the Server will use a different connection. |
| allowUserToChangePassword | Boolean value of “true” or “false.” Default: true | This value specifies whether or not users can change their passwords on the Client when the database indicates the password has or is about to expire. If enableAuthentication is false, this setting has no affect. |
| dbConnectionName | Text value with valid system connection name. Default: set by installer. | The value of this setting contains the TNS name or ODBC DSN name the Server will use to connect with the database. |
| dbConnectionUserID | Text value with valid user ID | The user ID the Server will use to log into the database. |
| dbConnectionPassword | Text value with valid password. Default: set by installer. | The password for the user ID the Server will use to log into the database. |
| dbConnectionPasswordEncoded | Boolean value of “true” or “false.” Default: false | Specifies whether or not the value in dbConnectionPassword has been encoded by the quick password encoder utility. This value should not be changed manually as the encoder utility will set it appropriately. |
| dbConnectionType | “Oracle” or “ODBC.” Default: set by installer. | Specifies whether the Server is connecting to the database using an ODBC or Oracle Net Service Name. |
| disconnectFromDB | Boolean value of “true” or “false.” Default: false | This Boolean value specifies whether or not the Server should disconnection from the database at the time specified in disconnectTime. This is set to true when the database performs periodic batch or other processing and when such processing dictates that no connections should be made to the database system. |
| disconnectTime | 24 hour clock value in hours and minutes. Default: 2:30 | This setting contains the time of day when the Server should disconnect from the database. This setting has no affect if disconnectFromDB is false. |
| reconnectTime | 24 hour click value in hours and minutes. Default: 4:00 | This setting contains the time of day when the Server should reconnect to the database. It must be later than the time specified in disconnectTime. This setting has no affect if disconnectFromDB is false. |
| timeZoneName | Valid time zone name. | This setting contains the name of the time zone to which date and time values are converted when received from Clients; or from which they are converted when sent to Clients. This conversion is based on the application definitions. This setting is only used to specify a time zone other than the one for the back end system. |