Ok, this is driving me crazy, so when you figure it out, I'd love to know.
But going back to your last email - " It is almost like there is something set
up SOMEWHERE that says rbadmin can access everything except LIVE.DATA." - we
know that's not true (so ignore my last email), because your eportal site is
using the rbadmin uid/pw successfully. Sooo....
We know it's not the password because eportal (your site not the account) can
use it.
We know it's not the account setup because your eportal can use it.
We know this works:
account=Application("Account").
myCart.Open2 account,"SF:oPreOrder"
And this doesn’t:
accnt=Application("ERPAccount").
oOrder.Open2 accnt,"SF:oOrder",userid,passwd
The only difference it seems between your eportal working in live and your
storefront not working in live the ERPAccount variable which I don't remember
being used in epicor's eportal, only storefront (but haven't verified). Do you
have full path in global.asa or just the account name? I'm sure you have it
right since you're comparing to the working sites, just trying to cover all
bases....
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 12:08 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem
Can you login to your live site with RedBack Designer, with the rbadmin
password you have in your live global.asa?
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 12:04 PM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem
Correct. That was part of my checking. File pointers, catalog pointers, etc...
SPIDER command is working everywhere.
Very frustrating.
It is almost like there is something set up SOMEWHERE that says rbadmin can
access everything except LIVE.DATA.
John
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 2:54 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem
And no pointers missing in live back to eportal SFxxx files?
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 11:49 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem
Correct
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 2:48 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem
I'm just throwing out some ideas, in hopes it would spark something for you or
anyone following...
Check the global.asa in your live site one more time....
1) You are setting Application("ERPAccount") = "LIVE.DATA"
2) Your rgwresp has the same account, as #1
3) Before you do the oOrder.Open2 accnt,"SF:oOrder",userid,passwd , you do
accnt=Application("ERPAccount"). Correct?
Also, In your simple test page with connection test only, can you switch it to
try and open something in the ECP module, like ECP:oOrders? Just wondering if
you've only been using the ecp side of things so far, if it's possible you
might be missing some pointers in live, like to SFINCLUDE or OORDER, or
something like that....
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 11:18 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem
Yes and No.
ePortal has been up and running for years.
StoreFront (the on-line ordering) has NEVER been live. I have a due date of
next week and tried to get it up and running over the past weekend in case I
had issues (which I clearly did).
I do not know why Epicor coded it the way they did.
It works perfectly in TEST
It works perfectly in PILOT
I have run compare utilities against everything and cannot find any differences
that are not intentional (like the name of the desired account, the web site,
etc.)
The horribly annoying and confusing thing is it works in TEST and PILOT! All
of ePortal works cleanly until it tries to connect to LIVE.DATA.
Thanks
John
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 1:57 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem
I'm guessing you're up and running on your production eportal site, and this is
just a new method you're implementing, so the questions below are probably moot
- but just in case....
If it's something specific to the Avante account, have you verified:
1) login paragraph in live is the same as in pilot?
2) the workdir in your rgwresp.ini is correct path to your Avante account?
3) the port to your live.data account isn't blocked
Other than that, I haven't ever gotten anything useful out of this, but can you
set trace and/or verbose levels in rgwresp.ini and see if you get any better
information in the redback logs?
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Israel, John R.
Sent: Monday, January 23, 2012 10:16 AM
To: 'U2 Users List'
Subject: Re: [U2] Redback Connection Problem
It is not returning an error to the web page at all (just the generic "500"
error message). If I look at the server logs, it is giving a meaningless error
stating it basically had a problem on the server and did not finish correctly.
I tracked it down to the open2 method that tried to connect to the Avanté
account. Everything looks good, so I am at a loss.
I build a simple web page that does nothing but attempt to make this
connection, and if successful, give the pertinent parameters involved. This
works flawlessly in TEST and PILOT, but fails in LIVE.
I have a call into Epicor, and have been waiting for a call back for a while
now.
John
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 12:54 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem
Hi John,
Hopefully you've gotten through to tech support this morning, but if not - what
error is it returning to RedBack?
Have you compared LOGIN paragraph between live and pilot?
Is there any indication in the redback logs?
Amy
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Israel, John R.
Sent: Saturday, January 21, 2012 7:53 PM
To: 'U2 Users List'
Subject: [U2] Redback Connection Problem
I have 3 UniData accounts (LIVE.DATA, PILOT.DATA & TEST.DATA). Each has its
own web site (live, pilot & test). We are using Redback (U2 Web DE). We are
using Epicor's Avanté backend and a HEAVILY customized version of their ePortal
web software. Over the past few months, I have developed code in TEST and
moved it to PILOT for user testing. Everything works 100% in TEST and PILOT.
Today, I loaded everything from PILOT to LIVE (UniData code, web stuff, Redback
objects, etc.) There are 2 ways that the web pages connect to UniData:
myCart.Open2 account,"SF:oPreOrder" - where
myCart is the object
account is the ePortal account (sister account to the Avanté account)
and
oOrder.Open2 accnt,"SF:oOrder",userid,passwd - where
oOrder is the object,
accnt is the Avanté account
userid is the Redback login
passwd is the Redback passwd
I have never been told the reason for a difference, but it works cleanly in
TEST and PILOT , but the 2nd type of connection is failing in LIVE. I have
confirmed that the userid and password are correct (the same in TEST and PILOT
since Redback is global) and accnt is the intended Avanté account.
If I do not get success over the weekend, I will be contacting Epicor for help,
but I would REALLY like to get this working before Monday.
Any thoughts?
John
John Israel
Senior ERP Developer
Dayton Superior Corporation
1125 Byers Rd Miamisburg, OH 45342
Office: 937-866-0711 x44380
Fax: 937-865-9182
[email protected]
This message w/attachments (message) is intended solely for the use of the
intended recipient(s) and may contain information that is privileged,
confidential or proprietary. If you are not an intended recipient, please
notify the sender, and then please delete and destroy all copies and
attachments, and be advised that any review or dissemination of, or the taking
of any action in reliance on, the information contained in or attached to this
message is prohibited.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
