?
Solved

Column 'OwnerGroup' does not belong to table Table.

Posted on 2012-03-29
18
Medium Priority
?
906 Views
Last Modified: 2012-04-02
I am getting error when i call the following function:


Dim DataXmlId As Guid = Guid.NewGuid
            TPStyleDevelopmentInsert(DataXmlId.ToString, StyleId, strStyleColorwaySeasonYearID, strSystemCultureId)
            Response.Redirect(strReportServer & "/TPFolderRedirect.aspx?DXID=" & DataXmlId.ToString & "&SDID=" & _StyleDevelopmentId & "&SID=" & StyleId & _
                              "&RTPID=" & ReportTPFolderId & "&SV=" & Request.QueryString("SV") & "&SSID=" & Me._StyleSourcingID & _
                              "&TID=" & Me.UserProperties.TeamID & "&SYID=" & Me._SeasonYearID & "&SN=" & Me._StyleSet)

Open in new window



And error is :

Error:Column 'OwnerGroup' does not belong to table Table.

Page:/almReport/TPFolderRedirect.aspx?
DXID=1a79a78b-30bc-4b35-a7b9-85381fe0988e&SDID=6dac0929-4e19-4ef1-acfc-3a367ce89eb0
&SID=dab0f156-06a8-450a-8df8-1285ab8fafee&RTPID=f1000000-0000-0000-0000-000000000010&SV=2
&SSID=3f47ed6f-584b-4cae-9ec6-6462f19d80d2
&TID=203517c2-2bd4-4ed3-9ef7-ac37de447321
&SYID=60f5b984-9def-4cb4-af17-387e2719f28b&SN=1
Exeption:System.ArgumentException

System.Data
Trace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) 
at almCore.FormHandler.GetReportSqlControls() 
at alm2Report.TPFolderRedirect.LoadXMLFile(Object XmlId) 
in D:\Jais\JaisPLM\Trunk\Software\padawan\Application\alm2Report\TPFolderRedirect.aspx.vb:line 339 
at alm2Report.TPFolderRedirect.GetSqlReport() 
in D:\Jais\JaisPLM\Trunk\Software\padawan\Application\alm2Report\TPFolderRedirect.aspx.vb:line 658 
at alm2Report.TPFolderRedirect.Page_Load(Object sender, EventArgs e) 
in D:\Jais\JaisPLM\Trunk\Software\padawan\Application\alm2Report\TPFolderRedirect.aspx.vb:line 155 
at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() 
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, 
Boolean includeStagesAfterAsyncPoint)

Open in new window


What is the cause of this ?
0
Comment
Question by:PeteEngineer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 12
  • 6
18 Comments
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 2000 total points
ID: 37781563
According to the error message you are requesting the value in a field called OwnerGroup from a table (data set) - but that doesn't appear in your code snippet.
Can you step into the function and see where this field is being requested ?
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37781585
which function i need to step into ?

alm2Report.TPFolderRedirect.LoadXMLFile(Object XmlId)
alm2Report.TPFolderRedirect.GetSqlReport()
at alm2Report.TPFolderRedirect.Page_Load(Object sender, EventArgs e)
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 37781602
I don't know -  I don't see the code they contain.
Just step into the function then out again - if it errors then you know it is somewhere in that particualr function.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Author Comment

by:PeteEngineer
ID: 37781629
I will put a break point on the first line of all the above three functions

let me see
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37781650
I am not able to hit the break point when the execution reaches the following line:

Response.Redirect(strReportServer & "/TPFolderRedirect.aspx?DXID=" & DataXmlId.ToString & "&SDID=" & _StyleDevelopmentId & "&SID=" & StyleId & _
                              "&RTPID=" & ReportTPFolderId & "&SV=" & Request.QueryString("SV") & "&SSID=" & Me._StyleSourcingID & _
                              "&TID=" & Me.UserProperties.TeamID & "&SYID=" & Me._SeasonYearID & "&SN=" & Me._StyleSet)
           

it shows the error which i posted above.
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37781706
ok..i am passing a false as a parameter and try
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37781784
that not working ..i am unable to hit the break points to see whats happening!
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 37781841
OK.
Looking at the trace stack
line 14:  at alm2Report.TPFolderRedirect.LoadXMLFile(Object XmlId)
Maybe check that first.

You could also do a search for the string 'OwnerGroup' - that is what the exception refers to.
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37781861
Ok let see the possibiliteis of problem area as bellow :

I found page load call getsqlreport and this calls loadxml

and there is a line may cousing the issue shown below :

        ReportTableInsert(conConnection, XmlId, objXmlHandler.DataColumnNumber, objXmlHandler.DataColumn, objXmlHandler.DataHeader, objXmlHandler.DataValue, i)
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37782003
i have searched there is no ownergroup anyway
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37782015
I got a defenition of function above :


 Private Shared Sub ReportTableInsert(ByVal connection As SqlConnection, ByVal dataXmlId As String, ByVal dataColumnNumber As Integer, _
        ByVal dataColumnName As String, ByVal dataHeader As String, ByVal dataValue As String, ByVal dataSort As String)

        Dim spx As String = plmOnCore.SPXoverride.GetSPX_Shared(connection, "TechPackFolderRedirect", "spx_RptTable_INSERT")
        Dim params() As SqlParameter = { _
            New SqlParameter("@DataXmlID", SqlDbType.VarChar, 40, ParameterDirection.Input, False, Nothing, Nothing, Nothing, DataRowVersion.Current, dataXmlId), _
            New SqlParameter("@DataColumnNumber", SqlDbType.Int, 4, ParameterDirection.Input, False, Nothing, Nothing, Nothing, DataRowVersion.Current, dataColumnNumber), _
            New SqlParameter("@DataColumnName", SqlDbType.NVarChar, 200, ParameterDirection.Input, False, Nothing, Nothing, Nothing, DataRowVersion.Current, dataColumnName), _
            New SqlParameter("@DataHeader", SqlDbType.NVarChar, 200, ParameterDirection.Input, False, Nothing, Nothing, Nothing, DataRowVersion.Current, dataHeader), _
            New SqlParameter("@DataValue", SqlDbType.NVarChar, 4000, ParameterDirection.Input, False, Nothing, Nothing, Nothing, DataRowVersion.Current, dataValue), _
            New SqlParameter("@DataSort", SqlDbType.VarChar, 5, ParameterDirection.Input, False, Nothing, Nothing, Nothing, DataRowVersion.Current, dataSort) _
        }
        SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, spx, params)

    End Sub

Open in new window



Looks like problem is from @DataColumnName"

what say?
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 37782017
Have you checked the values of the different objects contained within objXmlHandler ?  One of those might be 'OwnerGroup'
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37782030
how can i check i cannot hit the breakpoint ..i can use sql profiler but still no use
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 37782061
aaaargh !!!

Can you check it when it gets filled ?
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37782073
when it filled in means? i didnt get?
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 37782317
Somewhere you load the contents of that object - from file / database / ...
Check at that point if there is an 'OwnerGroup'
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37786435
Just see the files ... and am still not getting where actually causing the error
Pageload
GetSQLReport
LoadXML
0
 
LVL 8

Author Comment

by:PeteEngineer
ID: 37786438
The above files are from the page which is redirected

and button click event of the page has the redirect code which i pasted above.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question