Association Model Loading

[Former Member]

Dear All,

The Loading activity from Info cubeàAssociation ModelàDSO(Info Package) in BWP is taking very long time to complete after Oracle 11G Upgrade.

We are having Two such loads which are happening through Process chains which we trigger monthly once.

1.       CRM Basket Chain

2.       Basket Analysis by Brick.

This month we have triggered the both process chains on 4^th July 2013, But these loads are still running. Normally “CRM Basket chain” used to complete in 2 days and “Basket Analysis by brick” by 4~7 days.

Please suggest me.

Thanks,

Manas

[former_member184473 · Accepted solution]

Hello Manas,

Have you set the parameters as per note 1431798? You can use the parameter check (note 1171650).

Also, ensure you have statistics updated (note 588668😞

• brconnect -u / -c -f stats -t oradict_stats
• brconnect -u / -c -f stats -t system_stats
• brconnect -u / -c -f stats -t all

Regards,

Eduardo Rezende