Error importing package

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