The below SQL script will give the product version.
Note: This is MSSQL and if you use other DBs please update the syntax wherever applicable.
DECLARE @ConfigurationVersion nvarchar(250)
DECLARE @PrimaryCulture nvarchar(250)
DECLARE @Product nvarchar(250)
DECLARE @SysAdminUnit_AllUsers uniqueidentifier ='A29A3BA5-4B0D-DE11-9A51-005056C00008'
BEGIN
SELECT @ConfigurationVersion = TextValue
FROM SysSettingsValue ssv
INNER JOIN SysSettings ss on ss.Id= ssv.SysSettingsId
WHERE ss.Code='ConfigurationVersion'
AND SysAdminUnitId = @SysAdminUnit_AllUsers
SELECT @PrimaryCulture = c.Name
FROM SysSettingsValue ssv
INNER JOIN SysSettings ss on ss.Id= ssv.SysSettingsId
INNER JOIN SysCulture c on c.Id= ssv.GuidValue
WHERE ss.Code='PrimaryCulture'
AND SysAdminUnitId = @SysAdminUnit_AllUsers
SELECT @Product =
CASE
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')
THEN 'bpmonline bank sales & bank customer journey & lending & marketing'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
THEN 'bpmonline bank sales & bank customer journey'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesEnterprise')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='ServiceEnterpriseSoftkey')
THEN 'bpmonline sales enterprise & marketing & service enterprise'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesEnterprise')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='CustomerCenterSoftkey')
THEN 'bpmonline sales enterprise & marketing & customer center'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesCommerce')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='CustomerCenterSoftkey')
THEN 'bpmonline sales commerce & marketing & customer center'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesTeam')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='CustomerCenterSoftkey')
THEN 'bpmonline sales team & marketing & customer center'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
AND EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesTeam')
THEN 'bpmonline sales team & marketing'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesTeam')
THEN 'bpmonline sales team'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesCommerce')
THEN 'bpmonline sales commerce'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name ='SalesEnterprise')
THEN 'bpmonline sales enterprise'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name Like 'MarketingSoftkey%')
THEN 'bpmonline marketing'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name ='CustomerCenterSoftkey')
THEN 'bpmonline customer center'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name ='ServiceEnterpriseSoftkey')
THEN 'bpmonline service enterprise'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Studio%')
THEN 'bpmonline studio'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')
THEN 'bpmonline lending'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
THEN 'bpmonline bank sales'
WHEN
EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
THEN 'bpmonline bank customer journey'
ELSE '?' END
SELECT @Product Product, @ConfigurationVersion Version, @PrimaryCulture Localization
END
Im using PostgreSQL - All MSSQL syntax checkers ive tried also says this syntax is wrong and I cant seem to get anything that will run from this, I cant find any conversions that work manually and ive tried using online converters too
None of the syntax works, could you please be more specific in what I can do to get it working
If you scrolled slightly further down the page you got that code from you'd have seen me commenting that it doesnt seem to work.
I have the need for connect Creatio to a sql server using active directory password authentication. We need a script task that basically is using the sql connector.
From my dev environment was working OK, but installing the package in cloud server I'm getting the error the adalsql.dll is missing.
I tried to installed importing the dll but I'm getting a error. Net asambly.
We don't have practical examples of such issue. As we said before, it couldn't be performed on our side, but checking your request I found some info which might be helpful for you. Please check the solution in this article below:
Thanks Bogdan, that's require a manipulation from the server side, with in cloud environments is not posible install the library. I'm trying to import the dll using creatio but I'm getting a error of. Net asambly, no Metter with version of dll.
The reply from anastassia requiere the dll that Im asking to install and she said is not posible. Still I dont understand what security reason can be installing a library from microsot that is allowing connect to datbase sql using AD connetions.
<h4>Se ha quitado el recurso que está buscando, se le ha cambiado el nombre o no está disponible en estos momentos.</h4>
</div>
<div class="content-container">
<fieldset><h4>Causas más probables:</h4>
<ul> <li>El directorio o archivo especificado no existe en el servidor web.</li> <li>La dirección URL contiene un error tipográfico.</li> <li>Un filtro o módulo personalizado, como URLScan, restringe el acceso al archivo.</li> </ul>
</fieldset>
</div>
<div class="content-container">
<fieldset><h4>Qué puede intentar:</h4>
<ul> <li>Cree el contenido en el servidor web.</li> <li>Revise la dirección URL del explorador.</li> <li>Cree una regla para hacer un seguimiento de las solicitudes con error para este código de estado HTTP y ver qué módulo llama a SetStatus. Para obtener más información sobre la creación de una regla de seguimiento para solicitudes con error, haga clic <a href="http://go.microsoft.com/fwlink/?LinkID=66439">aquí</a>. </li> </ul>
</fieldset>
</div>
<div class="content-container">
<fieldset><h4>Información detallada de error:</h4>
I have translated the error messages you have sent us and they indicate that the resource you are looking for is not available. This means that the database cannot be located. Please review your connectionstrings file.
I had trying with other version an give me this error
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Data.SqlClient.SqlException: Error de inicio de sesión del usuario 'IIS APPPOOL\bpmonline'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Error de inicio de sesión del usuario 'IIS APPPOOL\bpmonline'.]
You would need to check the file ConnectionStrings.config and check the authorization type. If windows authentication is used the parameter Integrated Security=SSPI should be specified and Identity=ApplicationPoolIdentity or domain user data should be in the the application pool (https://prnt.sc/mmoea5). If sql authentication instead of upper mentioned parameter user's login and password should be specified which can be used for authorization in SQL Management Studio:
User id=xxx; password=xxx; and LocalSystem in the application pool (https://prnt.sc/mmofx2).
Also please make sure all required windows components are installed.