Installation Guide

3.0.2
- 3.0 HotFix 1

Back Next

Complete SQL and Oracle Configuration

After you install Proactive Monitoring, follow these general configuration steps to ensure that your SQL Server or Oracle Database runs the Design services smoothly without any issues.

When you make the configuration changes, ensure that all services are shut down and no Java processes run in the background.

Complete SQL and Oracle Configuration File Updates

The following table outlines the necessary additions to the configuration files, applicable to both SQL and Oracle databases:

Relative Path	File Name	Required Configuration
Proactive_Monitoring\rulepoint\conf\	Activemq.xml	<authenticationUserusername="{activemq.password}" groups="producers,consumers,admins" /> hibernate.id.db_structure_naming_strategy=single
Proactive_Monitoring\ rulepoint\conf\	Am_hibernate.cfg	<property name=" hibernate.c3p0.timeout">180</property> <mapping resource="com/informatica/cep/am/entity/Logs.hbm.xml"/>
Rulepoint\conf\cs.hibernate.cfg.xml rulepoint\design\webapps\RTAM\WEB-INF\classes\cs.hibernate.cfg.xml rulepoint\design\webapps\rulepoint\WEB-INF\classes\cs.hibernate.cfg.xml	Cs.hibernate.cfg.xml	<property name=" hibernate.c3p0.timeout">180</property>
rulepoint\conf\ felix.properties	Felix.properties	org.osgi.framework.bootdelegation=com.informatica.cep.sdk,com.informatica.cep.sdk.service,com.informatica.cep.sdk.service.api,com.informatica.cep.sdk.base,org.w3c.dom,org.xml.sax,javax.xml.parsers,javax.xml.namespace,org.xml.sax.ext,javax.xml.stream,org.apache.logging.log4j,javax.xml.soap,javax.xml.transform.stream,javax.xml.transform,javax.xml.transform.dom,javax.sql,java.sql,java.util.concurrent,org.apache.logging.log4j,javax.crypto,javax.crypto.spec,javax.naming,javax.management,javax.xml.soap,javax.xml.transform.stream,javax.xml.transform,javax.xml.transform.dom,javax.net.ssl,javax.net
rulepoint\design\conf\server.xml	Server.xml	<!--Listener className=" org.apache.catalina.core.JasperListener" /--> URIEncoding="UTF-8" redirectPort="8443" relaxedQueryChars=" []\| {}^&#x5 c;&#x 60;& quot;& lt;>" />
Proactive_monitoring\rulepoint\design\webapps\RTAM\WEB-INF\web.xml	web.xml	Add before springsecurityfilterchain <filter-name> RequestFilter</filter-name> <filter-class> com.agentlogic.rtam.filter.RequestFilter</filter-class> </filter> <filter-mapping> <filter-name> RequestFilter</filter-name> < url-pattern>/*</ url-pattern> </filter-mapping> Add before </ web-app > < session-config > < tracking-mode > COOKIE </ tracking-mode > </ session-config >
rulepoint\design\webapps\rulepoint\WEB-INF\classes\config\jdbc.properties.sample	Jdbc.properties.sample	### JDBC Connection URL ### db.url={db.name}
rulepoint\design\webapps\ rulepoint\WEB-INF\classes\felix.properties rulepoint\ sdk\ src\main\external-resources\ felix.properties	Felix.properties	org.osgi.framework.bootdelegation= com.informatica.cep.sdk,com.informatica.cep.sdk. service,com.informatica.cep.sdk.service.api, com.informatica.cep.sdk.base, org.w3c.dom,org.xml.sax, javax.xml.parsers, javax.xml.namespace, org.xml.sax.ext,javax.xml. stream,com.informatica.cep.sdk. propertyeditors,org. apache.logging.log4j

Complete File Configuration for SQL

The following table outlines the necessary additions to the configuration files applicable SQL database:

Relative Path	Configuration
<PMPC_INSTALLED_DIR>\rulepoint\design\webapps\rulepoint\WEB-INF\classes\jdbc.properties	hibernate.id.new_generator_mappings = false hibernate.id.db_structure_naming_strategy=single
<PMPC_INSTALLED_DIR>\rulepoint\design\webapps\RTAM\WEB-INF\classes\rtam-config.properties	hibernate.id.new_generator_mappings = false hibernate.id.db_structure_naming_strategy=single
<PMPC_INSTALLED_DIR>\rulepoint\design\webapps\RTAM\WEB-INF\classes\hibernate.xml	<prop key="hibernate.id.new_generator_mappings">false</prop> <prop key="hibernate.id.db_structure_naming_strategy">single</prop>

Complete Schema Configuration for SQL

To configure a schema for the SQL database with the database administrator credentials, use the following query:

ALTER TABLE RulePoint_Design.WizardCfg_WResponseConfig DROP CONSTRAINT FK3BEC61B424440FAC;

ALTER TABLE RulePoint_Design.WizardCfg_WResponseConfig RENAME COLUMN WizardCfg_id TO WizardConfiguration_id;

alter table RulePoint_Design.WizardCfg_WResponseConfig add constraint FK3BEC61B424440FAC foreign key (WizardConfiguration_id) references RulePoint_Design.WizardCfg;

ALTER TABLE RulePoint_Design.WIZARDCFG_WTOPICCONFIG DROP CONSTRAINT FK42DFE42024440FAC;

ALTER TABLE RulePoint_Design.WIZARDCFG_WTOPICCONFIG RENAME COLUMN WizardCfg_id TO WizardConfiguration_id;

alter table RulePoint_Design.WIZARDCFG_WTOPICCONFIG add constraint FK42DFE42024440FAC foreign key (WizardConfiguration_id) references RulePoint_Design.WizardCfg;

UPDATE RulePoint_Activity.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_Topology.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_Design.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_RTAM.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_TopologyState.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';


COMMIT;

Complete Schema Configuration for Oracle

To configure a schema for the Oracle database with the database administrator credentials, use the following query:

ALTER TABLE RulePoint_Design.WizardCfg_WResponseConfig DROP CONSTRAINT FK3BEC61B424440FAC;

ALTER TABLE RulePoint_Design.WizardCfg_WResponseConfig RENAME COLUMN WizardCfg_id TO WizardConfiguration_id;

alter table RulePoint_Design.WizardCfg_WResponseConfig add constraint FK3BEC61B424440FAC foreign key (WizardConfiguration_id) references RulePoint_Design.WizardCfg;

ALTER TABLE RulePoint_Design.WIZARDCFG_WTOPICCONFIG DROP CONSTRAINT FK42DFE42024440FAC;

ALTER TABLE RulePoint_Design.WIZARDCFG_WTOPICCONFIG RENAME COLUMN WizardCfg_id TO WizardConfiguration_id;

alter table RulePoint_Design.WIZARDCFG_WTOPICCONFIG add constraint FK42DFE42024440FAC foreign key (WizardConfiguration_id) references RulePoint_Design.WizardCfg;

UPDATE RulePoint_Activity.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_Topology.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_Design.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_RTAM.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

UPDATE RulePoint_TopologyState.SCHEMA_CONFIGURATION SET VERSION = '6.2.2' WHERE VERSION = '6.1';

create sequence RulePoint_Design.hibernate_sequence;

ALTER TABLE RulePoint_Design.HIBERNATE_SEQUENCES RENAME COLUMN SEQUENCE_NEXT_HI_VALUE TO next_val;

SELECT * FROM RulePoint_Design.HIBERNATE_SEQUENCES ;

INSERT INTO "RULEPOINT_DESIGN"."HIBERNATE_SEQUENCES" (SEQUENCE_NAME, NEXT_VAL) 
select 'default', max(Max_value)+1 from ( SELECT 'rulepoint_design.dtrole' AS table_name, 'ROLEID' AS column_name, MAX(ROLEID) AS max_value FROM rulepoint_design.dtrole
UNION ALL
SELECT 'rulepoint_design.dtuser' AS table_name, 'userid' AS column_name, MAX(userid) AS max_value FROM rulepoint_design.dtuser
UNION ALL
SELECT 'RULEPOINT_DESIGN.deploymentplan' AS table_name, 'id' AS column_name, MAX(id) AS max_value FROM RULEPOINT_DESIGN.deploymentplan
UNION ALL
SELECT 'RULEPOINT_DESIGN.designproject' AS table_name, 'id' AS column_name, MAX(id) AS max_value FROM RULEPOINT_DESIGN.designproject
UNION ALL
SELECT 'rulepoint_design.templateParamBase' AS table_name, 'id' AS column_name, MAX(id) AS max_value FROM rulepoint_design.templateParamBase);

COMMIT;

Rename Saved Search

Table of Contents

Installation Guide

Installation Guide

Complete SQL and Oracle Configuration

Complete SQL and Oracle Configuration