If this is driving YOU crazy, you can imagine how I feel.  I have very little 
hair left on my already balding head.  This is a 6 month project that is due 
next week that is held up on this one issue (so far).

Anyway, the connections to the ERPAccount (i.e LIVE.DATA) is only used by 
ePortal in the checkout process once a basket has been successfully populated 
by the user.  From that point on, I believe all the connections go against the 
Avanté account.  Why?  I have no clue.  So long as the program and files that 
are needed are there, who cares?  The only place I could see this making a 
difference is when the order is actually built as an XML file and "pushed" 
through Avanté via the iConnect suite (which is also global like Redback).  
Since I have not gotten that far, iConnect is not in the picture at this point.

I MIGHT be able to switch everything to work from just the ePortal accounts, 
but my hesitation is:
1) I did not need to do this in TEST/PILOT so why should I need to in LIVE?
2) If changing DOES work up until the end, why did Epicor write it this way (I 
am not expecting a great answer here)?
3) If the final filing that kicks in the iConnect stuff DOES need it that way, 
I will have re-written a bunch of code that I have to put back anyway.

The bottom line to all this is: WHAT IS DIFFERENT BETWEEN TEST/PILOT AND LIVE!!!

I will happily post the solution to this when Epicor finally gets back to me.

In the words of the profit, John Belushi: "My advice to you is to start 
drinking heavily."


John



-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy
Sent: Monday, January 23, 2012 3:48 PM
To: U2 Users List
Subject: Re: [U2] Redback Connection Problem

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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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

johnisr...@daytonsuperior.com

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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to