ARHDQMCR module: DQM Index Creation Program (Doc ID 309713.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

1) Select the Trading Community Manager responsibility.
2) Navigate: Control > Request > Run
3) Enter Name: "DQM Staging Program "
.
Enter parameter as follows:
-Number of Parallel Staging Workers: "4"
-Staging Command: "STAGE_ALL_DATA"
-Continue Previous Execution: "NO"
-Press the "Submit" button
.
Problem:

Each of the worker programs ran just over 48 hours. One of the DQM Create Index jobs errored request id 676836 errored.

Log file shows:

ARHDQMCR module: DQM Index Creation Program

**Starts**01-APR-2005 12:51:30
**Ends**03-APR-2005 04:51:41
Error encountered when running Staging Worker request (ID: 676832). Please examine request in
the log file for more information.

ARHDQMSTW module: DQM Staging Worker

Starting Concurrent Program 'Stage Party Data', Worker: 1
Start Time 04-01-05 12:51:14

This worker stages all parties whose party_id/10 produces a remainder equal to the worker number

Stage Parties begin
Staging Organization Party Records
Staging Person Party Records
Staging Group Party Records
Concurrent Program Execution completed
End Time : 04-03-05 15:56:56

Reran DQM Staging Program, it hangs, no records were inserted into staged tables.

Changes

Cause