Service Configuration
-
Change the log file location, if required. By default the log file will be placed in C:\Files\CIS\Logs.
<appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender"> <param name="File" value="C:\Files\CIS\Logs\RX_CIS.log"/>
<appender name="MissingRollingLogFileAppender" type="log4net.Appender.RollingFileAppender"> <param name="File" value="C:\Files\CIS\Logs\RX_CIS_Missing.log"/>
-
Change the MSMQ ComputerName to the FQDN of the Responder Server.
Verify that the ComputerName is not populated, it should say ComputerName.
<wellknown type="Miner.Responder.Shared.IDataServices, Miner.Responder.Shared" url="msmq://FormatName:DIRECT=OS:{ComputerName}\private$\RxServer/DataServices.rem" />Set the ComputerName here:
<channel ref=”msmq” ComputerName="ComputerName" />
-
Application Configuration
The tables below provide explanation and examples of service configurations.
Cis Database:
Config Key
Config Description
Default Config Value
ServerName
Database server name.
For sqlserver, the ServerName setting should contain the server and instance
Oracle: “minerva.miner.com”
SQL Server:
"marlins\mssql5"
ServerSID
Database SID.
For sqlserver, the ServerSID setting should contain the database, e.g. GIS
Oracle: “minerva.miner.com”
SQL Server:
"GIS"
ServerServiceName
Service name for Oracle
“orca9.minerva”
ServerUser
Server username
“responder”
ServerPass
Server Pasword
“responder”
ServerUseOracle
If Oracle needs to be used mention true
false
ServerUseServiceName
If Oracle Service Name needs to be used mention true
false
Rx Database:
Config Key
Config Description
Default Config Value
RxServerName
Rx Database server name.
For sqlserver, the ServerName setting should contain the server and instance
Oracle: “minerva.miner.com”
SQL Server:
"marlins\mssql5"
RxServerSID
Database SID.
For sqlserver, the ServerSID setting should contain the database, e.g. GIS
Oracle: “minerva.miner.com”
SQL Server:
"Responder"
RxServerServiceName
Service name for Oracle
“orca9.minerva”
RxServerUser
Server username
“responder”
RxServerPass
Server Pasword
“responder”
RxServerUseOracle
If Oracle needs to be used mention true
false
RxServerUseServiceName
If Oracle Service Name needs to be used mention true
false
SQLString
Specify the staging view name which contains data from CIS
"SELECT * FROM RESPONDER.RESPONDER.RX_CUSTOMERS_CIS_VW {0}"
SetDefaultOID
Determines whether to set a default service point ObjectID for a customer whose service point cannot be found in GIS.
false
DefaultOID
The default service point ObjectID to assign to customers that cannot be associated with a service point in GIS.
320212
ChangeVersion
Set to true if not using sde.default version searching service points in GIS.
false
Version
Name of version to use for searching for service points. (this is ignored if the above parameter is set to false).
SDE.DEFAULT
CustomFields
A comma-delimited list of custom fields in RxCustomers table to be populated. These field names should also match the names of the corresponding source fields in the staging view referenced in the SQLString parameter above.
Example:
TransformerId, LocationId
ExcludedColumns
A comma-delimited list of fields in RxCustomers table to exclude from the sync.
Example:
FEEDER_ID
UseSecondaryID
Determines whether to use an additional field (in addition to ACCOUNT) for searching for matching customer in RxCustomers table. If match is not found by ACCOUNT, then the additional field is searched.
false
SecondaryID
Additional field to use for searching for matching customer in RxCustomers table.
SID
LogUpdates
Determines whether to include detailed logging of individual field updates in the application log file.
true