Skip to Content
author's profile photo Former Member
Former Member

Data Integrator 11.7.3: Error <70602>

Hi,

I have scheduled my entire production environment in one job, many levels, many workflows, dataflows, scripts, variables aso. After an upgrade from 11.7.2 to 11.7.3 the job stops every night initiating one particular workflow and dataflow. It's a Sybase repo.

Here is the part of the log where the df initiates and fails. Anybody with the same experience or knows what this sybase error 70602 often relates to in BODI ?

23687 1 WORKFLOW 04.12.2008 06:29:17 Work flow <EDW_FAKTA_OPPDRAG_FEILMELDING_WF> is started.

4139 1 DATAFLOW 04.12.2008 06:29:23 Process to execute data flow <EDW_FAKT_OPPDRAG_FEILMELDING_AKTIV_DF> is started.

4139 1 DATAFLOW 04.12.2008 06:29:29 Data flow <EDW_FAKT_OPPDRAG_FEILMELDING_AKTIV_DF> is started.

4139 1 DATAFLOW 04.12.2008 06:29:29 Cache statistics for data flow <EDW_FAKT_OPPDRAG_FEILMELDING_AKTIV_DF> are not available to be used for optimization and need

4139 1 DATAFLOW 04.12.2008 06:29:29 to be collected before they can be used.

4139 1 DATAFLOW 04.12.2008 06:29:29 Data flow <EDW_FAKT_OPPDRAG_FEILMELDING_AKTIV_DF> using PAGEABLE Cache with <3443 MB> buffer pool.

4139 1 DATAFLOW 04.12.2008 06:31:47 Data flow <EDW_FAKT_OPPDRAG_FEILMELDING_AKTIV_DF> is terminated due to error <70602>.

4139 1 DATAFLOW 04.12.2008 06:31:47 Process to execute data flow <EDW_FAKT_OPPDRAG_FEILMELDING_AKTIV_DF> is completed.

23687 1 WORKFLOW 04.12.2008 06:31:48 Work flow <EDW_FAKTA_OPPDRAG_FEILMELDING_WF> is terminated due to an error <70602>.

23687 1 WORKFLOW 04.12.2008 06:31:48 Work flow <FAKTA_2_KJORING> is terminated due to an error <70602>.

23687 1 WORKFLOW 04.12.2008 06:31:48 Work flow <EDW_WF> is terminated due to an error <70602>.

23687 1 JOB 04.12.2008 06:31:48 Job <DW_Job> is terminated due to error <70602>.

regards,

-jem

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 04, 2008 at 01:52 PM

    What does the error log say? The trace log you posted doesn't go into the details.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      It was not easy to get anything out of the huge logs I received from the IT department but we isolated one df that got the same error as the original job when we run it with several days of data. This df is pretty complex, lots of lookups aso and with 2 validation objects. Probably one of the df's that often caused the errors for the daily job. This df executes about 200' rows each day and I did an attempt with one month, 4 mill, and with both stats and sample checked. It went like this:

      - I just run it 3 times and it failed after 200' - 400' rows.

      - I then adjusted the DOP to 3 and checked 3 big lookups with run as separat processes. I then reached 700' - 1 mill rows before it failed.

      - I remember you mentioned something about In mem so I did that next. This time the hole df did run successfully 😊

      - I adjusted the original job but it failed near another complex df. This time I just adjusted that df to run in mem. I failed again but when I checked a couple of heavy operations as separat processes and adjusted the DOP the hole job went through.

      So this look like the way to do it, but I am not 100% sure why..:) Could it be helping the page cache out and let the os do the job with swapping if necessary aso. ? The pagable cache got 3.2 gb.

      I think we will go for an upgrade to 3.1 sp1.

      Thanks for your patience !

      - jem

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.