Разделы

, ,

[PCSF_46026] ERROR: Cannot connect to Integration Service

[ пятница, 23 октября 2015 г. | 1 коммент. ]

I got error message, while running the pmcmd commands on server host.


[PCSF_46026] Unable to find valid TrustStore certificate in PEM format
ERROR: Cannot connect to Integration Service

Cause:


This issue occurs in the Informatica domain that has secure communication enabled and the INFA_TRUSTSTORE environment variable was not set.


Action:


Set the INFA_TRUSTSTORE environment variable to the directory that contains the truststore files for the SSL certificates for the secure domain. The directory must contain a truststore file named infa_truststore.pem.



INFA_TRUSTSTORE=%INFROMATICA_HOME%\services\shared\security
Читать полностью
,

Register scheduler agent

[ четверг, 22 октября 2015 г. | 0 коммент. ]

I have error:


D:\oracle\client112040\BIN>schagent -registerdatabase dwh.prod.local 8080
Agent Registration Password ? ***********

ERROR: Connecting to: http://dwh.prod.local:8080/remote_scheduler_agent/register_agent. java.io.IOException: Server returned HTTP response code: 401 for URL: http://dwh.prod.local:8080/remote_scheduler_agent/register_agent2

Cause:
Agent DAD is not installed.


Action:
Run the script prvtrsch.plb with following command:



SQL> @?/rdbms/admin/prvtrsch.plb


Set a registration password for the Scheduler agents using the SET_AGENT_REGISTRATION_PASS procedure.


The following example sets the agent registration password to mypassword.



BEGIN
DBMS_SCHEDULER.SET_AGENT_REGISTRATION_PASS('mypassword');
END;


D:\oracle\client112040\BIN>schagent -registerdatabase dwh.prod.local 8080
Agent Registration Password ? ***********

Oracle Scheduler Agent Registration for 11.2 Agent
Agent Registration Successful!

D:\oracle\client112040\BIN>

<\br>
Читать полностью
,

[DOM_10022] The master gateway node for the domain is not available. Electing another master gateway. Wait for the election of the master gateway node to complete. If the problem persists, verify that the master gateway node is running.

[ понедельник, 19 октября 2015 г. | 0 коммент. ]

I have error:
2014-03-06 01:11:08,122 ERROR [Monitor Guaranteed Message Logger Thread] [CCM_10322] While logging messages to the Log Service, the following error occurred: [[DOM_10022] The master gateway node for the domain is not available. Electing another master gateway. Wait for the election of the master gateway node to  complete. If the problem persists, verify that the master gateway node is running.]. Fix the errors written to the node.log file.
com.informatica.isp.domainservice.exceptions.ISPMasterNotAvailableException: [DOM_10022] The master gateway node for the domain is not available. Electing another master gateway. Wait for the election of the master gateway node to  complete. If the problem persists, verify that the master gateway node is running.

Cause:
The master gateway node for the domain is not available.
Master Node should update each 8 seconds field LAST_REFRESH_TIME in table PCSF_MASTER_ELECTION.
Domain Monitor tracks that this field is updated. If the field is not updated, then Master Node died.

Action:
Increase the value of MasterDBRefreshInterval from 8(8 seconds default) to 25...30 seconds.
And increase the value of infa.masterUpdateTimeInterval from 15000(15000 milliseconds default) to 30000...200000 milliseconds.

MasterDBRefreshInterval is custom parameter in Domain properties.
infa.masterUpdateTimeInterval is command line property for the node process.
On Linux\Unix

$ export INFA_JAVA_OPTS="-Dinfa.masterUpdateTimeInterval=30000"

On Windows


-Dinfa.masterUpdateTimeInterval=30000
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Informatica9.5.1\Parameters\JavaOptions


HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Informatica9.5.1\Parameters\JavaOptions
"-Dcatalina.base=C:\informatica\9.5.1\tomcat -Dcatalina.home=C:\informatica\9.5.1\tomcat -Djava.endorsed.dirs=C:\informatica\9.5.1\tomcat\common\endorsed -Duser.dir=C:\informatica\9.5.1\tomcat\bin -DINFA_PLUGINS_HOME=C:\informatica\9.5.1\plugins -DINFA_HOME=C:\informatica\9.5.1 -DINFA_DEV_LOG_DIR= -DINFA_DOMAINS_FILE=C:\informatica\9.5.1\domains.infa -Djava.io.tmpdir=C:\informatica\9.5.1\tomcat\temp -Xrs -XX:GCTimeRatio=9 -XX:MaxPermSize=128m -Djava.util.logging.config.file=C:\informatica\9.5.1\tomcat\bin\isplogging.properties -Dinfa.masterUpdateTimeInterval=30000"



See also: How to configure node heartbeat intervals for internal health check of Informatica nodes and domain

Читать полностью