Focal Point Banner

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 for further assistance. Reference the community FAQ to learn more about the community.

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     We're upgrading from 5.3.4 to 7.6.5 any thoughts/tips appreciated!

Read-Only Read-Only Topic
We're upgrading from 5.3.4 to 7.6.5 any thoughts/tips appreciated!
Platinum Member
Hi all,

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?

Many thanks


WebFocus 765. iSeries v5r4
Posts: 175 | Location: England | Registered: April 11, 2006Report This Post
posted Hide Post
If you search on 762 there's a blog about an upgrade I did.

You will have to test all your code as backward compatibility is not guaranteed. As IBI are doing the upgrade I would suggest you put all your effort in to making sure you test everything.

Good luck. If you get stuck post us your probs and I'll try and help. On the upside 762 is a lot quicker and there's a lot of new features.


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
posted Hide Post
I agaree, test test test. You may be 'bit' by code tightening, as it shouldn't have worked in the past, but it did, now it doesn't due to code fixes by IB.

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
posted Hide Post
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.)

Good luck



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, 2007Report This Post
posted Hide Post
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.

Good luck!

Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
posted Hide Post
As Ginny pointed out the varchar was the biggest problem when my previous employer upgraded. It affected our SQL passthrus as well as our WebFocus code.

WF 7.6.8, AIX, AS400, NT
Oracle, DB2, JDE, Lotus Notes
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     We're upgrading from 5.3.4 to 7.6.5 any thoughts/tips appreciated!

Copyright © 1996-2020 Information Builders