Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (11)

Resolved .NET WEBSERVICE ERROR

  1. Issue
0
Votes
Undo
  1. ENRICO MENEGOTTO
    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?

Datawindow Reports Printing Issue on PB 2022
STD Framework 2022 R3
Responses (11)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 21 September 2021 15:59 PM UTC
  2. PowerBuilder
  3. # 1

Hi Enrico;

   Does your PB Packager look like this ...

Regards ... Chris

 

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

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
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Tuesday, 21 September 2021 16:13 PM UTC
  2. PowerBuilder
  3. # 3

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

Comment
Chris Pollach @Appeon
  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.
ENRICO MENEGOTTO
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Tuesday, 21 September 2021 17:14 PM UTC
  2. PowerBuilder
  3. # 4

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
Chris Pollach @Appeon
  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
ENRICO MENEGOTTO
  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
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Thursday, 23 September 2021 13:50 PM UTC
  2. PowerBuilder
  3. # 5

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
Load more comments
Chris Pollach @Appeon
  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
ENRICO MENEGOTTO
  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
ENRICO MENEGOTTO
  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
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Saturday, 25 September 2021 16:31 PM UTC
  2. PowerBuilder
  3. # 6

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
Armeen Mazda @Appeon
  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
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 25 September 2021 19:44 PM UTC
  2. PowerBuilder
  3. # 7

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.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Sunday, 26 September 2021 07:23 AM UTC
  2. PowerBuilder
  3. # 8

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
Load more comments
Marco Meoni
  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
ENRICO MENEGOTTO
  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
ENRICO MENEGOTTO
  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
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 27 September 2021 18:55 PM UTC
  2. PowerBuilder
  3. # 9

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
ENRICO MENEGOTTO
  1. ENRICO MENEGOTTO
  2. Tuesday, 28 September 2021 10:05 AM UTC
Yes, it is installed.
  1. Helpful
There are no comments made yet.
ENRICO MENEGOTTO
ENRICO MENEGOTTO Accepted Answer Pending Moderation
  1. Tuesday, 28 September 2021 10:04 AM UTC
  2. PowerBuilder
  3. # 10

Yes, it is installed.

Comment
There are no comments made yet.
iliyan iliev
iliyan iliev Accepted Answer Pending Moderation
  1. Wednesday, 21 December 2022 09:22 AM UTC
  2. PowerBuilder
  3. # 11

I have same problem ! How to resolve ?!

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 21 December 2022 18:16 PM UTC
Hi Iliyan;

After you updated your PB IDE & runtime, did you ...

1) Replace the WSClientNNN.pbd library in your PB App's library list with the new version from the latest PB installation?

2) Regenerate all your Web Service Data Window objects?

Regards ... Chris
  1. Helpful
iliyan iliev
  1. iliyan iliev
  2. Thursday, 22 December 2022 09:16 AM UTC
This is happened on remote server win 2016 server on which it is installed PB RT v. 19.2.0.2779.

Yes , Regenatred ws !

How to find is WSClientNNN.pbd and replace ?!
  1. Helpful
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.