Skip navigation
Contact Us
1147 Views 2 Replies Latest reply: Nov 21, 2012 5:45 AM by Mobeena Begum RSS
Mobeena Begum Newbie 4 posts since
Jan 17, 2012
Currently Being Moderated

Nov 21, 2012 3:37 AM

Space error CMN_1117

Problem:

A informatica workflow is failing with the space error. We have increased cache space but still showing the same error.

Error:

 

ERROR: Could not allocate space in file [%s].

CMN_1117 [/u01/Informatica/PowerCenter8.6.1/server/infa_shared/Cache/PMJNR173_57_0_9871.dat

 


Experts please answer.

 

Thanks for reading,

Mobeena

 

Note: log file is enclosed

  • Mariappan Kannapiran Apprentice 143 posts since
    Jan 29, 2011
    Currently Being Moderated
    Nov 21, 2012 5:38 AM (in response to Mobeena Begum)
    Space error CMN_1117

    if possible please try these options..

     

    Try to change the master table as the one with smaller number of records..As only usually the records in the master table only cached..u can save some space.

     

    Remove the unwanted columns in the joiner trabsformation..so data and index cache wont be created for unwanted columns.

     

    try to increase the total memory percentage to an good extent  in the session property,instead of incresing the cache space seperately.

     

    try to pass the sorted records in the joiner transformation

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points