Run the following SQL against the repository to enable Amazon and Azure connections
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('907','Amazon Connection')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('908','Amazon Connections')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('909','Azure Connection')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('910','Azure Connections')
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=25000
WHERE OBJECT_TYPE= '907' --Amazon Connection
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '908' --Amazon Connections
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '909' --Azure Connection
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '910' --Azure Connection/
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-5 as OBJECT_ID,
PARENT_ID,
'Amazon' as NAME,
907 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-6 as OBJECT_ID,
PARENT_ID,
'Azure' as NAME,
909 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322
Note: If you are having problems upgrading our software please let us know and we will do our best to assist you