Help with Updatable Dashboard not working?

Yahoo Archive
1

Using Part Update ext seems have been issue. I updated the BAQ and it works now in both the BAQ and the Dashboard.

Thanks for the help.

2

I made an updateable BAQ/Dashboard to update the Lead Time in Part Plant.

Everything runs without an error but the DB is not updating the new Lead Time.

For the Update Process I am using Parts.Update > update table tt.PartPlant

I've looked over the ICE docs but can't seem to see what I missed.


Does anyone know what I might be missing??


3
Make sure you have PartPlant.Company, PartPlant.Plant, PartPlant.PartNum, PartPlant.LeadTime & Part.PartNum selected under Display. Did you also click the Regenerate BPM Directive button under Update Processing? And also select ttPart under Update Processing.
From: "khilborn@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Monday, July 28, 2014 3:53 PM
Subject: [Vantage] Help with Updatable Dashboard not working???



I made an updateable BAQ/Dashboard to update the Lead Time in Part Plant.
Everything runs without an error but the DB is not updating the new Lead Time.
For the Update Process I am using Parts.Update > update table tt.PartPlant
I've looked over the ICE docs but can't seem to see what I missed.

Does anyone know what I might be missing??





4

Thanks Ted.

 I have all that in my BAQ.

 I ran a trace and here are the results for the update section.

I still can't figure out what I missed.

 

 <tracePacket>
 <businessObject>Epicor.Mfg.BO.DynamicQuery</businessObject>
 <methodName>Update</methodName>
 <returnType>System.Data.DataSet</returnType>
 <localTime>7/29/2014 08:04:45:4517424 AM</localTime>
 <executionTime>78</executionTime>
 <parameters>
  <parameter name='queryDesignDataSet' type='Epicor.Mfg.BO.QueryDesignDataSet' ><QueryDesignDataSet xmlns="http://www.epicor.com/Mfg/100/BO.DynamicQuery/QueryDesign" /></parameter>
  <parameter name='queryResultDataset' type='System.Data.DataSet' ><NewDataSet /></parameter>
 </parameters>
 <paramDataSetChanges>
  <paramDataSet name='queryDesignDataSet' useDataSetNbr='0' >
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='0' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='1' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='2' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='3' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
  </paramDataSet>


<<<<this shows the change I tried to save to the first item. from LeadTime 365 to 364 >>>>>


  <paramDataSet name='queryResultDataset' useDataSetNbr='0' >
   <changedValue tableName='Results' rowState='Modified' rowNum='0' colName='PartPlant.LeadTime' ><![CDATA[364]]></changedValue> 
  </paramDataSet>
 </paramDataSetChanges>
</tracePacket>

5
I assume you tried the updatable BAQ before making it into a dashboard?

From: "khilborn@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Tuesday, July 29, 2014 8:10 AM
Subject: [Vantage] Re: Help with Updatable Dashboard not working???

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285 --

#ygrps-yiv-2037092868yiv5249816285 .ygrps-yiv-2037092868yiv5249816285ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285photo-title
a,
#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285photo-title a:active,
#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285photo-title a:hover,
#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285attach-table div.ygrps-yiv-2037092868yiv5249816285attach-row {
clear:both;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285attach-table div.ygrps-yiv-2037092868yiv5249816285attach-row div {
float:left;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285ygrp-file {
width:30px;}
#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285attach-table div.ygrps-yiv-2037092868yiv5249816285attach-row div div a {
text-decoration:none;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285attach-table div.ygrps-yiv-2037092868yiv5249816285attach-row div div span {
font-weight:normal;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 div.ygrps-yiv-2037092868yiv5249816285ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-2037092868
#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285 –
#ygrps-yiv-2037092868yiv5249816285ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285ygrp-mkp #ygrps-yiv-2037092868yiv5249816285hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285ygrp-mkp #ygrps-yiv-2037092868yiv5249816285ads {
margin-bottom:10px;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285ygrp-mkp .ygrps-yiv-2037092868yiv5249816285ad {
padding:0 0;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285ygrp-mkp .ygrps-yiv-2037092868yiv5249816285ad p {
margin:0;}

#ygrps-yiv-2037092868 #ygrps-yiv-2037092868yiv5249816285 #ygrps-yiv-2037092868yiv5249816285ygrp-mkp .ygrps-yiv-2037092868yiv5249816285ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-2037092868



Thanks Ted.
 I have all that in my BAQ.
 I ran a trace and here are the results for the update section.
I still can't figure out what I missed.
 
 <tracePacket>
 <businessObject>Epicor.Mfg.BO.DynamicQuery</businessObject>
 <methodName>Update</methodName>
 <returnType>System.Data.DataSet</returnType>
 <localTime>7/29/2014 08:04:45:4517424 AM</localTime>
 <executionTime>78</executionTime>
 <parameters>
  <parameter name='queryDesignDataSet' type='Epicor.Mfg.BO.QueryDesignDataSet' ><QueryDesignDataSet xmlns="http://www.epicor.com/Mfg/100/BO.DynamicQuery/QueryDesign" /></parameter>
  <parameter name='queryResultDataset' type='System.Data.DataSet' ><NewDataSet /></parameter>
 </parameters>
 <paramDataSetChanges>
  <paramDataSet name='queryDesignDataSet' useDataSetNbr='0' >
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='0' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='1' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='2' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
   <changedValue tableName='QueryTable' rowState='Modified' rowNum='3' colName='DBRowIdent'
><![CDATA[System.Byte[]]]></changedValue>
  </paramDataSet>

<<<<this shows the change I tried to save to the first item. from LeadTime 365 to 364 >>>>>

  <paramDataSet name='queryResultDataset' useDataSetNbr='0' >
   <changedValue tableName='Results' rowState='Modified' rowNum='0' colName='PartPlant.LeadTime' ><![CDATA[364]]></changedValue> 
  </paramDataSet>
 </paramDataSetChanges>
</tracePacket>




6

As this is my first attempt, I did try it before I created the dashboard. The row mod field received a U but the db was not updated. I assumed it was just because the BAQ reported what the results would be but not actually update the record.

I have a ticket in with Epicor to see if there are any issues since I can't figure it out.

7
I'm running into something very similar.  Trying to make a dashboard for sales, and I want the ability to flag order releases that require special attention.  I was trying to make an updateable BAQ so they could use OrderRel.CheckBox01 as a flag.  In the BAQ Designer it seems to be working.  It says "Query update fulfilled and reported no error".  The Row Mod column displays a "U", and my check box is checked.  However, when I refresh the BAQ my changes are lost.  Not sure what I'm missing as well.  Please update with any help from Epicor.
8
Kurt,

on the Update General processing tab do you have the ParPlantLeadtime field marked as updateable?

On the update processing tab use business object part, update method update ext, and make sure the ttpart and ttpartplant tables are both checked. 

in the column mapping box below you should have have the following fields: 
ttpart.Company, ttpart.partnum, ttpartplant.company, ttpartplant.plant, ttpartplant.partnum, ttpartplant.leadtime. 

All these fields must be displayed in your query.  And every expression field should have something in it.  if one is blanks something is wrong and it won't work. you can leave the defaults for now. 

Then click the regenerate BPM directive button. then analyze, get list list, double click on the row you want to update, it should pop up a box, enter a lead time, click ok, and hit update, then refresh, this should work. 

If you're trying to do more than 1 row in an update make sure you have allow multiple row update. 



IAROULER:
you will probably need to use the orderhead, orderdtl, and orderrel table for yours to work. 

how this helps.

Bobby
9

Not sure if anyone suggested this…have you cleared out the programdata folder?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 30, 2014 4:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Help with Updatable Dashboard not working???

 

 

Kurt,

 

on the Update General processing tab do you have the ParPlantLeadtime field marked as updateable?

 

On the update processing tab use business object part, update method update ext, and make sure the ttpart and ttpartplant tables are both checked. 

 

in the column mapping box below you should have have the following fields: 

ttpart.Company, ttpart.partnum, ttpartplant.company, ttpartplant.plant, ttpartplant.partnum, ttpartplant.leadtime. 

 

All these fields must be displayed in your query.  And every expression field should have something in it.  if one is blanks something is wrong and it won't work. you can leave the defaults for now. 


Then click the regenerate BPM directive button. then analyze, get list list, double click on the row you want to update, it should pop up a box, enter a lead time, click ok, and hit update, then refresh, this should work. 

 

If you're trying to do more than 1 row in an update make sure you have allow multiple row update. 

 

 

 

IAROULER:

you will probably need to use the orderhead, orderdtl, and orderrel table for yours to work. 

 

how this helps.

 

Bobby