Content Database Migration Error: Cannot insert NULL into RoleID

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Portal Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - SPS Portal restore to new Farm.. Hello - i'm hoping someone can help with this problem. We are replicating our sharepoint infrastructure onto 2 new farms (the company is demergin so we need to create 2 new environments for everything we have!). Currently we have 2 farms that either host sharepoint sites for internal users (e.g. company intranet) or external users (e.g. collaboration sites). The Farms are setup as: 2 x Web Servers (WSS 2.0 & SPS 2003) 1 x Job & Index Server (WSS 2.0 & SPS 2003) 1 x SQL Server (SQL Server 2000). The 2 new companies will have 1 Farm with all the sites consolidated into it. Don't ask why there are 2 farms currently - it was inherited! Anyway, i am using the SPS Backup and Restore Utility to backup portals and restore. Everything works as expected for Portals backed up from the internal farm but not for the external farm. On restoring a portal we receive the following errors: In SPS Backup & Restore Utility following message is displayed, usually about 35% through the restore: "Error: The site database specified is already in use by another component of the farm". The popup box also says to consult the database servers event log. The SQL Server eventlog has the following entry: "Recovery is checkpointing database 'Projects1_SITE'." The SQL Activity logs has an entry that says: "Bypassing recovery for database 'Projects1_SITE' because it is marked IN LOAD." Followed by: "Recovery is checkpointing database 'Projects_SITE' (18)" I have seen posts that say to do the restore with the NORECOVERY switch but i don't see where to specify that using the SPS Backup & Restore Utility. Any advice would be greatly appreciated. Thanks, Oli. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99693
  - 2
    - Moss 2007 Active Directory/LDAP with SSL Configuration Issue Hi all, I tried to setup moss 2007 form based authentication against Active Directory with AD/LDAP Membership Provider. However, I tried for the last 5 days to figure out what's wrong with the setup but no luck. Could anyone tell me what could be wrong with the setup? Here is what I did 1. Create web application to host https://extranet.acme.com with "default zone" and use form with either AD/LDAP Membership Provider so external users login with their internal NT Account or Email (BTW I used SSL 128 bit) 2. Extend the above web application to host intranet http://intranet with "Intranet zone" 3. Modify web.config of both Central Administration and extranet 4.Here is partial of web.config file that show connection and membership //AD Membership Provider <connectionStrings> <add name="ADConnection" connectionString="LDAP://server1.acme.com/ CN=Users,DC=acme,DC=com" /> </connectionStrings> <membership defaultProvider="ADProviderService"> <providers> <add name="ADProviderService" type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="ADConnection" connectionUsername="acme\app_account" connectionPassword="abc123"/> </providers> </membership> //LDAP Membership Provider <membership> <providers> <add name="ADProviderService" type="Microsoft.Office.Server.Security.LDAPMembershipProvider, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" server="server1.acme.com" port="389" useSSL="true" userDNAttribute="distinguishedName" userNameAttribute="sAMAccountName" userContainer="OU=Users,OU=Dener,DC=acme,DC=com" userObjectClass="person" userFilter="(|(ObjectCategory=group) (ObjectClass=person))" scope="Subtree" otherRequiredUserAttributes="sn,givenname,cn" /> </providers> </membership> When I try AD Membership Provider and login to the form with either email or nt account, I got the following sign in form error "The server could not sign you in. Make sure your user name and password are correct, and then try again." Then I take a look at the server event viewer, I got the following error Event Type: Information Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1315 Date: 5/1/2008 Time: 12:40:27 AM User: N/A Computer: MYSERVER Description: Event code: 4006 Event message: Membership credential verification failed. Event time: 5/1/2008 12:40:27 AM Event time (UTC): 5/1/2008 7:40:27 AM Event ID: 5ed5b12b0e7c491fb4962f07827ac9f3 Event sequence: 4 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/918023365/ Root-1-128541012094024926 Trust level: WSS_Minimal Application Virtual Path: / Application Path: C:\Inetpub\wwwroot \wss\VirtualDirectories\extranet.acme.com80\ Machine name: MYSERVER Process information: Process ID: 3824 Process name: w3wp.exe Account name: acme\app_account Request information: Request URL: https://extreanet.acme.com:443/_layouts/login.aspx?ReturnUrl=Membership credential verification failed.f_layoutsMembership credential verification failed.fAuthenticate.aspx5/1/2008 12:40:27 AMfSource5/1/2008 12:40:27 AMd%252f&Source=Membership credential verification failed.f Request path: /_layouts/login.aspx User host address: 10.247.229.41 User: Is authenticated: False Authentication Type: Thread account name: MYSERVER \IUSR_FLATFILE Name to authenticate: john.doen@acme.com Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. After the above AD membership provider failed, I then try to use LDAP Membership Provider and I still get the same sign in form error above. There was no server error in the event viewer. For both provider, I try to look up user in people picker Ex: ADProviderService:jonh.doe@acme.com, but I could not find any of them I checked membership/connection string syntax many times and could not find anything wrong. I search on the internet and found several threads about above issues and followed those instructions, but no luck. Here is some of the threads that I found http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2337663&SiteID=1 http://www.setfocus.com/technicalarticles/nickkellett/MOSS2007-and-Novell-LDAP-Authentication_pg1.aspx http://blogs.msdn.com/harsh/archive/2007/01/10/forms-based-authentication-in-moss.aspx http://blogs.infosupport.com/porint/archive/2007/05/07/Step_2D00_by_2D00_Step-guide_2C00_-installing-AD-Provider-on-WSS-v3.aspx http://jasonflowers2k.spaces.live.com/blog/cns!1889117EF017B979!118.entry Thanks all Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99690
  - 3
    - Creating users I would like to create some new SharePoint users. My sys admin told me that he cannot create them in the AD. The goal is to test the audience with some fake users and to give a demo to someone logging in from a VPN. Optimally, our client will will log in as himself (SP Site Collection admin) through a VPN and connect to SharePoin to see some functionality (always as himself), and then log in as different users (IndiaUser, MexicoUser) throught the menu option "Sign me in as a differnt user" to view the audience functionality. How can I arrange this from SharePoint? It seems it will only accept domain users. I'm relatively new to SharePoint and cannot find info on this topic anywhere. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99686
  - 4
    - Problem with sharepoint intermittently not saving changes. We are experiencing a problem with Sharepoint intermittently not saving changes made to word documents & excel spreadsheets in document libraries and also when opening a document or spreadsheet it will intermittently open read-only (The file is always opened for editing in the native application.) Sharepoint allows you to edit a file, make changes and then save, but when it is reopened the changes have disappeared. This happens from multiple workstations running XP (SP2) & Office 2003 (SP2 & SP3) and on multiple documents and spreadsheets and is occuring on the Portal and within WSS. We have 2 sharepoint servers one Live and one Development and we are experiencing the same problem on both server, here are the configuration details: Devsharepoint01 - Development server Windows server 2003 Std + SP2 Sharepoint 2003 + SP3 Using local MSDE ( 8.00.2039 ) Sharepoint01 - Live server Windows server 2003 Std + SP1 Sharepoint 2003 + SP2 Using SQL Server 2005 x64 SP2 on a separate server ( Windows 2003 Std x64 Edition + SP1) Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99684
  - 5
    - Boxed View Style Hi When I create a new view on the contacts list using the Boxed Style, SharePoint 2007 includes the column headings horizontally at the top of the view. This doesn't make sense as the Boxed View pivots the data row to display it vertically and column headings can be included as labels. I've checked the behaviour on SP 2003 and it does not include the column heading, in other words this works as you would expect it to in 2003 but not in 2007. Any ideas? Is there a way to suppress the display of column headings when displaying lists via a web part? Cheers Doug Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99682
  - 6
    - MOSS 2007-Search Crawl Errrors: Error in Site Data Web Service. (Invalide High Surrogate Character...) I have a MOSS 2007 Sharepoint site setup with several document libraries with several thousand documents. Running Windows Server 2003, WSS3 SP1, and OfficeServers SP1. One of my document libraires, and several folders in another document library thrown errors in the crawler like the following: (and subsequently none of the files in the library, or the folders beneath are returned in search results): --Error Text--------------------------------------------------- http://internalsite/library..ms/simpleview.aspx Error in the Site Data Web Service. (Invalid high surrogate character (0xDE94). A high surrogate character must have a value from range (0xD800 - 0xDBFF).) ---------------------------------------------------------------- The Hex code in the error seems to vary - also get: 0xDD00 0xDED0 0XDE50 on and on The ASPX page of the view in question shows up in search results, but none of the documents inside the library or folder show up in search results. Any advice is appreciated. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99677
  - 7
    - how to get top 10 search results! Hi, Im working with MOSS 2007. Im finding some problem with search feature. Actually I need to get the top 10 searched documents from the portal I am working for. Can u suggestion me any solution and send me the dot net code it will require. And also information like how to implement the scope feature into it. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99671
  - 8
    - List Search Result Incorrect Hi Folks, In regards to MOSS search: For some reason when I search for a list item, the returned URL is incorrect. Instead of returning a url with the appropriate http://site.com/Lists/ListName/DispForm.aspx?ID=2, I get the following type of URL: http://site.com/Lists/ListName/3_.000 I have checked the crawl account and recreated the search indexes. I have also setup the query and indexes on the same server and rather than on two different servers. It just seems to be the lists, all other types are searched correctly. Am I missing a setting somewhere? Thanks, -Alan L Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99665
  - 9
    - SharePoint Upgrade Help Needed Hi all, I amhaving a single server implementation of SPS 2003 SP3, Sql 2000....everything in one box. I am moving to new hardware, which will be a full fledge server farm with web servers, application servers and sql servers all separated. I do not want to use database migration technique, since ultimately it would be an in place upgrade, and if some sites are not properly upgraded, there is no going back...yea I understand that I will have the original environment intact as a back up....but how would I deal with a site which is not properly upgraded in the new environment, given there is no going back option. (Am I right, wrong, there is a work around, anything). So, currently, I plan to run the gradual upgrade on my current single server implementation. Once upgraded, I intend to move everything from it to the new full fledge farm implementation. (Later, we will retire this server). (Is this approach correct, incorrect, your suggestions) Now can I do anything of the following and which is correct, best, or anything that you suggest: Backup the whole portal (on my single server implementation) and restore it to the new farm. And Im done. New farm will have two web servers, two app servers and sql cluster. The new farm is configured independently of the old single server implementation. (I wonder if this is even possible?) OR, I should use attach/detach to move the sql server components to new Sql cluster. And then move the web server components to new web servers. And then configure the app servers. And all that is done manually. (Am I actually talking about database migration technique but doing it after the upgrade?) Portal currently in use is not highly customized, may be a few frontpage customizations. 500 to 800 users. No custom webparts. One main level portal. 150 to 200 sites. 50+- subsites. Please note that doing the gradual upgrade on the current server is what I HAVE to do, officially. Anything totally different that you wanna suggest is most welcome. Best regards, Rehman Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99655
  - 10
    - (MOSS 2007/WSS3) Question about AUTHOR Property: Why can't I edit it? Ok here's a strange one. I've got a vanilla Document library in a MOSS 2007 site. I add the AUTHOR site column to it and upload several WORD documents (both 2003 adn 2007). The Author comes into the field as expected; however I cannot EDIT it using the Edit Properties option int he doc library. In Word 2007 I can go into the (Office Icon)-->Preapre-->Properties window and I see 3 optoins: -Document Properites -Document Properites - Server -Advanced Properties If I EDIT the "_Author" property under Advanced Properties, I can change the Author that shows up in sharepoint. Editing either of the other 2 doesn't change it. And I just noticed that editing the Author on the site in Edit-Properties actually edits the Documents properties, but the site still only shows the _Author property. Driving me nuts...any advice is greatly appreciated. regards, -h.liles Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99654
  - 11
    - Organization Hierarchy in my site dose not update hi... i have a problem when i change user properties in Active Ditectory for example in organization tab ( tile, manager and ...) , in my site at sharepoint portal dose not update . wha is solution? or how can i synchronize my site with AD? please help me? Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99651
  - 12
    - Alerts and timezone When alerts are created, is the timezone included in the definition? Is it possible to exclude this? Users who created an alert during the winterperiod (CET), is now getting the alert an hour too late.. (CEST).. If possible, then how? Thanks, SL. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99650
  - 13
    - Sharepoint search issue after SP1 We have 2 WFE (with WNLB) and 1 indexquery server Once we upgraded to SP1 the Office SharePoint Server Search cannot be started from the index server anymore, it gives the error message "An unhandled exception occurred in the user interface.Exception Information: Unable to connect to the remote server ". Try to do enumservices on the server nad it gives the following: <Services> <Service> <Type>Microsoft.SharePoint.Administration.SPWebService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Windows SharePoint Services Web Application</ DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPWebService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>WSS_Administration</Name> <DisplayName>Central Administration</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.OfficeServerService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>SSP Job Control Service</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPAdministrationService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPAdmin</Name> <DisplayName>Windows SharePoint Services Administration</ DisplayName> <Status /> </Service> <Service> <Type>Microsoft.Office.Server.Administration.AnalyticsService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Office SharePoint Usage Analytics Service</ DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.SharePoint.Portal.Administration.PortalService, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Portal Service</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.ApplicationRegistryService, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>ApplicationRegistryService</Name> <DisplayName>Business Data Catalog</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.JobSchedulerService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Shared Services Timer</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Search.Administration.SearchService, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>OSearch</Name> <DisplayName>Office SharePoint Server Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Search.Administration.SearchService, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>OSearch</Name> <DisplayName>Office SharePoint Server Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPTimerService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPTimerV3</Name> <DisplayName>Windows SharePoint Services Timer</DisplayName> <Status /> </Service> <Service> <Type>Microsoft.Office.Excel.Server.ExcelServerSharedWebService, Microsoft.Office.Excel.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Excel Calculation Services</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.SharePoint.Portal.Administration.SsoService, Microsoft.SharePoint.Portal.SingleSignon, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SSOSRV</Name> <DisplayName>Single Sign-on Service</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Search.Administration.SearchAdminSharedWebService, Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SearchAdminSharedWebService</Name> <DisplayName>Office SharePoint Server Search Admin Web Service</ DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Search.Administration.SPSearchService, Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPSearch</Name> <DisplayName>Windows SharePoint Services Help Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.SharePoint.Search.Administration.SPSearchService, Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>SPSearch</Name> <DisplayName>Windows SharePoint Services Help Search</DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Conversions.LauncherService, Microsoft.Office.Server.Conversions, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>DCLauncher</Name> <DisplayName>Document Conversions Launcher Service</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.Office.Server.Conversions.LoadBalancerService, Microsoft.Office.Server.Conversions, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>DCLoadBalancer</Name> <DisplayName>Document Conversions Load Balancer Service</ DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.Office.RecordsManagement.Internal.PolicyConfigService, Microsoft.Office.Policy, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name>PolicyConfigService</Name> <DisplayName>Microsoft.Office.RecordsManagement.Internal.PolicyConfigService</ DisplayName> <Status>Online</Status> </Service> <Service> <Type>Microsoft.Office.Server.Administration.SessionStateService, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Session State Service</DisplayName> <Status>Disabled</Status> </Service> <Service> <Type>Microsoft.SharePoint.Administration.SPIncomingEmailService, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type> <Name /> <DisplayName>Windows SharePoint Services Incoming E-Mail</ DisplayName> <Status>Online</Status> </Service> </Services> Not sure why there is teo osearch there. Does anyone have any idea to resolve this search problem? Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99649
  - 14
    - Is there a way let anonymous users add attachemnts Hi guys, Is there a way let anonymous users add attachemnts while they adding items into a list? Br, Alan Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99648
  - 15
    - How to accomplish this goal? Hi guys, We would like to add a custom list in Sharepoint site. And only let a specific group users add item, but can not view those items. I've tried the approach below. Create 2 lists(list a and list b) with same columns. give the specific group users contribute permission on list a, but no access on list b. And develop an event handler on list a's itemadded event. When one item was added in list a, copy it to list b then delete it from list a. Unfortunately, I found the event handler did NOT work for the specific group users. Only work for the group users who have access on list b. Do you have any good ideas? Br, Alan Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99645
  - 16
    - How to create new WSS sites in newly upgraded MOSS 2007 installati I recently upgraded my SPS 2003 to MOSS 2007 and all is running well. Back in the SPS 2003 world, I had some WSS sites that I had created under a special, separate url, http://wss/sites This helped me stay organized. After the upgrade, there's an app called WSS and it's for the http://wss. I can't figure out how to create new WSS sites user the http://wss/sites path. Does anyone have any idea? -- Sandy Wood Orange County District Attorney Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99640
  - 17
    - Configure top nav to display sub folders in drop down? Hi, I'd like to configure my top nav bar to show drop downs for each sub folder created in the document libraries linked to the tabs. I know we can configure the drop downs to display sub sites and pages, but can they be configured to dynamically show sub folders under document libraries? Thank You Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99639
  - 18
    - Sharepoint not a valid user error hello, I have the following problem with MOSS Enterprise, this problem ocurrs every minute and I don't know how I can resolve it, please help me. Event Type: Error Event Source: Office SharePoint Server Event Category: General de Office Server Event ID: 7888 Date: 4/24/2008 Time: 12:59:51 PM User: N/A Computer: SHRPOINTSRV Description: Se ha detectado una excepciÃ³n en tiempo de ejecuciÃ³n. Detalles. Mensaje: 'sharepointuser' is not a valid Windows NT name. Give the complete name: <domain\username>. Detalles tÃ©cnicos: System.Data.SqlClient.SqlException: 'sharepointuser' is not a valid Windows NT name. Give the complete name: <domain\username>. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.Data.SqlServerManager.GrantLogin(String user) at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeConfigurationDatabaseAccess(SharedComponentSecurity security) at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity) at Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Synchronize() Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99635
  - 19
    - Forefront Databases on Server with MOSS 2007 I am trying to setup my forefront databases with the reporting on the same SQL server that our MOSS installation is on. I keep running into problems with the reporting website on my Forefront installation. Are there special conciderations I need to take when installing Forefront Client Security on the same server with MOSS or is it even supported? Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99634
  - 20
    - SharePoint Connectors (Protocol Handlers) I'm giving away my SharePoint connector framework (Protocol Handler.NET) for free. You can develop protocol handlers and ifilters with .NET to connect to any system to index data and documents and make available through search. Sample code and documentation included. Just go to http://www.fastsharepoint.com/products.aspx to download. Chris www.fastsharepoint.com Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99633
  - 21
    - MOSS 2007 Excel Web Access Web Part Hello, Can you anyone advise if the MOSS 2007 Excel Web Access Web Part is compatible with MS Office Excel 2003. When we add the Excel Webpart and attempt to display a workbook we are presented with the following error message. "An error has occurred, Please contact your system administrator if this problem persists" Can anyone suggest where we should look to troubleshoot the problem. Thank you. Samir Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99632
  - 22
    - companyweb intranet site savings doc isssue Windows 2003 SBS have a companyweb intranet site users set up word documents... other users edit the documents using word XP. Changes are often not saves unless the user chooses save as and even then they sometimes have to save the document twice to get the changes to appear... anyone have any ideas... the save fucntionality works perfectly fine with Excel XP. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99631
  - 23
    - Get SharePoint Email Enabled Doc Library to Store Messages as MSG We have a large (20 GB +) set of Public Folders on Exchange 2000. We migrate all the closed PF to MOSS 2K7 using Quest's Public Folder Migrator. We were all ready to go live and move production data, when we saw the behavior of new email messages sent to them. Has anyone else seen this problem and found a solution? I'd be willing to look at another 3rd Party tool of it could get us over this hump quickly. It really seems like it should be a no-brainer given that the tool is meant to integrate with Exchange and Outlook. Sincerely, Bill Teeple System Administrator Minnetronix Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99630
  - 24
    - Is it possible Single Sign-on between two sharepoint sites I have 2 sharepoint applications in my web server ( First application is called A and the second application is called B). Both applications (A+B) are working absolutely fine without any issues. When we browse the web site A it asks for authentication and once the credentials are provided, I get access to the web site. This is the same case with Application B. There is a link in sharepoint application A to sharepoint application B. When we follow the link, the authentication popup appears again=85.Is there any way with which we can avoid the second authentication popup. Any possible help/links in this will be greatly appreciated. Thanks and Regards Sreejesh Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99624
  - 25
    - Exam Module in SharePoint?? Hi All, I need to display a page which shows questions and answers(radio button/dropdown). When the user clicks done, I want the score to be calculated based on a predefined weightages for each answer. How can this be done without coding? I can utmost use SharePoint Designer. Please provide your inputs... Thanks and Regards, Mahesh. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99621
- Next
  - 1
    - MOSS 2007 Site Content not appearing After adding a SP Portal 2003 db to a MOSS 2007 application via sts (see below) I am unable to see any content from the db. The problem is when I am looking at the db I see in dbo.alldocs there are some 27000 items both the site version (12.0.0.6219) and BitFlags (262144) are correct but no data. STSADM Command: stsadm -o addcontentdb -url http://blah-web:24146 -databasename dbblahSITE -datbaseserver There was no customization in the templates, no web parts... this was just a straight forward SPS 2003 site that was pre=scan based on the version number. I'm at a loss and spent some time on the phone with Microsoft... One tech asked me what WSS stood for, not feeling too confident in them.... Any ideas would be appreciated Just to summarize... I connected a prescanned SPS2003 to a MOSS 2007 site / web application not being used by anything else. I am unable to see any of the content that should be there with the exception of the site structure, links, sub sites. This was out of the box with no parts or customization. I can see the content in the db... How do I now get his content viewable in the site again. Bad part... There are no backups before the site was upgraded to the MOSS / WSS 30 schema. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99619
  - 2
    - Re: lock file error I'm having the same issue, and I'm running Office 2007/Vista. I tried disabling IPv6 as well and that seemed to help a little, but I'm still getting the same "unable to lock file" error. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99618
  - 3
    - Login Issue We just deployed MOSS 2007, and we have the following issue: Sally logs in to her computer at startup as Sally. Sally enters her SharePoint portal home URL and is automatically logged in as Administrator (Sally has access to both accounts as she is also the SP Admin.) Sally clicks on "Sign in as Different User" and signs in as Sally. Sally clicks on "My Site" and is taken to the Administrator's My Site instead of Sally's My Site. How can we make it so that Sally logs in automatically as Sally, not the administrator? Any help would be greatly appreciated. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99615
  - 4
    - Is this even possible Hi All, Got a question i am planning to create a AD SharePoint install to our production domain my main issue is that i will be using stored procedures based on AD information. I am wondering if it's possible to use data view webparts with a stored procedure passing the Office and say the department fields to the stored procedure??? Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99608
  - 5
    - Great Indian Developer Awards 2008 Vote for your favorite trailblazing individuals & products in the IT Developer ecosystem and win exciting prizes! Prizes include: Apple Mac Air Book, 26" PLASMA TV, NOKIA95 8 GB, APPLE iPOD 80Gb, ZEST HOLIDAYS, GIDS GOODIES. The Great Indian Developer Awards is a first-of-its-kind initiative that honors individual & organisational excellence in the IT Developer ecosystem. Just click and cast your vote. With over 15 categories & a distinguished independent jury, who knows... it could be your colleague, company or product that will emerge triumphant. And you get to go home with cool goodies as well! Hurry! Click here to vote for the Great Indian Developer Awards: http://www.developersummit.com/awards.html#vote Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99606
  - 6
    - Corrupted PDF files when dragging and dropping to a mapped drive I have a user who maps drives to his document libraries. Occasionally after dragging and dropping a PDF file into a doc library mapped drive, the file will become corrupted. When users download the file Adobe fails to open the file and says the file is corrupted. However, when the user uploads the same problem files via the SharePoint site upload feature, the file goes up there clean. Mapped drive funcionality is a must for this user as he enjoys the convenience of working from his file explorer and not have to browse through the SharePoint site interface. Does anyone have any idea why dragging and dropping in this manner causes certain PDF files to corrupt? He is currently trying to pinpoint a common factor between the problem PDF's. I will post again if he comes up with anything. Thanks, Alex Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99599
  - 7
    - list item access Hi. I have a Document Library with list item access (permissions set to each item on the DL). If a user sees a Document Library View or a Web Part not filtered by anything (with all items), then that user only sees the documents that he has permission to read =96 this a correct behavior, as I think. If the view has any kind of filter, like items added today, for example, the user sees a list with all documents added today even if he does not have access to read them (if he clicks on a document a message saying that he has no permission shows up). If the user sets an =93alert=94 on that list, he will be informed on any change in any document, even if he doesn=92t access to it (again, if he clicks on the document link, inside the email, a message saying that he doesn=92t have access to the document shows up). Is this the default behavior? Is there anything I can do to change these 2 behaviors? i.e. users only sees in any situation, and is only alerted on documents he has access? Thanks. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99598
  - 8
    - How to combine tasks lists into a single tasks list? I have a list of projects and for each of them an attached workspace. In these workspaces, tasks lists. How can I have a single tasks list showing all current tasks from all these workspaces? Thanks. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99587
  - 9
    - "Error Access denied" to site We have the weirdest thing just happen with our install of MOSS and it has stumped us all. Under our Ops department site, we have 3 sub sites for Admin, Frontline and 3rd Line. Admin and 3rd Line are fine, but no-one other than the 2 SharePoint admin accounts can access Frontline. The error is the standard "Access Denied" message that you would get if you didn't have permissions to the site, but the site is using inherited permissions, so exactly the same as the parent Ops site and the 2 sibling sites, but nothing. We have done everything that we can think of bar recreating the site, so hoping that someone might be able to save us before we have to resort to this ... Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99581
  - 10
    - Using dates in the fixed keyword query I am using fixed keyword query in the search core results webpart to view documents modified in the last 30 days. The fixed keyword query does not give any results when queried on date say Modified Date: [Today]-30. It does not even work for any other date related query like Modified Date:"Today" or Modified Date:"4/21/2007" or Modified Date:4/21/2007. Does anyone know how to filter on dates in search core results web part? Thanks, Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99578
  - 11
    - Worflow looping endlessly Hin I have this simple workflow which looks if a user sets a task as modified and assigns the current date to the date modified field... nothing exceptional... The problem is the workflow loops endlessly because I guess, each time the today's date is set by the workflow, the worflow thinks the record is modified and launch itself again... What't the logic? How to put and end to that nonsense? Thanks! Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99577
  - 12
    - How to add date fields in the scope rules (property restrictions) Hi, I am trying to add property restrictions on date field of a rule in scopes in the central administration (in the search settings). Modified=[Today] and created = 4/4/2008 throws error and there are no results for this query. But if I use Author=admin in the property restriction, it works. How can I set property restrictions on date fields? I basically need to use [Today] in the properties restriction query. Thanks. Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99574
  - 13
    - Server Application Unavailable - Sharepoint 2003 error Hi All, Whenever I try to open either my portal home page or central administration page I am getting the below error Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. I am working in Sharepoint 2003,windows server 2003 - Service Pack 2, IIS 6.0 environment. I checked the IIS and all the application pools mappings are fine with the virtual directories. Can anyone please sugest the work around for this problem. Thanks Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99572
  - 14
    - How to show the Supplier Address Hi all expert, I have create a List named as Supplier. In the list got 3 fields - Supplier Code, Supplier Name, Address. I have save few supplier record in the list. After that, i create a new List called as Product Supplier. In the list got some fields such as - Product Code, Product Name, Price, Supplier Name, Address. Product Code and Product Name are blank fields, but the Supplier Name is a drop down list and will shown the Supplier Name from the Supplier List. It's work fine. But i facing a problem to show the Supplier Address after i select the supplier in the Supplier Name drop down list. Mean if i select Supplier Name - ABC, then i want the Supplier Address show the ABC company address in another address label in row below the Supplier Name. Can anyone tell me, is it this problem can be solve? What is the step i need to do for this problem? Thanks in advance for your kindy help... Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99570
  - 15
    - Wss 3.0 SP1 install using SQL 2005: collation problem? I am trying to install SharePoint Services 3.0 SP1 to use our SQL 2005 server but SharePoint complains about the collation. I cannot reinstall SQL and change the server's collation since the server has other applications using it in production If I run the configuration wizard it has an error: The SQL Server collation on SQL Server instance 'sqlserverX' is not supported. Windows SharePoint Services requires a Latin1 General dictionary order, case insensitive, accent sensitive, kana sensitive, and width sensitive collation (SQL_Latin1_General_*_CI_AS) If I follow the DBA created databases instructions from page 42 in this MS document (http://go.microsoft.com/fwlink/?LinkID=115666) and create the db's with the proper collation, when I run the psconfig command it fails with a similiar message: Command: "psconfig.exe -cmd configdb -create -server sqlserverX\instanceY -database sp_config user sharepoint_services -password sharepointpass -admincontentdatabase sp_admin" Error: "An exception of type Microsoft.SharePoint.SPException was thrown. Additional exception information: The specified SQL server instance has invalid sort order Latin1_General_BIN. Choose a server instance that performs case-insensitive and non-binary comparisons." Is there a way to tell Sharepoint to use the db we have already created or some other way to fix this? Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99565
  - 16
    - Anonymous viewing RSS feed I'm getting the dreaded "The RSS webpart does not support authenticated feeds" error when attempting to view a list with the RSS Web part. I have Kerberos Authentication enabled and working (All users authenticate via Kerberos) and I have enabled Anonymous Access on my site. I've even had this RSS feed working without issue, however a day or two ago it broke and I don't know why. When I go into the List and click Settings -> List Settings -> Permissions for this List -> Settings -> Anonymous Access I have the four boxes available to select. It doesn't matter which box is selected, the settings don't stick. I have selected View, Edit, Add, and even all four, but when I click Ok and go back in they are all unselected. I am unable to locate anything in the logs except a "401 unauthorized" error when attempting to load the RSS feed (Which is obvious since the settings aren't applying correctly). Has anyone seen this before? Is there a hidden setting somewhere that I'm missing? All external RSS web parts are working as expected, it's only ones that are attempting to read a List Library. And, to stress, this was working up until a day or two ago when it just mysteriously broke.... Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99560
  - 17
    - allow access to default view only Hi, I have a task top create a "expense form".. for the company. I created and library where anybody can submit a expense form (I used infopath and workflow using "sharepoint designer"). Then I ended up with two "person columns"... "created by" and "assigned to". Now I need to restrict access to this list... where one can view/edit items that is only created-by-me or assigned-to-me. I created a view that does this.... Now I need to stop users from looking at non-allowed items... create other views, use other tricks to view etc. How can I restrict users to only the customized view? Any help is deeply appreciated Thanks Nalaka Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99559
  - 18
    - MOSS2007 Server Capacity Reasonable? I am currently doing research on the server capacity for a future possible MOSS2007 server. Since it's currently virtualized using VMWare, the speed is a nightmare. (Oh the horror.. Thank god it's only for testing and it's already slow with only me on it!) After consulting with Microsoft Technet articles, diverse (MVP) blogs and people within this company that had some minor\major experience in SharePoint I have come with the following specs for our organization. Which is aimed at medium collaboration and medium publishing with around 140 employees. Through this newsgroup I am trying to have a better view on the needs and if what I suggested will be sufficient. Though it is not orthodox to install it on a single machine, our organization is looking very careful with the current budget. (Only for the server, we already own the licenses for the software) My aim is to start it on a (medium to heavy duty) single server, and when MOSS needs more resource we'll move into a 2-server or 3-server farm. FrontEnd+SQL+Index: 2x Intel Xeon Quad Core E5420 (12MB L2 Cache - 2.50Ghz - 45nm - TDP80w - Bus:1333Mhz) Memory: 16GB 667MHZ Registered + ECC Using SQL Server 2005 Standard Edition (To avoid the 4GB max memory in Express) 6x 15k SAS 147GB in RAID5 Would I encounter a bottleneck with this machine? If not, is dual processor an overkill for the current amount of users? Kind regards, Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99552
  - 19
    - Site Hierarchy for MySites I am attempting to view the Site Hiearchy for My Sites which uses "Personal" in the url. I thought that the information would be located on the following page: http://mysites.portalname/_layouts/vsubwebs.aspx but the page is blank. Any suggestions Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99551
  - 20
    - New to share point services3 i installed sharepoint services3 secusessfully, i tried to add ApplicationTemplateCore.wsp so i can import template smoothly. first step worked just fine: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o addsolution -filename "C:\ApplicationTemplateCore.wsp" Second: stsadm ?o deploysolution ?name "C:\ApplicationTemplateCore.wsp" -allowgacdeployment or stsadm ?o deploysolution ?name ApplicationTemplateCore.wsp -allowgacdeployment didn't work , i get command line error: For information about other operations and parameters, use "stsadm.exe -help" or "stsadm.exe -help <operation>" any Help ?? and also there's still remaining coomadn waiting the the que : stsadm -o copyappbincontent any Quick Advice ? A. Sabry Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99545
  - 21
    - Re-deploying site content Hey All, I've been creating most of my content on our dmz box i need to re- deploy this content to a new box in our production domain just wondering the best way to do this???? I need to keep all of my style templates and need to restore all of the sites as i've done a fair bit of development. Wondering if it will be a simple backup and restore (not sure how in SharePoint). Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99537
  - 22
    - Alternative Access Mapping User Prompts Hi, I have a problem with alternative access mapping. When opening /editing documents from a public zone (https://portal.company.com) the user gets prompted for their login details? We are using NTLM authentication (SharePoint) and Reverse Proxy Authentication via ISA Server 2006 (Forms with AD). Any ideas? Thanks!Peter Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99536
  - 23
    - efe Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99535
  - 24
    - Moving SPS2003 to a new domain. Hi all, I hope that someone can help me. I have had a good look around and can't seem to find a definitive answer. I have a requirement to move an SPS2003 installation from an existing domain to a new one. All user names and accounts have been migrated to the new AD with their original name and SID information (including SID history) retained. Is it just a case of installing a fresh copy of SPS2003 including SQL2005 on new servers in the new domain, taking a backup of SPS2003 (ie: database) and then restoring it in the newly created SPS2003 instance? From what I have read the SharePoint database contains references to the existing domain and this information also prefixes the actual user names themselves - is this correct? With the advent of SPS2003 sp2 there appears to be an API that can be used to migrate users to a new domain (http://support.microsoft.com/default.aspx?scid=kb;EN-US;896161). Is there a utility or a scripting method that will just go through the entire SharePoint database and make any relevant changes to remove any references to the old domain and to insert the new domain name? Also, are there any other gotcha's or steps that I should take into consideration? We use SSO for access to the portal. Also, just to confirm that I am not migrating versions (ie: SPS2003 to MOSS) but am keeping SPS2003 and just want to move it to a new domain. Any assistance much appreciated. Thanks in advance, Simon Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99531
  - 25
    - Indexing Single WSS Site in SPS 2003 Hi Folks, I am trying to create a separate search scope and content source for a single WSS site in SharePoint 2003. When I create the scope and the content source I am getting results from the entire SPS 2003 site including all the WSS sites. How can I create a scope and content source that will index just the single WSS site? I have tried changing the exclude and include rules and that made things worse. Not the most intuitive feature set I must admit. Any help would be greatly appreciated. Thanks, Lance Tag: Content Database Migration Error: Cannot insert NULL into RoleID Tag: 99527

hi,
i'm trying to migrate a wss 2.0 content database to 2007.prescan gave no
erros on the db. i run stsadm -o addcontetndb but it tells me that some
errors happened and to look into upgrade log.
in log file it says
[SPManager] [ERROR] [5/2/2008 3:26:48 PM]: Upgrade [SPContentDatabase
Name=IstWeb01 Parent=SPDatabaseServiceInstance Name=OfficeServers] failed.
[SPManager] [ERROR] [5/2/2008 3:26:48 PM]: Cannot insert the value NULL into
column 'RoleId', table 'IstWeb01.dbo.RoleAssignmentT'; column does not allow
nulls. INSERT fails.
The statement has been terminated.
[SPManager] [ERROR] [5/2/2008 3:26:48 PM]: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)

does anybody know how to solve this problem?

thanks in advance.

Top

Re: Content Database Migration Error: Cannot insert NULL into RoleID by Daniel

Daniel
Sun May 04 15:03:55 CDT 2008

Try to follow this guide:
http://www.sharepointforum.com/en-US/Wiki/Forms/DispForm.aspx?ID=7

It can be used to move ContentDB's.

/Daniel Bugday
http://www.sharepointforum.com/
http://www.sharepointforum.com/en-US/Blog/default.aspx

"Goker" <Goker@discussions.microsoft.com> wrote in message
news:329989F5-259A-4226-9693-95563EB1607F@microsoft.com...
> hi,
> i'm trying to migrate a wss 2.0 content database to 2007.prescan gave no
> erros on the db. i run stsadm -o addcontetndb but it tells me that some
> errors happened and to look into upgrade log.
> in log file it says
> [SPManager] [ERROR] [5/2/2008 3:26:48 PM]: Upgrade [SPContentDatabase
> Name=IstWeb01 Parent=SPDatabaseServiceInstance Name=OfficeServers] failed.
> [SPManager] [ERROR] [5/2/2008 3:26:48 PM]: Cannot insert the value NULL
> into
> column 'RoleId', table 'IstWeb01.dbo.RoleAssignmentT'; column does not
> allow
> nulls. INSERT fails.
> The statement has been terminated.
> [SPManager] [ERROR] [5/2/2008 3:26:48 PM]: at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean
> breakConnection)
>
> does anybody know how to solve this problem?
>
> thanks in advance.

Top