Informatica ERROR: unable to acquire execute lock on session instance

Posted in the Informatica Forum

Shaju

Germany

#1 Jan 8, 2009
When Informatica Workflow is executed from Linux, session fails with following ERROR: unable to acquire execute lock on session instance
When the session is re-executed manually it works properly. These workflows are executing for long time without any problems in old environment.
In new environment it failed. If any one can provide information to fix this issue, please publish.

Regards,
Shaju
Mani Kandan

India

#2 Aug 24, 2010
I faced the similar issue, This looks like an orphaned process keeping a lock active. A restart of the server (server reboot, where informatica powercenter is hosted) would be the best option, in order to reclaim all the lost processes.

Regards,
Mani Kandan
Chennai
TALK 2 EXPERTS

Richmond Hill, Canada

#3 Feb 14, 2011
Try at "TALK 2 EXPERTS" for an immediate response.

INFORMATICA forums:
http://www.informatica.talk2experts.com/

.

Since: Jan 13

Bangalore, India

#4 Jan 8, 2013
This happens when some other process/user having the control on session.
Please make sure your session is completely executed before reusing the same session.
Also make sure that no other users doing any sort of operations on the sessions while you are running them.

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Can some Xpert answer these Informatica Real-ti... Oct 12 Anonymous 1
Informatica Next Generation Data Integration Fo... (Mar '13) Oct 2 Elisa 2
which is the Best institute for IDQ informatica... Sep '14 Raza Khan 1
Job oriented - online Informatica real time tra... Sep '14 trainer 1
Source Qualifier is not getting the values from... (Jun '07) Sep '14 Team_Project 5
Help needed to resolve ERROR 2737: Not Enough M... Sep '14 naresh 1
Is there a way to see a detail of the last run ... Aug '14 Jack 1

Informatica People Search

Addresses and phone numbers for FREE