Hello. When you load data into Paxata, a version is associated with the data. That version gets updated when your data is updated. The initial version value is always set to 1, and any update incrementally adjusts the version by 1. For example, if you are importing data from a database, the initial version of that data is set for 1. If you run a daily update for 7 days in a row, you will end on version 8 of the data.
When you load data into your project, Paxata will track which version of the data is associated with that project. When you use Automation to refresh your project, what Paxata will do is:
- Look to see which files are being used in the project, and more importantly what version of the file is being used.
- Paxata checks the library to see if there are any newer versions of the files in the library
The default action Paxata will take is that if a new file exists, then Paxata will update the project with the newer version. If there are no newer versions of the file, and the project is using the latest version, then Paxata will return the "Complete with Error" due to no newer versions of the file exist. You can control these settings if you have a mixture of data that will be not have a newer version vs a file that does have a new version. There are ways of testing this and adjusting this from within the project (Please see the comment field below for links on these actions
It sounds like that you have automated the refresh of your database. Even though the data may not change, you are getting a new version of your data. It sounds like that the other file isn't being updated which is what is causing the error you are encountering. Please check the versions of the files. You can always open a support ticket at email@example.com
and we can take a closer look at your issue.