1. ENRICO MENEGOTTO
  2. PowerBuilder
  3. Tuesday, 21 September 2021 15:39 PM UTC

Hi all,

From a long time I have a webservice that always worked fine.

After I've installed the last PB 19.2.0.2703, if I create and install the msi file, when I call the webservice it return me SOAP SERVICE ERROR.

I've found that the error is about "Sybase.PowerBuilder.Interop.dll"; it seems that the system can't find this module or it's dependencies. 

Obviously before to run the webservice I've done the follwing steps:

1) installed the "PBNETRT 19.2.0.2703" using the packager utility.

2) installed the "PBCLTRT 19.2.0.2703" using the packager utility.

3) Copied the necessary DLL in c:\window\syswow64

4) I've set the environment variable PATH as "C:\Program Files (x86)\Appeon\PowerBuilder Runtime Packager\Runtime 19.2.0.2703"

The system is Windows 2019 X64

The feature IIS is installed with .NET framework 4.7

When I call the webservice the return is always "SOAP Service Error"

Can anyone help me? What can I try?

ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Tuesday, 28 September 2021 10:04 AM UTC
  2. PowerBuilder
  3. # 1

Yes, it is installed.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 27 September 2021 18:55 PM UTC
  2. PowerBuilder
  3. # 2

Hi Enrico;

  Just another random thought .... Did you install the "Microsoft Visual C++ 2010 x86 Redistributable" software on your IIS server environment?

Regards .... Chris

Comment
  1. ENRICO MENEGOTTO
  2. Tuesday, 28 September 2021 10:05 AM UTC
Yes, it is installed.
  1. Helpful
There are no comments made yet.
Marco Meoni Accepted Answer Pending Moderation
  1. Sunday, 26 September 2021 07:23 AM UTC
  2. PowerBuilder
  3. # 3

Hi Enrico,

did you check your old post

https://community.appeon.com/index.php/qna/q-a/net-soap-webservice

?

All you did, and all Chris suggested, is crystal correct, that has been the traditional setup for years. However there was a bug in some build 2019.2.0. I had some error. Then I received ad-hoc Sybase.PowerBuilder.Interop.dll from Appeon, which fixed the very error you have. I suggest you open a support ticket at

https://www.appeon.com/standardsupport/search

and mention bug fix #5979.

Best,

.m

 

 

Comment
  1. Marco Meoni
  2. Monday, 27 September 2021 07:18 AM UTC
Hi Enrico,

bug #59t9 is in the PDF attached to the old ticket.

Best,

.m
  1. Helpful
  1. ENRICO MENEGOTTO
  2. Monday, 27 September 2021 07:33 AM UTC
Hi Marco,

i've done what is witten into bug #59t9. It didn't works.

The mentioned problem you had is relative the "Sybase.PowerBuilder.DataWindow.Interop.dll", but my problem is relative the "Sybase.PowerBuilder.Interop.dll".
  1. Helpful
  1. ENRICO MENEGOTTO
  2. Monday, 27 September 2021 07:54 AM UTC
Hi Marco,

I also have copied all DLL present in a working server in "C:\Windows\Microsoft.NET\assembly\GAC_32" wich starts with Sybase*.*; copied in the production server, restarted the server, but it didn't work. I can't figure out what's wrong. I also have done a new configuration on a new server ... same results, it didn't works.

Ho copiato tutte le DLL presenti in un server funzionante nel percordo "C:\Windows\Microsoft.NET\assembly\GAC_32" wich starts with Sybase*.*; copiate nel server di produzione, riavviato, ma niente, non funziona! Non riesco a capire cosa non va. Ho anche rifatto tutte le configurazioni in un server pulito, ma ancora non va.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 25 September 2021 19:44 PM UTC
  2. PowerBuilder
  3. # 4

Hi Enrico;

  I know that some PB developers with this challenge went as far as installing the IDE on the production IIS server. Then the WS's started working that way after that.  Food for thought.

Regards ... Chris

Comment
There are no comments made yet.
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Saturday, 25 September 2021 16:31 PM UTC
  2. PowerBuilder
  3. # 5

Hi Crhis,

thank you.

I controlled and reinstalled everything step by step. But the problem persists.

How can I get help to solve this problem? It is true that .NET webservice are not supported, but I think that ther is someone who can help me to solve this problem. What you think about? 

Comment
  1. Armeen Mazda @Appeon
  2. Saturday, 25 September 2021 17:51 PM UTC
Buy a premium support ticket, and our team will need to remotely access the problematic machine: https://www.appeon.com/premium-support.html
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 September 2021 18:09 PM UTC
  2. PowerBuilder
  3. # 6

Hi Enrico;

  FYI: Here is what I have in my GAC "Sybase.XXXX" wise ...

Regards ... Chris

Comment
There are no comments made yet.
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Thursday, 23 September 2021 13:50 PM UTC
  2. PowerBuilder
  3. # 7

Hi Chris,

as you see in the attached image, I installed the 2728 version, the deployed in the production server, setted properly the new path ad restarded.

Nothing change!

Other ideas?

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 23 September 2021 15:49 PM UTC
After that, did you: A) Add the PB runtime folder to the O/S System Path so that IIS can locate the PBVM support DLLs and B) Did you create / modify the associated IIS Application pool(s) to allow 32bit processing?
  1. Helpful
  1. ENRICO MENEGOTTO
  2. Thursday, 23 September 2021 15:58 PM UTC
Yes Chris

A) I had already done this because it is part of the installation procedure

B) Yes, was done
  1. Helpful
  1. ENRICO MENEGOTTO
  2. Thursday, 23 September 2021 16:05 PM UTC
I also have:

1) installed the vc++ redistributable 2010

2) copied the necessary DDL'S (msvcr100.dll , msvcp100.dll, atl100.dll ) to C:\WINDOWS\SYSWOW64

Restated the server.
  1. Helpful
There are no comments made yet.
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Tuesday, 21 September 2021 17:14 PM UTC
  2. PowerBuilder
  3. # 8

The log of the web application calling the webservice return this error

Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies. The specified module could not be found. ---> Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies. The specified module could not be found.

I can confirm that this file "Sybase.PowerBuilder.Interop.dll"  exists in the folder C:\Windows\Microsoft.NET\assembly\GAC_32\Sybase.PowerBuilder.Interop\v4.0_19.0.0.0__6e9b5029db92175f

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 23 September 2021 16:12 PM UTC
The files needed for the WS runtime would be:

Sybase.PowerBuilder.Common.dll

Sysbase.PowerBuilder.Core.dll

Sybase.PowerBuilder.DataWindow.Interop.dll

Sybase.PowerBuilder.DataWindow.Win.dll

Sybase.PowerBuilder.Editmask.Interop.dll

Sybase.PowerBuilder.EditMask.Win.dll

Sybase.PowerBuilder.Interop.dll

Sybase.PowerBuilder.Win.dll

Sybase.PowerBuilder.WinWebDataWindowCommon.dll
  1. Helpful
  1. ENRICO MENEGOTTO
  2. Thursday, 23 September 2021 16:44 PM UTC
Thank you Chris.

this files must be present in

C:\Program Files (x86)\Appeon\PowerBuilder Runtime Packager\Runtime 19.2.0.2728

OR

C:\Windows\Microsoft.NET\assembly\GAC_32\...

  1. Helpful
There are no comments made yet.
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Tuesday, 21 September 2021 16:13 PM UTC
  2. PowerBuilder
  3. # 9

Yes Exactly! At the moment I have only the 2703 version.

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 21 September 2021 18:44 PM UTC
If I recall correctly, there was a fix included in build 2728 that addressed the missing DLL's required to support the older SOAP (.NET 2.0) web services.
  1. Helpful 1
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 21 September 2021 15:59 PM UTC
  2. PowerBuilder
  3. # 10

Hi Enrico;

   Does your PB Packager look like this ...

Regards ... Chris

 

Comment
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.