Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DI MySQL Job stops early

I'm trying to load data into a reporting table, but can only get the DI job to load the first 10,000 rows or so before the state of the job goes to "stop". I am joining two mysql tables together that should give a result set of 9.6 million records or so.

This should be the resulting sql of the table joins, and when run in a mysql query browser, the result set is 9589630 records.

SELECT

Table1.ID,

Table2.ID

FROM

Table1,

Table2

WHERE

Table1.col1 = Table2.col1 and

Table1.col2 = Table2.col2 and

Table1.ins_date <= $ins_date

but when the job runs, it will cache Table2, and only bring in the first 10,000 rows of Table1 before it just stops. I can't find anything on the mysql server that would prevent this from running, and no errors are returned from DI.

Has anyone seen this problem? Anyone have any advice?

DI Version: 11.7.3

MySQL version: 5.0.445

Not what you were looking for? View more on this topic or Ask a question