Itgenpwf002 on Exact Online query

Questions
,
1

Receive the following error: itgenpwf002

My query is the following:

select GL.*
,      FP.*
from   ExactOnlineREST.GeneralJournalEntry.GeneralJournalEntryLines GL
join   ExactOnlineREST.Financial.FinancialPeriods FP
ON     GL.Division = FP.DIVISION
limit  1000;
2

What is the actual and complete error text?

3

Please see screenshot.

image
image1727×428 31.6 KB

4

Hmm, that is a confusing error as in a BSOD is also an error, but does not provide guidance.

Can you download Invantive Query Tool from https://download.invantive.com and run the query from there? I seem to miss at least one join.

6

Please note that the itgenpwf002 error now displays the actual error text as described on Vague itgenpwf002 message replaced by new error window displaying actual error message