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 6 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

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