https://drive.google.com/file/d/14bXG1fyxZCbehwAVJIHvBv6TdTwKPz0s/view

 

I get this error every time I try to import an application, whats going wrong?

Like 0

Like

7 comments
Best reply

Hello,



Please use the following script:

 

CREATE OR REPLACE FUNCTION "GetInstallPkgInfo"()

    RETURNS TABLE (

        "Product"              VARCHAR(250),

        "ConfigurationVersion" VARCHAR(250),

        "PrimaryCulture"       VARCHAR(250)

    )

AS $$

DECLARE

    Product VARCHAR(250);

    AppName VARCHAR(250) = 'creatio';

    UseAppName BOOL = FALSE;

    ConfigurationVersion VARCHAR(250);

    PrimaryCulture VARCHAR(250);

    SysAdminUnit_AllUsers UUID = 'A29A3BA5-4B0D-DE11-9A51-005056C00008';

    HasBankSales BOOL;

    HasBankCustomerJourney BOOL;

    HasLending BOOL;

    HasMarketing BOOL;

    HasSalesEnterprise BOOL;

    HasSalesCommerce BOOL;

    HasSalesTeam BOOL;

    HasServiceEnterprise BOOL;

    HasCustomerCenter BOOL;

    HasStudio BOOL;

    HasAlmPortal BOOL;

    HasAlmProxy BOOL;

BEGIN

    SELECT

        ssv."TextValue"

    INTO ConfigurationVersion

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    WHERE ss."Code" = 'ConfigurationVersion'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    SELECT

         c."Name"

    INTO PrimaryCulture

    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 ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    --region check root packages

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankSalesSoftkey%') THEN

        HasBankSales = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankOnboardingSoftkey%') THEN

        HasBankCustomerJourney = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Lending%') THEN

        HasLending = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'MarketingSoftkey%') THEN

        HasMarketing = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesEnterprise') THEN

        HasSalesEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesCommerce') THEN

        HasSalesCommerce = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesTeam') THEN

        HasSalesTeam = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'ServiceEnterpriseSoftkey') THEN

        HasServiceEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'CustomerCenterSoftkey') THEN

        HasCustomerCenter = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Studio%') THEN

        HasStudio = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'Environments') THEN

        HasAlmPortal = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'TeamCityIntegration') THEN

        HasAlmProxy = TRUE;

    END IF;

    --endregion

    SELECT

        CASE

            WHEN HasBankSales AND HasBankCustomerJourney AND HasLending AND HasMarketing

                THEN 'bank sales & bank customer journey & lending & marketing'

            WHEN HasBankSales AND HasBankCustomerJourney

                THEN 'bank sales & bank customer journey'

            WHEN HasSalesEnterprise AND HasMarketing AND HasCustomerCenter

                THEN 'sales enterprise & marketing & customer center'

            WHEN HasSalesEnterprise AND HasMarketing AND HasServiceEnterprise

                THEN 'sales enterprise & marketing & service enterprise'

            WHEN HasSalesCommerce AND HasMarketing AND HasCustomerCenter

                THEN 'sales commerce & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing AND HasCustomerCenter

                THEN 'sales team & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing

                THEN 'sales team & marketing'

            WHEN HasSalesEnterprise

                THEN 'sales enterprise'

            WHEN HasSalesCommerce

                THEN 'sales commerce'

            WHEN HasSalesTeam

                THEN 'sales team'

            WHEN HasMarketing

                THEN 'marketing'

            WHEN HasServiceEnterprise

                THEN 'service enterprise'

            WHEN HasCustomerCenter

                THEN 'customer center'

            WHEN HasAlmPortal

                THEN 'alm studio'

            WHEN HasAlmProxy

                THEN 'alm studio proxy'

            WHEN HasStudio

                THEN 'studio'

            WHEN HasLending

                THEN 'lending'

            WHEN HasBankSales

                THEN 'bank sales'

            WHEN HasBankCustomerJourney

                THEN 'bank customer journey'

            ELSE '?'

        END

    INTO Product;

    IF (UseAppName = TRUE) THEN

        Product = CONCAT(AppName, ' ', Product);

    END IF;

    RETURN QUERY (

        SELECT

            Product              AS "Product",

            ConfigurationVersion AS "Version",

            PrimaryCulture       AS "Culture"

        );

END;

$$ LANGUAGE plpgsql;

SELECT

    "Product",

    "ConfigurationVersion",

    "PrimaryCulture"

FROM "GetInstallPkgInfo"()

Im running the following on the machine im exporting from: Version 8.0.3.2908 Sales enterprise

importing into: Version 8.0.6.3429

 

Does the version need to be the exact same?

Hello Oliver,



What is the bundle of the target website, Sales enterprise as well? 

 



 

Bogdan,

Yeah, Im not sure 100% if the one im exporting from is, but im pretty sure its Sales Enterprise too

 

Is there any way to confirm what version youre running?

Oliver Crowe,

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

 

 

BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

 

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.

Hello,



Please use the following script:

 

CREATE OR REPLACE FUNCTION "GetInstallPkgInfo"()

    RETURNS TABLE (

        "Product"              VARCHAR(250),

        "ConfigurationVersion" VARCHAR(250),

        "PrimaryCulture"       VARCHAR(250)

    )

AS $$

DECLARE

    Product VARCHAR(250);

    AppName VARCHAR(250) = 'creatio';

    UseAppName BOOL = FALSE;

    ConfigurationVersion VARCHAR(250);

    PrimaryCulture VARCHAR(250);

    SysAdminUnit_AllUsers UUID = 'A29A3BA5-4B0D-DE11-9A51-005056C00008';

    HasBankSales BOOL;

    HasBankCustomerJourney BOOL;

    HasLending BOOL;

    HasMarketing BOOL;

    HasSalesEnterprise BOOL;

    HasSalesCommerce BOOL;

    HasSalesTeam BOOL;

    HasServiceEnterprise BOOL;

    HasCustomerCenter BOOL;

    HasStudio BOOL;

    HasAlmPortal BOOL;

    HasAlmProxy BOOL;

BEGIN

    SELECT

        ssv."TextValue"

    INTO ConfigurationVersion

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    WHERE ss."Code" = 'ConfigurationVersion'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    SELECT

         c."Name"

    INTO PrimaryCulture

    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 ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    --region check root packages

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankSalesSoftkey%') THEN

        HasBankSales = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankOnboardingSoftkey%') THEN

        HasBankCustomerJourney = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Lending%') THEN

        HasLending = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'MarketingSoftkey%') THEN

        HasMarketing = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesEnterprise') THEN

        HasSalesEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesCommerce') THEN

        HasSalesCommerce = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesTeam') THEN

        HasSalesTeam = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'ServiceEnterpriseSoftkey') THEN

        HasServiceEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'CustomerCenterSoftkey') THEN

        HasCustomerCenter = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Studio%') THEN

        HasStudio = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'Environments') THEN

        HasAlmPortal = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'TeamCityIntegration') THEN

        HasAlmProxy = TRUE;

    END IF;

    --endregion

    SELECT

        CASE

            WHEN HasBankSales AND HasBankCustomerJourney AND HasLending AND HasMarketing

                THEN 'bank sales & bank customer journey & lending & marketing'

            WHEN HasBankSales AND HasBankCustomerJourney

                THEN 'bank sales & bank customer journey'

            WHEN HasSalesEnterprise AND HasMarketing AND HasCustomerCenter

                THEN 'sales enterprise & marketing & customer center'

            WHEN HasSalesEnterprise AND HasMarketing AND HasServiceEnterprise

                THEN 'sales enterprise & marketing & service enterprise'

            WHEN HasSalesCommerce AND HasMarketing AND HasCustomerCenter

                THEN 'sales commerce & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing AND HasCustomerCenter

                THEN 'sales team & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing

                THEN 'sales team & marketing'

            WHEN HasSalesEnterprise

                THEN 'sales enterprise'

            WHEN HasSalesCommerce

                THEN 'sales commerce'

            WHEN HasSalesTeam

                THEN 'sales team'

            WHEN HasMarketing

                THEN 'marketing'

            WHEN HasServiceEnterprise

                THEN 'service enterprise'

            WHEN HasCustomerCenter

                THEN 'customer center'

            WHEN HasAlmPortal

                THEN 'alm studio'

            WHEN HasAlmProxy

                THEN 'alm studio proxy'

            WHEN HasStudio

                THEN 'studio'

            WHEN HasLending

                THEN 'lending'

            WHEN HasBankSales

                THEN 'bank sales'

            WHEN HasBankCustomerJourney

                THEN 'bank customer journey'

            ELSE '?'

        END

    INTO Product;

    IF (UseAppName = TRUE) THEN

        Product = CONCAT(AppName, ' ', Product);

    END IF;

    RETURN QUERY (

        SELECT

            Product              AS "Product",

            ConfigurationVersion AS "Version",

            PrimaryCulture       AS "Culture"

        );

END;

$$ LANGUAGE plpgsql;

SELECT

    "Product",

    "ConfigurationVersion",

    "PrimaryCulture"

FROM "GetInstallPkgInfo"()

Cherednichenko Nikita,

 

This is the best solution for PostgreSQL, thanks!

Show all comments

Hello team,

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.

Somebody face this issue before?

 

The library is https://www.microsoft.com/en-us/download/details.aspx?id=48742

And the dll is adalsql.dll or adal.sql

Like 0

Like

5 comments

Hi Feredico, 

 

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: 

 

https://github.com/Microsoft/sql-server-samples/issues/265

 

Best Regards, 

 

Bogdan L.

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.

Federico Buffa ...,

 

We also double checked this question so this reply from Anastasiia still valid. 

 

 

Please also check this articles:

 

https://stackoverflow.com/questions/4469929/could-not-load-file-or-asse…

 

https://www.outsystems.com/forums/discussion/46739/problem-when-trying-…

 

Best Regards, 

 

Bogdan L.

Bogdan Lesyk,

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.

 

I will check the others 2 articles.

https://www.nuget.org/packages/Microsoft.Data.SqlClient.SNI.runtime/

 

Package is impossible to install in the server? Is a very well know Microsoft library and the servers are windows.

Show all comments

Hi,

I tried to install add-on "Field surveys for bpm'online" but it was not successful. How can I fix it?

 

Thank

File attachments
Like 0

Like

1 comments

Dear Song, 

We kindly ask you to send an email with a description of your issue to our technical support team (support@bpmonline.com) for further assistance.

Thank you in advance!

Best regards, 

Olga. 

Show all comments

Hi! I have problem when I try of configurate BPMonline on local, give me next error:

IIS Web Core

MapRequestHandler

Cod: 0x80070002

This error show it when I try of introduce user and password. What it happens?

Greetings

PD: this error show it on console (F12), with code HTML

Like 0

Like

9 comments

Hello.

Any chance you can send the screenshot of the error?

Matt

all-combined.js:7 Error while sending request 

    response status: 404 (Not Found)

    request url: http://192.168.1.58:82/ServiceModel/AuthService.svc/Login

    method: undefined

    request data: {"UserName":"Supervisor","UserPassword":"Supervisor","TimeZoneOffset":-60}

log @ all-combined.js:7

loginModule.js:711 Uncaught i

core-base.js:681 user: Demo_ru/1B4B9325-66CC-DF11-9B2A-001D60E938C6

 file: http://192.168.1.58:82//core/cea18c1437c88307af4598dcbd5db3b0/Terrasoft…

 line: 711

 column: 7

 message: Uncaught Terrasoft.UnauthorizedException: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 

<html xmlns="http://www.w3.org/1999/xhtml"> 

<head> 

<title>Error detallado de IIS 10.0 - 404.0 - Not Found</title> 

<style type="text/css"> 

<!-- 

body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;} 

code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;} 

.config_source code{font-size:.8em;color:#000000;} 

pre{margin:0;font-size:1.4em;word-wrap:break-word;} 

ul,ol{margin:10px 0 10px 5px;} 

ul.first,ol.first{margin-top:5px;} 

fieldset{padding:0 15px 10px 15px;word-break:break-all;} 

.summary-container fieldset{padding-bottom:5px;margin-top:4px;} 

legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;} 

legend{color:#333333;;margin:4px 0 8px -12px;_margin-top:0px; 

font-weight:bold;font-size:1em;} 

a:link,a:visited{color:#007EFF;font-weight:bold;} 

a:hover{text-decoration:none;} 

h1{font-size:2.4em;margin:0;color:#FFF;} 

h2{font-size:1.7em;margin:0;color:#CC0000;} 

h3{font-size:1.4em;margin:10px 0 0 0;color:#CC0000;} 

h4{font-size:1.2em;margin:10px 0 5px 0; 

}#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS",Verdana,sans-serif; 

 color:#FFF;background-color:#5C87B2; 

}#content{margin:0 0 0 2%;position:relative;} 

.summary-container,.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;} 

.content-container p{margin:0 0 10px 0; 

}#details-left{width:35%;float:left;margin-right:2%; 

}#details-right{width:63%;float:left;overflow:hidden; 

}#server_version{width:96%;_height:1px;min-height:1px;margin:0 0 5px 0;padding:11px 2% 8px 2%;color:#FFFFFF; 

 background-color:#5A7FA5;border-bottom:1px solid #C1CFDD;border-top:1px solid #4A6C8E;font-weight:normal; 

 font-size:1em;color:#FFF;text-align:right; 

}#server_version p{margin:5px 0;} 

table{margin:4px 0 4px 0;width:100%;border:none;} 

td,th{vertical-align:top;padding:3px 0;text-align:left;font-weight:normal;border:none;} 

th{width:30%;text-align:right;padding-right:2%;font-weight:bold;} 

thead th{background-color:#ebebeb;width:25%; 

}#details-right th{width:20%;} 

table tr.alt td,table tr.alt th{} 

.highlight-code{color:#CC0000;font-weight:bold;font-style:italic;} 

.clear{clear:both;} 

.preferred{padding:0 5px 2px 5px;font-weight:normal;background:#006633;color:#FFF;font-size:.8em;} 

--> 

</style> 

 

</head> 

<body> 

<div id="content"> 

<div class="content-container"> 

  <h3>Error HTTP 404.0 - Not Found</h3> 

  <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> 

  <div id="details-left"> 

   <table border="0" cellpadding="0" cellspacing="0"> 

    <tr class="alt"><th>Módulo</th><td>&nbsp;&nbsp;&nbsp;IIS Web Core</td></tr> 

    <tr><th>Notificación</th><td>&nbsp;&nbsp;&nbsp;MapRequestHandler</td></tr> 

    <tr class="alt"><th>Controlador</th><td>&nbsp;&nbsp;&nbsp;StaticFile</td></tr> 

    <tr><th>Código de error</th><td>&nbsp;&nbsp;&nbsp;0x80070002</td></tr> 

     

   </table> 

  </div> 

  <div id="details-right"> 

   <table border="0" cellpadding="0" cellspacing="0"> 

    <tr class="alt"><th>Dirección URL solicitada</th><td>&nbsp;&nbsp;&nbsp;http://192.168.1.58:82/ServiceModel/AuthService.svc/Login</td></tr>&nbsp;

    <tr><th>Ruta de acceso física</th><td>&nbsp;&nbsp;&nbsp;C:\inetpub\wwwroot\Bpmonline\ServiceModel\AuthService.svc\Login</td></tr> 

    <tr class="alt"><th>Método de inicio de sesión</th><td>&nbsp;&nbsp;&nbsp;Anónimo</td></tr> 

    <tr><th>Usuario de inicio de sesión</th><td>&nbsp;&nbsp;&nbsp;Anónimo</td></tr> 

     

   </table> 

   <div class="clear"></div> 

  </div> 

 </fieldset> 

</div> 

 

<div class="content-container"> 

 <fieldset><h4>Más información:</h4> 

  Este error significa que el archivo o directorio no existe en el servidor. Cree un archivo o directorio y vuelva a realizar la solicitud. 

  <p><a href="https://go.microsoft.com/fwlink/?LinkID=62293&amp;IIS70Error=404,0,0x80…">Ver más información &raquo;</a></p> 

   

 </fieldset> 

</div> 

</div> 

</body> 

</html> 

 

 date: Mon Feb 11 2019 13:34:24 GMT+0100 (hora estándar de Europa central)

 stack: undefined

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.

Please read more below:

https://academy.bpmonline.com/documents/administration/7-13/installing-…

Best regards,

Matt

It's possible known what line I am fail, or avaible mode debugger or someting

 

?

tgonzalez,

Not quite. You just need to make sure you have specified the correct path and db name in the file.

Matt

Dabase it's fine defined, I think that can be problem of permissions what permission must have user of Microsoft SQL server 

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'.]

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) +1480

System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +1149

System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +70

System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +979

System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +103

System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1595

System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +159

System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +382

System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +307

System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +198

System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +422

System.Data.SqlClient.SqlConnection.Open() +199

Terrasoft.Core.DB.DBExecutor.<get_DBConnection>b__14_0() +22

Polly.<>c__DisplayClass109_0.<Execute>b__0(Context ctx, CancellationToken ct) +23

Polly.<>c__DisplayClass103_0.<NoOp>b__1(Context ctx, CancellationToken ct) +18

Polly.NoOp.NoOpEngine.Implementation(Func`3 action, Context context, CancellationToken cancellationToken) +17

Polly.<>c.<NoOp>b__103_0(Action`2 action, Context context, CancellationToken cancellationToken) +105

Polly.Policy.Execute(Action`2 action, Context context, CancellationToken cancellationToken) +70

Polly.Policy.Execute(Action action) +119

Terrasoft.Core.DB.DBExecutor.get_DBConnection() +238

Terrasoft.Core.DB.DBExecutor.PingDB(UserConnection userConnection) +46

[SecurityException: System login error. Error has been recorded in system log of the server. Please contact your system administrator.]

Terrasoft.Core.DB.DBExecutor.PingDB(UserConnection userConnection) +239

Terrasoft.Core.SystemUserConnection.InitializeCurrentUser(String userName, TimeZoneInfo timeZone, String clientIP, String agent, Boolean needRegisterSessionStart) +28

Terrasoft.Core.AppConnection.InitializeSystemUserConnection(ConfigurationSection schemaManagerProviderConfigurationSection) +172

Terrasoft.Core.AppConnection.Initialize(ConfigurationSectionGroup appConfigurationSectionGroup) +550

Terrasoft.WebApp.Loader.Global.InitializeAppConnection() +513

 

tgonzalez,



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. 

here is the academy pagein on-site installation: 

https://academy.bpmonline.com/documents/administration/7-13/deploying-b…

Best regards, 

Dennis 

Show all comments