Analytical view - graphical representation

[Former Member]

Hello,

We are trying to activate analytical view and get the following error message:

repository/base/activation/activator.cpp:1006

Repository: Cyclic runtime dependency detected.;Found circular dependency of runtimes. For details see indexserver trace file.

When we look at the indexserver trace we find the following:

e REPOSITORY       objectDependencies.cpp(00423) : Found circular dependency etween runtimes. Runtime graph:

digraph G {

1 -> 0;

0 -> 1; 0 -> 2;

2 [label="BI-runtime"];

1 [label="Business Rules runtime"];

0 [label="sqlproc-runtime"];

}

Object dependencies:

digraph G {

0 -> 1; 0 -> 2; 0 -> 3; 0 -> 4;

2 -> 5; 2 -> 6; 2 -> 7; 2 -> 8; 2 -> 9; 2 -> 10; 2 -> 11; 2 -> 12; 2 -> 13; 2 -> 14; 2 -> 15; 2 -> 16; 2 -> 17; 2 -> 18; 2 -> 19; 2 -> 20; 2 -> 21; 2 -> 22; 2 -> 23; 2 -> 24; 2 -> 25; 2 -> 26; 2 -> 27; 2 -> 28; 2 -> 29; 2 -> 30; 2 -> 31; 2 -> 32; 2 -> 33; 2 -> 34; 2 -> 35; 2 -> 36; 2 -> 37; 2 -> 38; 2 -> 39; 2 -> 40; 2 -> 41; 2 -> 42; 2 -> 43; 2 -> 44; 2 -> 45; 2 -> 46; 2 -> 47;

102 -> 130; 102 -> 61;

130 -> 61;

56 -> 102; 56 -> 61;

103 -> 61;

59 -> 103; 59 -> 61;

104 -> 61;

60 -> 104; 60 -> 61;

105 -> 61;

55 -> 105; 55 -> 61;

106 -> 61;

53 -> 106; 53 -> 61;

107 -> 61;

58 -> 107; 58 -> 61;

52 -> 108;

109 -> 61;

54 -> 109; 54 -> 61;

110 -> 61;

51 -> 110; 51 -> 61;

111 -> 61;

57 -> 111; 57 -> 61;

35 -> 51; 35 -> 52; 35 -> 53; 35 -> 54; 35 -> 55; 35 -> 56; 35 -> 57; 35 -> 58; 35 -> 59; 35 -> 60; 35 -> 61;

62 -> 112;

112 -> 131;

40 -> 62;

39 -> 63;

64 -> 113;

38 -> 64;

42 -> 65;

65 -> 114;

45 -> 66; 45 -> 67;

67 -> 115;

66 -> 67;

70 -> 68; 70 -> 69;

6 -> 68; 6 -> 69;

7 -> 70; 7 -> 71; 7 -> 72; 7 -> 73; 7 -> 74; 7 -> 75;

74 -> 76;

8 -> 76;

46 -> 77;

11 -> 12; 11 -> 78;

12 -> 79;

79 -> 116;

116 -> 132;

13 -> 78; 13 -> 14;

14 -> 80;

80 -> 117;

117 -> 132;

37 -> 81; 37 -> 82; 37 -> 83; 37 -> 84;

84 -> 118;

83 -> 118;

82 -> 118;

81 -> 118;

15 -> 85; 15 -> 86; 15 -> 87; 15 -> 88; 15 -> 89;

133 -> 146;

119 -> 133;

87 -> 119;

88 -> 119;

89 -> 119;

27 -> 90;

25 -> 91;

18 -> 92; 18 -> 93;

20 -> 93;

93 -> 120;

44 -> 61; 44 -> 94;

94 -> 61;

147 -> 95;

136 -> 147;

……………….

………………….

0 [labelXXXXX.analyticview \n phase: A/A"];

2 [label="XXXXX1.calculationview\n phase: R/R"];

102 [label="XXXXX2.calculationview\n phase: R/R"];

130 [label=" XXXXX3.calculationview\n phase: R/R"];

56 [label=" XXXXX4.calculationview\n phase: R/R"];

……………….

………………….

subgraph "cluster_BI-runtime" {label="BI-runtime"; 61;}

subgraph "cluster_Business Rules runtime" {label="Business Rules runtime"; 24;}

subgraph "cluster_sqlproc-runtime" {label="sqlproc-runtime"; 0;2;102;130;56;103;59;104;60;105;55;106;53;107;58;108;52;109;54;110;51;111;57;35;62;112;131;40;63;39;64;113;38;42;65;114;45;67;115;66;70;68;6;7;72;73;76;74;8;71;69;9;10;75;46;77;11;12;79;78;116;132;13;14;80;117;36;37;118;84;83;82;81;15;85;133;146;119;86;87;88;89;90;26;27;28;29;30;31;32;33;25;91;18;19;20;93;92;120;44;94;95;147;136;148;137;47;139;140;149;135;1;16;121;122;96;41;43;150;126;124;134;48;123;97;100;151;128;152;127;34;141;21;125;98;99;49;3;50;101;129;143;144;145;4;153;158;159;23;155;157;160;169;172;175;154;156;161;170;173;176;138;163;164;162;142;165;166;167;168;171;174;17;5;22;}

}

To better understand what is wrong copy/paste the two graph descriptions above into separate files and use

dot -Tpdf <file_name> -O

to generate graphical representations

Is there a guide or something how to make this graphical representation to understand the error?

We are in HANA version 1.00.112.02.1459851171

Thanks,

Amir

[lucas_oliveira · Accepted solution]

Hello Amir,

Well, there's a cyclic dependency amongst your nodes. That's not supported indeed.

If you need to open this file, install graphviz, copy the contents on a new graph and render it.

Otherwise you can use linux dot to convert that graph into pdf/png/svg as suggested by the error message.

BRs,

Lucas de Oliveira

[Former Member · Accepted solution]

Hi Lucas,

Thank you!

We got this message in Analytical view. How can it be? Analytical view can only contain tables and attribute Views and Attribute Views Cannot contain Analytical view....

Thanks,

Amir

[lucas_oliveira · Accepted solution]

Yes, not real easy to read I know. It's mostly targeted at HANA developers actually.

However, given that cyclic dependency is not supported you may try to find it and fix it on your model.

BRs,
Lucas de Oliveira