Hello - just following up on this request. Has anyone experienced this
issue and can shed some light?
Does any use external baq's?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jkig77
Sent: Tuesday, March 27, 2012 3:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] External BAQ Queries "Field Check" Errors
Hello - Is anyone using external baq queries in Epicor 905.607A?
1. I created a view in SQL from existing Epicor tables.
2. Attached it in my external BAQ
3. I can see data under analyze, but I receive "field check" errors
under "Actions".
Any clue to why I'm getting these errors?
Thanks in advance!
Error Detail
============
Display columns contain nonexistent items:
Table: dbo#myvDMRCycleTime Field: ClosedDelta
Table: dbo#myvDMRCycleTime Field: Company
Table: dbo#myvDMRCycleTime Field: DMRNum
Table: dbo#myvDMRCycleTime Field: MaxDate
Table: dbo#myvDMRCycleTime Field: MinDate
Table: dbo#myvDMRCycleTime Field: OpenAging
Table: dbo#myvDMRCycleTime Field: OpenDMR
Table: dbo#myvDMRCycleTime Field: PartNum
Table: dbo#myvDMRCycleTime Field: Plant
Sort By columns contain nonexistent items:
Table: dbo#myvDMRCycleTime Field: DMRNum
Stack Trace
===========
at Epicor.Mfg.UI.App.BAQTransaction.CheckQueryFields()
Attention Disclaimer: This e-mail and its attachments are privileged and confidential and are the exclusive property of Advanced Integration Technologies, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. Do not copy, use, or distribute this e-mail or its attachments without the consent of Advanced Integration Technologies. If you are not the intended recipient please delete the message and notify the sender. If you are not the intended recipient, you are hereby notified that you may not derive any rights from the information contained herein; and any use, dissemination, or reproduction is strictly prohibited and may be unlawful. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.
[Non-text portions of this message have been removed]
issue and can shed some light?
Does any use external baq's?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jkig77
Sent: Tuesday, March 27, 2012 3:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] External BAQ Queries "Field Check" Errors
Hello - Is anyone using external baq queries in Epicor 905.607A?
1. I created a view in SQL from existing Epicor tables.
2. Attached it in my external BAQ
3. I can see data under analyze, but I receive "field check" errors
under "Actions".
Any clue to why I'm getting these errors?
Thanks in advance!
Error Detail
============
Display columns contain nonexistent items:
Table: dbo#myvDMRCycleTime Field: ClosedDelta
Table: dbo#myvDMRCycleTime Field: Company
Table: dbo#myvDMRCycleTime Field: DMRNum
Table: dbo#myvDMRCycleTime Field: MaxDate
Table: dbo#myvDMRCycleTime Field: MinDate
Table: dbo#myvDMRCycleTime Field: OpenAging
Table: dbo#myvDMRCycleTime Field: OpenDMR
Table: dbo#myvDMRCycleTime Field: PartNum
Table: dbo#myvDMRCycleTime Field: Plant
Sort By columns contain nonexistent items:
Table: dbo#myvDMRCycleTime Field: DMRNum
Stack Trace
===========
at Epicor.Mfg.UI.App.BAQTransaction.CheckQueryFields()
Attention Disclaimer: This e-mail and its attachments are privileged and confidential and are the exclusive property of Advanced Integration Technologies, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. Do not copy, use, or distribute this e-mail or its attachments without the consent of Advanced Integration Technologies. If you are not the intended recipient please delete the message and notify the sender. If you are not the intended recipient, you are hereby notified that you may not derive any rights from the information contained herein; and any use, dissemination, or reproduction is strictly prohibited and may be unlawful. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.
[Non-text portions of this message have been removed]