[Pansophy] Pansophy Development Server

Tue May 26 09:32:36 EDT 2020

Sure.  Sherman - is that good for you?

From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Tuesday, May 26, 2020 9:15 AM
To: Bobby Lawrence <robertl at jlab.org>; Sherman White <srwhite at jlab.org>
Cc: pansophy <pansophy at jlab.org>; David Sheppard <sheppard at jlab.org>; Tony Reilly <areilly at jlab.org>; E. Anne McEwen <mcewen at jlab.org>
Subject: RE: Pansophy Development Server

Thank you Bobby and Sherman.

Can we make the change at 12 pm?

Valerie

From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Friday, May 22, 2020 3:24 PM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>; Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: RE: Pansophy Development Server

Ok - we are ready for Tuesday.  Contact me when you are ready to go and I'll ask Sherman to make the switchover at that time.

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Friday, May 22, 2020 12:52 PM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>; Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: RE: Pansophy Development Server

Bobby,

I think we are ready to go. We still have a few issues with our Export to Excel/PDF but they are not game stoppers.
We were working with David Sheppard and have decided to wait on the upgrade to 18c until our new database machine comes in.
Can we make the changeover Tuesday May 26th around Noon or later?
That will give us time to inform users of the upgrade.
Thanks!

Valerie
Pansophy Team

From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Tuesday, May 19, 2020 3:43 PM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>; Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: RE: Pansophy Development Server

Valerie - have you guys made any more progress on preparing for the production upgrade?  It would be nice to get pansophy on the latest software sometime soon...

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Friday, May 01, 2020 10:46 AM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>; Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: RE: Pansophy Development Server

Bobby,

Most of our testing is complete except for our DataMine system. Having problems with the use of (+) in sql queries. Also, when we changed to pansophydev we started getting the following error. It doesn't seem to find our components. We did not do any mappings on our local servers so I'm not sure what I am missing on the development server. Any ideas?  As soon as we get these fixed we can proceed with the production server upgrade. Thank You for checking.

Valerie

[cid:image001.png at 01D61FA4.28846070]

From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Thursday, April 30, 2020 6:54 PM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>; Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: RE: Pansophy Development Server

Valerie - any idea when you would be ready to do the production pansophy server?

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Tuesday, April 21, 2020 11:34 AM
To: Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>; Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: Re: Pansophy Development Server

As long as it's ok to do the production server turnover without this incident?
________________________________
From: Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Sent: Tuesday, April 21, 2020 11:30 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>; Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: Re: Pansophy Development Server

Hi All,

It sounds like I can close this incident...

Sherman
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: 21 April 2020 10:32
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>; pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>; E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: Re: Pansophy Development Server

Bobby,

Yes, you can shutdown the old development server. Thank You for your help. We will let you know when we are ready to do production.

Valerie
Pansophy Team
________________________________
From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Monday, April 20, 2020 4:35 PM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Cc: Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>; pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>; David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>
Subject: RE: Pansophy Development Server

Cool.  Are we safe to officially turn off the old pansophydev?

As for upgrading Oracle, I will defer to David Sheppard.  He should be in contact with you in the next few days...

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Monday, April 20, 2020 4:20 PM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>; pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: Re: Pansophy Development Server

Bobby & Sherman,

Thank you. Sorry it took me so long to get back to you.

We did get the development server up and running the new code.

A few errors we are still working on and I will keep you informed of our progress.

We hope to turn on the production server by the end of the week.

What will it take to upgrade the Oracle? Please advise.

Valerie

________________________________

From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Monday, April 20, 2020 11:59 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Cc: Sherman White <srwhite at jlab.org<mailto:srwhite at jlab.org>>
Subject: RE: Pansophy Development Server

Ok - Sherman has made the switchover.  The "pansophydev.jlab.org" name should now be pointing to the new CF2018 server.  Again - you may have to flush your DNS cache to pick up the change.

https://pansophydev.jlab.org/CFIDE/administrator

Please let me know if everything is ok so we can shut down the old pansophydev server

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Monday, April 20, 2020 11:10 AM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Subject: Re: Pansophy Development Server

Bobby,

with all the work I thought maybe a clean reboot would just ensure we are at point-0 for testing.

Valerie

________________________________

From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Monday, April 20, 2020 11:03 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: RE: Pansophy Development Server

Sorry - just now seeing this.  I will ask Sherman to begin the process.  Do you want the entire pansophydev-2018 server rebooted or just ColdFusion restarted?

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Monday, April 20, 2020 10:45 AM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: Re: Pansophy Development Server

Bobby,

Can the change for the development server be done starting at 11am-ish?

Just let us know when it is done.

Also, can the CF2018 server be rebooted at that time as well?

Valerie

________________________________

From: Pansophy <pansophy-bounces at jlab.org<mailto:pansophy-bounces at jlab.org>> on behalf of Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Monday, April 20, 2020 9:54 AM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: Re: [Pansophy] Pansophy Development Server

Bobby,

We have a P-Team meeting at 10am.  Afterwards we can make the switch for development.

As for the datasources, we currently have duplicates because we are working towards elimnating the 11G, but we have not yet rebooted the production server to remove it's dependence on them. When we switch to the new server we will have the Application.cfc updated for the non-11G versions and can then remove those datasource names.

I think upgrading our Oracle on the development server would be good. That way we can test it along with our new SQL statements that have been giving us a problem in the new CF2018. lol But will confirm with the team.

I will get back to you as soon as we are done with our meeting.

Thank You.

Valerie

________________________________

From: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Sent: Monday, April 20, 2020 9:44 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: RE: Pansophy Development Server

I (we) are ready to make this change whenever you want.  I've also got a new production server ready to go.  All that currently needs to be done (on either dev or production) is to shut down the server and add an alias for its existing name that points to the new server.  Once the alias is in place, you will likely have to flush your DNS cache to pick it up immediately, otherwise the change should happen whenever you OS normally flushes it cache.
Also - a couple other questions....

1)      David was wondering about an Oracle upgrade.  We upgraded our dev instances to Oracle 18c last week and he was wondering if you wanted to do the same with your dev instances.

2)      I noticed on pansophy that there are a number of what look like "duplicate" datasources listed.  We have an "11G" version of each datasource (live and tst) that point to the exact same database as the non-11G version.  Are those still necessary?

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Monday, April 20, 2020 9:39 AM
To: Bobby Lawrence <robertl at jlab.org<mailto:robertl at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: Pansophy Development Server

Good Morning Bobby,

Just checking in to see where we are at for starting to switch the development server?

We have a couple errors to still work through, but can do those with the development change. We would like to wait a couple days before pushing to production.

Thank you for your support! We really appreciate this.

Valerie

Pansophy Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200526/cca72590/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 64532 bytes
Desc: image001.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200526/cca72590/attachment-0001.png>