This is my first post for Informatica problem. I am primarily involved in OBIEE development. But I faced following issue during production data load.
I faced the error in Informatica 8.1.1 SP4. I found a related knowledge base document on Informatica support web.
https://communities.informatica.com/infakb/solution/12/Pages/104852.aspx?docid=104852&type=external&index=1
The error message in article is equal to the one I faced. But the solution I used is different from the document.
Error Message:
*********** FATAL ERROR : Unexpected Condition in file [\ZeusbuilderProduction\view\powrmart\server\cmnutils\svecmatrix.cpp] line [256]. Contact Informatica Technical Support for assistance. Aborting this DTM process due to an unexpected condition. ***********
Cause:
The error occurred due to sorter transformation's cache size setting. Cache size was set to 1GB.
Resolution:
Resetting the cache size to Auto will resolve the problem. Max limit for cache size on 32-bit server is 3.99 GB. When I calculated the cache size for data I was getting was approximately 5 GB. So I set cache size to Auto at session level and re-run the workflow.
Hello Diptesh,
ReplyDeleteThanks for sharing the resolution, I was getting exatly the error and through your post I was able to resolve it.
Regards,
Mithun