Extending Configuration File Manually

Configuration file extension is required if on automatic creation of configuration file the required sections in structure were not created.

To extend configuration file manually, follow the steps:

1. Open configuration file in any text editor.

2. Add the required modifications according to the configuration file structure and section description.

3. Save configuration file in the XML format and refresh settings of tasks scheduler.

Configuration File Structure

A configuration file with all possible settings for one task container looks as follows:

<Metabases ThreadsCount = "10" ProcessLocale = "1033" UILocale = "1033">

<TEST Name="TEST" Authentication="1" Driver="ORCL8" Package="STANDARDSECURITYPACKAGE" DebugMode="1">

<LogonData SCHEME="TEST" SERVER="TEST" />

<Credentials Authentication="1" USER="User1" PASSWORD="Password" />

<TaskContainer ID="MY_TASK_CONTEINER" RestartSecs="300"/>

<LOG Logging="1" File = "File.log" MaxRecordCount = "1000"/>

<Host>

<Mail Host="mail.example.com" Port="0" From="user1@example.com" />

<Ftp Agent="prognoz application server" AccessType="0" ProxyName="" />

<Credentials USER="domain\user" PASSWORD="password" Ask="1"/>

<MailTo Mail="admin@example.com"/>

<SPCredentials SAME="0" USER="domain\user" PASSWORD="<password>"/>

</Host>

</TEST>

</Metabases>

NOTE. The <HOST> section is required if the container task parameters are set up to send email messages or to save the file to an FTP server. This section and the <LOG> subsection are not created automatically. If more than one connection to metabase are planned in the configuration file settings, settings of the <HOST> section and the <LOG> subsection are read from the first connection and will be used for all next connections.

Child elements of the <Metabases> section contain information on repository connection, email server settings, task scheduler settings, and so on.

<Metabases> Section

Attribute	Brief description
ProcessLocale	It determines regional settings value for the task scheduler. If this attribute is not set, the value of regional settings is obtained from regional settings of the operating system.
UILocale	It determines the interface language value for the task scheduler. If this attribute is not set, the value is taken from Foresight Analytics Platform language settings for the current user. If language settings are not determined, they match value of the ProcessLocale attribute.
ThreadsCount	It determines the maximum number of tasks running simultaneously at the task scheduler. Restriction of the number of simultaneously running threads is caused by certain server problems, for example, memory shortage, which arise when a large number of tasks are executed at the same time. If this attribute is not set, the number of threads is not restricted.

Repository Settings Section

Repository settings section may have an arbitrary name. When a configuration file is created automatically, the section name matches the repository identifier. In the example of the configuration file given above this section has the name TEST. This section includes several subsections.

Attribute	Brief description
Name	It sets repository name.
Authentication	It sets authentication type: 1. Password. 2. Integrated domain. 3. Role.
Driver	It sets the driver type: ORCL8 - Oracle. MSSQL2008 - Microsoft SQL Server 2008. MSSQL2012 - Microsoft SQL Server 2012\2014\2016. MSSQL2012ODBC - Microsoft SQL Server (ODBC). TRDT - Teradata. POSTGRES - PostgreSQL. SQLITE - SQLite. TIP. For details about supported DBMS versions, see the Supported DBMS article.
Package	Sets a security package.
DebugMode	It determines whether assemblies are cached on the local disk: 0. Without caching. 1. Assemblies are cached.
DL	It determines authorization with delayed loading of descriptors: FALSE (by default). Delayed loading is disabled. TRUE. Delayed loading is enabled.

<LogonData> Section

Attribute	Brief description
Server	It sets name of the DBMS server containing a repository. It is specified when working with one of the DBMS: Oracle, Teradata, PostgreSQL, Microsoft SQL Server.
Scheme	It sets name of the schema, in which a repository is created. It is specified when working with one of the DBMS: Oracle, PostgreSQL.
Database	It sets name of the schema, in which a repository is created. It is specified when working with one of the DBMS: Microsoft SQL Server, Teradata.
FileName	It sets database file name. It is specified when working with SQLite DBMS.

The list of latest supported DBMS versions is given in the Supported DBMS subsection.

<Credentials> Section

Attribute	Brief description
Authentication	It sets a type of authorization in the repository at task scheduler start: 0. Authorization type is selected at the server start. 1. Password authorization. 2. Domain authorization. 6. Password with credentials encryption.
USER	It sets the user name for password authorization.
PASSWORD	It sets the user password for password authorization.
Ask	It determines whether the user name and the password should be requested during user authorization in the repository: 1. Request user name and password. The authorization dialog box opens. If the authorization type is chosen at the scheduler start, you can use domain authorization when the user name and the password are requested. If this attribute is missing, the user name and the password are not requested during authorization.

Section <TaskContainer>

Attribute	Brief description
ID	It sets task container identifier in the specified repository.
RestartSecs	It sets the interval for task container check (in seconds).

<LOG> Section

Operations log is maintained if the configuration file contains this section.

Attribute	Brief description
Logging	It determines whether operation log is maintained: 1. Maintain. 0. Do not maintain.
File	Determines a name of the file to maintain operation log. If the attribute is missing, Scheduler.log is used by default. The log file is located in the folder with installed Foresight  Analytics Platform.
MaxRecordCount	It determines the maximum number of entries in the operation log. If the attribute is missing, the maximum number of records in the log equal to 10 000 000 is set by default.

<HOST> Section

The <HOST> section includes several subsections.

<Mail> Section

Attribute	Brief description
Host	It sets the server to send email messages.
Port	It sets the number of the email port.
From	It sets the email address, which is specified as the sender.
EnableSsl	It determines whether SSL encryption is required for sending messages via external mail services: 1. In use. 0. Not in use.

<Ftp> Section

Attribute	Brief description
Agent	It sets a name of the application that is used to connect to FTP server.
AccessType	It sets access type: 0. Registry settings are used. 1. The Internet is used. 2. Proxy is used.
ProxyName	It sets proxy server name.

<Credentials> Section

This element is required only if the outgoing mail server requests authorization.

Attribute	Brief description
USER	It sets user name for authorization. If the USER attribute contains the "\" character, the domain name is specified before this character, and the user name is specified after this character.
PASSWORD	It sets user password for server authorization.
Ask	It determines whether user name and the password should be requested during user authorization: 1. Show authorization dialog box on the outgoing mail server. If this attribute is missing, the user name and password are not requested during authorization, and the data specified in the USER and PASSWORD attributes is used.

<MailTo> Section

Attribute	Brief description
Mail	It sets the email address, to which a message will be sent on repository connection. This message contains information on whether the connection has been successful or not. Also, messages on errors not related to tasks execution are sent to this address.

<SPCredentials> Section

This element is necessary if you need to specify credentials for authorization at the SharePoint web site.

If this section is unavailable, site authorization uses credentials specified at the OS login.

Attribute	Brief description
SAME	It determines whether to use specified credentials: 0. Credentials are used that are specified in the USER and PASSWORD attributes of this subsection. 1. Credentials are used that are specified in the Credentials subsection of the HOST section.
USER	It sets user name for authorization. If the USER attribute contains the "\" character, the domain name is specified before this character, and the user name is specified after this character.
PASSWORD	It sets user password for server authorization.