• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 38 subscribers
  • Views 472 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Migrating from Report Writer to Web Writer: Unable to deserialize new report file.

larosa

I am currently on NPM 10.6.1, working on migrating from report writer to web writer before upgrading.

Using the following process:

  1. Login to NPM Server
  2. Login to DB Manager and into DB for NPM
  3. Copy content from the definitions portion of the table for the report i want to transfer
  4. Save it XML with UTF-8 encoding
  5. /orion/reports/import.aspx‌
  6. import the XML file i created

Error:

Unable to deserialize new report file.

Expecting element 'Report' from namespace 'http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models'.. Encountered 'Element' with name 'Report', namespace '

Detailed Error:

Message: Expecting element 'Report' from namespace 'http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models'.. Encountered 'Element'  with name 'Report', namespace ''.

ErrorSite: System.Runtime.Serialization.DataContractSerializer.InternalReadObject

ErrorType: System.Runtime.Serialization.SerializationException

Stack:

at System.Runtime.Serialization.DataContractSerializer.InternalReadObject(XmlReaderDelegator xmlReader, Boolean verifyObjectName, DataContractResolver dataContractResolver)

at System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(XmlReaderDelegator reader, Boolean verifyObjectName, DataContractResolver dataContractResolver)

at System.Runtime.Serialization.DataContractSerializer.ReadObject(XmlReader reader)

at SolarWinds.Orion.Core.Reporting.DAL.Loader.Deserialize(XElement data)

at Orion_Reports_Import.OnLoad(EventArgs e)

My XML File Created from Report Writer:

- <Report Version="1.0" Group="Test Report" Title="Test Report" Type="History" TypeDescription="Historical - Interface Traffic" Icon="History" Schema="InterfaceTraffic.Schema" SubTitle="" Description="" Footer="" Time_Frame="Named" Named_Time_Frame="Last Month" Relative_Time_Frame="4 Months" Starting_DateTime="8/1/2008" Ending_DateTime="8/31/2008 11:59:59 PM" Grouping="Date" Group_Position="Beginning" SQL="SELECT TOP 10000 Convert(DateTime,Floor(Cast(DateTime as Float)),0) AS SummaryDate, Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, Interfaces.InterfaceName AS Interface_Name, Interfaces.InterfaceSpeed AS Interface_Speed, AVG(Case When InBandwidth+OutBandwidth=0 Then 0 When InBandwidth=0 Then (Out_Averagebps/OutBandwidth) * 100 When OutBandwidth=0 Then (In_Averagebps/InBandwidth) * 100 Else ( (Out_AverageBps/OutBandwidth)+(In_AverageBps/InBandwidth))*50 End) AS AVERAGE_of_CircuitUtil_AvgRecvXmit, AVG(Case When InBandwidth+OutBandwidth=0 Then 0 When InBandwidth=0 Then (Out_Averagebps/OutBandwidth) * 100 When OutBandwidth=0 Then (In_Averagebps/InBandwidth) * 100 Else Case When (Out_AverageBps/OutBandwidth) > (In_AverageBps/InBandwidth) Then (Out_AverageBps/OutBandwidth)*100 Else (In_AverageBps/InBandwidth) *100 End End) AS AVERAGE_of_CircuitUtil_MaxRecvXmit, AVG(InterfaceTraffic.In_Averagebps) AS AVERAGE_of_Average_Receive_bps, MAX(InterfaceTraffic.In_Maxbps) AS MAX_of_Peak_Receive_bps, AVG(InterfaceTraffic.Out_Averagebps) AS AVERAGE_of_Average_Transmit_bps, MAX(InterfaceTraffic.Out_Maxbps) AS MAX_of_Peak_Transmit_bps FROM (Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)) INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID) WHERE ( DateTime BETWEEN 39659 AND 39689.9999884259 ) AND ( (Nodes.Caption LIKE '%l3dex11%') AND (Interfaces.InterfaceName LIKE '%0/11%') ) GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)),0), Nodes.NodeID, Nodes.Caption, Interfaces.InterfaceName, Interfaces.InterfaceSpeed ORDER BY SummaryDate ASC, 3 ASC" TopX="All" TopXCount="10" TopXPercent="10" Orientation="Landscape" CookedData="TRUE" Web="TRUE" ShowFolders="">

- <QueryBuilder>

- <Fields>

- <QUERY>

<KIND>2</KIND>

- <COMPLEX>

<TAG />

<CONNECTIVE>1</CONNECTIVE>

<CHECKED>1</CHECKED>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>0</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Network Nodes.Node Details.Node ID</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Node ID</LEFTCAPTION>

<RIGHTVALUETYPE>3</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>0</FUNCTION>

<SORT>1</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Network Nodes.Node Details.Node Name</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Node Name</LEFTCAPTION>

<RIGHTVALUETYPE>130</RIGHTVALUETYPE>

<RIGHTVALUE />

<RIGHTCAPTION />

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>0</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Interfaces.Interface Details.Interface Name</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Interface Name</LEFTCAPTION>

<RIGHTVALUETYPE>129</RIGHTVALUETYPE>

<RIGHTVALUE />

<RIGHTCAPTION />

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>0</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Interfaces.Interface Details.Interface Speed</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Interface Speed</LEFTCAPTION>

<RIGHTVALUETYPE>5</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>3</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Historical Interface Traffic.Transmit+Receive Data Combined.Circuit Utilization (Avg of Recv,Xmit)</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Circuit Utilization (Avg of Recv,Xmit)</LEFTCAPTION>

<RIGHTVALUETYPE>4</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>3</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Historical Interface Traffic.Transmit+Receive Data Combined.Circuit Utilization (Max of Recv,Xmit)</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Circuit Utilization (Max of Recv,Xmit)</LEFTCAPTION>

<RIGHTVALUETYPE>4</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>3</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Historical Interface Traffic.Received Data.Average Receive bps</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Average Receive bps</LEFTCAPTION>

<RIGHTVALUETYPE>4</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>5</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Historical Interface Traffic.Received Data.Peak Receive bps</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Peak Receive bps</LEFTCAPTION>

<RIGHTVALUETYPE>4</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>3</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Historical Interface Traffic.Transmitted Data.Average Transmit bps</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Average Transmit bps</LEFTCAPTION>

<RIGHTVALUETYPE>4</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>0</COMPARISON>

<FUNCTION>5</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Historical Interface Traffic.Transmitted Data.Peak Transmit bps</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Peak Transmit bps</LEFTCAPTION>

<RIGHTVALUETYPE>4</RIGHTVALUETYPE>

<RIGHTVALUE>0</RIGHTVALUE>

<RIGHTCAPTION>0</RIGHTCAPTION>

</SIMPLE>

</COMPLEX>

</QUERY>

</Fields>

- <Filter>

- <QUERY>

<KIND>1</KIND>

- <COMPLEX>

<TAG />

<CONNECTIVE>1</CONNECTIVE>

<CHECKED>1</CHECKED>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>8</COMPARISON>

<FUNCTION>0</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Network Nodes.Node Details.Node Name</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Node Name</LEFTCAPTION>

<RIGHTVALUETYPE>8</RIGHTVALUETYPE>

<RIGHTVALUE>l3dex11</RIGHTVALUE>

<RIGHTCAPTION>l3dex11</RIGHTCAPTION>

</SIMPLE>

- <SIMPLE>

<TAG />

<ALIAS />

<ADVANCED>0</ADVANCED>

<COMPARISON>8</COMPARISON>

<FUNCTION>0</FUNCTION>

<SORT>0</SORT>

<CHECKED>1</CHECKED>

<LEFTSIDEKIND>2</LEFTSIDEKIND>

<RIGHTSIDEKIND>1</RIGHTSIDEKIND>

<COMPARISONATTRIBUTES />

<FUNCTIONATTRIBUTES />

<LEFTFIELDPATH>Interfaces.Interface Details.Interface Name</LEFTFIELDPATH>

<RIGHTFIELDPATH />

<LEFTVALUETYPE>0</LEFTVALUETYPE>

<LEFTVALUE />

<LEFTCAPTION>Interface Name</LEFTCAPTION>

<RIGHTVALUETYPE>8</RIGHTVALUETYPE>

<RIGHTVALUE>0/11</RIGHTVALUE>

<RIGHTCAPTION>0/11</RIGHTCAPTION>

</SIMPLE>

</COMPLEX>

</QUERY>

</Filter>

</QueryBuilder>

<LayoutGroups />

- <Fields>

<Field Name="SummaryDate" Header="Date" Range="Positive" Parser="Date" Format="" Alignment="Left" Width="1590" Units="" Hidden="False" WebURL="" />

<Field Name="NodeID" Header="Node ID" Range="Positive" Parser="None" Format="" Alignment="Center" Width="0" Units="" Hidden="True" WebURL="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:${NodeID}" />

<Field Name="AVERAGE_of_CircuitUtil_AvgRecvXmit" Header="Circuit Utilization (Avg of Recv,Xmit)" Range="ZeroAndAbove" Parser="Numeric" Format="0.00" Alignment="Center" Width="1200" Units="%" Hidden="False" WebURL="" />

<Field Name="NodeName" Header="Node" Range="ALL" Parser="None" Format="" Alignment="Left" Width="1245" Units="" Hidden="False" WebURL="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:${NodeID}" />

<Field Name="Interface_Name" Header="Interface" Range="ALL" Parser="None" Format="" Alignment="Left" Width="1755" Units="" Hidden="False" WebURL="/NetPerfMon/View.asp?View=InterfaceDetails&NetObject=I:${InterfaceID}" />

<Field Name="AVERAGE_of_CircuitUtil_MaxRecvXmit" Header="Circuit Utilization (Max of Recv,Xmit)" Range="ZeroAndAbove" Parser="Numeric" Format="0.00" Alignment="Center" Width="1005" Units="%" Hidden="False" WebURL="" />

<Field Name="Interface_Speed" Header="Speed" Range="ZeroAndAbove" Parser="Bandwidth" Format="" Alignment="Center" Width="960" Units="bps" Hidden="False" WebURL="" />

<Field Name="AVERAGE_of_Average_Receive_bps" Header="Average Receive bps" Range="ZeroAndAbove" Parser="Bandwidth" Format="" Alignment="Center" Width="990" Units="bps" Hidden="False" WebURL="/NetPerfMon/CustomChart.asp?Chart=AVGBPS&NetObject=I:${InterfaceID}" />

<Field Name="MAX_of_Peak_Receive_bps" Header="Peak Receive bps" Range="ZeroAndAbove" Parser="Bandwidth" Format="" Alignment="Center" Width="960" Units="bps" Hidden="False" WebURL="/NetPerfMon/CustomChart.asp?Chart=MMAVGBPS&NetObject=I:${InterfaceID}" />

<Field Name="AVERAGE_of_Average_Transmit_bps" Header="Average Transmit bps" Range="ZeroAndAbove" Parser="Bandwidth" Format="" Alignment="Center" Width="975" Units="bps" Hidden="False" WebURL="/NetPerfMon/CustomChart.asp?Chart=AVGBPS&NetObject=I:${InterfaceID}" />

<Field Name="MAX_of_Peak_Transmit_bps" Header="Peak Transmit bps" Range="ZeroAndAbove" Parser="Bandwidth" Format="" Alignment="Center" Width="1035" Units="bps" Hidden="False" WebURL="/NetPerfMon/CustomChart.asp?Chart=MMAVGBPS&NetObject=I:${InterfaceID}" />

</Fields>

</Report>

Thanks

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.