Показаны сообщения с ярлыком Informatica. Показать все сообщения
Показаны сообщения с ярлыком Informatica. Показать все сообщения
, ,

[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
Читать полностью

,

[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

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

,

[PCSF_46007] No gateway connectivity is provided for domain. ERROR: Cannot connect to Integration Service.

пятница, 1 ноября 2013 г. 0 коммент.

Error: [PCSF_46007] No gateway connectivity is provided for domain [Domain_vminf]. ERROR: Cannot connect to Integration Service [is_vminf].


C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>pmcmd startworkflow -sv is_vminf -d Domain_vminf -u Administrator -p Administrator -f TEST -rin wf_test_0001 wf_test

Informatica(r) PMCMD, version [9.5.1 HotFix3], build [261.0906], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2013
All Rights Reserved.

Invoked at Fri Nov 01 15:39:04 2013

[PCSF_46007] No gateway connectivity is provided for domain [Domain_vminf].
ERROR: Cannot connect to Integration Service [is_vminf].

Completed at Fri Nov 01 15:39:05 2013

C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>

Check the connection:


C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>pmcmd pingservice -sv is_vminf -d Domain_vminf

Informatica(r) PMCMD, version [9.5.1 HotFix3], build [261.0906], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2013
All Rights Reserved.

Invoked at Fri Nov 01 15:48:52 2013

[PCSF_46007] No gateway connectivity is provided for domain [Domain_vminf].
ERROR: Cannot connect to Integration Service [is_vminf].

Completed at Fri Nov 01 15:48:53 2013

C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>

Cause: The pmcmd command is not able to find the domains.infa file to read the information.


Action: Set the environment variable INFA_DOMAINS_FILE.


C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>set INFA_DOMAINS_FILE=C:\Informatica\9.5.1\clients\PowerCenterClient\domains.infa


C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>pmcmd startworkflow -sv is_vminf -d Domain_vminf -u Administrator -p Administrator -f TEST -rin wf_test_0001 wf_test

Informatica(r) PMCMD, version [9.5.1 HotFix3], build [261.0906], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2013
All Rights Reserved.

Invoked at Fri Nov 01 15:54:36 2013

Connected to Integration Service: [is_vminf].
Starting workflow [wf_test]
INFO: Starting execution of workflow [wf_test] in folder [TEST] last saved by user [Administrator].
Workflow wf_test with run instance name [WF_TEST_0001] and run id [42] started successfully.
Disconnecting from Integration Service

Completed at Fri Nov 01 15:54:38 2013

C:\Informatica\9.5.1\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin>

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