Delta Init and loading for InfoCube...

[Former Member]

Dear All,

             I'm working in SAP NetWeaver 7.02 and I would like to Initialize delta. What I'm going to do, Full load into an standard InfoCube which does not have Aggregates and then Delta Init without Data Transfer for deltas.

1. Since, I'm working in BW PRD and my source is ERP PRD, Do I need to block the posting before Delta Initialization?

2. Should I be able to load the Deltas during document posting after the initialization of delta (say after 3 hours same day)?

3. Do I need to wait for the close of the day or run/execute Deltas during office closing time or during night?

4. Is the delta initialization differ for different DataSources?

5. What is the best practice for delta initialization and delta uploads?

6. How do I know that I've successfully Initialized Delta for my Infocube and how many records are there in DataSource after Delta Initialization for next load?

Looking forward to your reply!

Many Thanks!

Arshiyan

[RamanKorrapati · Accepted solution]

Hi,

1. Since, I'm working in BW PRD and my source is ERP PRD, Do I need to block the posting before Delta Initialization?

its depends on.if you want down time then you can block the users. if not then you first run info pack without data transfer.

next run the full load. mean time if any docs are created or modified those will capture in ur delta.

2. Should I be able to load the Deltas during document posting after the initialization of delta (say after 3 hours same day)?

once delta was initiated then you can trigger delta info pack every 3hrs once if you want. actually its depend on the data volume. if you know as your getting more records in your delta, you can run delta info pack  multiple times in a day.

if you designed process chain,delta infopack, delta dtp. you can run as you need in a day.

3. Do I need to wait for the close of the day or run/execute Deltas during office closing time or during night?

No.

4. Is the delta initialization differ for different DataSources?

delta init is function, just enables delta for data source which data source support delta.

5. What is the best practice for delta initialization and delta uploads?

First run info pack init without data transfer, next run the full load. after the full you can trigger delta info pack.

6. How do I know that I've successfully Initialized Delta for my Infocube and how many records are there in DataSource after Delta Initialization for next load?

Delta is related to data source not for info cube.

after the init success you can check at RSA7, your data source will visible there along the records in column "Total'.

Even as per v3 updated methods you can check delta records at SM13/LBWQ for LO.

Thanks

[Former Member · Accepted solution]

Thanks and welcome back dear, Wishing you for moderator.

I have got ask few questions!

1) What is down time in simple words and what is its usage?

2) What is the difference between (as you have mentioned above reply)

  ''first run info pack without data transfer.>>>next run the full load>> mean time if any docs are created or modified those will capture in ur delta''.

I understood that part. Now what if I perform with following sequence:

Full load>>>> INIT Delta with Data transfer >>>>then Delta for new records

Thanks

Arshiyan

[RamanKorrapati · Accepted solution]

Hi,

1) What is down time in simple words and what is its usage?

Down time - mean blocking the users without entering records in ecc.after finishing init successful, we unlock users, once users enter records at ecc, those records will capture in next delta load.

2) What is the difference between (as you have mentioned above reply)

  ''first run info pack without data transfer.>>>next run the full load>> mean time if any docs are created or modified those will capture in ur delta''.

I understood that part. Now what if I perform with following sequence:

Full load>>>> INIT Delta with Data transfer >>>>then Delta for new records.

After the success of full load and before running the init delta  with data transfer, if any record changed in fraction seconds. it may not be guarantee to get those record in next delta. that's y first enable the delta, then run full load and delta. maximum we won't miss any record.

Thanks

[Former Member · Accepted solution]

Hi Raman,

               According to your suggestion I've created new InfoPackage with Delta Init without Data Transfer and scheduled it

When I went to Monitor I've found following screen:

1. Why there is one record only? What does this one record mean?

When I went to ECC side and at transaction RSA7 I've found following screen or Status:

1. Have I managed to create successful Delta?

2. What should I do to Initialize successful Delta?

3. How to resolve about issue?(This is for the first time that i'm gonna Initialize Delta)

Many Thanks

Arshiyan

[former_member619464 · Accepted solution]

Hi,

Looks like you have to replicate the datasource in BW and activate the transfer structure.

Check if you have an existing active transfer struc & datasource struc in BW first

Ravi

[RamanKorrapati · Accepted solution]

Hi,

May be one empty row will be there. its default one.

Your init was success, that's y you can see your data source at RSA7.

Seems like some changes are happened transfer structuer. so please make it as active by running program - SE38 - Transtru_activate_all .

Thanks

[Former Member · Accepted solution]

Hi Raman,

I have logged on ECC side and used T code  SE38 and executed the function  rs_Transtru_activate_all   and below screen popped up.

After executing, I had the display log screen. Please see the below short

When I  went to T code  RSA7, i still have got BW delta screen as below

1. As per your direction for the activation of Transfer Structure by running program - SE38 - RS_Transtru_activate_all. I'm still not getting green signal light in RSA7 and the total column is zero?

2. What should I do now?

3. I have not triggered full load yet for the DataSource since yesterday as, I'm not sure that the delta has been successfully initialized.

4. What does the Log Display message mean " No Transfer Structure Found".

Cheers

Arshiyan

[RamanKorrapati · Accepted solution]

hi,

you need to make active in bw side not in ecc side.

Bw side execute that program , give the info source and source system execute it.

After that execution, delete init and check rsa7. no data source will be there.

again do the step init without data transfer and check it.

Thanks

[Former Member · Accepted solution]

Hello Raman

On Ecc side I have made active and got the following display log.

i have deleted init IP and when i went to RSA7 and then deleted data source,

i again performed the step init without data transfer and checked and on monitor view, i got the dummy records (1 record) but the problem couldn't resolved RSA7:BW Delta Queue Maintenance. 0 record with red single.

When i have checked the relevant Info source it is emulated, here is the screen short

Do i have to do any thing with it?

Thanks a lot!

Arshiyan

[former_member182516 · Accepted solution]

Hi Arshiyan,

- Why there is one record only? What does this one record mean?

You had just performed INIT with out data transfer initially. we will perform INIT Without data transfer when you had already loaded full data load and you want to set the delta pointer then we will opt for init without data transfer.

Here in your case as you are running the loads for the first time, best practise is to perform INIT WITH data transfer and once this load is comeplted set the update mode to Delta as the delta pointer is set.

When you perform INIT without data transfer you will get a dummy record entry which set the detla pointer at the source system side. that's the reason why you are able to see only 1 record loaded for init without data transfer.

Due to which as the init was not taken care and delta pointer was not set the RSA7 its displayed as red.

1. Have I managed to create successful Delta? --> First execute INIT with data transfer and once this is done set the IP update mode to delta.

2. What should I do to Initialize successful Delta? --> Run INIT with data transfer and once this is done delta pointer will be automatically set.

3. How to resolve about issue?(This is for the first time that i'm gonna Initialize Delta) --> this was discussed above..

Regards

KP

[Former Member · Accepted solution]

Hello KP

According to your suggestion I have logged on ECC side and used T code RSA7  and deleted previous Delta Queue request which was RED and Records where 0. Then I went to BW side and deleted Infocube data and InfoPackage and created new one with Delta Init with Data Transfer: And when I clicked on Monitor button I've received following Information: ''express document check load from InfoSource received from author biremote''.

When I googled it and found that I need to Replicate my DataSource to resolve this issue. But after Replication the issue was there. and at Monitor after Schedule I found following Screen:

When I went to ECC side and at transaction RSA7 this time I found that DataSource Status with Yellow and Records are 0. see below screen shot:

1) Could you please tell me what was the information about (''express document check load from InfoSource received from author biremote''.)?

2) Why 0 records showing in the above screen short  in the above screen why red single is showing in the PSA screen short monitor as you see the 1st screen short.

3) When i went on EEC RSA7, why it showing a yellow status with 0 record? What does it mean

weather the delta has been Initialized successful?

Thanks

Arshiyan

[former_member182516 · Accepted solution]

Hi

The error caused due to the time stamp of the data sources is different in both the systems.

try to replicate the data source once and trigger the data load.

Kill the job at source system and delete the entry from RSA7 as well.re trigger the data load once after replicate the data source.

Hope this helps

KP

[Former Member · Accepted solution]

Hello

I have already replicated Data-source and went to RSA7 and delete the entry for delta and the Error'' express document check load from InfoSource received from author biremote'' has been solved.

The above the situation has not been resolved. I'm still getting 0 records in Red color in PSA and on ECC RSA7 side still getting Record in Yellow color status for Data source.

What do you mean by'' Kill the job at source system and how to do it?

Thanks

Arshiyan

[former_member182516 · Accepted solution]

Ok good...

I mean to say that the source system job of the load might be active, cross check once and kill if its active.

Update the status once your load finished.

Regards

KP

[former_member182516 · Accepted solution]

Have you filled the setup tables for the sales orders...in ECC side... Check in RSA3 if the data source is returning any data entries or not?

[Former Member · Accepted solution]

Hello

I have already done with Setup table ( Delete & Setup) and I have checked RSA3, i found data records are constructively increasing.

I have taken all the necessary steps. Problem is being,  my DELTA is not Initializing ( With data Transport).

1) What do you mean by ''I mean to say that the source system job of the load might be active, cross check once and kill if its active'' as you mentioned in the above reply?

[former_member182516 · Accepted solution]

Arshiyan,

You had triggered the data load (INIT) -- load got failed with the message...

express document check load from InfoSource received from author biremote

and the status of the data source in RSA7 was yellow.I was just giving idea if source system job which might be still active causing the status of the data source in RSA7 as yellow.

before replicating the data source once again i asked you to check and kill the source system job.

Arshiyan: There are all BASIC things we check when ever a job fails...

- KP

[Former Member · Accepted solution]

Hello KP

Thanks for reply. Could you please tell me '' How to kill the source system job''?

Thanks

Arshiyan

[Former Member · Accepted solution]

Arshiyan,

Select your Infopackage and go to Process monitor in that

Go to Header,

There you will find Request (job)and double click on that Copy it.

Goto R/3 side

Use T code SM37

Provide Job Name(Request) which u r copied above.

Provide the User Name as  * and execute if you find that job with active status then kill it.

[RamanKorrapati · Accepted solution]

Hi,

Go to info pack monitor,from menu  Environment --> job overview --> source system

--> it will prompt for ID n PWD -enter and check the status. if it active. select and from menu job, click on cancel.

Thanks

[Former Member · Accepted solution]

Hello all

Thank you so much for your assistance.

1.I've been able to resolve the issue. Now when I see RSA7 BW Delta Queue Maintenance at ECC side its now Green but still Total column is Zero. Why?

2. I've created new Infopackage for Full load and all records have been loaded successfully into PSA. But when I activated and Executed DTP I've encountered following RunTime Exception or Error and i"m unable to proceed? see below Screen Shot:

Thanks

Arshiyan

[Former Member · Accepted solution]

pls refer http://scn.sap.com/docs/DOC-11084

[RamanKorrapati · Accepted solution]

Hi,

You can see records at  RSA7, once new records are created in ecc. it will take a time to get into rsa7.

Please go thru below link to resolve your issue. ITAB_DUPLICATE_KEY.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a04c82eb-ec7c-2c10-7fae-ca6e764c4...

Thanks

[former_member182516 · Accepted solution]

Arshiyan,

Check if there are any duplicate entries of Infosource in the table RSISOSMAP .

Check the below link

http://scn.sap.com/people/amit.abhishek2/blog/2012/02/13/itab-duplicate-key--a-row-with-the-same-key...

Regards

KP