Time stamp table BWmo2_timest

[Former Member]

HI all can u some one please tell me where to find this table(timestamp) and how do u find out which record has been sent to bw and which is waiting to be loaded..

k.mohan

[Former Member]

(mispost)

[Former Member]

Hi,

ROOSPRMSC gives you the timestsamp details.

To know the records that are waiting to be sent to BW, look at TCode RSA7. This gives you the delta Q details and you can see the contents of the Delta Queue.

If it is a full upload, please check in RSA3. This is an extraction checker . You need to give the datasource name and it gives the records that are in datasource and that will be pulled to BW once they are scheduled.

To know the number of records that has arrived BW, look at RSMO. This is the monitor where you see the data load details.

To view the contents of the records that has arrived BW, you need to see the PSA if your load goes through PSA and then you can cehck the cintents of the data target (CUBE, ODS) where the data has been loaded.

Hope this helps...

Thanks,

Raj

[former_member631416]

Dear All,

Recently we encountered with "Time stamp" issue Data siurce

As in the Data Target DSO loaded successfully with 0records. In PSA the request is also having no records.

But the BW Delta Queue Maintainance showing uncertain "Time Stamp" for

the data source. Previously Due to some reason, We deleted all request from DSO loaded u201C Init without

data transfer u201D. since then the delta is not correctly loading to the

target due to the " Time Stamp".

And the in RSMO the request having below error--

-

---

" Error message from the source system

Diagnosis

An error occurred in the source system.

System Response

Caller 09 contains an error message.

Further analysis:

The error occurred in Extractor .

Refer to the error message.

Procedure

How you remove the error depends on the error message.

Note

If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.

-

---

We check also the Datasources in Table -

ROOSPRMSC. We found that The Datasource(OLTPSOURCE) dor respective DS has

generated & the timestamp is also genrated but some of the fields showing

blank , Where as one of our working

Datasource(OLTPSOURCE) having all details in all fields and

its Delta is working fine.

Please can anybody help me to come out this situation as the delta used to load daily

Regards,

Taps

[Former Member]

Hi,

1.for Time Stamp ...try table ROOSPRMSC

In the se11 by choosing the menu path utilities->Runtime object->Display you can see the time stamp.

2.In RSA7(Delta Queue) would help u

-Shreya