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