sharepoint 2007 daylight saving problem

SharePoint - Setup, Upgrade, Administration and Operation

- Previous
  - 1
    - create multiple websites in different languages using WSS 3.0 I'm almost certain that MOSS 2k7's "site variation" functionality is what you are looking for. This link might help you out: http://msdn2.microsoft.com/en-us/library/ms493894.aspx Tag: sharepoint 2007 daylight saving problem
  - 2
    - [MOSS 2007] Custom list, need to validate email-address... URGENT! In JavaScript: onclick="return IsValidEmailAddress();" Where IsValidEmailAddress verifies the email address, and returns false if it is not valid. That will prevent the button from submitting the form. You should be able to do the same in the onsubmit event of the form as well. Tag: sharepoint 2007 daylight saving problem
  - 3
    - Create a new UI for adding content types You could create the Content Type as a Site (Web) Feature. and then use code to Activate the Feature. You can look at other Content Type Features in the 12\Template\Features folder to learn how to do this. The SDK has some code examples of how to activate the Feature on a site. Brett Tag: sharepoint 2007 daylight saving problem
  - 4
    - Using the WSS List UI to display (filter, sort, group) non-typical data? It looks like WSS is executed a direct SELECT query and hence, difficult to intercept and cause the list to read from some other datasource. The following example is from the SQL Profiler that retrieves the data for a single SharePoint List web part: exec sp_executesql N' SELECT TOP 101 t1.[Type] AS c0,UserData.[tp_ContentTypeId],t2.[nvarchar4] AS c6c9,t1.[TimeCreated] AS c4,UserData.[nvarchar4],t2.[tp_ID] AS c6c8,UserData.[tp_Created],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N''/'' + t1.LeafName END AS c1,UserData.[tp_ModerationStatus],UserData.[tp_Level],UserData.[nvarchar1],UserData.[tp_HasCopyDestinations],UserData.[tp_HasAttachment],t1.[LeafName] AS c3,UserData.[nvarchar2],t1.[DirName] AS c5,UserData.[tp_ContentType],UserData.[int1],t2.[nvarchar1] AS c6c7,t2.[tp_Created] AS c6c11,t1.[ScopeId] AS c2,UserData.[nvarchar3],UserData.[tp_UIVersion],t2.[nvarchar5] AS c6c10,UserData.[tp_ID],UserData.[tp_CopySource],UserData.[nvarchar5],t3.[Status1] AS c12c13 FROM UserData LEFT OUTER LOOP JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int1]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) ) AND t2.[tp_CalculatedVersion] = 0 AND t2.[tp_DeleteTransactionId] = 0x AND t2.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN Workflow AS t3 WITH(NOLOCK) ON ( CAST ( CAST (UserData.[nvarchar5]AS VARBINARY) AS UNIQUEIDENTIFIER)=t3.[ID] AND UserData.[tp_RowOrdinal] = 0 AND t3.SiteId = @L2 AND t3.ListId = UserData.tp_ListId AND t3.ItemId = UserData.tp_Id AND UserData.tp_ListId = @L4) WHERE UserData.tp_ListID=@L4 AND ( (UserData.tp_IsCurrent = 1) ) AND UserData.tp_SiteId=@L2 AND ( UserData.tp_DirName=@DN ) AND UserData.tp_RowOrdinal=0 AND ( t1.SiteId=@L2 AND ( t1.DirName=@DN )) ORDER BY UserData.[tp_ID] Asc OPTION (FORCE ORDER) ',N'@L0 uniqueidentifier,@L2 uniqueidentifier,@L3 uniqueidentifier,@L4 uniqueidentifier,@DN nvarchar(260)',@L0='00000000-0000-0000-0000-000000000000',@L2='E43EE8A0-02DB-419C-A1F7-4A29B06BBD63',@L3='D2118EF9-48EB-49B4-A0C8-DB5CF5B39415',@L4='2A35A543-A0C0-4A38-8F7E-E10EFD6372E2',@DN=N'SiteDirectory/ifsdocrepo1/cm1/Lists/Cases' Tag: sharepoint 2007 daylight saving problem
  - 5
    - i need to change the default value of a field in create new item in the task list items Why are you doing that every time the user opens a new task isnt one time enough I think you should reconsider using a web part, and consider a feature instead. Code - first of all - why are you looping over the lists just use the list name as an indexer: SPList list = spw.Lists["Tasks"];//is there a list with this name use try-catch to be sure! Now, to get the field: SPField field = list.Fields["Title"]; //is there a field with this name use try-catch to be sure! Now, make the change: field.DefaultValue = "value"; field.Update(); You may have to allow unsafe updates for the SPWeb object before doing that, so if this doesnt work, put the following code before the code above. spw.AllowUnsafeUpdates = true; Ishai Sagi www.spstips.blogspot.com Tag: sharepoint 2007 daylight saving problem
  - 6
    - Customise Search results James, You can do this with a List View Web Part or Data View Web Part, attach a filter web part and you should get better results. Tag: sharepoint 2007 daylight saving problem
  - 7
    - Issues With Delay Activity I am having the same issue with this ... does anyone have any idea how to go around this issue or is it just me not using it proper. I have a delay activity with a code activity before and after. I am using ASP.net and ManualWorkflowScheduler. The code reaches the delay activity , fires off the initialize timeowtduration and then goes to sleep. The rest of the code never gets executed. Tag: sharepoint 2007 daylight saving problem
  - 8
    - Suddenly unable to create a new Top Level Site You might have to do a little research on this to verify this is the problem, but here is an idea. Maybe you have reached your threshold of total # of sites. You can increase that number, and be back in business. Somewhere within SharePoint Central Administration, you can set that limit for the content database, but I don't remember exactly where. I hope this at least gets you started in the right direction. Tag: sharepoint 2007 daylight saving problem
  - 9
    - Trying to bind dropdownlist selection to Sharepoint list column on custom insert form It turns out that I was very close to getting this to work. I had to add the items in red. <SharePoint VDropDownList FieldName="Categories" runat="server" id="ff4{$Pos}" DataSourceID="spDataSource2" DataTextField="Title" DataValueField="ID" __designer:bind="{ddwrt ataBind('i',concat('ff4',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),' @Categories' )}"/> What I fixed: 1) The property FieldName was missing. 2) The second parameter was @ID and I thought that referred to the DataValueField="ID", but no, it needs to bind to the FieldName. Tag: sharepoint 2007 daylight saving problem
  - 10
    - SQL 2005 Database Mirroring in MOSS and WSS I've been trying to follow the whitepaper released by Microsoft about SQL Server 2005 Mirroring and MOSS ( http://go.microsoft.com/fwlink/ LinkId=83725&clcid=0x409 ), but I've found that the document has a drastical error --it indicates that database mirroring session must be started from the principal server, and it must really be done from the mirror one. Ok let's pass it and move ahead (I could configure high availability mirroring with a witness server, finally) and when the backend fails over and I have to reconfigure MOSS, I follow the steps provided in the whitepaper but I can't reconnect to the Configuration Database, even though I have done stsadm.exe -o renameserver -oldservername <SQLPRINCIPAL> -newservername <SQLMIRROR> So I'm stuck here! I've tried to restart each and every service, restarted IIS, checked SQL Server services (mirror server active holding the active copies of the databases), I've run the MOSS configuration wizard first doing nothing but "Next .... next ..... next", then deattaching from the farm and reattaching again. Nothing. I've also tried with stsadm.exe –o setconfigdb –databaseserver <SQLMIRROR> –farmuser <MYDOMAIN\MOSS_Service_Account> –farmpassword <myFarmPassw0rd> and get nothing. If I swith SQL roles back and use the stsadm.exe -o renameserver to reverse to the initial situation, then it works!! (MOSS back online). So what's wrong! I'm really stuck here. Two days by far. Marcel Jeanneau Tag: sharepoint 2007 daylight saving problem
  - 11
    - New to sharepoint workflows, where to start? Nicola Young has a quick example with SharePoint Designer: http://nicolayoung.blogspot.com/2007/03/creating-workflow-in-sharepoint_20.html Nick Swan has two very nice postings: http://weblog.vb-tech.com/nick/archive/2006/09/04/1753.aspx http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx Hope those help Tag: sharepoint 2007 daylight saving problem
  - 12
    - protecting sensitive data Even if you hide the text box, people will be able to download the form, inspect the XML, and view what was entered into the text box. To implement privacy, you would have to encrypt the data. But you will also need to know how data will be accessed before you can choose an encryption mechanism. Tag: sharepoint 2007 daylight saving problem
  - 13
    - stsadm.exe FatalError: Could not find WebTemplate KB#75806 with LCID 1033 KB#75806 looks like KnowledgeBase, so I wonder if you had installed the WSS 3.0 site and server admin templates in your original location. Tag: sharepoint 2007 daylight saving problem
  - 14
    - MOSS2007 standalone no search results Ran into this a while back. What happens when you try to open that site ( http://csciisris2 ) in your browser As a guess i bet your getting page that cant be displayed. What i did to fix this was to create a blank team site at that location and from there it worked with no issue. Tag: sharepoint 2007 daylight saving problem
  - 15
    - I get an error when the IP form try to load. try this : <ElementManifests> <ElementManifest Location="workflow.xml" /> <ElementFile Location="FormName.xsn" /> </ElementManifests> Tag: sharepoint 2007 daylight saving problem
  - 16
    - using custom authentication provider Fijaz, got a question for u, how did u add users to ur DB Did u use the aspnet_regsql.exe tool Can i authenticate users frm my own custom table if so how Tag: sharepoint 2007 daylight saving problem
- Next
  - 1
    - Elevated privileges problem It appears RunWithElevatedPrivileges runs as the app pool account. Your issue may lie with what rights are needed by the app pool account. You may try adding the app pool account to the Farm Administrators Group in operations. Tag: sharepoint 2007 daylight saving problem
  - 2
    - Read only custom field type Do you use a custom schema.xml-definition If yes, you have to create a new Field-tag in the Fields-List and make a reference in the ContentType of the schema. For Visibility, you have the attributes ShowInDisplayForm, ShowInEditForm, ShowInNewForm Tag: sharepoint 2007 daylight saving problem
  - 3
    - approval workflow You need to look at the details of the workflow, I bet that it is set to the default Approvers group. You either need to add your Execs to the default Approvers group or Create a new group and change the workflow to use the new group. Tag: sharepoint 2007 daylight saving problem
  - 4
    - List 'View Item' in my views don't work Open the page up in SharePoint Designer then from the File menu choose reset to site defintion. This will put the page back to the way it was before you made changes. Now it should work again. Once it functions at normal try your changes again. Shane - SharePoint Help Tag: sharepoint 2007 daylight saving problem
  - 5
    - How to form files *.xps or *.pdf on a SharePoint server 2007? How to form files *.pdf on a SharePoint server 2007 Tag: sharepoint 2007 daylight saving problem
  - 6
    - document conversion I found this article on the document converter included in MOSS 2007: http://blogs.msdn.com/ecm/archive/2006/06/13/629525.aspx. It looks like you need to go into Central Administration and turn it on then you can play around with it. Tag: sharepoint 2007 daylight saving problem
  - 7
    - Facing problem while adding web part in Sharepoint2007 using SPLimitedWebPartManager Hi all, I am facing problem while adding a custom webpart in a sharepoint2007 web page. The code: using System.Xml.Serialization; using System.Xml; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; using Microsoft.SharePoint.WebControls; using Microsoft.SharePoint.WebPartPages; namespace AddWebPartProgrammatically { [ DefaultProperty ( "Text" )] [ XmlRoot (Namespace= "AddWebPartProgrammatically" )] [ ToolboxData ( "<{0}:AddWebPart runat=server></{0}:AddWebPart>" )] public class AddWebPart : WebPart { [ Bindable ( true )] [ Category ( "Appearance" )] [ DefaultValue ( "" )] [ Localizable ( true )] string msg; protected override void CreateChildControls() { try { SPWeb myWeb = SPControl .GetContextWeb(Context); SPLimitedWebPartManager coll = myWeb.GetLimitedWebPartManager( "default.aspx" , System.Web.UI.WebControls.WebParts. PersonalizationScope .Shared); //SPLimitedWebPartCollection allwebPart = coll.WebParts; string errorMsg; string dwp = @"< xml version=""1.0"" ><WebPart xmlns=""http://schemas.microsoft.com/WebPart/v2""><Assembly>DisplayTitleOfList, Version=1.0.0.0, Culture=Neutral </Assembly><TypeName>DisplayTitleOfList.DisplayTitleWebPart</TypeName><Title>My Simple Web Part</Title><Description>A sample Web Part</Description></WebPart>" ; XmlTextReader reader = new XmlTextReader (dwp); coll.ImportWebPart(reader, out errorMsg); } catch ( Exception ex) { msg = ex.Message; } } protected override void RenderContents( HtmlTextWriter output) { RenderChildren(output); output.Write(msg); } } I am getting an error while reading the dwp string by xmlReader. ex.Message = "Illegal characters in path." Please help me. Thanks KA2 Tag: sharepoint 2007 daylight saving problem
  - 8
    - Error in communicating with Excel Calculation Services From your description of the topology, I assume you're trying to use kerberos delegation for communicating in the farm. To set Excel Services to delegation please run: stsadm -o set-ecssecurity -accessmodel delegation -ssp sharedservices1 If the timer service isn't running on the Shared Services machine please, run the following on that machine: stsadm -o execadmsvcjobs Last, do iisreset for both the web front end and shared services machines. Then check See if that solves the issue. Tag: sharepoint 2007 daylight saving problem
  - 9
    - WSS 3.0 - Drop down menu It's made by Web Parts and ActiveX (ASP) technology. Try to dig in Web Parts, cause this is the main tool of customizing your components on page. Good luck! Tag: sharepoint 2007 daylight saving problem
  - 10
    - Migrating mcms 2002 users to sharepoint 2007 This usually happens when the environment where you are doing the migration is in a different domain from that of MCMS. Adnan Tag: sharepoint 2007 daylight saving problem
  - 11
    - Accounts From everything I've seen and read, and what I do when I install MOSS is create 4 accounts. 1. SharePoint Administrator - the SharePoint admin, log in as this user when installing SharePoint as well as the Administrator user you need to enter when running the configuration wizard. This user needs local admin rights to install SharePoint as well as rights on the DB server to created DB's and assign permissions to those DBs 2. SharePoint Web Application - This user is used for the app pool identity on all the web applications as well as the Shared Services credentials. This user only needs domain user rights 3. SharePoint Search - This user is used when starting the search service. They need local admin access on the search server 4. SharePoint Crawl - This is the content crawler for SharePoint, use this user when setting up indexing and crawling inside of Shared Services. This user only needs domain user rights. That is how I set up my SharePoint installations based on various documents I've read about SharePoint and creating different accounts and how to set them all up. I hope that helps, Ben Tag: sharepoint 2007 daylight saving problem
  - 12
    - html page Can you elaborate a bit Does the site only show up in the search, and nowhere else Tag: sharepoint 2007 daylight saving problem
  - 13
    - Creating an event handler for a custom content type Rob, good catch. Searching the web, I saw the following example: http://www.sharepointblogs.com/tonstegeman/archive/2007/02/15/19518.aspx I think this may have to be done by code and not by features. I hope this is wrong. This gave me an idea to add to my utility pack, to register an event handler to a content type and not just to a library. But until I do that, you are on your own. Tag: sharepoint 2007 daylight saving problem
  - 14
    - session cookies must be allowed I get the same issue, any suggestions Tag: sharepoint 2007 daylight saving problem
  - 15
    - Installation Issue no, you can only install MOSS on a server product. Tag: sharepoint 2007 daylight saving problem
  - 16
    - Reporting Services Configuration problem Hi, The Reporting Services Feature needs to be activated in Central Admin for the Application Management section to show up with the 3 options. Please follow the instructions in this blog article to enable this feature - http://blogs.msdn.com/rosettaue/archive/2007/04/06/how-to-activate-the-report-server-feature-in-sharepoint-central-administration.aspx . If this does not work, probably the add-in might not have been installed properly. Try to unistall and re-install the add - in. Please let me know if this helps. Thanks, Gowri Tag: sharepoint 2007 daylight saving problem

osinoob

We have a Sharepoint 2007 portal and the document libraries in the site. The site and server has been patched with the latest fix for daylight saving but when we upload files in it, the time when the files were uploaded is 1 hour behind.

When we create a new site on Sharepoint 2007, and did the similar, it shows the correct time. Does anyone has similar problems or fix for this

Top

Re: sharepoint 2007 daylight saving problem

Rene Peinl

I have an even worse problem. Every configuration change in central administration that is replicated to the frontend servers in our farm using the OWSTimer lasts one hour. We have the problem in our test system with Windows 2003 SP1 without daylight savings patch as well as on the production system with Windows 2003 SP2 and latest patches.
The servers are in German time zone (GMT+1) with daylight savings on. I have also followed the instructions given at http://www.sharepointbuzz.com/index.php/2007/01/12/sharepoint-2007-timer-service-and-timer-jobs-owstimerexe/
but the problem still persists
If anyone has a suggestion I would be very thankful.
Regards
Rene

Top