Skip to Content
0
May 28, 2014 at 10:26 AM

Error while doing "Visulaize Plan"

246 Views

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

Attachments

Viz_Plan_error.jpg (30.3 kB)