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

Resolved Web Service Issue

  1. How-to
0
Votes
Undo
  1. Ron Calder
    Ron Calder
  2. PowerBuilder
  3. Thursday, 16 August 2018 15:05 PM UTC

Deployed a web service to my Windows Server 2012 R2 and when I test the service on the server the following error shows in the log file.  The server does have Power Server running on it using DotNet.

PB Trace output file: C:\inetpub\wwwroot\ldap_root\log\PBTrace.log

Main Exception:
Exception Time: 2018-08-16 10:25:56.7259285
Process ID: 4608
AppDomain: /LM/W3SVC/1/ROOT/LDAP-1-131789023859756287 Domain ID: 2
 Managed Thread ID: 27
Current Thread State: Background
Method: Int32 FormatDate(Sybase.PowerBuilder.PBDate ByRef, System.String, Boolean, System.String ByRef)
Exception Type: System.IO.FileNotFoundException
Exception Message: System.IO.FileNotFoundException: Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies. The specified module could not be found.
File name: 'Sybase.PowerBuilder.Interop.dll'
   at Sybase.PowerBuilder.PBInteropWrapper.FormatDate(PBDate& date, String format, Boolean isDataNull, String& ret)
   at Sybase.PowerBuilder.DataTypeFormater.Format(PBDate val, String format)


Exception Source: Sybase.PowerBuilder.Common
Exception StackTrace:    at Sybase.PowerBuilder.PBInteropWrapper.FormatDate(PBDate& date, String format, Boolean isDataNull, String& ret)
   at Sybase.PowerBuilder.DataTypeFormater.Format(PBDate val, String format)
Exception Call Stack:    at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at Sybase.PowerBuilder.PBLogger.logException(Exception ex, LogLevel logLevel, Boolean inner, Boolean logCallStack)
   at Sybase.PowerBuilder.PBLogger.logException(Exception ex, LogLevel logLevel, Boolean inner)
   at Sybase.PowerBuilder.PBLogger.LogExceptionOnly(Exception e, LogLevel logLevel)
   at Sybase.PowerBuilder.PBLogger.LogException(Exception e, LogLevel logLevel)
   at Sybase.PowerBuilder.PBLogger.LogException(Exception e)
   at Sybase.PowerBuilder.DataTypeFormater.Format(PBDate val, String format)
   at Sybase.PowerBuilder.PBSystemFunctions.String(PBAny v, PBString f)
   at c__nc_iis_master.of_write_file(PBString as_msg) in c:\Users\calder.rr\Downloads\PB2017\WebService\LDAP\pb2cstempout\LDAP\nc_iis_master.of_write_file(IS):line 80
   at c__nc_iis_master.of_write_log(PBString as_msg) in c:\Users\calder.rr\Downloads\PB2017\WebService\LDAP\pb2cstempout\LDAP\nc_iis_master.of_write_log(IS):line 26
   at c__nc_std_active_directory_controller.of_validate_credentials(PBString as_domain, PBString as_user_id, PBString as_password) in c:\Users\calder.rr\Downloads\PB2017\WebService\LDAP\pb2cstempout\LDAP\nc_std_active_directory_controller.of_validate_credentials(ISSS):line 44
   at c__nc_std_active_directory_interface.of_validate_credentials(PBString as_domain, PBString as_user_id, PBString as_password) in c:\Users\calder.rr\Downloads\PB2017\WebService\LDAP\pb2cstempout\LDAP\nc_std_active_directory_interface.of_validate_credentials(ISSS):line 41
   at cns_ap_std_ldap_webservice.PBWS__nc_std_active_directory_interface.of_validate_credentials(String as_domain, String as_user_id, String as_password) in c:\Users\calder.rr\Downloads\PB2017\WebService\LDAP\pb2cstempout\LDAP\ap_std_ldap_webservice.asmx.cs:line 54
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
   at System.Web.Services.Protocols.WebServiceHandler.Invoke()
   at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
   at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
   at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
   at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
   at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
   at System.Web.Hosting.ISAPIRuntime.System.Web.Hosting.IISAPIRuntime2.ProcessRequest(IntPtr ecb, Int32 iWRType)
-------------------------------------------------------------------------------

Any help would be appreciated.

Thank you, Ron

 

Unable to track Parent when open user object dynam...
Application Executable build using PowerBuilder 20...
Responses (6)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Friday, 17 August 2018 14:23 PM UTC
  2. PowerBuilder
  3. # 1

Hello Ron,

you are missing library dependency on your server, see the error complains about missing Sybase.PowerBuilder.Interop.dll and its dependencies.

You can fix it by installing PB and .Net runtimes, available running the package C:\Program Files (x86)\Appeon\PowerBuilder 17.0\DotNET\pbiu\BootStrapper\Packages\1-PBRuntime\pbruntime.msi.

Please note that MS C++ Redistributable Runtime is a prerequisites too.

Best,

.m

Comment
There are no comments made yet.
Ron Calder
Ron Calder Accepted Answer Pending Moderation
  1. Friday, 17 August 2018 18:13 PM UTC
  2. PowerBuilder
  3. # 2

Hi Marco,

I have installed the .net runtime and the PB2017R3 Runtimes along with the C++ Runtimes for 32 and 64 bit 2005 and 2008 and I still get the issue above.  I'm deploying the service from PB2017 R3.

Any other ideas or places I can look. 

Thank you, Ron

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 August 2018 19:24 PM UTC
  2. PowerBuilder
  3. # 3

Hi Ron / Marco;

  The PB.NET run-time installation is no longer included in PB2017R3 release and will probably be missing in the old folder that Marco mentions (C:\Program Files (x86)\Appeon\PowerBuilder 17.0\DotNET\pbiu\BootStrapper\Packages\1-PBRuntime) after the R3 installation (might still be there if doing an upgrade from R2).

 To install the PB.Net run-time in the future though on another IIS server, please use the following procedure ...

1) Add a PBPACK.ini file to the "C:\Program Files (x86)\Appeon\Shared\PowerBuilder" folder

2) In the INI file, set the following ...

[Packager]
DotNetComponents=1

3) Start PB Packager utility and then choose the PB.Net run-time (now visible) to create the PB.Net MSI for the IIS web service.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Monday, 20 August 2018 08:37 AM UTC
  2. PowerBuilder
  3. # 4

Hi Chris,

indeed upgrading from R2 doesn't remove pbruntime.msi.

Thanks for explaining the PBPACK.ini procedure, I think it is not intuitive though.

Best,

.m

Comment
There are no comments made yet.
Ron Calder
Ron Calder Accepted Answer Pending Moderation
  1. Tuesday, 28 August 2018 16:22 PM UTC
  2. PowerBuilder
  3. # 5

Still having an issue after all of the suggestions above.  What version of the C++ Redistributable runtime do I need?  I currently have versions 2005 and 2008 on the windows 2012 R2 server.

Thank you,

Ron

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 28 August 2018 16:36 PM UTC
Hi Ron;

FWIW: This is well defined in the PB help file. Just search for the keyword "deployment". Then read about the required C++ module DLLs.

HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Ron Calder
Ron Calder Accepted Answer Pending Moderation
  1. Tuesday, 28 August 2018 16:41 PM UTC
  2. PowerBuilder
  3. # 6

Thank you Marco and Chris for all of your help!  I finally got the service working by adding the C++ 2010 Redistributable Runtime files and then uninstalling and reinstalling the web service.  All is working fine now! :)

 

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.