DAC server crashes
Hi,
I have had my DAC server crash on me a number of times during an ETL run, its very confusing as to why it actually crashes. I look in the DAC log there is no indication of anything wrong the logs just stop (see below)
25158 INFO Tue Jan 15 23:12:18 GMT 2013
2013-01-15 23:12:18.814 INFORMATICA TASK:SILOS:SIL_GLCOGSFact_DiffManLoad:(Source : FULL Target : FULL) has started.
25159 INFO Tue Jan 15 23:12:33 GMT 2013
Sessions for workflow SIL_GLCOGSFact_DiffManLoad
SIL_GLCOGSFact_DiffManLoad
25160 INFO Tue Jan 15 23:12:42 GMT 2013
2013-01-15 23:12:42.079 CREATE INDEX:W_AP_INV_DIST_F:W_AP_INV_DIST_F_F21 has started.
25161 SEVERE Tue Jan 15 23:12:42 GMT 2013 Request to start workflow : 'SILOS:SIL_GLCOGSFact_DiffManLoad' has completed with error code 0
25162 INFO Tue Jan 15 23:13:18 GMT 2013
2013-01-15 23:13:18.29 CREATE INDEX:W_AP_INV_DIST_F:W_AP_INV_DIST_F_F22 has started.
25163 INFO Tue Jan 15 23:13:50 GMT 2013 Workflow 'SIL_GLCOGSFact_DiffManLoad' completed executing.
25164 INFO Tue Jan 15 23:13:50 GMT 2013
2013-01-15 23:13:50.818 CREATE INDEX:W_AP_INV_DIST_F:W_AP_INV_DIST_F_F23 has started.
The above line is the last line in my current DAC server log file. I am now unsure where to look with regards to finding the root cause of the error and a resolution.
As it just seems to crash I am leaning towards a java issue and could increase the java heap size, but my question is will this resolve the issue?
$JAVA -server -Xms256m -Xmx800m -cp $DACCLASSPATH com.siebel.etl.net.QServer
I can provide logs or any other information required.