Updateable BAQ ttResults - schema error

Yahoo Archive
1

found the answer. Not a great one, but I’ll stop banging my head trying to solve it.

 

Thanks

 

Greg

 

Summary:

 

UBAQ updatable BAQ fails upon update with a schema mismatch error.

Details:

Page:
13226ESC

Summary:
UBAQ updatable BAQ fails upon update with a schema mismatch error.

Description of issue:
When attempting to update a BAQ that worked previously, it fails with a version of the following error: (field numbers may vary)

"ERROR condition: Parameter number 2 (table ttResults) mismatch. Has 28 fields - client schema has 29 fields."


Cause:
If the UBAQ was working at one point, the likely reason is that an upgrade to the Epicor 9.05 software was performed and the BAQ was not properly updated during the conversions. As a result of the upgrade, the BAQ Designer may expect a certain number of fields that the improperly converted BAQ no longer meets.


Resolution:
Unfortunately the only resolution at this time is to rebuild the BAQ from scratch.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 6:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ ttResults - schema error

 

 

sorry, 9.05.702A

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ ttResults - schema error

 

 

What version and DB?  In E10 I would probably be going to the Admin Console and doing the  bit that updates the DB schema info like when you add a UD table.  Had to do that too when  I updated from 10.0.700.1 to 700.4.  Don’t recall the steps or what it is called but that might be worth investigating – along with a good full backup.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ ttResults - schema error

 

 

Can someone tell me what this errors means? I have added every key of every table, used the standard PartCost BO to update and advanced bpm processing.

 

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

 

It happens as soon as I change a value.

 

Thanks

 

Greg Payne

 

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
2

Can someone tell me what this errors means? I have added every key of every table, used the standard PartCost BO to update and advanced bpm processing.

 

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

 

It happens as soon as I change a value.

 

Thanks

 

Greg Payne

 


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
3

What version and DB?  In E10 I would probably be going to the Admin Console and doing the  bit that updates the DB schema info like when you add a UD table.  Had to do that too when  I updated from 10.0.700.1 to 700.4.  Don’t recall the steps or what it is called but that might be worth investigating – along with a good full backup.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ ttResults - schema error

 

 

Can someone tell me what this errors means? I have added every key of every table, used the standard PartCost BO to update and advanced bpm processing.

 

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

 

It happens as soon as I change a value.

 

Thanks

 

Greg Payne

 

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

4
#ygrps-yiv-1393727487 {font-family:'Times New Roman';font-size:13px;}
In E10 -

1. Sync all UD tables to database
2. Regenerate data model 

-T

On Thu, 05 Mar 2015 14:34:34 -0600, Todd Caughey tcaughey@... [vantage] <vantage@yahoogroups.com> wrote:

  
<div id="ygrps-yiv-1393727487ygrp-text">
  
  
  <p>

What version and DB?  In E10 I would probably be going to the Admin Console and doing the  bit that updates the DB schema info like when you add a UD table.  Had to do that too when  I updated from 10.0.700.1 to 700.4.  Don’t recall the steps or what it is called but that might be worth investigating – along with a good full backup.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ ttResults - schema error

 

 

Can someone tell me what this errors means? I have added every key of every table, used the standard PartCost BO to update and advanced bpm processing.

 

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

 

It happens as soon as I change a value.

 

Thanks

 

Greg Payne

 

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

</div>
 


<div style="color:#fff;height:0;"></div>



--
Using Opera's mail client: http://www.opera.com/mail/
5

sorry, 9.05.702A

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ ttResults - schema error

 

 

What version and DB?  In E10 I would probably be going to the Admin Console and doing the  bit that updates the DB schema info like when you add a UD table.  Had to do that too when  I updated from 10.0.700.1 to 700.4.  Don’t recall the steps or what it is called but that might be worth investigating – along with a good full backup.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 05, 2015 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ ttResults - schema error

 

 

Can someone tell me what this errors means? I have added every key of every table, used the standard PartCost BO to update and advanced bpm processing.

 

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

 

It happens as soon as I change a value.

 

Thanks

 

Greg Payne

 

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."