Error while doing "Visulaize Plan"

[rindia]

Hi,

Before i did Visualize plan many times without any problem.Now I am getting error while doing so.

I was able to run "Explain Plan" successfully.

I am on HANA revision 60.

  

I saved above error log and the log information is given below:

I can identify invalid XML tag <TablesInvolved><![CDATA[raj/AN_VIZ]]></TablesInvolved> but how to fix this issue?

I gone through various blogs related to Visulaization Plan but not found related to this issue.

<Plan xmlns="http://www.sap.com/ndb/planviz" ID="ID_0" Type="Estimated">

<SQL><![CDATA[SELECT KOKRS, BELNR, PERIO, SUM(MEGBTR)

FROM "_SYS_BIC"."raj/AN_VIZ"

GROUP BY KOKRS, BELNR, PERIO]]></SQL>

<CompileTime>

  <Start Unit="us">1401281467643661</Start>

  <End Unit="us">1401281467658329</End>

</CompileTime>

<RootRelation ID="ID_0" TypeName="PROJECT" Status="Finished">

  <Name>Project</Name>

  <ExecutionType>Row Search</ExecutionType>

  <Summary><![CDATA[raj/AN_VIZ.KOKRS, raj/AN_VIZ.BELNR, raj/AN_VIZ.PERIO, SUM(raj/AN_VIZ.MEGBTR)]]></Summary>

  <Location>hanasp7:30003</Location>

  <EstimatedCost>

   <Exclusive Unit="us">2.12902e+06</Exclusive>

   <Inclusive Unit="us">2.64021e+06</Inclusive>

  </EstimatedCost>

  <EstimatedOutputCardinality>648284</EstimatedOutputCardinality>

  <Details><![CDATA[{"Projected Cols":"raj/AN_VIZ.KOKRS, raj/AN_VIZ.BELNR, raj/AN_VIZ.PERIO, SUM(raj/AN_VIZ.MEGBTR)","Project column0":"NString(4, 0)  __trex_field_NVarchar3__() ....... [3]:040:<5/7 (16B)>:

  /1/ void*  \"__rids__\" ....... [0]:NOP:<0/1 (8B)>:

  /2/ int32_t(10, 0) const := 0 ....... [1]:LOAD:<3/4 (4B)>:

  /3/ int32_t(10, 0) const := 0 ....... [2]:LOAD:<4/5 (4B)>:","Project column1":"NString(10, 0)  __trex_field_NVarchar3__() ....... [8]:040:<5/7 (16B)>:

  /1/ void*  \"__rids__\" ....... [5]:NOP:<0/1 (8B)>:

  /2/ int32_t(10, 0) const := 0 ....... [6]:LOAD:<3/4 (4B)>:

  /3/ int32_t(10, 0) const := 1 ....... [7]:LOAD:<4/5 (4B)>:","Project column2":"NString(3, 0)  __trex_field_NVarchar3__() ....... [13]:040:<5/7 (16B)>:

  /1/ void*  \"__rids__\" ....... [10]:NOP:<0/1 (8B)>:

  /2/ int32_t(10, 0) const := 0 ....... [11]:LOAD:<3/4 (4B)>:

  /3/ int32_t(10, 0) const := 2 ....... [12]:LOAD:<4/5 (4B)>:","Project column3":"Decimal(18, 3)  __typecast__() ....... [23]:076:<10/12 (16B)>:

  /1/ Fixed16(18, 3)  __trex_field_Fixed16__() ....... [19]:043:<6/8 (16B)>: 

     /1/ void*  \"__rids__\" ....... [15]:NOP:<0/1 (8B)>:

     /2/ int32_t(10, 0) const := 0 ....... [16]:LOAD:<3/4 (4B)>:

     /3/ int32_t(10, 0) const := 3 ....... [17]:LOAD:<4/5 (4B)>:

     /4/ int32_t(10, 0) const := 3 ....... [18]:LOAD:<5/6 (4B)>: 

  /2/ int32_t(10, 0) const := 18 ....... [21]:LOAD:<8/9 (4B)>:

  /3/ int32_t(10, 0) const := 3 ....... [22]:LOAD:<9/10 (4B)>:"}]]></Details>

  <Child ID="ID_8" >

  </Child>

</RootRelation>

<Relation ID="ID_8" TypeName="TREX_SEARCH" Status="Finished">

  <Name>Column Search</Name>

  <ExecutionType>Column Search</ExecutionType>

  <Summary><![CDATA[Aggregation on a single table]]></Summary>

  <Location>hanasp7:30003</Location>

  <EstimatedCost>

   <Exclusive Unit="us">511194</Exclusive>

   <Inclusive Unit="us">511194</Inclusive>

  </EstimatedCost>

  <EstimatedOutputCardinality>648284</EstimatedOutputCardinality>

  <TablesInvolved><![CDATA[raj/AN_VIZ]]></TablesInvolved>

  <LogicalPlan ID="ID_11" Type="Estimated">

   <RootRelation ID="ID_11" TypeName="PROJECT" Status="Finished">

    <Name>Project</Name>

    <EstimatedCost>

     <Exclusive Unit="us">0</Exclusive>

     <Inclusive Unit="us">0</Inclusive>

    </EstimatedCost>

    <EstimatedOutputCardinality>648284</EstimatedOutputCardinality>

    <Child ID="ID_12" >

    </Child>

   </RootRelation>

   <Relation ID="ID_12" TypeName="GROUP_BY" Status="Finished">

    <Name>Aggregation</Name>

    <Summary><![CDATA[raj/AN_VIZ.KOKRS, raj/AN_VIZ.BELNR, raj/AN_VIZ.PERIO\nSUM(raj/AN_VIZ.MEGBTR)]]></Summary>

    <EstimatedCost>

     <Exclusive Unit="us">0</Exclusive>

     <Inclusive Unit="us">0</Inclusive>

    </EstimatedCost>

    <EstimatedOutputCardinality>648284</EstimatedOutputCardinality>

    <Details><![CDATA[{"Grouping Cols":"raj/AN_VIZ.KOKRS, raj/AN_VIZ.BELNR, raj/AN_VIZ.PERIO","Aggregation Cols":"SUM(raj/AN_VIZ.MEGBTR)"}]]></Details>

    <Child ID="ID_13" >

    </Child>

   </Relation>

   <Relation ID="ID_13" TypeName="TABLE" Status="Finished">

    <Name>Column View</Name>

    <Schema><![CDATA[_SYS_BIC]]></Schema>

    <ObjectName><![CDATA[raj/AN_VIZ]]></ObjectName>

    <Location>hanasp7:30003</Location>

    <EstimatedCost>

     <Exclusive Unit="us">0</Exclusive>

     <Inclusive Unit="us">0</Inclusive>

    </EstimatedCost>

    <EstimatedOutputCardinality>682404</EstimatedOutputCardinality>

   </Relation>

  </LogicalPlan>

</Relation>

</Plan>

Regards

Raj

[michael_devine · Accepted solution]

Hi,

To solve this you must update your studio. In lower studio versions (PlanViz) does not allow "unknown" XML tags sent by higher version servers. A fix for this issue was made so that PlanViz parser can simply skip unknown tags.

Please go to version 74, if possible.

Regards,

Michael

[rindia · Accepted solution]

Thanks Michael.

I will tell to my admin to update HANA studio.

Will let you know once it is done.

Regards

Raj