Forum Discussion

GParreiras's avatar
GParreiras
New Contributor III
21 days ago
Solved

Replace not working

Hi all,
I'm experiencing an issue with the connector in one of the cubes. Although everything is set to "replace," the stage is not being cleared, and old data is being loaded together with the new data. As a result, I have to manually clear the stage to resolve it.

The log, is says replace 

Data keys are 2025M10,2025M11,2025M12,2026M1, but if i check th estage after the import i have periods outiside this range

The log indicates 9,261 lines, exacly the same amount of rows that the query produces. But the import shows 248 pages. With 50 rows per page, that would be around 12,400 rows loaded, which is quite different from what the log reports.

 

I'm not sure if I'm missing something here, but I haven’t noticed this happening in other data loads. I still need to replicate the issue in a different app. Has anyone seen this before? Thanks in advance!

 

 

Application Properties
  • GParreiras's avatar
    GParreiras
    10 days ago

    It seems the 'Replace' option doesn't replace all time periods every time, but 'Replace (All Time)' does. I'll update all workflows to use the 'Replace (All Time)' method. However, for batch file loading the documentation only shows only "R" and "A", i found some others. 

     

    Even if the workflow is set to "Replace (All Time)," you still need to specify the proper load method in the batch file name. I’m currently using "RT." Here is what we have for the replace load methods.

    R = Replace
    RB = BackgroundAllTimeAllSourceId
    RT = ReplaceAllTime

     

7 Replies

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee
    15 days ago

    I'm curious what your scenario workflow tracking frequency is. I assume it's not a range based on the name shown in your log. If that's the case, the stage will be replaced according to the data keys found in the file - in your case, M10-12+M1. The M9 will remain as you've shown in your screenshots.

    • GParreiras's avatar
      GParreiras
      New Contributor III
      15 days ago

      Hi chul​ . 

      It's yaerly. So should a manually clear the stage every time before loading?

      Thanks!

      • JackLacava's avatar
        JackLacava
        Icon for OneStream Employee rankOneStream Employee
        15 days ago
        1. which version are you on?
        2. Are you changing the SourceID value between loads? IIRC, as long as the Source ID stays the same, the system should automatically clear everything related to it when you reload.

         

  • GParreiras's avatar
    GParreiras
    New Contributor III
    10 days ago

    It seems the 'Replace' option doesn't replace all time periods every time, but 'Replace (All Time)' does. I'll update all workflows to use the 'Replace (All Time)' method. However, for batch file loading the documentation only shows only "R" and "A", i found some others. 

     

    Even if the workflow is set to "Replace (All Time)," you still need to specify the proper load method in the batch file name. I’m currently using "RT." Here is what we have for the replace load methods.

    R = Replace
    RB = BackgroundAllTimeAllSourceId
    RT = ReplaceAllTime