Studio Creatio
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

Web.config configuration (Oracle only)

When deploying an Oracle-based Creatio application, altering the application configuration Web.config file is the next required step after configuring the ConnectionStrings.config file to ensure Creatio operates as intended.

To configure Web.config:

1.Go to the root directory of the Creatio application ~\WebAppRoot\Creatio.

2.Open the Web.config file in a text editor.

3.In the general parameter of the <db> block, change the value of the currentSchemaName attribute to the schema name that is specified in ConnectionStrings.config. This is to allow the website application read the connection configuration parameters.

<db>
    <general securityEngineType="Terrasoft.DB.Oracle.OracleSecurityEngine, Terrasoft.DB.Oracle"
executorType="Terrasoft.DB.Oracle.OracleExecutor, Terrasoft.DB.Oracle"
isCaseInsensitive="true" maxAnsiJoinCount="0"
engineType="Terrasoft.DB.Oracle.OracleEngine, Terrasoft.DB.Oracle"
metaEngineType="Terrasoft.DB.Oracle.OracleMetaEngine,
Terrasoft.DB.Oracle"
metaScriptType="Terrasoft.DB.Oracle.OracleMetaScript,
 Terrasoft.DB.Oracle" typeConverterType="Terrasoft.DB.Oracle.OracleTypeConverter,
Terrasoft.DB.Oracle" connectionStringName="db"
binaryPackageSize="1048576" useOrderNullsPosition="true"
 currentSchemaName="[Oracle DB schema name]" maxEntitySchemaNameLength="30" />
</db>

4.Make sure that the 4.112.1.2 library version is specified in the <DbProviderFactories> block. The parameter defines the data provider to connect the website to the database.

<system.data>
       <DbProviderFactories>
           <remove invariant="Oracle.DataAccess.Client" />
           <add name="Oracle Data Provider for .NET"
invariant="Oracle.DataAccess.Client" description="Oracle Data
 Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess,
Version=4.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
       </DbProviderFactories>
   </system.data>

5.Specify the quartz.dataSource.SchedulerDb.provider key value in the <quartz> block. The parameter is required by the scheduler to interact with the database tables.

<add key="quartz.dataSource.SchedulerDb.provider" value="OracleODP-1123-40" />

6.Save the changes.

See also

Checking Windows mandatory components

Configure the application site on IIS.

Set up websockets.

Switching from HTTP to HTTPS

Did you find this information useful?

How can we improve it?