Data from Exact Online is not being loaded into the database for one specific administration. All other administrations have the same authorisations and rights and do appear in the database. We’ve also checked the API connection, and it’s functioning correctly. We see in Exact Online that the administration is authorised, but the data isn’t coming through. We’ve verified this by querying the database in Invantive itself, but the data for this administration does not come through there either.
Regarding which Invantive product is this?
General checks can be found in:
- Nieuwe Exact Online administratie niet zichtbaar in Invantive Cloud voor Power Query/BI
- Op administratieniveau rechten verlenen aan Exact Online Apps met DivisionLevelScoping
- Wat is "division scoping"?
- Wat is "data scoping" op Exact Online?
- Niet meer alle divisie te selecteren?
- Hoe trek ik de app rechten in voor Exact Online?
Invantive Cloud
Thanks!
The advice is to go through the previously mentioned checks.
It is often useful to search for the division code in the contents of SystemDivisions (directly on Exact for what is there, regardless of the status) and SystemPartitions@DataDictionary to see if there are any messages and if the two sources align.
Keep in mind that not every administration can be processed. For example, administrations outside the service area will appear in SystemDivisions, but cannot be processed within the application itself.
This question was automatically closed after 1 week of inactivity. The last given answer is marked as the solution.
Please post a new question in a separate topic if the issue occurs again. In the new question, please include a link to this topic by pasting its URL in the text.