Objectel 2.10.3.1 Migration Script Errors. (Doc ID 1370065.1)

Last updated on AUGUST 10, 2016

Applies to:

Oracle Communications Objectel - Version: 2.10.3 and later   [Release: 2.10 and later ]
Information in this document applies to any platform.

Symptoms

There are some log errors after the migration process.

Most of the errors are normal, however there is one that is an issue. It is the ProjectLogInsert trigger compilation that is causing this issue.


 

SQL> CREATE OR REPLACE TRIGGER ProjectLogInsert BEFORE INSERT OR UPDATE OF AG2ProjectID,ObjectID ON ProjectLog FOR EACH ROW

2 DECLARE

3 cnt NUMBER;

4 status NUMBER;

5 AG2ProjectID EXCEPTION;

6 ObjectID EXCEPTION;

7 ProjectDone EXCEPTION;

8 BEGIN

9 SELECT PROJECTLOG_SEQ.NEXTVAL INTO :NEW.AG2OBJECTSEQUENCENO FROM DUAL;

10 BEGIN

11 cnt := 1;

12 SELECT projectStatus into status FROM imProject WHERE objectID = :NEW.AG2ProjectID;

13 EXCEPTION WHEN NO_DATA_FOUND THEN cnt := 0;

14 END;

15 IF cnt = 1 THEN

16 IF status = 7 or status = 8 THEN

17 raise ProjectDone;

18 END IF;

19 GOTO lbl_AG2ProjectID;

20 END IF;

21 IF cnt = 0 THEN

22 RAISE AG2ProjectID;

23 END IF;

24 <>

25 NULL;

26 SELECT COUNT(*) into cnt FROM FEPortsHierarchy WHERE objectID = :NEW.ObjectID;

27 IF cnt > 0 THEN

28 GOTO lbl_ObjectID;

29 END IF;

30 SELECT COUNT(*) into cnt FROM imNetwork WHERE objectID = :NEW.ObjectID;

31 IF cnt > 0 THEN

32 GOTO lbl_ObjectID;

33 END IF;

34 SELECT COUNT(*) into cnt FROM Hierarchy WHERE ObjectId = :NEW.ObjectID;

35 IF cnt > 0 THEN

36 GOTO lbl_ObjectID;

37 END IF;

38 SELECT COUNT(*) into cnt FROM imConnection WHERE objectID = :NEW.ObjectID;

39 IF cnt > 0 THEN

40 GOTO lbl_ObjectID;

41 END IF;

42 SELECT COUNT(*) into cnt FROM PhysicalConnection WHERE ConnectionId = :NEW.ObjectID;

43 IF cnt > 0 THEN

44 GOTO lbl_ObjectID;

45 END IF;

46 SELECT COUNT(*) into cnt FROM Services WHERE AG2ServiceID = :NEW.ObjectID;

47 IF cnt > 0 THEN

48 GOTO lbl_ObjectID;

49 END IF;

50 SELECT COUNT(*) into cnt FROM Flow WHERE AG2ObjectID = :NEW.ObjectID;

51 IF cnt > 0 THEN

52 GOTO lbl_ObjectID;

53 END IF;

54 SELECT COUNT(*) into cnt FROM Customer WHERE AG2CustomerID = :NEW.ObjectID;

55 IF cnt > 0 THEN

56 GOTO lbl_ObjectID;

57 END IF;

58 SELECT COUNT(*) into cnt FROM RHServices WHERE AG2ServiceID = :NEW.ObjectID;

59 IF cnt > 0 THEN

60 GOTO lbl_ObjectID;

61 END IF;

62 SELECT COUNT(*) into cnt FROM RHServices WHERE AG2ServiceID = :NEW.ObjectID;

63 IF cnt > 0 THEN

64 GOTO lbl_ObjectID;

65 END IF;

66 SELECT COUNT(*) into cnt FROM Association WHERE ASSOCIATIONID = :NEW.ObjectID;

67 IF cnt > 0 THEN

68 GOTO lbl_ObjectID;

69 END IF;

70 IF cnt = 0 THEN

71 RAISE ObjectID;

72 END IF;

73 <>

74 NULL;

75 EXCEPTION

76 WHEN AG2ProjectID THEN

77 raise_application_error(-20507, 'Project ID not found : '|| :old.AG2ProjectID);

78 WHEN ObjectID THEN

79 raise_application_error(-20507, 'Object ID not found: '|| :old.ObjectID);

80 WHEN ProjectDone THEN

81 raise_application_error(-20507, 'Project has been canceled or completed '|| :old.AG2ProjectID);

82 END;

83 /

Warning: Trigger created with compilation errors.

 



Changes

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms