Increase the Java Heap size for DAC Server

The Java heap size for DAC server can be changed by changing Java heap size in startserver.sh file

1.   Login to DAC Server machine and sudo appadmin.   
2. Navigate to dac folder cd $DAC_HOME/dac 
3. Stop the DAC Server ./stopserver.sh
4. Make sure on the Windows DAC client, the DAC Server connection status icon changes to red & disconnected.  
5.   Edit startserver.sh and increase the java heap size by changing –Xms256m and –Xmx800m values to –Xms1024m and –Xmx2048m respectively .
   vi startserver.sh
   $JAVA –server –Xms1024m –Xmx2048m –cp $DACCLASSPATH com.siebel.etl.net.QServer
6.  Save the file 
7. Start the DAC Server.  Make sure in the DAC client, the status icon changes to connected

Registering a new Informatica workflow in DAC

1. Register table name in Design -->Tables tab.
2.   Create new records for task in Design --> Tasks and add the source and target tables. Make sure to specify logical data sources. (Mention Mapping variable in Parameters section so as to clear refresh date in Full load).
   
   
   
3.  Add target table under subject area and assemble subject area.
4.  Select execution plan and generate connectivity parameters. Make sure parameters are correct.
5.  Build the execution plan.

CEF_23005 : Failed to create thread due to operating system error [Resource temporarily unavailable]

Sometimes when you trigger ETL via DAC, ETL fails or hung with the following error message

Informatica Session Log

CEF_23005 : Failed to create thread due to operating system error [Resource temporarily unavailable].

OR

DAC Log

ANOMALY INFO::: Error while executing : com.siebel.analytics.etl.etltask.ParallelTaskBatch:Create Index Batch

MESSAGE:::java.lang.OutOfMemoryError: unable to create new native thread

EXCEPTION CLASS::: java.lang.Exception

Solution

Increase the value of below mentioned parameter in Informatica server box.

max user processes (-u)