http://www.sharepointforums.org/forums/ For SharePoint 2007 (MOSS) / WSS 3.0 installation and configuration discussions. en Tue, 07 Sep 2010 23:44:16 GMT vBulletin 60 http://www.sharepointforums.org/forums/images/misc/rss.jpg http://www.sharepointforums.org/forums/ http://www.sharepointforums.org/forums/moss-installation-configuration/3629-not-all-lookup-fields-updated-when-synchronizing-ms-access.html Sun, 29 Aug 2010 19:14:47 GMT I have an MS-Access database with links to SharePoint lists. The lookup fields are not all updated when I synchronize after I create records offline... I have an MS-Access database with links to SharePoint lists. The lookup fields are not all updated when I synchronize after I create records offline . I built a test with the following result:

* I created 4 SharePoint lists A, B, C, D. C has a lookup to A and one to B and D has a lookup to A
* I created an MS-Access database with links to A, B, C,
* I created a record in A (ID=-1), in B (ID=-1) and in C (pointing to A=-1 and B=-1)
* I synchronized
* Now all ID's are correct: A and B got ID=1, C points to A (ID=1) and B (ID=1)
* However, when I add D, make D point to A (ID=-1) and repeat the steps above the pointer in D is not updated, but remains -1. A, B and C are updated correctly.

Is this a Sharepoint/Access limitation or is there a way to resolve it?

Thanks a lot for any help. ]]> MOSS Installation / Configuration JanVanBekkum http://www.sharepointforums.org/forums/moss-installation-configuration/3629-not-all-lookup-fields-updated-when-synchronizing-ms-access.html http://www.sharepointforums.org/forums/moss-installation-configuration/3587-sharepoint-down-after-failed-sp-2-install-2007-a.html Sat, 21 Aug 2010 00:36:32 GMT Recently, i tried to install Sharepoint Services 3.0 SP2 & Sharepoint Server 2007 SP2. Sharepoint Services 3.0 sp2 install failed.
I got this error:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Topology
Event ID: 5617
Date: 8/20/2010
Time: 4:02:03 PM
User: N/A
Computer: webserver
Description:
The schema version (3.0.149.0) of the database dbname on dbserver is not consistent with the expected database schema version (3.1.8.0) on websesrver. Connections to this database from this server have been blocked to avoid data loss. Upgrade the web front end or the content database to ensure that these versions match.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I then tried the following:

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>psco
nfig -cmd upgrade -inplace b2b -wait -force
SharePoint Products and Technologies Configuration Wizard version 12.0.6413.1000
Copyright (C) Microsoft Corporation 2005. All rights reserved.

Performing configuration task 1 of 4
Initializing SharePoint Products and Technologies upgrade...

Failed to initialize SharePoint Products and Technologies upgrade.

An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSe tupConfig
urationTaskException was thrown. Additional exception information: The initiali
ze command is invalid or a failure has been encountered.
Unable to upgrade SharePoint Products and Technologies because an upgrade is alr
eady in progress. Upgrade progress can be monitored using the Central Administr
ation Web Application or by monitoring the upgrade log on server.

Total number of configuration settings run: 1
Total number of successful configuration settings: 0
Total number of unsuccessful configuration settings: 3
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed. Configuration mus
t be performed before you use SharePoint Products and Technologies. For further
details, see the diagnostic log located at D:\SharePointLogs\PSCDiagnostics_8_2
0_2010_18_44_0_785_352064456.log and the application event log.

I was given this advice:
"Disconnect the dbs from the WebApp using the stsadm -o deletecontentdbs, then complete the upgrade by running psconfig –cmd upgrade –inplace b2b -wait. if you need to list the dbs first run stsadm -o enumcontentdbs... Once the the Uprade is complete reattach the DBs using stsadm -o addcontentdbs and the dbs will be upgraded to the new schema..."

I disconnected the databases and the upgrade completed successfully, but now when I try to reconnect the databases using the addcontentdb command I get the following errors:
Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 3759
Date: 8/20/2010
Time: 7:34:49 PM
User: N/A
Computer: webserver
Description:
Database 'database' on SQL Server instance 'dbserver' is not empty and does not match current database schema.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
and:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o addcontentdb -url siteurl -databasename dbname

dbname on dbserver contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.


Please, I am not finding anything on how to fix this and need to try to get it running by monday. Thanks ahead of time. ]]> MOSS Installation / Configuration chriswebb18 http://www.sharepointforums.org/forums/moss-installation-configuration/3587-sharepoint-down-after-failed-sp-2-install-2007-a.html