Wednesday, September 25, 2019

List of users connected to client tools



SELECT c.cnx_id,
  SUBSTR(u.name,1,30),
  SUBSTR(c.login_time,1,20),
  SUBSTR(c.app_name1,1,20),
  SUBSTR(c.host_name,1,25),
  c.host_port
FROM opb_client_conn c,
  opb_user_group u
WHERE c.login_id                                  =u.id
AND to_date(SUBSTR(login_time,1,10),'mm/dd/yyyy')!=trim(sysdate)
AND app_name1 IN ('Designer' ,'Workflow Manager' , 'Workflow Monitor', 'Repository Manager')
ORDER BY Host_name,
  app_name1,
  Login_time;



Wednesday, September 18, 2019

Purging BDM workflows from the workflow database



Please make sure to have proper backups before you work on below commands (safer side), on Informatica BDM this command will help to purge workflow transnational details from workflow database.


Starting from Informatica 10.2 HotFix 1, there is a new command available to delete workflow process data from workflow DB. You can configure the command to delete all of the process data in the workflow database. Or, you can delete the process data that the workflows generated during a time period that you specify.

The pruneOldInstances command deletes process data only. The command does not delete any data that a workflow instance or any object in the workflow reads or writes. Likewise, the command does not delete any workflow object metadata.

To delete the process data, you must have the Manage Service privilege on the domain.

The infacmd wfs pruneOldInstances command uses the following syntax:

pruneOldInstances
<-domainname dn=""> domain_name
<-servicename sn=""> service_name
<-username un=""> user_name
<-password pd=""> password
[<-securitydomain sdn=""> security_domain]
<-days d=""> days
[<-resiliencetimeout re=""> timeout_period_in_seconds]


https://kb.informatica.com/faq/7/Pages/21/560591.aspx



Tuesday, September 17, 2019

Troubleshoot steps when Integration Services are Hung


Troubleshoot steps when Integration Services are Hung

When you are unable to connect Integration Service from client, make sure Integration Service is available in Administrator Console

Login to one of the nodes in the IS grid and try pmcmd connect to Integration Service

pmcmd> connect  -sv   -d -u -p

Please share the output.

Please collect below information:-

1.Stack traces using pmstack on pmserver process

     pmstack -p

pmstack should be available in $INFA_HOME/tools/debugtools/pmstack directory. Refer to KB 13652 for more information.

2.List of open files using lsof on pmserver process

     lsof -p

You need to redirect the output to file as shown below:

     lsof -p 324564 > lsof_324564_1.txt

3.System calls using strace on pmserver process

     strace -ttTfo strace_pmserver.txt -p         (Linux)
     truss -faedEl -o truss_pmrepagent.txt -p     (AIX/Solaris)

You need to end strace manually. Let it run for two minutes and then end it.
Please make sure you run each of above commands minimum four times with an interval of two minutes.
Please note that you cannot run pmstack and strace on a process at the same time. You could run strace between pmstack intervals.

4.Core file using gcore on pmserver process on all the nodes in grid(only once)

     gcore -o pmserver_dump

Informatica support needs libscollector output from pmserver core file and not the actual core file. You could refer KB 144522 to run libscollector. This can be done at the end, once you are done collecting all the details.

You need to run all above commands on all the nodes in the grid.

5.Stack traces on associated Repository Service using pmstack

6.jstack on the node Java process. You need to collect this on all the nodes in the grid.

jstack -l > jstack1.txt

jstack should be available in $INFA_HOME/tools/debugtools/java/bin directory.

You need to run it four times with an interval of one minute.

7.netstat output on all the nodes in the grid

netstat -peano > netstat.out

8.Domain, Repository and Integration Service logs for the day separately.

9.Node logs(catalina.out, exceptions.log, node.log, ispLogs.log , node_jsf.log from $INFA_HOME\logs\ directory) from all the nodes