As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
Next month we are moving our systems to a new AS400 and with that we are having to upgrade WebFocus. We are currently on 5.3.4 and will be going all the way to 7.6.5. Information Builders are booked to do the installation, so hopefully everything will be setup as best as possible.
We haven't done a WebFocus upgrade before and so I don't really know quite what to expect? My main concern is that we only have a very short window of time, 2 weeks, to test the new version and to fix any issues.
We are planning to run as many of our reports as possible on both systems and see if there are any differences - if they run at all!?
I have searched the forum and read quite a few posts on Upgrades, but would like to hear peoples thoughts and tips - especially on the coding side. Theoretically should all our code still work on the newer version? Does anyone know of any aspect that definitely won’t work and that we should look out for?
WebFocus 765. iSeries v5r4
Posts: 175 | Location: England | Registered: April 11, 2006
I'll echo John's statement about testing EVERYTHING. I wouldn't assume that similar reports/processes will run the same way. You MIGHT be able to assume that identical reports (except for criteria values, etc) will run the same.
Another thing to be careful of is your process for migrating metadata - will MFD and ACX files remain the same or will they be regenerated in the new environment? Compare any newly created MFDs to the old ones. (We had an issue where sytem-generated field names in parent-child segments CHANGED leaving us in a lurch.)
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
We went from 5.3.3 to 7.6.2 with testing for 7.6.0 and 7.6.1 in between. Most of the serious problems were corrected in 762, but Leah is correct in that there is quite a bit of code tightening.
One of the things that bit our developers was laziness when coding the AYM and AYMD subroutines. You MUST use legacy date formats as documented in the Functions manual. Using a smart date format won't cut it anymore.
The autoprompt screen, if you use it, has changed its look. It also has a number of incarnations so check into that.
Darin is correct about the metadata for relational tables. If you are not into variable alpha formats, i.e. A10V, then I would suggest that you code the following in your edasprof for each type of data source that you have: ENGINE SQLxxx SET VARCHAR OFF. It will save you many problems in the future.
We are getting ready to move to 765 ourselves but we did all the heavy testing for 762.