.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Lookup field issue after restore

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :SharePoint
After restoring a site collection in MOSS 2007, lookup fields cannot link up with the parent list. May I know if this problem fixed in MOSS 2010? Besides, the list item GUID in MOSS 2007 are changed after restoring. Does this case still appear in MOSS 2010? Thanks!

View Complete Post

More Related Resource Links

Issue Adding a new Lookup Field to an existing List Instance

I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

Infopath field promotion issue with lookup


Can anyone help.


I have code which generates a site (libraries, lists and data) and attaches a form library with my form on it.

Everything is working great form opens and saves at each stage of the process etc.

A note due to installing this form and lists etc in a subsite I create the lookup I need in code so I can link the relevent lists etc to each other.

I am now in the final stages of the development and want to promote out some of the form fields to sharepoint however when I do this and then try it on a different site collection to see if the whole solution will install the infopath promoted fields for lookup are always not clickable when viewing the content type.


This is really annoying and I can't be the first to run into this but I can't seem to find a solution to fix it.


Small edit,


The fields I am guessing are grey because I can't edit them as they are read only?

But my lookup on my deployed site are showing as Text fields rather than the Lookup I need so are only displaying the Id of the Lookup value instead of the name...


This is annoying.

Datasheet view lookup column issue


When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.


Any ideas how to get this resolved?

SSIS Lookup Transformation Issue

I am having a strange issue, In my data flow i have a Lookup Transformaton which will match on key columns of the fact and is followed by a condetional split that would deside if it should insert (old db destination) or go to update (oledb command) or ignore if no change. I have packages running for the last 1 year with the same logic. But in the recent packages I am experiencing a problem.  example: Key columns for join are - type_no (varchar 16) with all numeric values except one record wihh ' '(space) in it  and type_cd (decimal(18,0)) with values(0,1,2,3,4,5) It worked fine when I test the package. After couple of day running in schedule I get integrity violation and huge file with failed records which are supposed to be blocked at the condetional split as they are already in the fact. When i add a data viewer what i found is for all the llokup columns its having nulls (no match found). Workaround that is working for me for now is - I select full cash and say ok in the lookup transofrmation and again open it and set it back to no cash. Then it starts working as expected. Did anyone come accross this kind of issue? is the some standard that I have to follow to make sure this doesnot happen again  

restore log issue while doing the logshipping

We have a database for logshipping, recently we have the following issue which is the restore log job failed in the standby mode database. We uncommonly encounter such issues, and search the answer on the internet with no answers. Can anyone help ? Following is the issue with the details: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3142: [Microsoft][ODBC SQL Server Driver][SQL Server]File 'oadb_Log' cannot be restored over the existing 'F:\MSSQL\LOG\oadb_log.ldf'. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.happyMan

How do you update a Lookup Field from CAML by Name rather than ID

Hi, I have the following batch update in my code: xml += "<Method ID='" + currentID + "' Cmd='Update'>"; xml +=   "<Field Name='ID'>" + ID + "</Field>"; xml +=   "<Field Name='FileRef'>" + fileRef + "</Field>"; xml +=   "<Field Name='Title'>" + doc.NewFileName + "</Field>"; xml += "<Field Name='Keywords'>" + doc.Keywords + "</Field>"; xml +=   "<Field Name='Select_x0020_Type'>" + ((doc.TypeName == "General") ? 1 : 2) + "</Field>"; xml +=   "<Field Name='Population'>" + "Demography" + "</Field>"; xml += "</Method>"; The Population field is a lookup. It works if I put the ID of the ListItem in there, but not if I put the name - I need to put the name in. Can anyone help? Thanks. John.  

DataView WebPart with lookup and person field

Hi I want to insert a dataview webpart, using REST, referring to a list with look-up fields and people fields. The results I receive are the ID's instead of the values. How can I get back the corresponding values? TIA Sjokke

WSS Lists - Lookup field information missing in Excel 2010

Hi, I've got this xls workbook which contains a two-way synchronized SharePoint list. This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source. In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in this combobox and synchronizing. This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell isn't among available values. Is there something special I should do to enable this feature in Excel 2010? Regards, Carl 

SharePoint Designer 2007 Workflow needs to initialize lookup field value and store it

This is for a governance tracking list. I have two tables: Roadmap and Roadmap Status In Roadmap, there are two fields of interest that are lookup fields to Roadmap Status:Title they are Status and OldStatus When an item is entered in Roadmap, I want to force the initial Status to "Submit" from Roadmap Status. I don't see any way in my workflow to to lookup that item in Roadmap Status and place the pointer (I'm assuming it is a GUID) into the field. The value is also stored in OldStatus to catch changes as I'm trying to force order of status in a few cases but not all. I'm doing it with a Lookup instead of Choice because the business tends to change the terminology they like and this way I don't change it in several places plus it allows them to change it in the list instead of someone changing the list field values. I've seen several places on the forum where people have a similar problem and Lambert Qin has given an answer but it never fits this scenario exactly. Do I have to go back to Choice columns? I only have Designer and would rather not have to learn another tool for a simple SharePoint implementation. Thanks for any help!

lookup error o/p exel issue

I created one ssis package ,I configure lookup error o/p and provided exel destination .When I am running package again and again ,the error row is adding in exel destination file .I want different exel file whenever I run the package.Thanks

Lookup field with drop downs

Hi, I have created a lookup called projectname in a list called status. This projectname selects it's value from the project list. There are 2 fields on this list that are drop down list of values that I want to appear in the status list as lookups based on the projectname. However any special field types such as person or drop down list don't seem to appear, it looks like you can only show the related text fields? Is there anyway around this? Many Thanks, Michael  

Relation List Lookup Issue

Hi, I have 2 lists that are related. List 1 - costs ----- cost - Number quarter - Drop Down Created By - Default SP Field List 2 - people ----- person - User/Group AD Lookup team - drop down I am trying to link these 2 lists so I can retrieve the users team from the people list in a view for the costs. I have tried making it so the user has manually select their name for each cost (instead of using the Created By field), but when I try to make this value a lookup it doesn't allow me to select the person or team field from the people list? Does a lookup only allow you to lookup text values and is there a work around? Many Thanks, Michael

Sharepoint Designer restore issue or perhaps BPOS permissions issue


Trying to use Sharepoint Designer 2007 SP2 to backup and restore site to BPOS. Backup works fine, restore uploads all .cmp files and then comes with an error "Operator does not have web administrator access to import location".

Any ideas ?

Restore Site Collection on a Different Farm with Taxonomy Field



I am trying to restore a site collection from my production environment into a staging environment (completely separate farm).  However, my site collection contains a Pages library which has a taxonomy field that points to a Managed Metadata Service term store in the production environment.  When the site collection is restored in the staging environment, the items in the Pages library have invalid content in the taxonomy field.  Ie. The values are there, but when I try and edit an item, the values in the picker are invalid. 

I have imported the same term set in the term store in the staging environment but it still doesn't work.  I am assuming it is because all of the terms have different guids in each environment so the values are not 'synching' up properly... 

Can I restore the Managed Metedata Service application from my production environment into my staging environment?  Or, am I going about this process in the wrong way entirely?

Thank you for any advice.


SSRS 2005 Render Format Excel Issue with Time Field


I have a report that uses a datetime field but gets populated only with the time. So, in SQL db, it gets stored with a default date value of 1899-12-30 12:01:01 with the correct time filled in. Report in SSRS Preview mode displays the value just fine when I use the Time format in Layout mode. I build and deploy and able to view the report in a web browser with no problem displaying the time field. But when I subscribe to the report and choose Excel render format, when I open up the Excel file from the email that was sent, I get negative decimal values. I have tried every possible Time format in SSRS but I get the same result. I also tried just the default and still gives me negative decimal values that show up as ####### in Excel.

Any help will be greatly appreciated. Thanks

Issue in Look up field in SPD workflow


I have created a workflow in my task list. I have also created another SharePoint List known as "Leave Application" which is a forms library. Now i want to use 2 fields from "Leave Application" list to the task list. 

I am using SharePoint Designer to create my workflow. I want to extract two fields from my "Leave Application" list to task list so that i can show these fields in my task view.

How to do that? In task list, i am only able to see the columns which i created in task list. But what if i want to use 2 columns from some other list in to the task list so that task list can get the same values for those fields or columns when the user fills leave application form.

Also in the action "Collect Data from a User", if i want to add fields from other list then how to do that?

Can anyone help me in this?


lookup field list instance



Got and problem with and lookupfield I create some list instances, list definitions, content types with a lookupfields and all works fine  the list resovels the good list source guid so I can selected te values but when I try to save I get;

<nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only.

When I manualy create a new list instance from the list definition everything works fine.
I'm guessing that the create list instances in the feature is causing the problem?

What am I doing wrong?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend