Solved

Column 'OwnerGroup' does not belong to table Table.

Posted on 2012-03-29
18
868 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
  • 12
  • 6
18 Comments
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 500 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

785 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