Quality system refresh from production system

[Former Member]

Hi Team,

S&OP Version: 3.0.2.3 (on-premise)

Hana Version: 1.00.85.04.401020

We intend to copy production database (master and transaction data) to quality system as a quality refresh activity. We tried doing a production database backup and restoring it in quality which lead to many planning area activation errors in quality system.

Does anyone have a tested methodology for this?

Regards,

Aditya G

[Former Member · Accepted solution]

Hi Aditya,

Are you getting same activation error for all the planning area ?

Can you please share the error message ?

Regards

Avijit

[Former Member · Accepted solution]

Hi Avijit,

We have only a single planning area. We had tried this activity few months ago, and we then restored quality system with the latest backup so we lost all activation errors.

Regards,

Aditya G

[Former Member · Accepted solution]

Hi Aditya,

It is possible to create a new system from the DB copy of another system. New system is then becomes the clone system of the source system. Planning area activation works perfectly in this case. We did this for a cloud system but i think it should be possible for on-premise as well.

Best regards

Rinju

[Former Member · Accepted solution]

Hi Rinju/Avijit,

We will re-try this activity and update.

Regards,

Aditya G

[Former Member · Accepted solution]

Hi,

We conducted a backup and restore activity and users, data, planning area and templates were successfully refreshed but are facing issues in executing copy operator, statistical forecast and supply planning runs.

It seems that CRON job runs every 2 minutes but is not picking up the jobs. Jobs are stuck in ready state.

Regards,

Aditya G

[Krishna1 · Accepted solution]

Open OSS ticket ...It happened to us many time...

[Former Member · Accepted solution]

Hi Krishna,

I already did but thought of not troubling SAP is someone already had the solution.

Regards,

Aditya G

[Krishna1 · Accepted solution]

Yes..if I get OS and HANA access

[Former Member · Accepted solution]

Hi,

The issue was that we did not run the post installation script after restore.

Regards,

Aditya G