BAQ report frustration

Yahoo Archive
1
Rob
Just

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Tuesday, October 20, 2009 7:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ report frustration...




Hi all..

So I have a couple BAQ reports that I have scheduled to run every night.
And every night, run they do, and when I get in the next morning and
look in my system monitor....nothing. History shows they ran, but the
reports tab is a big blank...no xml file in my folder. I look at the
server back up and they're right there...until midnight. The form will
not let me save defaults, so I can't set the archive period that way. I
did hard code the archive period in the form itself, and the form shows
the archive period to be 1 week, and when you run it manually it honors
that. When it runs scheduled..it does not. Anyone else have similar
frustrations? Below is a copy of the code I placed in the BAQ report
form.

Private Sub BAQReportForm_Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm.Load

'//

'// Add Event Handler Code

'//

Dim edvReportParam As EpiDataView =
CType(oTrans.EpiDataViews("ReportParam"), EpiDataView)

edvReportParam.dataView(edvReportParam.Row)("ArchiveCode") = 7

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site) <http://www.dsmfg.com/
<http://www.dsmfg.com/> >

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
Hi all..



So I have a couple BAQ reports that I have scheduled to run every night.
And every night, run they do, and when I get in the next morning and
look in my system monitor....nothing. History shows they ran, but the
reports tab is a big blank...no xml file in my folder. I look at the
server back up and they're right there...until midnight. The form will
not let me save defaults, so I can't set the archive period that way. I
did hard code the archive period in the form itself, and the form shows
the archive period to be 1 week, and when you run it manually it honors
that. When it runs scheduled..it does not. Anyone else have similar
frustrations? Below is a copy of the code I placed in the BAQ report
form.



Private Sub BAQReportForm_Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm.Load

'//

'// Add Event Handler Code

'//

Dim edvReportParam As EpiDataView =
CType(oTrans.EpiDataViews("ReportParam"), EpiDataView)

edvReportParam.dataView(edvReportParam.Row)("ArchiveCode") = 7



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>







[Non-text portions of this message have been removed]
3
(Maybe dumb questions) -

Are you running them before or after midnight? (If before midnight, could Vantage be purging them when the clock ticks 12:00AM on the assumption it is a new day & the archive can be deleted?)

Do you have multiple dbs running that could be interacting with each other? (say - your live db, a test db & a development db?) If you do they can step on each other (yes - even on seperate boxes). (Been there!)

Along same lines as above, are you hard specifying a path where the archive is to be saved? (That can aggravate the multi db problems mentioned above - or the files may be being saved somewhere you aren't looking.)

Rob Brown




________________________________
From: Rob Bucek <rbucek@...>
To: vantage@yahoogroups.com
Sent: Tue, October 20, 2009 10:17:36 AM
Subject: [Vantage] BAQ report frustration...

Â
Hi all..

So I have a couple BAQ reports that I have scheduled to run every night.
And every night, run they do, and when I get in the next morning and
look in my system monitor....nothing. History shows they ran, but the
reports tab is a big blank...no xml file in my folder. I look at the
server back up and they're right there...until midnight. The form will
not let me save defaults, so I can't set the archive period that way. I
did hard code the archive period in the form itself, and the form shows
the archive period to be 1 week, and when you run it manually it honors
that. When it runs scheduled..it does not. Anyone else have similar
frustrations? Below is a copy of the code I placed in the BAQ report
form.

Private Sub BAQReportForm_ Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm. Load

'//

'// Add Event Handler Code

'//

Dim edvReportParam As EpiDataView =
CType(oTrans. EpiDataViews( "ReportParam" ), EpiDataView)

edvReportParam. dataView( edvReportParam. Row)("ArchiveCod e") = 7

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg com/>

(Click the logo to view our site) <http://www.dsmfg com/>

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
4
Hi Rob! All good questions..thanks for taking the time.

They are set to run at 11:55 pm nightly..and my presumption was that
Vantage was purging them...



We do have multiple data bases on separate boxes. To my knowledge we
haven't had any interference there. Canned or standard reports we can
of course set the archive period, save it and it works without the
problems of these home brewed BAQ reports...



I am not specifying a path, they are showing up as all other reports do,
in the folder of the person who set the schedule...moi... We mount our
back up from the previous day...they show as being there...



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Tuesday, October 20, 2009 11:35 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ report frustration...





(Maybe dumb questions) -

Are you running them before or after midnight? (If before midnight,
could Vantage be purging them when the clock ticks 12:00AM on the
assumption it is a new day & the archive can be deleted?)

Do you have multiple dbs running that could be interacting with each
other? (say - your live db, a test db & a development db?) If you do
they can step on each other (yes - even on seperate boxes). (Been
there!)

Along same lines as above, are you hard specifying a path where the
archive is to be saved? (That can aggravate the multi db problems
mentioned above - or the files may be being saved somewhere you aren't
looking.)

Rob Brown

________________________________
From: Rob Bucek <rbucek@... <mailto:rbucek%40dsmfg.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, October 20, 2009 10:17:36 AM
Subject: [Vantage] BAQ report frustration...


Hi all..

So I have a couple BAQ reports that I have scheduled to run every night.
And every night, run they do, and when I get in the next morning and
look in my system monitor....nothing. History shows they ran, but the
reports tab is a big blank...no xml file in my folder. I look at the
server back up and they're right there...until midnight. The form will
not let me save defaults, so I can't set the archive period that way. I
did hard code the archive period in the form itself, and the form shows
the archive period to be 1 week, and when you run it manually it honors
that. When it runs scheduled..it does not. Anyone else have similar
frustrations? Below is a copy of the code I placed in the BAQ report
form.

Private Sub BAQReportForm_ Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm. Load

'//

'// Add Event Handler Code

'//

Dim edvReportParam As EpiDataView =
CType(oTrans. EpiDataViews( "ReportParam" ), EpiDataView)

edvReportParam. dataView( edvReportParam. Row)("ArchiveCod e") = 7

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg com/>

(Click the logo to view our site) <http://www.dsmfg com/>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
I am using a Global alert to send an e-mail when a DMR User defined check box is checked off. The problem I have is I am sending the alert to a series of Project Managers. I am only interested in sending the alert to the person who is defined as the Job Planner. Is this something that I can do with a Global Alert, or do I have to create a BPM? The Global Alert e-mail function works, now I just need to refine it

I am not quite sure what I have to do.

We are on Version 8.03

Any help would be appreciated

Bob


__________________________________________________________________
Make your browsing faster, safer, and easier with the new Internet Explorer® 8. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/

[Non-text portions of this message have been removed]
6
A bpm could do that...a BAM with an alert attachment would probably be
even better..



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Molson
Sent: Tuesday, October 20, 2009 11:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Global Alert or BPM Help





I am using a Global alert to send an e-mail when a DMR User defined
check box is checked off. The problem I have is I am sending the alert
to a series of Project Managers. I am only interested in sending the
alert to the person who is defined as the Job Planner. Is this something
that I can do with a Global Alert, or do I have to create a BPM? The
Global Alert e-mail function works, now I just need to refine it

I am not quite sure what I have to do.

We are on Version 8.03

Any help would be appreciated

Bob

__________________________________________________________
Make your browsing faster, safer, and easier with the new Internet
Explorer(r) 8. Optimized for Yahoo! Get it Now for Free! at
http://downloads.yahoo.com/ca/internetexplorer/

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
7
We are Version 8.03. We have a couple of plants here, but all of our consumables and tooling arrives in our main Shipping Receiving area. My purchasing Agent creates a P.O. and defines the appropriate warehouse that this should be received into. Having said that, Vantage ignores the warehouse as defined by the P.O. and uses the default warehouse as defined in the Company Configuration. Epicor tells me this is the way Advanced Material Management works. Does this make sense? If so, does anyone have a work around who is using AMM?

Bob Goss

BC Instruments


__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!

http://www.flickr.com/gift/

[Non-text portions of this message have been removed]