In 7.3, dependencies are not required between two JEE analysis units, provided that they belong to the same execution unit. That is why they are not always declared in Cast-MS.
Starting from 8.0, the behaviour of the JEE analyzer has changed : it will create links between objects belonging to different analysis units IF AND ONLY IF a dependency is declared in Cast-MS.
That is why, after migration from a 7.3.x version to a 8.y.z version, it is necessary to review the dependencies between JEE analysis units to avoid missing links.
This query, run on the 7.3.x CAST management base, will provide the list of dependencies required in Cast-MS 8.y.z to retrieve all the links that were present in 7.3.x
Release | Yes/No |
---|---|
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
-- replace <MNGT> with the management base name -- replace <LOCAL> with the knowledge base name SET search_path=<LOCAL>; DROP TABLE IF EXISTS MAINT_JEEObjects; CREATE TEMPORARY TABLE MAINT_JEEObjects AS SELECT ap.IdJob, ap.IdPro, op.IdObj AS IdKey FROM AnaPro ap JOIN Keys kp ON kp.IdKey = ap.IdPro AND kp.ObjTyp IN (98,281) AND ap.Jobtyp = 719 JOIN ObjPro op ON op.idPro = ap.IdPro AND op.prop = 0; CREATE INDEX MAINT_JEEObjects_IdKey ON MAINT_JEEObjects ( IdKey ); SELECT cjar.OBJECT_ID AS "source analysis unit id", cjar.OBJECT_NAME AS "source analysis unit" , cjae.OBJECT_ID AS "target analysis unit id", cjae.OBJECT_NAME AS "target analysis unit" FROM (SELECT DISTINCT clr.IdPro AS clr, cle.IdPro AS cle FROM MAINT_JEEObjects clr JOIN Acc a ON a.IdClr = clr.IdKey JOIN MAINT_JEEObjects cle ON cle.IdKey = a.IdCle AND cle.IdPro != clr.IdPro LEFT JOIN MAINT_JEEObjects cle2 ON cle2.IdKey = a.IdCle AND cle2.IdPro = clr.IdPro WHERE cle2.IdJob IS NULL ) pro JOIN PMC_SUBSET_OBJECTS psor ON psor.OBJECT_ID = pro.clr JOIN PMC_SUBSETS psr ON psr.SUBSET_ID = psor.SUBSET_ID AND psr.SUBSET_NAME LIKE 'CMS_PRO__%' JOIN <MNGT>.CMS_J2EE_Analysis cjar ON cjar.Object_id = CAST(substring(psr.SUBSET_NAME, 10) AS INT) JOIN PMC_SUBSET_OBJECTS psoe ON psoe.OBJECT_ID = pro.cle JOIN PMC_SUBSETS pse ON pse.SUBSET_ID = psoe.SUBSET_ID AND pse.SUBSET_NAME LIKE 'CMS_PRO__%' JOIN <MNGT>.CMS_J2EE_Analysis cjae ON cjae.Object_id = CAST(substring(pse.SUBSET_NAME, 10) AS INT);
12353;"onemap-rest";93578;"foundation"
31520;"accessline";12280;"shop"
92985;"personalization";95652;"shopcore"
31519;"shop";92155;"cloudstorage"
92986;"fanprofiletool";12349;"wbfcuverse"
There should be the following dependencies in Cast-MS 8.x for all the links to be created :
From AU "onemap-rest" to AU "foundation"
From AU "accessline" to AU "shopcore"
From AU "personalization" to AU "shopcore"
From AU "shop" to AU "cloudstorage"
From AU "fanprofiletool" to AU "wbfcuverse"
-- replace <MNGT> with the management base name -- replace <LOCAL> with the knowledge base name BEGIN EXECUTE IMMEDIATE 'DROP TABLE MAINT_JEEObjects'; EXCEPTION WHEN OTHERS THEN IF SQLCODE != -942 THEN RAISE; END IF; END; CREATE GLOBAL TEMPORARY TABLE MAINT_JEEObjects ON COMMIT PRESERVE ROWS AS SELECT ap.IdJob, ap.IdPro, op.IdObj AS IdKey FROM <LOCAL>.AnaPro ap JOIN <LOCAL>.Keys kp ON kp.IdKey = ap.IdPro AND kp.ObjTyp IN (98,281) AND ap.Jobtyp = 719 JOIN <LOCAL>.ObjPro op ON op.idPro = ap.IdPro AND op.prop = 0; SELECT cjar.OBJECT_ID AS "source analysis unit id", cjar.OBJECT_NAME AS "source analysis unit" , cjae.OBJECT_ID AS "target analysis unit id", cjae.OBJECT_NAME AS "target analysis unit" FROM (SELECT DISTINCT clr.IdPro AS clr, cle.IdPro AS cle FROM MAINT_JEEObjects clr JOIN <LOCAL>.Acc a ON a.IdClr = clr.IdKey JOIN MAINT_JEEObjects cle ON cle.IdKey = a.IdCle AND cle.IdPro != clr.IdPro LEFT JOIN MAINT_JEEObjects cle2 ON cle2.IdKey = a.IdCle AND cle2.IdPro = clr.IdPro WHERE cle2.IdJob IS NULL ) pro JOIN <LOCAL>.PMC_SUBSET_OBJECTS psor ON psor.OBJECT_ID = pro.clr JOIN <LOCAL>.PMC_SUBSETS psr ON psr.SUBSET_ID = psor.SUBSET_ID AND psr.SUBSET_NAME LIKE 'CMS_PRO__%' JOIN <MNGT>.CMS_J2EE_Analysis cjar ON cjar.Object_id = CAST(SUBSTR(psr.SUBSET_NAME, 10) AS INT) JOIN <LOCAL>.PMC_SUBSET_OBJECTS psoe ON psoe.OBJECT_ID = pro.cle JOIN <LOCAL>.PMC_SUBSETS pse ON pse.SUBSET_ID = psoe.SUBSET_ID AND pse.SUBSET_NAME LIKE 'CMS_PRO__%' JOIN <MNGT>.CMS_J2EE_Analysis cjae ON cjae.Object_id = CAST(SUBSTR(pse.SUBSET_NAME, 10) AS INT);
source analysis unit id source analysis unit target analysis unit id target analysis unit
------------------------------ ----------------------------- ----------------------------- ---------------------------
224776 crc 224769 CRCBE
224784 anc 224776 crc
224782 WebArTe 224771 SAG
There should be the following dependencies in Cast-MS 8.x for all the links to be created :
From AU "crc" to AU "CRCBE"
From AU "anc" to AU "crc"
From AU "WebArTe" to AU "SAG"
Enter the SQL query