Updateable BAQ's-Dashboard Question

system · May 12, 2014, 4:42pm

Now the dashboard has stopped working.

I added a calculated field but, re-synchronized and I am getting the same error again.

The calculated field Â - calculation is â€˜If Customer.EstDate > Today - 90 then 'New' Else ''â€™

Is there something I need to do with a Calculated field?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 11:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Thank you!!! It is working now.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 11:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Add key field from the Customer file such as company and CustNum also add QuoteHed.CustNum

I have found the Updatable BAQs are much happier with Key Fields included.

I just duplicated yours in 9.05.702 with no issues.

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 13:21
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Below is the list from the Display tab.

QuoteHed.Company	Company	x(8)
QuoteHed.QuoteNum	Quote #	>>>>>>>>9
QuoteHed.DateQuoted	Date Quoted	99/99/99
Customer.CustID	Cust. ID	x(10)
Customer.Name	Name	x(50)
QuoteHed.Number03	YTD Revenue	->>>,>>>,>>9.99999
QuoteHed.ShortChar04	Quote Status	X(50)
QuoteHed.ShortChar06	Opportunity Type	X(50)
QuoteHed.ConfidencePct	Confidence %	>>9
QuoteHed.Number04	Score	->>>,>>>,>>9.99999
QuoteHed.ShortChar07	Owner	X(50)
QuoteHed.FollowUpDate	Follow up	99/99/99
QuoteHed.QuoteComment	Comment	X(1000)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 11:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

What fields are selected on the BAQ Display Tab?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 13:04
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

QuoteHed is the Master.

Below is the query from the BAQ.

for each QuoteHed no-lock where QuoteHed.ShortChar04 <> '' , each Customer no-lock where (QuoteHed.Company = Customer.Company and QuoteHed.CustNum = Customer.CustNum ).

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Is the QuoteHed the master table or is the Customer?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 12:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

I am trying to create an updateable dashboard to update some fields on the QuoteHed.

I have 2 tables â€“ QuoteHed and Customer in the BAQ. We want the customer id and name to be displayed.

My Updateable BAQ is working but, I get errors when creating the Dashboard.

The error is below.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Epicor.Mfg.Common.BusinessObjectException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211) --->

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Updateable BAQ's-Dashboard Question

Can I ask what you are trying to do here, what fields are you trying to update? Could it be done with a BPM instead of update-able dashboard?

Also, You don't need those fields in the Update Processing section under column mappings. You only want the fields for the table that will be updated. If you want the customer fields to display then go under the display tab and show the fields that you want to show.

-Bobby

system · May 9, 2014, 3:24pm

I am getting this error when trying to update a row in a BAQ -

ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211)

This is the first time I have used two tables.

Customer and QuoteHed.

Under Update Processing, I clicked Advanced BPM Update only - and picked the Business Object from the Suggested Business Object.

I only want to update the Quotehed but, need the Customer ID and Name for display.

What do I need to do?

system · May 9, 2014, 6:22pm

I redid the BAQ and it works.

However, when I create the updateable dashboard, deploy â€“ test application.

I go to update a field â€“ click the save button â€“ I get this error below.

I go back to my BAQ and it work.

Any suggestions?

************** Exception Text **************

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Epicor.Mfg.Common.BusinessObjectException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schemaÂ has 18 fields. (8030) (7211)Â ---> Progress.Open4GL.Exceptions.RunTime4GLErrorException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schemaÂ has 18 fields. (8030) (7211)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 09, 2014 12:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ's-Dashboard Question

I am getting this error when trying to update a row in a BAQ -

ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211)

This is the first time I have used two tables.

Customer and QuoteHed.

Under Update Processing, I clicked Advanced BPM Update only - and picked the Business Object from the Suggested Business Object.

I only want to update the Quotehed but, need the Customer ID and Name for display.

What do I need to do?

system · May 12, 2014, 9:18am

I think that's the error I received when I didn't have column mapping (under Update>Update Processing tab) for all fields. Check to make sure all fields used in your BAQ are mapped. Also make sure the index fields you'll need for linking are included.

Sue

system · May 12, 2014, 10:44am

After you check the mappings I would also try clearing your client cache. I have run into similar problems where the dashboard is cached and a newly deployed dashboard won't work correctly until I clear the client cache.

-Bobby

system · May 12, 2014, 12:32pm

Under Update > Update Processing â€“ I cannot make Customer.CustID or Customer.Name.

The dropdown allows me to add fields from ttQuoteHed.

These two fields are for display only.

How can I get these two fields mapped?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 6:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updateable BAQ's-Dashboard Question

I think that's the error I received when I didn't have column mapping (under Update>Update Processing tab) for all fields. Check to make sure all fields used in your BAQ are mapped. Also make sure the index fields you'll need for linking are included.

Sue

system · May 12, 2014, 1:42pm

Can I ask what you are trying to do here, what fields are you trying to update? Could it be done with a BPM instead of update-able dashboard?

Also, You don't need those fields in the Update Processing section under column mappings. You only want the fields for the table that will be updated. If you want the customer fields to display then go under the display tab and show the fields that you want to show.

-Bobby

system · May 12, 2014, 1:52pm

I am trying to create an updateable dashboard to update some fields on the QuoteHed.

I have 2 tables â€“ QuoteHed and Customer in the BAQ.Â We want the customer id and name to be displayed.

My Updateable BAQ is working but, I get errors when creating the Dashboard.

The error is below.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Epicor.Mfg.Common.BusinessObjectException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211) --->

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Updateable BAQ's-Dashboard Question

Can I ask what you are trying to do here, what fields are you trying to update? Could it be done with a BPM instead of update-able dashboard?

Also, You don't need those fields in the Update Processing section under column mappings. You only want the fields for the table that will be updated. If you want the customer fields to display then go under the display tab and show the fields that you want to show.

-Bobby

system · May 12, 2014, 1:58pm

system · May 12, 2014, 2:03pm

QuoteHed is the Master.

Below is the query from the BAQ.

for each QuoteHed no-lockÂ whereÂ QuoteHed.ShortChar04 <> ''Â ,Â each Customer no-lockÂ where (QuoteHed.Company = Customer.Company and QuoteHed.CustNum = Customer.CustNum ).

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Is the QuoteHed the master table or is the Customer?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 12:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

I am trying to create an updateable dashboard to update some fields on the QuoteHed.

I have 2 tables â€“ QuoteHed and Customer in the BAQ. We want the customer id and name to be displayed.

My Updateable BAQ is working but, I get errors when creating the Dashboard.

The error is below.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Epicor.Mfg.Common.BusinessObjectException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211) --->

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Updateable BAQ's-Dashboard Question

Can I ask what you are trying to do here, what fields are you trying to update? Could it be done with a BPM instead of update-able dashboard?

Also, You don't need those fields in the Update Processing section under column mappings. You only want the fields for the table that will be updated. If you want the customer fields to display then go under the display tab and show the fields that you want to show.

-Bobby

system · May 12, 2014, 2:18pm

system · May 12, 2014, 2:21pm

Below is the list from the Display tab.

QuoteHed.Company	Company	x(8)
QuoteHed.QuoteNum	Quote #	>>>>>>>>9
QuoteHed.DateQuoted	Date Quoted	99/99/99
Customer.CustID	Cust. ID	x(10)
Customer.Name	Name	x(50)
QuoteHed.Number03	YTD Revenue	->>>,>>>,>>9.99999
QuoteHed.ShortChar04	Quote Status	X(50)
QuoteHed.ShortChar06	Opportunity Type	X(50)
QuoteHed.ConfidencePct	Confidence %	>>9
QuoteHed.Number04	Score	->>>,>>>,>>9.99999
QuoteHed.ShortChar07	Owner	X(50)
QuoteHed.FollowUpDate	Follow up	99/99/99
QuoteHed.QuoteComment	Comment	X(1000)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 11:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

What fields are selected on the BAQ Display Tab?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 13:04
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

QuoteHed is the Master.

Below is the query from the BAQ.

for each QuoteHed no-lock where QuoteHed.ShortChar04 <> '' , each Customer no-lock where (QuoteHed.Company = Customer.Company and QuoteHed.CustNum = Customer.CustNum ).

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Is the QuoteHed the master table or is the Customer?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 12:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

I am trying to create an updateable dashboard to update some fields on the QuoteHed.

I have 2 tables â€“ QuoteHed and Customer in the BAQ. We want the customer id and name to be displayed.

My Updateable BAQ is working but, I get errors when creating the Dashboard.

The error is below.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Epicor.Mfg.Common.BusinessObjectException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211) --->

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Updateable BAQ's-Dashboard Question

Can I ask what you are trying to do here, what fields are you trying to update? Could it be done with a BPM instead of update-able dashboard?

Also, You don't need those fields in the Update Processing section under column mappings. You only want the fields for the table that will be updated. If you want the customer fields to display then go under the display tab and show the fields that you want to show.

-Bobby

system · May 12, 2014, 2:25pm

system · May 12, 2014, 2:57pm

Thank you!!! It is working now.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 11:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Add key field from the Customer file such as company and CustNum also add QuoteHed.CustNum

I have found the Updatable BAQs are much happier with Key Fields included.

I just duplicated yours in 9.05.702 with no issues.

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 13:21
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Below is the list from the Display tab.

QuoteHed.Company	Company	x(8)
QuoteHed.QuoteNum	Quote #	>>>>>>>>9
QuoteHed.DateQuoted	Date Quoted	99/99/99
Customer.CustID	Cust. ID	x(10)
Customer.Name	Name	x(50)
QuoteHed.Number03	YTD Revenue	->>>,>>>,>>9.99999
QuoteHed.ShortChar04	Quote Status	X(50)
QuoteHed.ShortChar06	Opportunity Type	X(50)
QuoteHed.ConfidencePct	Confidence %	>>9
QuoteHed.Number04	Score	->>>,>>>,>>9.99999
QuoteHed.ShortChar07	Owner	X(50)
QuoteHed.FollowUpDate	Follow up	99/99/99
QuoteHed.QuoteComment	Comment	X(1000)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 11:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

What fields are selected on the BAQ Display Tab?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 13:04
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

QuoteHed is the Master.

Below is the query from the BAQ.

for each QuoteHed no-lock where QuoteHed.ShortChar04 <> '' , each Customer no-lock where (QuoteHed.Company = Customer.Company and QuoteHed.CustNum = Customer.CustNum ).

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

Is the QuoteHed the master table or is the Customer?

Patrick

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 12:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Updateable BAQ's-Dashboard Question

I am trying to create an updateable dashboard to update some fields on the QuoteHed.

I have 2 tables â€“ QuoteHed and Customer in the BAQ. We want the customer id and name to be displayed.

My Updateable BAQ is working but, I get errors when creating the Dashboard.

The error is below.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Epicor.Mfg.Common.BusinessObjectException: ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 17 fields - client schema has 18 fields. (8030) (7211) --->

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 12, 2014 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Updateable BAQ's-Dashboard Question

Can I ask what you are trying to do here, what fields are you trying to update? Could it be done with a BPM instead of update-able dashboard?

Also, You don't need those fields in the Update Processing section under column mappings. You only want the fields for the table that will be updated. If you want the customer fields to display then go under the display tab and show the fields that you want to show.

-Bobby

Topic		Replies	Views
Help with Updatable Dashboard not working? Yahoo Archive	8	3687	July 30, 2014
UBAQ for custom JobHead field Epicor ERP 10 updateable-dashboard	8	732	September 22, 2020
uBAQ Driven Dashboard not Behaving the same uBAQ Epicor ERP 10 baq , ubaq , updateable-dashboard	10	1277	January 27, 2020
More than one UBAQ in a Dashboard? Epicor ERP 10 dashboard , ubaq , updatable-dashboard	44	6300	August 15, 2019
Updatable Dashboard Epicor ERP 10 updatable-dashboard	10	653	March 2, 2023

Updateable BAQ's-Dashboard Question

Related Topics