1. Bijal Karia
  2. PowerBuilder
  3. Friday, 1 November 2019 21:10 PM UTC

We have number of applications in Power Builder 10.x and 12.x with SQL server as back end database using ODBC connections. These are built using Power builder Classic. I know PB 10.x/12.x is not supported anymore. I need an advice from experts on what are risks (e.g. security) of keeping them on this platform for another 4-5 years.

David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Monday, 4 November 2019 15:26 PM UTC
  2. PowerBuilder
  3. # 1

Hi

Without a crystal ball I cannot guess what problems you will face, but let me tell you a story about a client of ours....

Many years ago, they were happily running some PB6 apps on Windows 2000 having taken the same view of not upgrading them. They were in the middle of a £40M upgrade to their oracle database infrastructure and rolling out upgrades to windows too when they hit a problem with the way DWs were working in the proposed production environment.

The whole project was on hold when they called us for help. The costs to the project were enormous and they needed a solution right now! We upgraded them to the latest versions of PB and they have used our services ever since having realised the error of their way. The problem was caused by a windows update something that could have hit their production service at any time. Unless you freeze all the environment you cannot be sure the apps will work in the future.  Freezing the environment is a major security risk as you will not receive any MS updates and subsequent security patches.

So to answer your question, the apps can stop working at any time unless you run the risk of a major security breach and do not update your operating environment. Either way the cost can be significant to resolve in a hurry where as a planned migration to the latest version is much cheaper and easier to manage.

Hope that helps.

David

Comment
  1. Miguel Leeuwe
  2. Monday, 4 November 2019 17:07 PM UTC
Added to that .. Try "freezing" windows 10, 2012, 2016 updates. Not very wise/ easy to do and even if you succeed using tools, things likely will start to fail.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Saturday, 2 November 2019 19:33 PM UTC
  2. PowerBuilder
  3. # 2

Hi Bijal,

If I read between the lines it sounds like you want to just "maintain" your apps until you can "migrate" off of PowerBuilder so you want to avoid upgrading to newer versions.

You really should look at PowerBuilder 2019 R2.  By upgrading to PowerBuilder 2019 R2 you not only will be on supported version of PowerBuilder, but its new "PowerScript Migrator" feature automates migration of PowerScript to C# and .NET Core framework.  It can automate 80-90% conversion of PowerScript business logic and DataWindows data objects.

Check out this short video: https://youtu.be/Bcn6tt7H-Kk?t=69

Unless you don't plan to use Windows 10 or update your database version over the next 4-5 years,  your organization is really taking on unnecessarily high risk while significantly increasing your C# migration costs by not upgrading. 

Regards,
Armeen

Comment
  1. Miguel Leeuwe
  2. Sunday, 3 November 2019 15:33 PM UTC
Are these bugs fixed on 2019 R2?

- Black background on tabpages with images

- Sort() on computed columns / expressions

If not I would not recommend anyone to go to 2019 R2

just my 2cts.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Sunday, 3 November 2019 16:40 PM UTC
Can you give me the bug ID # when you reported them and I can check for you.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Monday, 4 November 2019 15:55 PM UTC
I just checked with product engineering, and based on the descriptions you provided both of these bugs are fixed in the upcoming 2019 R2 released. But it might be a good idea you provide the bug ID # so we can make sure no miscommunication about which bugs to be fixed.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Saturday, 2 November 2019 05:04 AM UTC
  2. PowerBuilder
  3. # 3

Windows 10 support. That's the argument I would use.

Comment
  1. Bijal Karia
  2. Saturday, 2 November 2019 07:12 AM UTC
We have these apps running on Windows 10 though.
  1. Helpful
  1. Miguel Leeuwe
  2. Saturday, 2 November 2019 07:14 AM UTC
Haha, yes good point, but can you for example ... create a dw with more than one retrieval argument? PB 12.6 can't on windows 10. You have to edit the source code manually if you have more than one argument.
  1. Helpful
There are no comments made yet.
Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 4 November 2019 21:51 PM UTC
  2. PowerBuilder
  3. # 4

Hi Bijal,

Deciding to keep running production on non-supported products for years on end is the same as accepting risk of any attacker benefiting from any security flaws that may be discovered in the future - and not doing anything about it. Is the impact acceptable if:

  • EX #1: Large data set is lost or corrupted because somebody exploited a security flaw that has been fixed in a later release?
  • EX #2: Large data set is suddenly in the hands of a major competitor because flaw was exploited?
  • EX #3: Dataset containing personal sensitive data is suddenly publicly available on web because of security flaw?
  • etc. ...

If somebody notifies you or the public of such security flaws is it then 100% acceptable that you  do nothing to protect the data and fix the leak?

There is no final yes or no - this is like playing heads or tails? No definitive answer but you know management, owners, and customers - what is their accepted risk level?

 

HTH /Michael

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 5 November 2019 14:33 PM UTC
  2. PowerBuilder
  3. # 5

This is a popular asset management solution in USA that has kept up with new versions of PowerBuilder: http://www.assetpoint.com/

You might want to consider switching to a different third-party software.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 1 November 2019 21:32 PM UTC
  2. PowerBuilder
  3. # 6

Hi Bijal;

  FWIW: Its like not changing the engine oil in your car for 4-5 years. You can do that, but most people would not advise it! Basically, "totally at your own risk".

Regards ... Chris

Comment
  1. Bijal Karia
  2. Friday, 1 November 2019 21:38 PM UTC
Thanks. I totally agree. I just wanted to know if there any know risks, e.g. security vulnerabilities, etc. I want to make my case stronger with some facts to migrate this to a supported platform. There is a always going to be push back from Business on ROI, Why fix when it is not broken, and other reasons.
  1. Helpful
  1. John Fauss
  2. Sunday, 3 November 2019 02:59 AM UTC
Really? Your management is willing to risk potentially devastating future issues over the cost of a yearly PB license? That's incredible. When (not IF) it breaks, what are their plans to resolve the issue(s)? Much smarter to proactively migrate now BEFORE a critical issue appears. Yes, there are manpower costs in addition to licensing costs. I get that. I just have never understood the ostrich school of management. Good luck making your case, Bijal.
  1. Helpful
There are no comments made yet.
Bijal Karia Accepted Answer Pending Moderation
  1. Tuesday, 5 November 2019 05:27 AM UTC
  2. PowerBuilder
  3. # 7

Thank you everyone. I agree it is a big risk in not migrating to supported platform. We have few applications that we can control and will be migrating them. However we have some vendor applications that are still on 12.x platform e.g. one of Asset management solution is from https://mainsaver.com/ and they have no plan to upgrade application to new platform. 

Comment
  1. David Peace (Powersoft)
  2. Friday, 8 November 2019 16:10 PM UTC
Seriously!

The migration from 12.x is pretty easy and should hold any major worries for them. I wonder if they would consider outsourcing the support for their application going forward. We would be very happy to do that for them. That way they can keep customers like you....
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.