Rapid mart job warning

dataservices rapidmarts
1

Hi friend

one of our rapid mart got this followig error while executing the job

Job name: Plant_quick_kpi
(12.2) 05-05-12 19:29:47 (E) (3320:11432) RUN-050406: |Session Plant_quick_kpi|Work flow WF_PMKPI_Stage|Data flow DF_KPI_STAGE
Data flow <DF_KPI_STAGE> received a bad system message. Message text from the child process is
<`&#65490;J_&#65533;&#65506;Q_1==========================================================
Please collect the following and send to Customer Support:
1. Log files(error_, monitor_, trace_*) associated with this failed job.
2. Exported Atl file of this failed job.
3. DDL statements of tables referenced in this failed job.
4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
the job failed.
5. Core dump, if any, generated from this failed job.
==========================================================
>. The process executing data flow <DF_KPI_STAGE> has died abnormally. For NT, check errorlog.txt. For HPUX, check
stack_trace.txt. Also, notify Technical Support.
(12.2) 05-05-12 19:29:48 (W) (3320:11432) CON-120108: |Session Plant_quick_kpi|Work flow WF_PMKPI_Stage|Data flow DF_KPI_STAGE
Database connection to broken. Retrying with retry count <6> and sleep interval <10> seconds.
(12.2) 05-05-12 19:29:49 (W) (3320:11432) CON-120109: |Session Plant_quick_kpi|Work flow WF_PMKPI_Stage|Data flow DF_KPI_STAGE
Database connection to broken. Successfully obtained connection after <1> attempts.
(12.2) 05-05-12 19:29:49 (E) (3320:11432) RUN-050409: |Session Plant_quick_kpi|Work flow WF_PMKPI_Stage
The job process could not communicate with the data flow <DF_KPI_STAGE> process. For details, see previously logged error
<50406>.

Please help me analyzing these case why it has come and how to overcome this

Thanks & Regards

liveinsap (BOB member since 2012-01-23)

2

Can you post the monitor log please? At this stage it could be multiple things, with the monitor log we should be able to narrow it down, I hope.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Hi werner

thanks for your concerns,

could you please clarify which kind of log you are asking about

Like error ,log, or some thing else

Regards

liveinsap (BOB member since 2012-01-23)

4

you have posted snippets of the trace log, next to it is the monitor log with the number of rows processed.

Werner Daehn :de: (BOB member since 2004-12-17)