Skip to main content
Solved

Data not visible

  • 17 June 2024
  • 6 replies
  • 50 views

Good Day All, 

At this moment we have the following challenge: Client is utilizing TX version 20.10.43.64. Client requested us to add new fields. We've modified the *.rsd file, columns are being created however data is not visible after we've deplooy and execute. We've verified the source and can confirm that data is entered. 

Is there something that we've missed or overlooked? 

Appreciate your support in here. 

Regards, 

Marc

6 replies

Userlevel 3
Badge +4

Hi @Marc ,

Did you run the synchronize task after changing the RSD files? This ensures the new columns are detected.

After running the synchronize task, you need to synchronize the ODX Server (right-click ODX Server → Synchronize Objects). Once it is synced, the new columns should be visible in the data warehouse layer as well.

Hi @bas.hopstaken, synchronize task have been executed. Columns are visible however data fields are empty and missing data.

Thanks. 

Userlevel 6
Badge +5

Fields that appear empty while existing in the RSD file can be due to two things.

  1. The XPath in the field descriptor points incorrectly to the field making it appear empty
  2. The JSONPath setup does not point to the right level hence it can’t find the data.

This <api:set attr="JSONPath" value="$." /> is the default JSONPath for most RSD files, but it can be that it is on a lower level that the data exists. You can change the Data Model setup before generating the file to see how it affects this. If it is set to FlattenedDocuments it can aggregate more than one setup in this field using a ; to separate each setup.

Userlevel 6
Badge +7

Hi,

 

additionally if the table you are loading into is incremental or a history table, it won't populate new fields unless new records are loaded in. You may get more information if you set the verbosity on the logging to level 3 and verify that the raw data is being loaded from source.

Userlevel 6
Badge +5

Hi @Marc have you had a chance to try the suggestions above?

Hi Christian, 

We are currently receiving support from Thomas on this manner. Seems more challenging then originally anticipated. 

Reply