Cannot do initial load?

[Former Member]

Hi

I ran R3AS to load data from ECC to CRM. But the load is not started. The load remains in 'wait' status.

I checked R3AM1 but there's no other running initial load. I don't know why.

[Former Member · Accepted solution]

Hi

Firstly you can check if this load object has any parent load object, If any, you have to ensure the parent load object is downloaded first.

Secondly, you can check parameter MAX_PARALLEL_PROCESSES in table SMOFPARSFA, eg. if it's 5, this means you can have at most 5 running queues in total(for request, initial and SDIMA queues). If there're already 5 queues running, the rest of the queues will have to wait.

The status of all initial and synchronization download objects is stored in table SMOFDSTAT.

The status of all request downloads is stored in table SMOFRSTAT.

DIMa downloads (table SDIMASTAT).

Sometimes there's no running load seen in r3am1 or r3ar3, but the most accurate place to check if these db tables. If any load running is shown in these tables, you have to manually delete them in these tables by debugging.

James

[former_member186543]

Hi Brown,

Please open up SMQ1 and SMQ2 to check if there are any queues in the running related to this request.

You might find some queues with the name r3ar* .

/Hasan