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;

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.

Itgenpwf002 on Exact Online query

Vragen

forums 31 december 2021 om 11:18 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

Topic		Antwoorden	Weergaven
Receive itgengpr019 unable to access Exact Online company 2361366 with query Questions exact-online , invantive-query-tool	2	579	20 september 2023
Itgenoam005 error: Client with identifier '...' not found during log on to Exact Online from Query Tool Wiki (en) invantive-query-tool , exact-online	0	875	5 oktober 2021
Itgenlic127:igenqtl056: Invantive Query tool error - SQL joins Vragen invantive-sql	5	791	11 april 2024
Error itgeneor229 detected in Invantive Cloud Vragen exact-online , invantive-cloud	5	54	27 november 2024
Itgenexl053 A connection to the database Exact Online could not be established as user Questions invantive-control-for-excel , exact-online	3	702	11 april 2024

Itgenpwf002 on Exact Online query

Gerelateerde topics