Extending Configuration File Manually

In this article:

Configuration File Structure

<Metabases> Section

Repository Settings Section

<LogonData> Section

<Credentials> Section

Section <TaskContainer>

<LOG> Section

<HOST> Section

<Mail> Section

<Ftp> Section

<Credentials> Section

<MailTo> Section

<SPCredentials> Section

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 repository 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. 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:

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.

See also:

Configuration File