Post

1 follower Follow
0

HTML5 analyzer issue

In some cases, the HTML5 analyzer is getting failed at step-
Comparing objects on the server . . .
with error-
Error MODULMSG ; Job execution SQL Error: ERROR: null value in column "source_id" violates not-null constraint.

As a workaround we need to run below queries on local database (KB)--
select droptemporarytable('DUPLICATES');

CREATE TEMPORARY TABLE DUPLICATES
AS select idnam, objtyp
from objects
group by idnam, objtyp
having count(1) > 1;

DELETE FROM OBJECTS
USING DUPLICATES d
WHERE OBJECTS.idnam = d.idnam
AND OBJECTS.objtyp = d.objtyp
AND idkey NOT IN (
select idkey from objects o
join dss_objects dos
on dos.object_id = o.idkey
where dos.object_full_name = o.idnam
);
This should resolve the issue. After applying the workaround run analysis.

Please note that some of the functions will be considered added/deleted, but they would have been anyway because of the fix in place in version 1.9.2 and greater related to GUID:
https://doc.castsoftware.com/display/TECHNOS/HTML5+and+JavaScript+-+1.9

Please sign in to leave a comment.