Hi Community,
In the update guide (https://academy.creatio.com/docs/release/update-guide/update-guide#titl…), there are sets of scripts needs to be executed before proceeding to the upgrade. But in the guide they only specified MSSQL and PostgreSQL scripts they have not given a script for Oracle. Any idea what is the counterpart of the below scripts in Oracle. Thank you so much.
Before updating to version 7.15.3
{
declare @val as varchar(max) = ''
select @val = concat(@val, SchemaName, ', ')
from
(select SysSchema.Name as SchemaName
from SysSchemaContent with (nolock)
inner join SysSchema with(nolock) on SysSchemaContent.SysSchemaId = SysSchema.Id
inner join SysPackage with(nolock) on SysSchema.SysPackageId = SysPackage.Id
where
SysPackage.Maintainer != 'Terrasoft' and
SysSchema.ManagerName in ('EntitySchemaManager', 'PageSchemaManager',
'ProcessSchemaManager', 'ProcessUserTaskSchemaManager', 'SourceCodeSchemaManager') and
(
cast(SysSchemaContent.Content as varchar(max)) like '%Terrasoft.Reports%' or
cast(SysSchemaContent.Content as varchar(max)) like '%ReportSchemaManager%'
)
union
select SysSchema.Name as SchemaName
from SysSchema with(nolock)
inner join SysPackage with(nolock) on SysSchema.SysPackageId = SysPackage.Id
where
SysPackage.Maintainer != 'Terrasoft' and
SysSchema.ManagerName in ('EntitySchemaManager', 'PageSchemaManager',
'ProcessSchemaManager', 'ProcessUserTaskSchemaManager', 'SourceCodeSchemaManager') and
(
cast(SysSchema.MetaData as varchar(max)) like '%Terrasoft.Reports%' or
cast(SysSchema.MetaData as varchar(max)) like '%ReportSchemaManager%'
)
) as contentList
select DB_NAME(), @val as SchemaContent
}
Updating to 7.16.1
SELECT SysSchema.Name AS SchemaName FROM SysSchema (NOLOCK)
WHERE SysSchema.Id IN (
SELECT SysSchemaId FROM SysSchemaSource
WHERE SysSchemaId IN (
SELECT
ss.Id
FROM SysSchema ss WITH (NOLOCK)
INNER JOIN SysPackage sp WITH (NOLOCK) ON ss.SysPackageId = sp.Id
WHERE sp.Name NOT IN ('Base', 'ProcessDesigner', 'NUI', 'SSP')
AND sp.Maintainer != 'Terrasoft'
AND ss.ManagerName NOT IN ('ClientUnitSchemaManager', 'DcmSchemaManager', 'PageSchemaManager')
)
AND (Source LIKE '%MailBe%' OR (Source like '%SmtpClient%' AND Source like '%Terrasoft.Mail%'))
)