Hello
I m trying to call a sage300 webapi - for ARCustomers in swagger, without this i wont be able to deploy my custom app
log and screenshot attached
the following test has been conducted
- The user credentials and company ID you are using are right. yes
- The user security group has permission to connect to Sage web API. yes
- Application pool of the app has local system permissions, so that it can run with highest privileges. Yes
- Also run test permissions on web api, in IIS to verify complete access. Yes
- Make sure the application pool setting has 32 bit application set to true. Yes
---------------------------------------- ---------------------------------------- Timestamp: 3/28/2023 3:23:00 AM Message: Information-[Tenant:OnPremise] [Company:DFLDAT] [Module:GetTenantInfo] [User:WEBAPI] - Accessing credentials from Landlord DB. ProductUserId: dd78055b-dbd0-574a-9541-7e4600283828 TenantId: dd78055b-dbd0-574a-9541-7e4600283828 ScreenName: SessionId: Machine Name: KANGROO ---------------------------------------- ---------------------------------------- Timestamp: 3/28/2023 3:23:00 AM Message: Information-[Tenant:OnPremise] [Company:DFLDAT] [Module:CreateSession] [User:WEBAPI] - Ready to create a session. ProductUserId: dd78055b-dbd0-574a-9541-7e4600283828 TenantId: dd78055b-dbd0-574a-9541-7e4600283828 ScreenName: SessionId: Machine Name: KANGROO ---------------------------------------- ---------------------------------------- Timestamp: 3/28/2023 3:23:01 AM Message: Verbose-[Tenant:] [Company:] [Module:Watcher] [User:] - Time spent for Open View - AS0003 for Sage.CA.SBS.ERP.Sage300.AS.BusinessRepository,UserRepository`1 = 154ms Machine Name: KANGROO ---------------------------------------- ---------------------------------------- Timestamp: 3/28/2023 3:23:01 AM Message: Error-[Tenant:] [Company:] [Module:] [User:] - Sage 300 Web API encountered an error for Url 'http://192.168.0.142/Sage300WebApi/v1.0/-/DFLDAT/AR/ARCustomers'.: (Inner Exception) Exception Source: ACCPAC.Advantage.COMSVR.Interop Exception Type: System.Runtime.InteropServices.COMException Exception Message: Error HRESULT E_FAIL has been returned from a call to a COM component. ---- Stack Trace ---- AccpacCOMSVR.AccpacSvrDBLinkClass.ExOpenViewInstance(String ViewID, AccpacSvrView& ppView, Int32 OpenModes, Int32 OpenDirectives, Object OpenExtra, AccpacSvrProcessServerSetup ProcessServer) in ACCPAC.Advantage.COMSVR.Interop.dll ACCPAC.Advantage.Server.DBLink.OpenView(String viewID, ViewOpenModes openModes, Int32 prefetch, ViewOpenDirectives openDirectives, Object openExtra, ProcessServerSetup processServerSetup, ViewInfo& viewInfo) in ACCPAC.Advantage.Server.dll (Outer Exception) Exception Source: ACCPAC.Advantage Exception Type: ACCPAC.Advantage.DBLinkException Exception Message: ---- Stack Trace ---- ACCPAC.Advantage.DBLink.OpenView(String viewID, ViewOpenModes openModes, Int32 prefetch, ViewOpenDirectives openDirectives, Object openExtra, ProcessServerSetup processServerSetup) in ACCPAC.Advantage.dll Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.BusinessEntitySession.OpenView(String name, IBusinessEntitySession session, Boolean maintainState, Object extra, String consumingRepositoryName, Context context, Boolean isReadOnly) in Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.dll,file: BusinessEntitySession.cs,line: 0755 Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.BusinessEntitySession.OpenView(String name, IBusinessEntitySession session, String consumingRepositoryName, Context context, Boolean isReadonly) in Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.dll,file: BusinessEntitySession.cs,line: 0673 Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.Base.BaseRepository.OpenEntity(String name) in Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.dll,file: BaseRepository.cs,line: 0277 Sage.CA.SBS.ERP.Sage300.AS.BusinessRepository.UserRepository`1.CreateBusinessEntities() in Sage.CA.SBS.ERP.Sage300.AS.BusinessRepository.dll,file: UserRepository.cs,line: 0084 Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.Base.FlatRepository`1.GetById(TKey key) in Sage.CA.SBS.ERP.Sage300.Common.BusinessRepository.dll,file: FlatRepository.cs,line: 0266 Sage.CA.SBS.ERP.Sage300.AS.BusinessRepository.UserRepository`1.GetUserLogin(TKey key) in Sage.CA.SBS.ERP.Sage300.AS.BusinessRepository.dll,file: UserRepository.cs,line: 0262 Sage.CA.SBS.ERP.Sage300.AS.Services.UserEntityService`1.GetUserLogin(TKey key) in Sage.CA.SBS.ERP.Sage300.AS.Services.dll,file: UserEntityService.cs,line: 0049 Sage.CA.SBS.ERP.Sage300.Common.Web.Security.UserTenantResolverOnPremise.ResolveUserTenant(IUnityContainer container, Context context, String company, String userId, SecureString passwordSStr, List`1 companies) in Sage.CA.SBS.ERP.Sage300.Common.Web.dll,file: UserTenantResolverOnPremise.cs,line: 0122 Sage.CA.SBS.ERP.Sage300.Common.WebApi.Controllers.ResourceController.SetContext() in Sage.CA.SBS.ERP.Sage300.Common.WebApi.dll,file: ResourceController.cs,line: 0055 Sage.CA.SBS.ERP.Sage300.Common.WebApi.Controllers.ViewResourceController`1.InitializeRepository(Boolean forWriteAccess) in Sage.CA.SBS.ERP.Sage300.Common.WebApi.dll,file: ViewResourceController.cs,line: 0247 Sage.CA.SBS.ERP.Sage300.Common.WebApi.Controllers.ViewResourceController`1.Get(ODataQueryOptions queryOptions) in Sage.CA.SBS.ERP.Sage300.Common.WebApi.dll,file: ViewResourceController.cs,line: 0137 (Closure , Object , Object[] ) in <In Memory Module> System.Web.Http.Controllers.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters) in System.Web.Http.dll System.Web.Http.Controllers.ActionExecutor.Execute(Object instance, Object[] arguments) in System.Web.Http.dll System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) in System.Web.Http.dll System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in mscorlib.dll System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in mscorlib.dll System.Web.Http.Controllers.<InvokeActionAsyncCore>d__0.MoveNext() in System.Web.Http.dll System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in mscorlib.dll System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in mscorlib.dll System.Web.Http.Filters.<CallOnActionExecutedAsync>d__5.MoveNext() in System.Web.Http.dll System.Web.Http.Filters.<CallOnActionExecutedAsync>d__5.MoveNext() in System.Web.Http.dll System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in mscorlib.dll System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in mscorlib.dll System.Web.Http.Filters.<ExecuteActionFilterAsyncCore>d__0.MoveNext() in System.Web.Http.dll System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in mscorlib.dll System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in mscorlib.dll System.Web.Http.Controllers.<ExecuteAsync>d__2.MoveNext() in System.Web.Http.dll System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in mscorlib.dll System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in mscorlib.dll System.Web.Http.Filters.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext() in System.Web.Http.dll System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in mscorlib.dll System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in mscorlib.dll System.Web.Http.Controllers.<ExecuteAsync>d__0.MoveNext() in System.Web.Http.dll Machine Name: KANGROO ----------------------------------------
using the Cred for user WEBAPI
error is:
{
"error": {
"code": "DBLinkError",
"message": {
"lang": "en-US",
"value": "Unable to access the requested application due to an installation or configuration problem."
}
}
}