Tech Articles


SVN Enhancements in PowerBuilder 2017 R3


Support for using SVN as a source control system without going through a bridge product was added in 2017 R2 and covered in a previous blog post.  In this blog post we're going to look at the enhancements that were added to that feature in 2017 R3. 

 

Add to Source Control Changes

In R2, PowerBuilder forced you to create a remote repository that matched the workspace name.  You then provided PowerBuilder with base URL for the SVN server and PowerBuilder constructed the repository URL by appending the workspace name to the base URL for the server.   In R3 that limitation has been removed.  Now when you do the initial connect to source control you simply provide the full repository URL we copied earlier.

Connect to Workspace Changes

There was a similar limitation in R2 for the dialog for Connect To Workspace.  That has been addressed in R3 as well, as you can now supply the full URL for the remote repository.

Workspace Source Control Advanced Properties

In order for a couple of the new features to work we're going to need to go to the workspace properties, the Source Control tab and hit an "Advanced" button that's been added in this release.

Diff Viewer Configuration

There are two options on that dialog.  The first (Diff Viewer) allows you to select the program that will be used to perform diffs when you select that option in the PowerBuilder menu.  A large number of different tools are supported out of the box, and there's an Other option if your tool of choice isn't shown.  The default is TortoiseSVN.  SemanticMerge (which I recommended in the prior blog) is listed as well.  What I'll be using for this demo though is SourceGear's DiffMerge.

Show Log Configuration

The second option (Show Log) is where you specify the location of the TortoiseSVN executable so that it can be used to when you select the Show Log option in the PowerBuilder menu.  There's no option here, TortoiseSVN is the only choice.  Note that there are a lot of executables in the TortoiseSVN bin directory.  You won't want the ones with "Diff" in their names, although that seems logical.  The one you want is the TortoiseSvnProc.exe file.  Finally, for both these options (Diff and Show Log) the bitness of the application doesn't matter.  Since I'm using a 64 bit OS machine for the demo, I'm using the 64 bit version of TortoiseSvn, and PowerBuilder is calling it fine.

New Popup Menu Options

Now let's look at the popup menu in the PowerBuilder IDE.  If you click on a non-modifed object, you'll see the following:

We see several new options:

SVN Lock/Release Lock

The first two new items are "SVN Lock" and "SVN Release Lock".  Those do what you would expect, allow you to lock an object to discourage other developers from making changes to it while you're making your changes.  Note that Subversion supports "breaking" and "stealing" locks, so it's still possible that another developer could make changes to an object after you've locked it.

You would release the lock an object because you've decided not to commit your changes and want to release the object for other developers to work with. 

When you do a commit, you have the option to automatically release the lock after the commit or to retain the lock.  The default is to release the lock.

SVN Show Log

The next new option is Show Log.  It will show you the history of committed changes to the selected object and allow you to perform diffs between the versions.  The following is an example of what that looks like when PowerBuilder calls TortoiseSVN: 

Open Containing Folder

The new item after that on a non-modified object is "Open Containing Folder".  It's particularly useful if you want to perform some operation in TortoiseSVN that isn't supported by the PowerBuilder IDE (e.g. Repo Browser).  Selecting this option opens the folder in Windows Explorer where the actual source controlled object is at.  You can then right click on it and use the TortoiseSVN options in Windows Explorer to perform the operation.

SVN Diff

If you right click on a modified object, and additional menu option appears: SVN Diff.  This shows the differences between your modified object and the one in the repository. 

What it specifically looks like is highly dependent on what diff tool you specified in the workspace source control advanced properties.  This is what I got using DiffMerge:

Summary

The 2017 R3 changes in SVN support have address the problem and missing features in the R2 release, making the feature complete.

Comments (6)
Tuesday, Sep 25 2018

Hello everyone!

Has anyone had the problem below?
Failed to perform the specified operation. Please make sure you can connect to the server repository.

1
Wednesday, Oct 03 2018

I'm having that problem right now Thales. Just posted that issue to the forums myself.

0
Wednesday, Oct 03 2018

Hello Jeff!
Inside PowerBuilder we can't connect in our network. I created a PC for tests out of our domain e everything worked perfectly, but they don't have everything that we need here.
So we decided use a plugin to connect SVN Server, the PBSCC Proxy.
As we already know it, we back to use it.

0

Wednesday, Feb 27 2019

Hi Team,

After adding the workspace in repository using PB IDE I am getting the same issue when I try to do Git Push from PB IDE to push the project in remote repository.Getting the alert when i try to do Git Push - Failed to perform the specified operation. Please make sure you can connect to the server repository.

Is still in PB Appeon 2017 R3 we can not do Git Push from PB IDE ?

Please suggest and confirm as I am able to do all using TortoiseGit client but not using PB IDE.

Comment was last edited 5 years ago by Raghwendra jha
0
Thursday, Mar 07 2019

If using the proxy server, configure the proxy server IP address and port number in the PB.ini file (by default, the INI file is located in C:\Users\<username>\appdata\local\appeon\powerbuilder 17.0\ in Windows 7 or later). Copy the following section to the INI file and set the appropriate value for the proxy server:
[SourceControlProxy]
Url=192.0.0.88
Port=80
Username=
Password=
Timeout=10

0

Thursday, Dec 05 2019

"Failed to perform the specified operation."
Had the same problem. We copied "zlib.dll" from "C:\Program Files (x86)\Appeon\Shared\PowerBuilder" to "C:\Program Files (x86)\Appeon\PowerBuilder 19.0" and it started working.
Probably there where other "zlib.dll" in PATH, older, and it caused problems connecting to SVN.

2

Find Articles by Tag

64-bit SnapObjects iOS Windows OS Trial JSONParser REST Outlook Menu PowerServer Mobile Debugging CI/CD Script C# ActiveX JSON Web Service Proxy TFS Filter Database Painter Bug Validation NativePDF SDK Windows 10 Icons 32-bit DataWindow PDF RibbonBar Builder Database Object ODBC Elevate Conference Class Event Database Connection Encryption RibbonBar Import JSON Stored Procedure OAuth .NET Std Framework Transaction Migration Deployment Branch & Merge OrcaScript Testing Resize SQL Server Git Design .NET Assembly SVN Expression GhostScript Data Installation Error PBDOM Array DataType API IDE WinAPI MessageBox JSONGenerator Syntax TreeView Source Code PowerBuilder Compiler UI Azure PDFlib Window Android Encoding SqlModelMapper SnapDevelop OLE Model Database Table Data DataWindow JSON Application Source Control PowerServer Web Graph TortoiseGit PFC Configuration Icon SOAP Export JSON RichTextEdit Control BLOB Open Source Database Table SqlExecutor DevOps Messagging InfoMaker SQL File Platform WebBrowser PostgreSQL UI Modernization UI Themes RESTClient .NET DataStore Database Profile Database PowerScript (PS) PowerBuilder Automated Testing Performance Import Service Oracle Database Table Schema Interface Authorization DragDrop HTTPClient OAuth 2.0 Repository TLS/SSL External Functions Charts Web API Authentication Linux OS Mobile Debugger CrypterObject COM Export PostgreSQL ODBC driver Text Variable Event Handling CoderObject PowerBuilder (Appeon) DLL Excel XML Sort Debug Event Handler License Jenkins