0CML_DELTA Error reading time stamp

[former_member387209]

Hello Gurus

I've tried to run the delta load from 0CML_DELTA data source and I recieved the following error message:

Error reading time stamp FVD_BW 1

Errors in source system RSM 340

We have done the following steps.

1. The data source was activated as indicated in the prerequisites of help.sap:

Prerequisites

a) You have to define a technical valid-from date for the extractor.

SPRO / Financial Supply Chain Management / Treasury and Risk Management / Transaction Manager / General Settings / Business Information Warehouse

     Define InfoSources for Position Initialization

     Define InfoSources for Delta Position

     Delete Time Stamp for InfoSource

b) The change pointer must be activated.

  /SAP Banking/Loans Management/Basic Settings/Installation Parameters/Define General Installation Parameters

2. The replicated data source and communication structures and transfer rules are activated.

3. The infopackage was created and executed with various update modes combinations :

       Init w / o data transfer

       Init with Data transfer.

The Infopackage execution always ends with error.

Please gurus, help me!!

Thanks in advance

Felipe

[MGrob · Accepted solution]

Hi

It looks like step 3 has not been done correctly. Try to replicate the datasource and activate it in BW.

From the error I can't judge if you did 1&2..

hope that helps
Martin

[former_member387209 · Accepted solution]

Thanks Martin,

I debugged when running RSA3 transaction and found out in bwfs_general_settins_read FM a segment of code that validates the customize configuration.

* InfoSource für DeltaPosition
    select single datasource datum_ab pure_delta_is system_time_zone
                  retention_time
                  into (e_datasource, e_datum_ab, e_pure_delta_is,
                        e_system_time_zone, e_retention_time)
                  from bwfs_settings_0d
                  where infosource eq i_infosource.
    if sy-subrc eq 0.
      select single table_selection view_selection
                    into (e_table_sel, e_view_sel)
                    from  bwfs_datasrc_d
                    where datasource eq e_datasource.
      if sy-subrc ne 0.
        message x002 with i_infosource 'BWFS_DATASRC_D'
                     raising _invalid_infosource.
      endif.

*
      if e_pure_delta_is is initial.
        select infosource                       "#EC CI_SGLSELECT
                      into (e_infosource_init)
                      from bwfs_settings_0i
                      where infosource_delta eq i_infosource.
          loc_counter = loc_counter + 1.
          if loc_counter gt 1.
           message x006 with i_infosource raising _invalid_customizing.
          endif.
        endselect.
        if sy-subrc ne 0.
          message x006 with i_infosource raising _invalid_customizing.
        endif.
      endif.
    else.
      message x002 with i_infosource 'BWFS_SETTINGS_0D'
                   raising _invalid_infosource.
    endif.

The problem was that in the table: bwfs_settings_0d, there were two records for 0CML_DELTA.

Then I had to delete on of the two records with 0CML_DELTA in costomizing configuration.

Regards

Felipe