Our BAQs have recently stopped working reliably. At first I thought it was just our custom BAQs but then found that a simple query on any table in the BAQ designer gives me the following error message, “Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator.” This was returned on a query on the Part table displaying only the part # and part description with no other criteria. I have found that if we hit the Test button multiple times(3, 5, 10x) that eventually one of them returns results. I have done a db dump and load and it gave me no errors and did not fix the problem. Anybody have any idea what might be going on? Thanks.
9.05.702A
Progress 64bit
aidacra
(Nathan your friendly neighborhood Support Engineer)
2
Anything interesting in your database (\epicor905\db\mfgys.lg) log?
Only thing I see is the following, but I reran a BAQ and a similar entry was not created so I doubt it’s coming from the failed BAQ.
[2018/08/03@14:26:12.534-0400] P-7640 T-10800 I APPSRV 48: (8826) Field Source from BpPreProcDirective record (recid 13216710) was missing from FIELDS phrase.
[2018/08/03@14:26:12.535-0400] P-7640 T-10800 I APPSRV 48: (8826) Field Source from BpPreProcDirective record (recid 13216736) was missing from FIELDS phrase.
[2018/08/03@14:26:12.536-0400] P-7640 T-10800 I APPSRV 48: (8826) Field Source from BpPreProcDirective record (recid 13216743) was missing from FIELDS phrase.
[2018/08/03@14:26:12.536-0400] P-7640 T-10800 I APPSRV 48: (8826) Field Source from BpPreProcDirective record (recid 13217508) was missing from FIELDS phrase.
aidacra
(Nathan your friendly neighborhood Support Engineer)
4
What type of dump and load did you complete? ASCII or binary? If binary, that wouldn’t correct any “bad” data.