hi,
What is the deadlock in informatica?can any one explain?
regards
som
hi,
What is the deadlock in informatica?can any one explain?
regards
som
Typically this occurs when one transaction has a lock on a resource that another transaction is trying to obtain. This can be resolved by managing the workload schedule
Calling all the MS-OLAP objects at once will cause an error in the Analysis Services server and all the objects will be in the state of Unprocessed. The Informatica side has to call the dimensions first and only then the cubes. The cubes must not be called all at once if they have relationships between them. This will cause deadlock.
Friend Som,
Can you reply back whether you mean to say either one of these ?
- DEADLOCK on database level
- Write Lock on Informatica level
Both will be caused because of the unautorized access on which the object is locked for write by other resource.
Hope its clear for you..!
And Please post the thread with proper subject not in a VAGUE format
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.