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