[Sync AD Auth Provider] Error when deploying to 10.0.502.0

Forge Component
(5)
Published on 25 Mar (4 weeks ago) by João Pêgas
5 votes
Published on 25 Mar (4 weeks ago) by João Pêgas

Followed the installation document, but installation fails when trying to deploy to the DEV environment:


UpgradingNo need to upgrade Application.
UploadingUploading Application.
Uploading eSpaceUploading eSpace SyncADAuthProvider.
Creating ApplicationCreating Application 'Sync_AD_Auth_Provider'.
VerifyingVerifying the Application consistency and permission settings.
Upgrading ModulesUpgrading and refreshing modules of 'Sync_AD_Auth_Provider'.
Upgrading ModuleUpgrading module 'SyncADAuthProvider'.
Deprecated 'Session.ExceptionMessage''Session.ExceptionMessage' is being deprecated. Use the 'ExceptionMessage' runtime property of the 'Exception Handler' node, available inside exception handler flows.
Unexpected LoginPlease consider using login actions from module 'ServiceCenter'.
Unused ElementInput Parameter 'ActiveSubMenuItemId' is never used in Web Block 'Menu'.
Unused ElementLocal Variable 'DomainAndUsername' is never used in Web Screen 'Test'.
Unused ElementLocal Variable 'GroupsTheUserBelongsTo' is never used in Server Action 'Platform_GetConfiguredRole'.
Invalid SQLOSLTM_ is a reserved prefix in GetLifetimeRole.
Invalid SQLOSLTM_ is a reserved prefix in GetLifetimeRole.
SQL InjectionPlease ensure your argument is correctly encoded to avoid SQL injection security flaws.
Impact AnalysisPerforming Impact Analysis of 'Sync_AD_Auth_Provider'.
Preparing ExtensionsPreparing extensions of 'Sync_AD_Auth_Provider'.
Preparing DatabasePreparing database of 'Sync_AD_Auth_Provider'.
Associating DependenciesAssociating dependencies of 'Sync_AD_Auth_Provider'.
Compiling ModulesCompiling modules of 'Sync_AD_Auth_Provider'.
Compiling DependenciesCompiling dependencies of 'Sync_AD_Auth_Provider'.
Gathering DependenciesGathering dependencies of 'Sync_AD_Auth_Provider'.
Deployment AbortedThe deployment was aborted due to errors. No applications or modules were deployed.

I am getting the same error.  Our plan is to use AD groups to map to Outsystems Roles and Teams.


This is the SQL Code that has the error:

SyntaxEditor Code Snippet

SELECT TOP 1
    Role.[Name]
FROM {User}
INNER JOIN OSLTM_INFRASTRUCTUREUSER UserRoles   ON UserRoles.[UserId] = {User}.[Id]
INNER JOIN OSLTM_INFRASTRUCTUREROLE Role        ON UserRoles.[RoleId] = Role.[Id]
WHERE
    {User}.[Id] = @UserId 
    AND {User}.[Is_Active] = 1
    AND Role.[Name] <> 'Everyone'

Hi,

Any news on this topic, just installed the plugin in OS11 and get the same errors on this advanced SQL:

As of OS11 LifeTime has ALWAYS its own (lt) environment.

Anyhow the Isolated Lifetime Env if will check this, but I don't understand why the advanced SQL uses as it looks like an internal OS View, that as of version 11 of OutSystems generates an error.

Can I replace the advanced SQL not with calles to the LifeTimeUserManagement api?

Regards,

Daniel

This tool is still not working.  Is there anyone available to look at this tool?

Hi Chip,

I agree with you, I really hope some support is given on this tool by its owner.

Regards,

Daniel


Solution

Hi guys,


All these issues should have been fixed with the latest version of this component.


Happy Coding,

João Pêgas.

Solution

The new version is working.  Thank you Joao.


-Chip