Install License on Windows/Sql Server Cluster

PGNP Licensing/Sales Inquiries.

Install License on Windows/Sql Server Cluster

Postby rmerritt » Thu Jan 16, 2014 2:56 pm

I have just taken over the project, but the previous developers said that the PGNP license was failing to verify when installing on our Sql Server 2012 failover cluster. They believed that setup was reading the wrong computer name. I will be researching this but thought I would ask anyway, before I really have any details, to see if this is already a known problem. I saw in the product history that a bug was fixed related to licensing on a sql cluster in version 1.4.0.3132, and we just purchased version PGNP-Postgres-SE-1.4.0.3200. Any help will be much appreciated to give me a head start on this problem, as it is impacting production processing because ODBC is too slow. Thanks!
rmerritt
 
Posts: 6
Joined: Thu Jan 16, 2014 2:48 pm

Re: Install License on Windows/Sql Server Cluster

Postby Moderator » Mon Jan 20, 2014 10:05 am

The PGNP Provider supports cluster environment. We have previously fixed bugs in reading VSN, and in activation on active/inactive nodes.

However, the current build (3206) still has a minor issue related to the access to the license file from SQL Server account (in some clusters). The workaround is to grant permission for the user account to the license file folder C:/ProgramData/Intellisoft/PGNP.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Install License on Windows/Sql Server Cluster

Postby rmerritt » Mon Jan 20, 2014 2:29 pm

Thank you so much! I have reinstalled the driver on both nodes this morning and it accepted the key and I successfully run tests by moving data from our postgres data source into sql server instances on both (active/active) nodes. So I have had no problems with my test. Your answer may still save the day because I am an admin on everything, so perhaps the folder permission may come into play when the developers start testing it. I really appreciate your timely response!
rmerritt
 
Posts: 6
Joined: Thu Jan 16, 2014 2:48 pm

Re: Install License on Windows/Sql Server Cluster

Postby rmerritt » Mon Jan 20, 2014 3:05 pm

I deployed the package to Integration Services Catalogs in Sql Server, and ran into the error our developers have. I opened up the folder as you mentioned to read access, then to full control, and still get the same error message.

pgnp_test:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "PGNP" Hresult: 0x80004005 Description: "Invalid License".

This is affecting our production processing since the ODBC driver as you can imagine is extremely slow. Any ideas please?
rmerritt
 
Posts: 6
Joined: Thu Jan 16, 2014 2:48 pm

Re: Install License on Windows/Sql Server Cluster

Postby rmerritt » Mon Jan 20, 2014 3:24 pm

Executing through the 'Execute Package Utility' still works fine for me, executing through SSMS Integration Services Catalogs fails.
rmerritt
 
Posts: 6
Joined: Thu Jan 16, 2014 2:48 pm

Re: Install License on Windows/Sql Server Cluster

Postby Moderator » Mon Jan 20, 2014 9:29 pm

Yes, this issue is related to the permissions. Please find which user account is used for running the package. It could be Network Admin, or rather a dedicated SQL Server account.

There are many ways of determining the user account. One possibility is to use Process Explorer from sysinternals.com, and search for pgnp.dll/pgnp64.dll after the "invalid license" error occurred. The process that loaded the dll(s) is not having access to the C:\ProgramData\Intellisoft\PGNP folder.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Install License on Windows/Sql Server Cluster

Postby rmerritt » Tue Jan 21, 2014 7:35 am

Thanks, but not only did I grant full control to 'everyone' on both the 'Intellisoft' and 'PGNP' folders, but also to the account which runs the packages through SSIS. Still same error message. It seems I have covered the permissions issue.

Is this happening because running it through the 'Execute Package' utility runs on the hardware machine, whereas the SSMS submission runs on the clustered machine name? Are you checking two different names when running on a cluster? This is very serious for us and we will need to find another way to get this done if the PGNP driver will not work on a cluster. Thanks for the help.
rmerritt
 
Posts: 6
Joined: Thu Jan 16, 2014 2:48 pm

Re: Install License on Windows/Sql Server Cluster

Postby Moderator » Sun Feb 02, 2014 1:40 pm

We found that this issue was caused by the VSN case-sensitive comparison. The function that returns the VSN in some contexts returned upper case name, and in other context a mixed case. The issue is fixed in builds after 3206.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Install License on Windows/Sql Server Cluster

Postby rmerritt » Mon Feb 10, 2014 10:47 am

Thanks so much for working closely with me and resolving this issue quickly! Our dev and test environments aren't clustered and had other names so we didn't catch this until we had committed to put it into production. Our bad!

It seems we had two problems:
1) There was a File Server Virtual Server (cluster role) on the cluster with the same name as the Sql Server Virtual Server, except capitalized.
2) The Sql Server Virtual Server didn't get into the license file upon installation, so PGNP support added it manually and sent it back to me. We were getting an error saying the server name wasn't in the file, and the name which was missing was our clustered Virtual Server name.

# 1 required the program change from PGNP.
# 2 however, I might have a suggestion. I believe this may have happened because when I installed the PGNP driver, I was logged on to the hardware machine.
I believe I should have been logged onto the Cluster Virtual Server (role) which runs the clustered instance of Sql Server so that names goes into the license file.
This is the name which will be looked up when the jobs run under Sql Server, running on that Virtual Server.
I may be wrong as we still don't have a clustered test environment, but it seems possible that this was our problem with the license file error message.

Konstantin, thanks a million for the help! You got us up and running in less than two days, and we haven't had a problem again with PGNP!
rmerritt
 
Posts: 6
Joined: Thu Jan 16, 2014 2:48 pm

gyas uxyfhxpjegvj

Postby hxdrbunctsyw » Thu Sep 18, 2014 1:57 am

http://www.reconstyle.nl/libraries/Gcu/fEM http://www.brothertrouble.com/components/W4da0/ http://luxusshop.hu/libraries/nZf/m4N7 http://www.reconstyle.nl/libraries/c8G/72cL http://smokymountainportraits.com/plugins/Pzj/AXOHn http://terastud.ro/plugins/qqjk/BOS http://www.tfxconnect.com/stats/wxOJ/iCw http://www.brothertrouble.com/components/a79uz http://www.brothertrouble.com/components/jAElw/iIO http://www.jerseyslivinglegend.co.je/plugins/djaOI/ http://www.reconstyle.nl/libraries/lEGv7/tSXQ3 http://www.estetska.com/pdf/LYw7/Q7x http://www.estetska.com/pdf/DwQ/wFL http://www.estetska.com/pdf/EmQW/zR1H4 http://www.planetzog.co.za/components/H31Jz/Index.phpAgo http://terastud.ro/plugins/D3o8/mhi http://www.brothertrouble.com/components/RTRQ/q5tk http://luxusshop.hu/libraries/NnBMy/bD46 http://www.3alarmseries.com/documents/JIGB/5HOS http://www.estetska.com/pdf/EmQW/TWH3q http://www.tfxconnect.com/stats/yN5Pz/Q85H http://smokymountainportraits.com/plugins/9hPV/DOsD http://www.cse-mari.ru/backup/Ttk/0hRV http://www.estetska.com/pdf/kjJL/ http://www.3alarmseries.com/documents/QbrJ/iDu8 http://luxusshop.hu/libraries/emRe/Ldl http://www.brothertrouble.com/components/jAElw/AhmM9 http://www.planetzog.co.za/components/jFq/Index.phpFFC http://terastud.ro/plugins/QFp/oEV http://terastud.ro/plugins/2mg/ http://www.3alarmseries.com/documents/F52G/bxe http://terastud.ro/plugins/2mg http://luxusshop.hu/libraries/4Xb/hN6u9 http://smokymountainportraits.com/plugins/huJ/ http://www.3alarmseries.com/documents/pGUj/POmeJ http://www.planetzog.co.za/components/8Eh20 http://www.tfxconnect.com/stats/wxOJ/5Ix2 http://www.brothertrouble.com/components/kDq/ubVot http://www.jerseyslivinglegend.co.je/plugins/UsU1/37ixL http://www.reconstyle.nl/libraries/lEGv7/Lyp http://www.planetzog.co.za/components/oQP7v/Index.phpp46r http://www.jerseyslivinglegend.co.je/plugins/P06/Iq8X1 http://www.estetska.com/pdf/DwQ/KJYv http://www.cse-mari.ru/backup/Z8oeE/VrJ http://terastud.ro/plugins/7T9P7/ http://www.jerseyslivinglegend.co.je/plugins/Ve1/WWQki http://luxusshop.hu/libraries/emRe/sdFb9 http://www.3alarmseries.com/documents/xFPnX/08Eu http://www.3alarmseries.com/documents/JIGB/tnr http://www.estetska.com/pdf/DwQ/sfY0z
<a href="http://terastud.ro/plugins/QFp/">http://terastud.ro/plugins/QFp/</a> <a href="http://www.cse-mari.ru/backup/2yNJ/Ns4">http://www.cse-mari.ru/backup/2yNJ/Ns4</a> <a href="http://www.tfxconnect.com/stats/ZEWLR/Yeaf">http://www.tfxconnect.com/stats/ZEWLR/Yeaf</a> <a href="http://terastud.ro/plugins/2mg">http://terastud.ro/plugins/2mg</a> <a href="http://www.reconstyle.nl/libraries/Gcu">http://www.reconstyle.nl/libraries/Gcu</a> http://terastud.ro/plugins/7T9P7/mJ7
hxdrbunctsyw
 
Posts: 108
Joined: Wed Sep 17, 2014 7:42 am

Next

Return to Licensing

Who is online

Users browsing this forum: No registered users and 0 guests

cron