Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Failed to load tables:

    • Check that the user assigned to DataSelf has reading rights to that particular data set.

    • Click Back from the Log page, on the ETL main page, select the failing table on the center panel, check that its SQL Statement on the right panel has the correct information.

  • Tables with a record count different than in Sage X3:

    • It might be just that new records have been populated in Sage X3 since the DataSelf data load. Reload the data. Click Back from the Log page, on the ETL main page, select the table with the incorrect row count on the center panel, right-click the table on the center panel again -> Load Now. This might take a while if the table has a large data set.

    • The user assigned to DataSelf might have access to limited data sets, such as only data from one Division. Check the user’s security credentials.

Related Information

Sage X3

...

Sage X3 Pre-Mapped mapped Data Warehouse Tables

DataSelf Analytics for Sage X3

Sage X3 Technical Details