Epicor 905.702a very odd event

Not that I'maware of. 



Thanks,
Ken


-------- Original message --------
From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
Date: 2/8/2016 2:31 PM (GMT-06:00)
To: Vantage <vantage@yahoogroups.com>
Subject: Re: [Vantage] Epicor 905.702a very odd event

 
<div id="ygrps-yiv-164281293ygrp-text">
  
  
  <p></p><div dir="ltr"><div class="ygrps-yiv-164281293gmail_default" style="font-family:verdana, sans-serif;font-size:small;">I would say someone wrote a bad query, or a bad BPM... any BPM work done recently? anyone writing SQL direct stuff that may have made a booboo?</div></div><div class="ygrps-yiv-164281293gmail_extra"><br clear="all"><div><div class="ygrps-yiv-164281293gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br><br></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br><a rel="nofollow" target="_blank" href="http://www.josecgomez.com"><font color="#FF6600">http://www.josecgomez.com</font></a><br><a rel="nofollow" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Flinkedin.png&t=1473007187&sig=lDAERrMec6b1cgFyCFbkfw--~C" id="ygrps-yiv-1642812931454964064577"></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Ffacebook.png&t=1473007187&sig=yWzN2mYD9cCn55ORHlkfiw--~C" id="ygrps-yiv-1642812931454964064578"></a>&nbsp;</font><a rel="nofollow" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Fgoogle.png&t=1473007187&sig=LZHoB13oGqzl8HPGo_Y.uA--~C" id="ygrps-yiv-1642812931454964064578"></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.twitter.com/joc85"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Ftwitter.png&t=1473007187&sig=S_n8hU82JNReomYwctQDjw--~C" id="ygrps-yiv-1642812931454964064579"></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Fwp.png&t=1473007187&sig=ZEqp9yG.SJFm_wbyXTso_Q--~C" id="ygrps-yiv-1642812931454964064579"></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" target="_blank" href="http://www.josecgomez.com/feed/"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Frss.png&t=1473007187&sig=wRyqNeQmpI08_UGAMqL7Ow--~C" id="ygrps-yiv-1642812931454964064579"></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?



On Mon, Feb 8, 2016 at 3:04 PM, Greg Payne gpayne@… [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

If you are SQL, then I would be looking for an accidental sql update. I would restore the db from 2/4 to test or pilot and look at the dates.

 

If they are good then you can dump them to excel and use DMT and a update bpm on a UDxx table to put them back in. I don’t think you will be able to change the completed date on closed jobs.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 08, 2016 2:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.702a very odd event

 

 

Has anyone heard of this before.  This morning we discovered that none of our reports pertaining to Jobs would

product any results.   No history for completed Jobs and no Open Jobs.   So I wrote a BAQ to dump the Job Head table

and discovered that all the Complete Date fields where set to 02/05/2016 whether the Job was closed or not.   Meaning prior years and future jobs all have the same complete date regardless of Open status.  How in the world could this happen.  There is nothing in the System Monitor showing process being ran.  Any clues?




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-6240 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;min-height:0;"></div>

</div>
Has anyone heard of this before.  This morning we discovered that none of our reports pertaining to Jobs would
product any results.   No history for completed Jobs and no Open Jobs.   So I wrote a BAQ to dump the Job Head table
and discovered that all the Complete Date fields where set to 02/05/2016 whether the Job was closed or not.   Meaning prior years and future jobs all have the same complete date regardless of Open status.  How in the world could this happen.  There is nothing in the System Monitor showing process being ran.  Any clues?

If you are SQL, then I would be looking for an accidental sql update. I would restore the db from 2/4 to test or pilot and look at the dates.

 

If they are good then you can dump them to excel and use DMT and a update bpm on a UDxx table to put them back in. I don’t think you will be able to change the completed date on closed jobs.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 08, 2016 2:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.702a very odd event

 

 

Has anyone heard of this before.  This morning we discovered that none of our reports pertaining to Jobs would

product any results.   No history for completed Jobs and no Open Jobs.   So I wrote a BAQ to dump the Job Head table

and discovered that all the Complete Date fields where set to 02/05/2016 whether the Job was closed or not.   Meaning prior years and future jobs all have the same complete date regardless of Open status.  How in the world could this happen.  There is nothing in the System Monitor showing process being ran.  Any clues?




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-6240 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."
I would say someone wrote a bad query, or a bad BPM... any BPM work done recently? anyone writing SQL direct stuff that may have made a booboo?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Mon, Feb 8, 2016 at 3:04 PM, Greg Payne gpayne@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>

If you are SQL, then I would be looking for an accidental sql update. I would restore the db from 2/4 to test or pilot and look at the dates.

Â

If they are good then you can dump them to excel and use DMT and a update bpm on a UDxx table to put them back in. I don’t think you will be able to change the completed date on closed jobs.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 08, 2016 2:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.702a very odd event

Â

Â

Has anyone heard of this before. This morning we discovered that none of our reports pertaining to Jobs would

product any results. Â No history for completed Jobs and no Open Jobs. Â So I wrote a BAQ to dump the Job Head table

and discovered that all the Complete Date fields where set to 02/05/2016 whether the Job was closed or not.  Meaning prior years and future jobs all have the same complete date regardless of Open status. How in the world could this happen. There is nothing in the System Monitor showing process being ran. Any clues?




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-6240 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;min-height:0;"></div>