Notifications
Clear all
Topic starter
We've installed 9.8.5 in our Test environment. The advantage is that the CVS looks MUCH better.
Be very AWARE that there is a "gotcha" with the install if you are using the jobs.txt file for a fresh install of EMR. We had a few clients that had errors updating and we had to go this route (fresh install).
SP5 installs like a new install and removes all previous entries in the jobs.txt (ie. you will end up with 2 lines in the jobs.txt. One to copy over tnsnames.ora and the other to perform the update to SP5). For a fresh install of EMR, it *supposedly* knows what to load and does a half-ass job of it. We have a lot of "MEL vomit" with this upgrade and I'm 95% sure it has to do with the CCC's not being pushed over. No Crystal Reports are pushed. So if you do go to SP5 and use jobs.txt, make sure you have a backup where you can paste in the files that need to be pushed to the client. I got errors when I did this so am still looking to resolve but waiting to hear if we are going to back out of SP5. I do believe this issue can be resolved. There is an SPR with GE for fixing this (SPR #CISDB00060852).
We also had an issue with the CVS with SP5. It wouldn't print and only provided errors. If you have this problem, you will need to apply the following SQL command:
insert into ml.xsldata (xslid, description, data, CREATEDATE) select xslid, description, data, createdate from tut.xsldata where xslid=2;
I've heard different rumors about following updates. SP6 is supposed to fix crashes and be MU-centric. SP7 will only be MU-centric. 9.9 won't be out for a while, ... Who knows. I don't think GE even knows at this point.
Jill
Posted : September 5, 2014 11:01 am
JillSnider said:
We've installed 9.8.5 in our Test environment. The advantage is that the CVS looks MUCH better.
Be very AWARE that there is a "gotcha" with the install if you are using the jobs.txt file for a fresh install of EMR. We had a few clients that had errors updating and we had to go this route (fresh install).
SP5 installs like a new install and removes all previous entries in the jobs.txt (ie. you will end up with 2 lines in the jobs.txt. One to copy over tnsnames.ora and the other to perform the update to SP5). For a fresh install of EMR, it *supposedly* knows what to load and does a half-ass job of it. We have a lot of "MEL vomit" with this upgrade and I'm 95% sure it has to do with the CCC's not being pushed over. No Crystal Reports are pushed. So if you do go to SP5 and use jobs.txt, make sure you have a backup where you can paste in the files that need to be pushed to the client. I got errors when I did this so am still looking to resolve but waiting to hear if we are going to back out of SP5. I do believe this issue can be resolved. There is an SPR with GE for fixing this (SPR #CISDB00060852).
We also had an issue with the CVS with SP5. It wouldn't print and only provided errors. If you have this problem, you will need to apply the following SQL command:
insert into ml.xsldata (xslid, description, data, CREATEDATE) select xslid, description, data, createdate from tut.xsldata where xslid=2;
I've heard different rumors about following updates. SP6 is supposed to fix crashes and be MU-centric. SP7 will only be MU-centric. 9.9 won't be out for a while, … Who knows. I don't think GE even knows at this point.
Jill
We installed SP5 and find that our CVS prints a blank page except for the page number at top and date at bottom. Is this what you saw as well? We went from SP3 to SP5.
Posted : September 30, 2014 12:47 am
Topic starter
Yes! You should be able to run the command I provided.
Posted : September 30, 2014 12:54 am
Thanks Jill.. our folks here are apprehensive about running it as we're not sure what it does.
Posted : September 30, 2014 3:07 am
Topic starter
If you like, call GE support and you can discuss with them. That is where I got it from.
Posted : September 30, 2014 5:10 am
Thanks Jill... called them and they don't know anything about it, but I'll chat with the next person they are putting me in touch with.
Posted : September 30, 2014 5:13 am
Topic starter
I worked with John Christian and Hillary Hart - they should be very familiar. After the SQL command, they also had me reinstall JBoss and Service Layer. This fixed the CVS issue.
BTW, Eric Baldridge had updated us to SP5 and made a change in the JBoss setup to allow for better performance at the time. He stated you should never reinstall JBoss and that this is what support often suggests. Well reinstalling did fix our CVS problem. However, it removed his edit in the wrapper.conf file so this had to be re-entered for performance concerns.
Personally, if any customizations are done during an upgrade/install, I want to know about them at the time. 🙂
Posted : September 30, 2014 6:23 am
