Column 'OwnerGroup' does not belong to table Table.

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.


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 ?
Who is Participating?
AndyAinscowConnect With a Mentor Freelance programmer / ConsultantCommented:
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 ?
PeteEngineerAuthor Commented:
which function i need to step into ?

alm2Report.TPFolderRedirect.LoadXMLFile(Object XmlId)
at alm2Report.TPFolderRedirect.Page_Load(Object sender, EventArgs e)
AndyAinscowFreelance programmer / ConsultantCommented:
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.
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

PeteEngineerAuthor Commented:
I will put a break point on the first line of all the above three functions

let me see
PeteEngineerAuthor Commented:
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.
PeteEngineerAuthor Commented:
ok..i am passing a false as a parameter and try
PeteEngineerAuthor Commented:
that not working ..i am unable to hit the break points to see whats happening!
AndyAinscowFreelance programmer / ConsultantCommented:
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.
PeteEngineerAuthor Commented:
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)
PeteEngineerAuthor Commented:
i have searched there is no ownergroup anyway
PeteEngineerAuthor Commented:
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?
AndyAinscowFreelance programmer / ConsultantCommented:
Have you checked the values of the different objects contained within objXmlHandler ?  One of those might be 'OwnerGroup'
PeteEngineerAuthor Commented:
how can i check i cannot hit the breakpoint ..i can use sql profiler but still no use
AndyAinscowFreelance programmer / ConsultantCommented:
aaaargh !!!

Can you check it when it gets filled ?
PeteEngineerAuthor Commented:
when it filled in means? i didnt get?
AndyAinscowFreelance programmer / ConsultantCommented:
Somewhere you load the contents of that object - from file / database / ...
Check at that point if there is an 'OwnerGroup'
PeteEngineerAuthor Commented:
Just see the files ... and am still not getting where actually causing the error
PeteEngineerAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.