Odbc problem Blank Title 76830

system · April 17, 2009, 8:22am

that was my problem - didn't look at that because it was really weird that
only 2 of the 6 modified reports returned the error.

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Bill Jackson
Sent: Friday, April 17, 2009 5:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage][6.1] odbc problem

Â We have an 'error 599' when a Crystal report uses an ODBC connection and
the Vantage 'Launch' Script, for a certain user or users group, no longer
references the ODBC connection. Sometimes they find and use an old Icon,
launch script should look something like this, note bottom 4 lines:
Â
[MFG Startup]
Executable=V:\prgs91d\bin\prowin32.exe
Database=V:\mfgsys61\db\MFGSYS
IniFile=V:\mfgsys61\mfgsys.ini
ParameterFile=V:\mfgsys61\db\mfgsys.pf
ConnectOptions=-N TCP -H eevantageÂ -S 6100 -ld MFGSYS
TempDirectory=C:\Epicor\MfgWrk61
StartupProcedure=mainmenu.w
OtherParameters=-rand 2 -q -basekey ini
mfgsys=VN
mfglanguage=enu
mfgtranslator=yes
unicode=true
MFGODBCpasswd=odbcuser
MFGODBCUser=odbcuser
MFGODBCDbse=mfgsys
MFGODBCServer=eeVantage_Mfg

Â

--- On Thu, 4/16/09, Norm Watkins <nwatkins@...> wrote:

From: Norm Watkins <nwatkins@...>
Subject: [Vantage][6.1] odbc problem
To: "Vantage@Yahoogroups. Com" <vantage@yahoogroups.com>
Date: Thursday, April 16, 2009, 4:07 PM

I have 6 modified crystal reports. All printed fine yesterday. 2 of the
six return Error 599 on 2 workstations only - others work fine. Also, all
the reports work fine on a test database.

Any clues why only 2 reports don't work on only the live Db?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · April 16, 2009, 3:12pm

I have 6 modified crystal reports. All printed fine yesterday. 2 of the
six return Error 599 on 2 workstations only - others work fine. Also, all
the reports work fine on a test database.

Any clues why only 2 reports don't work on only the live Db?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

system · April 16, 2009, 3:20pm

Hi All,

We are on Vantage 8.03.305K.

Is there a way, in Vantage, to do lot traceability? By that I mean, I
have a raw material part number and lot number and want to know what
products shipped out that this part/lot went in to. We have multi-level
BOMs and some go many levels deep.

I can certainly do this outside of Vantage using Access but would rather
see if there is some way to do this in Vantage.

Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

M:508.838.4717

F:508.995.9597

joe.rojas@... <mailto:joe.rojas@...>

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

system · April 16, 2009, 3:26pm

Yes the system has a way to "track lots".

If you go into part master, check the Track Lots check box.

Just make sure if you are backflushing, know that the system will NOT
let you track lots.

You can only do one or the other...

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rojas, Joe
Sent: Thursday, April 16, 2009 2:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] True Lot Traceability

Hi All,

We are on Vantage 8.03.305K.

Is there a way, in Vantage, to do lot traceability? By that I mean, I
have a raw material part number and lot number and want to know what
products shipped out that this part/lot went in to. We have multi-level
BOMs and some go many levels deep.

I can certainly do this outside of Vantage using Access but would rather
see if there is some way to do this in Vantage.

Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

M:508.838.4717

F:508.995.9597

joe.rojas@... <mailto:joe.rojas%40symmetrynb.com>
<mailto:joe.rojas@... <mailto:joe.rojas%40symmetrynb.com> >

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

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

system · April 16, 2009, 3:33pm

1. If not already apply the Crystal Database & Export Patch...especially if there is any other Crystal based reporting tool on those PCs.

2. Logout of Vantage and delete everything in the mfgwrk61 folder and try again. Some users I have had to give a shortcut to a batch routine that does this for them. They end up needing to clean it out a couple times a week.

3. Actually before #2 double check the spelling of the mfgwrk61 folder on those two workstations. It has to match where the DB was verified to when the report was saved. Not sure if this would explain the test DB working though.

4. Make sure the 2 workstations are running only one Vantage session (and have no ghost sessions hanging around).

5. Does print preview work with the live DB? If so try a different printer or printer driver.

-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Norm Watkins
Sent: Thursday, April 16, 2009 3:08 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage][6.1] odbc problem

I have 6 modified crystal reports. All printed fine yesterday. 2 of the
six return Error 599 on 2 workstations only - others work fine. Also, all
the reports work fine on a test database.

Any clues why only 2 reports don't work on only the live Db?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

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

system · April 17, 2009, 7:53am

Â We have an 'error 599' when a Crystal report uses an ODBC connection and the Vantage 'Launch' Script, for a certain user or users group, no longer references the ODBC connection. Sometimes they find and use an old Icon, launch script should look something like this, note bottom 4 lines:
Â
[MFG Startup]
Executable=V:\prgs91d\bin\prowin32.exe
Database=V:\mfgsys61\db\MFGSYS
IniFile=V:\mfgsys61\mfgsys.ini
ParameterFile=V:\mfgsys61\db\mfgsys.pf
ConnectOptions=-N TCP -H eevantageÂ -S 6100 -ld MFGSYS
TempDirectory=C:\Epicor\MfgWrk61
StartupProcedure=mainmenu.w
OtherParameters=-rand 2 -q -basekey ini
mfgsys=VN
mfglanguage=enu
mfgtranslator=yes
unicode=true
MFGODBCpasswd=odbcuser
MFGODBCUser=odbcuser
MFGODBCDbse=mfgsys
MFGODBCServer=eeVantage_Mfg

Â

--- On Thu, 4/16/09, Norm Watkins <nwatkins@...> wrote:

From: Norm Watkins <nwatkins@...>
Subject: [Vantage][6.1] odbc problem
To: "Vantage@Yahoogroups. Com" <vantage@yahoogroups.com>
Date: Thursday, April 16, 2009, 4:07 PM

I have 6 modified crystal reports. All printed fine yesterday. 2 of the
six return Error 599 on 2 workstations only - others work fine. Also, all
the reports work fine on a test database.

Any clues why only 2 reports don't work on only the live Db?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

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