Fill setup tables without locking users

[Former Member]

Dear SDN,

I want to Load the sales data.

i.e., Fill the setup tables for 11, 12 and 13...

So, We have planned to loack the users and block the documents...But Our Basis consultant has given background job for back up...

So, my task was cancelled..

Now client is very busy..we are not getting a system (SAP R/3 Production) for 6 hrs..

Is there any alternative method to perform the tasks without locking users and blocking documents...

How to initialize??

Help will be greatly appreciated with points

Thanks in advance...

[Former Member · Accepted solution]

Hi

It should be done taking outage of system.

No other way, normal it is done in the week end, when the business is having holiday.

Regards,

Siddhardh

[Former Member]

if you use 1° level ODS in overwrite mode it's not necessary to lock users.

[Former Member]

Hi Venkat,

If there are users in other Time Zones who would be using the system, you can have a sort of Mutual Agreement with them for not using the system till your Setup is over.

You should be knowing by now how long it take approx to run the Setup and you can request the users not to use the system during that time.

One more thing what you need to bear in mind is, to check if there are any Scheduled jobs which are updating the transaction tables, which would definitely cause Data Reconciliation Issues.

After all this, still if you have missed some records, identify those records and load them seperately.

However, the best option is only to take an outage.

Regards,

Tom.

[former_member496813]

It's recommended initialize setup table out of posting periods ( at night, at weekends).

When data volume is big and i hava had to initializa setup tables, i initialized first closed periods in which people don't go to done entries ( for example in 2007 or 2006), this initializations can be done while users are working. Then the initialize last period at night.

Also check:

Hope this helps..

[former_member345199]

Hi,

You will need to fill the set up tables in 'no postings period'. In other words when no trasnactions are posted for that area in R/3 otherwise those records will not come to BW. Discuss this with end user and decide. Weekends are a general choice for this activity.

You can run them after business hours so that there wont be any transactions, or in the night times or you can do it on week ends so that there is no need to take down time.

Fill the setup tables with already closed values and then fill up again with open values.This will reduce the down time.

Try Early Delta Initialization

With early delta initialization, you have the option of writing the data into the delta queue or into the delta tables for the application during the initialization request in the source system. This means that you are able to execute the initialization of the delta process (the init request), without having to stop the posting of data in the source system. The option of executing an early delta initialization is only available if the DataSource extractor called in the source system with this data request supports this.

Extractors that support early delta initialization are delivered with Plug-Ins as of Plug-In (-A) 2002.1.

You cannot run an initialization simulation together with an early delta initialization.

Hope this link may make you clear about Early Delta Initialization

http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a65dce07211d2acb80000e829fbfe/frameset.htm

How To… Minimize Downtime For Delta Initialization

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d51aa90-0201-0010-749e-d6b...

How To Minimize Effects of Planned Downtime (NW7.0)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/901c5703-f197-2910-e290-a2851d1b...

How to Minimize Effects of Planned Downtime (NW2004)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a02397f9-0d8d-2910-e5a0-b8241bbc...

SAP Network Blog: SAP NetWeaver 7.0 BI: How To… Minimize the Reporting Downtime during the initial data load

/people/community.user/blog/2007/09/23/sap-netweaver-70-bi-how-to133-minimize-the-reporting-downtime-during-the-initial-data-load

SAP Network Blog: How to retain deltas when you change LO extractor in Production system

/people/pradip.patil/blog/2006/06/07/how-to-retain-deltas-when-you-change-lo-extractor-in-production-system

Zero DownTime

http://realtech.com.sg/wInternational/pdf/consulting/WithepaperZeroDowntime_Final_ENG.pdf

Note 753654 - How can downtime be reduced for setup table update

/thread/756626 [original link is broken]

thanks,

JituK