Child drop down list not getting values and it should...

Jan 13, 2010 at 8:57 PM

Hi, this is the scenario: 

I migrated some Oracle tables to some catalog lists and  the lists are as described below:

1- Region list, which contains a column DESC_REGION description of the region. Contains about 15 items.  and every description is unique. The amount of region's lists won't change in the future.

2.- Elements list, contains about 65,000 items. has a  column named desc_elemento ( description of the element), id_elemento  ( an integer ID stored as text), id_region, and a lookup  column to the region list,   displaying the DESC_REGION column in the lookup column.

 

So the idea then would be to instanciate in antother different list a cascading drop down list column for region list and for elements list.

Then, the Region drop down list would filter the elements lists.

I configured the columns and it worked great!, A little bit slow ( ¿Any suggestions in order to make it more quickly? I think that i should  set some index columns in the catalogs lists.. anyway this is not so important).

Yes it worked well. It loaded saved values  as expected, it saved values as expected, showed values as expected in both parent and child columns.

Now, it has been about 3 months and  it won't work anymore!!!!

THE CONFIGURATION IS:

PARENT COLUMN:  DESC_REGION AS TEXT AND VALUE FIELDS

CHILD COLUMN: ID_ELEMENTO AS VALUE AND DESC_ELEMENTO AS TEXT. PARENT COLUMN: ID_REGION.

 

I repeat, everything seemed to worked fine for about a month.... and then...

The problem  that i have is  as follows:

When i change a value from the parent drop down list,  it makes the postback, but the child drop down list is empty!!!. It should'nt. Note that  no changes have been done.

I decided to activate logs and I saw a  caml Query whit th

 

 

AND HERE IS THE LOG:

 

Monitorable    List item query elapsed time: 3251 milliseconds, Additional data (if available): Query HRESULT: 40EC6 List internal name, flags, and URL: {354D0626-5655-4885-B480-0961D23335F4}, flags=0x0000000020801000, URL="http://temm9dfspd01:31011/" Query XML: "<Query><Where><Eq><FieldRef Name="ID_REGION"/><Value Type="Text"/></Eq></Where></Query>" SQL Query: "      SELECT TOP 2147483648 t1.[Type] AS c0,UserData.[nvarchar32],UserData.[nvarchar10],UserData.[int3],t6.[tp_ID] AS c13c15,t7.[tp_Created] AS c19c18,UserData.[tp_ItemOrder],UserData.[tp_Created],UserData.[tp_ModerationStatus],UserData.[nvarchar1],UserData.[nvarchar6],UserData.[nvarchar23],UserData.[nvarchar28],UserData.[tp_WorkflowInstanceID],t1.[TimeLastModified] AS c23,t1.[Id] AS c3,UserData.[ntext1],UserData.[nvarchar31],UserData.[int2],User...    


An SPRequest object was not disposed before the end of this thread.  To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.  This object will now be disposed.  Allocation Id: {9FC31B3C-4F89-466E-8768-D2C5A46B109A}  This SPRequest was allocated at    at Microsoft.SharePoint.Library.SPRequest..ctor()     at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)     at Microsoft.SharePoint.SPWeb.InitializeSPRequest()     at Microsoft.SharePoint.SPWeb.EnsureSPRequest()     at Microsoft.SharePoint.SPWeb.get_Request()     at Microsoft.SharePoint.SPListCollect...    
01/13/2010 13:49:49.13*    w3wp.exe (0x146C)                           0x14C8    Windows SharePoint Services       General                           8l1n    High        ...ion.EnsureListsData(Guid webId, String strListName)     at Microsoft.SharePoint.SPListCollection.EnsureListsData(String strListName)     at Microsoft.SharePoint.SPListCollection.GetListByName(String strListName, Boolean bThrowException)     at Microsoft.SharePoint.SPListCollection.get_Item(String strListName)     at Stoneshare.CascadingDropDown.WithFilter.CascadingDropDownListFieldControlWithFilter.PopulateDropDown()     at Stoneshare.CascadingDropDown.WithFilter.CascadingDropDownListFieldControlWithFilter.CreateChildControls()     at System.Web.UI.Control.EnsureChildControls()     at Microsoft.SharePoint.WebControls.TemplateBasedControl.get_Controls()     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object sav...    
01/13/2010 13:49:49.13*    w3wp.exe (0x146C)                           0x14C8    Windows SharePoint Services       General                           8l1n    High        ...edState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIn...    
01/13/2010 13:49:49.13*    w3wp.exe (0x146C)                           0x14C8    Windows SharePoint Services       General                           8l1n    High        ...dex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadV...    
01/13/2010 13:49:49.13*    w3wp.exe (0x146C)                           0x14C8    Windows SharePoint Services       General                           8l1n    High        ...iewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByID(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Page....    
01/13/2010 13:49:49.13*    w3wp.exe (0x146C)                           0x14C8    Windows SharePoint Services       General                           8l1n    High        ...LoadAllState()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)    ...    
01/13/2010 13:49:49.13*    w3wp.exe (0x146C)                           0x14C8    Windows SharePoint Services       General                           8l1n    High        ... at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)     at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)     at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)      
01/13/2010 13:49:49.13     w3wp.exe (0x146C)                           0x14C8    WinO

 

 

 

¿aNY SUGGESTIONS / IDEAS?

 

Sep 26, 2014 at 4:31 AM
Hi Sewer,

Have you got that worked out? Anyway, here's a guide for drop down list, hope it would help somebody else who reads this.

Kind regards,
Ivy Miller