Web Services and Windows Server 2012 R2

[Former Member]

Hi to all

I'm trying to install Web service into WIndows Server 2012 R2.

When i execute 'TestWebServices.html' page and i select my 'Web service Test URL' i have an error ( see attached ).

some idea ?

I install Web Services by MSI file because i'm not able to publish the directly by Powerbuilder 12.1.

ty

Gimmy

[Former Member · Accepted solution]

Hi all

Sorry if i'm too N00b.

Have i to instrall the .net or the classic Runtime into the server ?

ty

GMY

[Former Member · Accepted solution]

1) You need both the PB run-time and the .Net run-time for their corresponding version.

     PB 12.0 .... .Net 2.0

     PB 12.5 .... .Net 3.5

     PB 12.6 .... .Net 4.0

2) Appeon 2015 requires .Net 4.5 BTW.

[Former Member]

Ok.

Now with both run-time  it work

thanks all for help

😃

[Former Member]

Excellent news ... molto bene Gimmy!   

[Former Member]

Good morning

It begins to be frustrating.

I installed Windows Server 2012 R2 and Windows Server 2008 R2 and have the same problems.

I have hundreds of heterogeneous clients. It is not possible for every customer to find me in a different situation that makes me crazy.

I know for sure.

- What should I install?

- How should I set up?

There are guides, walkthroughs, tutorials, for installation?

ty for answer

Gimy

[Former Member]

Ok i try in another server : 2008.

Where i can find the compatibility between PB / WIndiows / .NET ?

G.

[Former Member]

I install into Appeon server.

i have same problem

i can't believe.

[Former Member]

Hi Gimmy;

1)  Did you install the Appeon 2015 version?

2)  Exactly what problem(s) are you referring to?

Regards ... Chris

[Former Member]

Hi Bruce

Yes appeon 2015 is installed on the machine.

i have always the same error.  ( see attached )

[Former Member]

Hmmm ... since Appeon does not use any PB Runtime components - it should install easily on W2012R2. You should then be able to run the example applications (ie: sales).

Are you trying to call a PB Web service from an Appeon application using a Web Service DataWindow? Is that the error you are referring to?

[Former Member]

Hi

i  try to consume WS in powerbuilder client application ( classic ).

In developer mode ( Windows 7 stand alone machine ) WS works well. The WS respond and the client program is right.

In production mode ( windows server 2012R2 or Window server 20008Rs machine ) the WS does not work. I'm not able to call the WS from browser.

[Former Member]

All our production Appeon Web & Mobile applications call PB Classic WS's with no issues. Both are installed on W2008R2 servers running under IIs. We can also call these WS's from PB Classic applications as well.

[Former Member]

Question:

If the IIS server is a windows server 2012 r2 with which version of PB must develop the WS?

Now I'm using pb21.1. it is compatible?

ty for answer

[Former Member]

Hi Gimmy;

  Technically, PB v12.6 is the 1st W2012 compatible version. However, I am not sure why any v12.x of PB would not work if the PB run time & .Net requirements are met.

Regards ... Chris

[Former Member]

ok i check the configuration. ( see attached conf.png), but the error don't change ( see attached errore.png).

In errore.png i see that respond .NET 2.0

There may be some compatibility problems? I can not install the .NET 3.5 Service Pack 1.

I do doubleclick but nothing happens.

In attache install.png there is the installation programs.

Gmy

p.s.

What mean the red oval in errore.png file ?

[Former Member]

Hi Gimmy;

1)  Make sure that 32bit processing is enabled.

2) Try changing the Identity to NetWork Service.

HTH

Regards ... Chris

[Former Member]

As I wrote try this :

-Open a dos command

-Type gacutil -i Your_Path\Sybase.PowerBuilder.core

same for Sybase.PowerBuilder.Common

Sybase.PowerBuilder.Web.Webservice

These assemblies should have been installed by your installer.

Otherwise, copy them manually

Hope thsi helps.

Abdallah.

[Former Member]

Hi Adballah.

you are right but i have not that DLL.

i have :

Sybase.PowerBuilder.DataWindow.Excel12.dll

Sybase.PowerBuilder.Db.dll

Sybase.PowerBuilder.DbExt.dll

Sybase.Powerbuilder.WebService.Runtime.dll

Sybase.PowerBuilder.WebService.RuntimeRemoteLoader.dll

why ?

[Former Member]

Hi Gimmy,

I have no idea why some DLLs are missed in the installer. I have no fresh Windows 2012

for testing.

What I have seen in your first picture is that IIS is looking for Sybase.PowerBuilder.core.

Install it in the GAC and then it should ask for another assembly and so on.

Then You know all the missed assemblies.

HTH.

Abdallah.

[Former Member]

Hi Gimmy;

  Did you install the PB runtime MSI successfully prior to installing your Web Service?

Regards ... Chris

[Former Member]

Yes.

I have this files in path.

( see attached )

Il volume nell'unit… C non ha etichetta.

Numero di serie del volume: 3809-02CA

Directory di C:\Ateikon\Res1

03/07/2015  14:37    <DIR>          .

03/07/2015  14:37    <DIR>          ..

23/02/2011  12:28             2.753 APACHE_LICENSE.TXT

18/03/2003  19:05            89.088 atl71.dll

11/05/2011  16:08           212.992 EasySoap120.dll

11/05/2011  16:08           131.072 ExPat120.dll

23/02/2011  12:28            26.934 Gnu--LGPL.txt

31/12/2014  14:22         1.024.512 libeay32.dll

28/01/2011  12:19           366.016 libjcc.dll

28/01/2011  12:19            62.912 libjutils.dll

23/02/2011  12:28             6.406 LICENSE

19/03/2003  12:14           499.712 msvcp71.dll

21/02/2003  20:42           348.160 msvcr71.dll

02/09/2010  15:31           245.760 pb2xls.dll

03/09/2004  18:07            69.811 pbabbest.dll

11/05/2011  17:41            13.760 pbacc120.dll

11/05/2011  17:41           345.536 pbado120.dll

11/05/2011  17:41           431.552 pbase120.dll

11/05/2011  17:41            52.160 pbcomrt120.dll

11/05/2011  17:41           271.808 pbdir120.dll

11/05/2011  16:10           581.632 PBDOM120.pbx

11/05/2011  17:41           128.448 pbdpl120.dll

11/05/2011  17:41         3.933.632 pbdwe120.dll

11/05/2011  17:41            34.752 pbDWExcel12Interop120.dll

11/05/2011  16:10           195.584 pbdwr120.pbd

11/05/2011  16:08             2.215 pbejbclient120.jar

11/05/2011  16:08           188.416 pbejbclient120.pbx

11/05/2011  17:41           210.368 pbi10120.dll

11/05/2011  17:41           222.656 pbin9120.dll

11/05/2011  17:41           165.312 pbjag120.dll

11/05/2011  17:41           513.472 pbjdb120.dll

11/05/2011  15:46            46.801 pbjdbc12120.jar

11/05/2011  17:41            95.680 pbjvm120.dll

11/05/2011  17:42           255.424 pbNetWSRuntime120.dll

11/05/2011  17:42           341.440 pbo10120.dll

11/05/2011  17:42           333.248 pbo90120.dll

11/05/2011  17:42           509.376 pbodb120.dll

27/01/2011  19:06            75.402 pbodb120.ini

11/05/2011  17:42           447.936 pbole120.dll

11/05/2011  17:42           349.632 pbora120.dll

11/05/2011  17:42           304.576 pbrtc120.dll

11/05/2011  17:42         2.921.920 pbshr120.dll

11/05/2011  17:42           271.808 pbsnc120.dll

11/05/2011  16:09           688.128 pbsoapclient120.pbx

20/05/2011  18:54           431.552 pbsyc120.dll

20/05/2011  18:54           427.456 pbsyj120.dll

11/05/2011  17:42            79.296 pbtra120.dll

11/05/2011  17:42            25.024 pbtrs120.dll

11/05/2011  17:42         4.843.456 pbvm120.dll

11/09/2003  19:51         4.547.072 pbvm80.dll

11/05/2011  16:09           897.024 pbwsclient120.pbx

11/05/2011  17:43           382.400 pbXerces120.dll

31/12/2014  14:22           216.064 ssleay32.dll

13/03/1997  23:10           120.669 STAMPA32.DLL

25/05/2011  14:42            47.552 Sybase.PowerBuilder.DataWindow.Excel12.dll

25/05/2011  14:40           353.728 Sybase.PowerBuilder.Db.dll

25/05/2011  14:40           128.448 Sybase.PowerBuilder.DbExt.dll

25/05/2011  14:43            42.432 Sybase.Powerbuilder.WebService.Runtime.dll

25/05/2011  14:43           155.584 Sybase.PowerBuilder.WebService.RuntimeRemoteLoader.dll

23/02/2011  12:28             1.114 Thai Open License.txt

31/12/2014  14:13           811.008 tp15.dll

27/01/2011  19:19            61.440 tp15_bmp.flt

27/01/2011  19:19           360.448 tp15_css.dll

27/01/2011  19:19           774.144 tp15_doc.dll

27/01/2011  19:19         1.093.632 tp15_dox.dll

27/01/2011  19:19            57.344 tp15_gif.flt

27/01/2011  19:19           643.072 tp15_htm.dll

27/01/2011  19:19           131.072 tp15_ic.dll

27/01/2011  19:19               530 tp15_ic.ini

27/01/2011  19:19           200.704 tp15_jpg.flt

27/01/2011  19:19           327.680 tp15_obj.dll

27/01/2011  19:19           655.360 tp15_pdf.dll

27/01/2011  19:19           253.952 tp15_png.flt

27/01/2011  19:19           577.536 tp15_rtf.dll

27/01/2011  19:19            73.728 tp15_tif.flt

27/01/2011  19:19           237.568 tp15_tls.dll

27/01/2011  19:19            53.248 tp15_wmf.flt

27/01/2011  19:19            65.536 tp15_wnd.dll

27/01/2011  19:19           344.064 tp4ole15.ocx

27/01/2011  19:03         2.359.296 xerces-c_2_6.dll

27/01/2011  19:03           278.528 xerces-depdom_2_6.dll

              79 File     39.077.563 byte

               2 Directory  30.964.621.312 byte disponibili

[Former Member]

Hi Gimmy,

I think you need  to register the assemblies Sybase.PowerBuilder.* in the GAC.

Regards.

Abdallah;

[Former Member]

Hi Adbakkah.

i'm noob,

can you explain me how to do it ?

[Former Member]

No ... You need to run the PB Runtime installer created by the PB Packager application. That will register the appropriate DLL's in the GAC. You can't just copy the files from the PB IDE's "shared" folder!!!!

[Former Member]

you need to ru gacutil -i <assemly name>

See How to: Install an Assembly into the Global Assembly Cache

install all the PB assemblies needed from :

C:\Program Files (x86)\Sybase\PowerBuilder 12.5\DotNET\bin

Abdallah

[Former Member]

Hi Gimmy;

  Look for the PB Packager application in the PB "shared" folder. It will create the proper PB runtime install MSI. Running the MSI will register everything for you automatically! 

Regards ... Chris

[Former Member]

How you can see in my 2nd message picture i did it ( immagine.png).

nothing change

[Former Member]

Hi Abdallah.

I'm in application server, i don't have powerbuilder in it, only Powerbuilder 12.1 Run time.

=(

[Former Member]

Thanks ... I missed that.  

Now make sure that the supporting .Net runtime is installed & configured OK with IIs.

Also in IIs, check that the PB application pool is also created properly.

Note: looks like your using PB 12.x which is based on .Net 2.0. Make sure that's the prime .Net runtime in the W2012's System Path.

[Former Member]

Hi Chris.

Ty for answers but:

<<Now make sure that the supporting .Net runtime is installed & configured OK with IIs.>>

I see in: control pannel / IIS / Connection pools= i have .NET 2.0 and .NET 4.5.

I think that i have to install 3.5. right ? ( see attaced )

i'll do it.

<<Also in IIs, check that the PB application pool is also created properly.>>

what does it mean ?

Statement too general. Remember i'm N00b.

This whole world (IIS and WS) are new things.

=(

<<Note: looks like your using PB 12.x which is based on .Net 2.0. Make sure that's the prime .Net runtime in the W2012's System Path.>>

I have no .Net in path

G.

[Former Member]

If you open the IIs control panel, you will see an entry in the System tree for Application Pools. In selecting that area you should see the PBAppPool. Make sure that it's set to the same properties as your development IIs version.  

[Former Member]

 <<Also in IIs, check that the PB application pool is also created properly.>>
what does it mean ?
Statement too general. Remember i'm N00b.

This means fire up inetmgr.exe on your web server and select the Application Pools node in the connections tree view. I'm guessing you are using the default PB app pool for your web services.

Click on the Advanced Settings on the right with the PB app pool selected and make sure these highlighted values are set correctly. Since you're running PB 12.1 I'm guessing you would select .Net Framework v2.0 instead of v4.0.

hth,

Mark