This page helps you to check whether the link between the applications and the user defined modules is missing or not. If it is, it provides you the remediation to add the link manually.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
SELECT DOS1.object_name AS application, DOS2.object_name AS module FROM dss_links DLS JOIN dss_objects DOS2 ON DLS.next_object_id = DOS2.object_id AND DOS2.object_type_id = 20000 JOIN dss_objects DOS1 ON DLS.previous_object_id = DOS1.object_id AND DOS1.object_type_id = -102 AND DLS.link_type_id = 1
If the query returns no rows then you need to manually add the link between the application and the module
Fetch the application_ID using the below query :
SELECT object_id FROM dss_objects WHERE object_type_id = -102
Fetch the module_ID using the below query :
SELECT object_id FROM dss_objects WHERE object_type_id = 20000
Insert the link:
Insert into dss_links values(application_id , module_id , 1)
SELECT DOS1.object_name AS application, DOS2.object_name AS module FROM dss_links DLS JOIN dss_objects DOS2 ON DLS.next_object_id = DOS2.object_id AND DOS2.object_type_id = 20000 JOIN dss_objects DOS1 ON DLS.previous_object_id = DOS1.object_id AND DOS1.object_type_id = -102 AND DLS.link_type_id = 1
If the query returns no rows then you need to manually add the link between the application and the module.
Fetch the application_ID using the below query :
SELECT object_id FROM dss_objects WHERE object_type_id = -102
Fetch the module_ID using the below query :
SELECT object_id FROM dss_objects WHERE object_type_id = 20000
Insert the link :
Insert into dss_links values(application_id , module_id , 1)
SELECT DOS1.object_name AS application, DOS2.object_name AS module FROM dss_links DLS JOIN dss_objects DOS2 ON DLS.next_object_id = DOS2.object_id AND DOS2.object_type_id = 20000 JOIN dss_objects DOS1 ON DLS.previous_object_id = DOS1.object_id AND DOS1.object_type_id = -102 AND DLS.link_type_id = 1
If the query returns no rows then you need to manually add the link between the application and the module.
Fetch the application_ID using the below query :
SELECT object_id FROM dss_objects WHERE object_type_id = -102
Fetch the module_ID using the below query :
SELECT object_id FROM dss_objects WHERE object_type_id = 20000
Insert the link :
Insert into dss_links values(application_id , module_id , 1)