Thanks for your help everyone - I have this resolved now.
The issue was in my mfgsys file - the IP addresses were incorrect, and I had duplicated the error in my code.
By using the corrected IP address I can input data into the live database ;)
The issue was in my mfgsys file - the IP addresses were incorrect, and I had duplicated the error in my code.
By using the corrected IP address I can input data into the live database ;)
--- In vantage@yahoogroups.com, "gidgeboy" <shane.parker@...> wrote:
>
> Thanks folks;
>
> I have done a bunch of testing and found that:
>
> 1) If I login to epicor using the Epicor 9.05 Express application on my local machine with the server http://XXX.XXX.XXX.XXX:8080/aia/Aia?LiveXXX I have access to the live data (as expected).
>
> 2) If I login to epicor using the Epicor 9.05 Express application on my local machine with the server http://XXX.XXX.XXX.XXX:8080/aia/Aia?PilotXXX I have access to the live data (NOT as expected - I was expecting the pilot data).
>
> 3) If I login to epicor using the web client the system info lists the server as AppServerDC://EpicProdDB01:9401 and I have access to the live data (this gels with John's comments) - but this server is only visible to the web server, not me.
>
> 4) If I login to epicor using "New Session(User, Password, Server, Session.LicenseType.WebService)", where 'Server' is either of the addresses in 1) or 2) I have access to the Pilot.
>
> Inspection of session.Connectionpool.SessionID reveals 10.XXX.XXX.XXX::EpicorPilot905::9431:: {snip}. so it makes sense why I am looking at pilot data, but how should I modify the address in 1) above to dictate the port I require?
>
> Thanks again for all your help and pointers ;)
>
>
>
>
> --- In vantage@yahoogroups.com, John Driggers <waffqle@> wrote:
> >
> > If the data is going to pilot, you have the port wrong. It should be:
> > Prod: 9401
> > Train:9411
> > Test: 9421
> > Pilot: 9431
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> >
> > On Tue, Oct 30, 2012 at 10:25 AM, Ted Koch <tkoch77@> wrote:
> >
> > > **
> > >
> > >
> > > Are the port numbers different? You can also verify by going into the
> > > Management Console on your Epicor server. Go to your main AppServer for
> > > production database, select Broker Control and in there is the Host and
> > > Port.
> > >
> > > ________________________________
> > > From: gidgeboy <shane.parker@>
> > > To: vantage@yahoogroups.com
> > > Sent: Tuesday, October 30, 2012 10:18 AM
> > >
> > > Subject: [Vantage] Re: New session from external app.
> > >
> > > Thanks, that is the same as the string I am using for the server field
> > > when creating a new session. It is different between the live and pilot
> > > db's, but regardless of what I use the data is added to the pilot db, not
> > > the live db (great for testing, but no good for production!)
> > >
> > > --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> > > >
> > > > You can find ServerName:Port at the bottom right of the main Epicor
> > > window.
> > > >
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: gidgeboy <shane.parker@>
> > > > To: vantage@yahoogroups.com
> > > > Sent: Tuesday, October 30, 2012 9:59 AM
> > > > Subject: [Vantage] Re: New session from external app.
> > > >
> > > > Thanks for the Superfast response Ted,
> > > >
> > > > I am ultra new to Epicor (first customisation!), but have some
> > > experience with db, web & general coding, so any pointers are most helpful.
> > > >
> > > > Your snippet looks much like what I am doing (so I can't be far off!) I
> > > am replacing "AppServerDC://ServerName:Port" with the exact text in the
> > > "app server" field of the config manager. Do I need to suffix the ':port'
> > > to the end? If so, where would I find the appropriate number? By the way
> > > there is a :8080 in the server address - I thought that was the port, but
> > > it is the same between live and pilot...
> > > >
> > > > --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> > > > >
> > > > > Here is an example, it's using the BOReader but its the same idea...
> > > > >
> > > > > Using epiSession As New Session("manager",
> > > "manager", "AppServerDC://ServerName:Port", Session.LicenseType.Default)
> > > > > Dim _boReader As New
> > > BOReader(epiSession.ConnectionPool)
> > > > > End Using
> > > > >
> > > > >
> > > > > Hope it helps
> > > > >
> > > > > -Ted
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ________________________________
> > > > > From: gidgeboy <shane.parker@>
> > > > > To: vantage@yahoogroups.com
> > > > > Sent: Tuesday, October 30, 2012 9:29 AM
> > > > > Subject: [Vantage] New session from external app.
> > > > >
> > > > > Hi all,
> > > > >
> > > > > We are recent customers of Epicor Express, and are trying to link our
> > > existing CAD part number type customisations with Epicor (running locally
> > > from within the CAD system and referencing the local DLL's).
> > > > >
> > > > > I am using something similar to the below (sorry, not at work now so
> > > can't paste the exact code).
> > > > >
> > > > > Dim mySession As New Epicor.Mfg.Core.Session(user, password, server)
> > > > > Dim part as New Epicor.Mfg.BO.part(mySession.ConnectionPool)
> > > > > ... Etc
> > > > >
> > > > > When I use the address of the pilot db for the server everything seems
> > > to work fine - BUT:
> > > > >
> > > > > - if I change the server address from /pilot to /live (i.e used the
> > > app server address in the config file) the new part is still added to the
> > > pilot database, and not the live database. Inspection of the
> > > connectionpool property of the session object reveals an address that
> > > includes the word 'pilot'. Any ideas why I only seem to be able to connect
> > > to the pilot, and not the server?
> > > > >
> > > > > - repeated creation and destruction of the session object seems to max
> > > out our user licences. It seems as if the destruction of the session object
> > > doesn't "logout" and release the licence. Waiting about 15 minutes seems
> > > to resolve the issue (as in, the licences become available agin) but this
> > > won't be practical in production. Is there a way to ensure the session
> > > object releases the licence when it is done?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > 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
> > > > >
> > > > >
> > > > >
> > > > > [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
> > > >
> > > >
> > > >
> > > > [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
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>