André Krijnen

maintenance

Feature Deployment SharePoint 2010 (List Instance and List Definition)

by on Nov.07, 2011, under features, General, maintenance, Powershell, SharePoint 2010, SharePoint Foundation

So I started out today debugging some weird issues regarding feature deployment. And well sometimes I don’t know why I get errors, but what’s new. So first of all, let’s start where to start.

cannot complete this action.please try again

Starting point:

A colleague of mine had written a feature for a customer of us, which worked perfectly. The customer had never issues like it should. After almost a year we (me, and the customer) decided to change the full Site Templates. Like a developer should do is making and changing the solution work. Well then comes the burden. After days of work, testing everything out the solution worked by me. (Owwh yeah, the known starting point: well on my computer it works).

So after deployment at the production server it didn’t work. I didn’t knew why, because everything should work like my notebook. The reason is simple, I had the same configuration, databases, etc. Well that didn’t work that out to.

So I thought well, let’s start fresh with new content databases from production. Ahh yes, there we go. Well, at my notebook it didn’t work either. Whoehoe, nice, we’ve got a good starting point for debugging.

Visual Studio 2010:

So I worked with Visual Studio 2010 and the deployed the feature again to debug. Well. Strangely, the solution worked after that. So Microsoft did some tricks while deploying. So I searched and called some people, yes on sunday. And telling me that Visual Studio 2010 is deploying asychronously. Yeah I knew that, but after a minute and some conversation telling that Powershell is deploying synchronously. Well that the trick I thought. So I decided to help my self out with some times, running the admin jobs, etc.

Even that didn’t worked out.

Go debugging old fashioned style: disabling Web and Site scoped features in the onet.xml.

After the first Web Feature (Deploying some List Instances and List Definitions) disabled the solution worked by powershell. I didn’t have a clue, but ohh well, I decided to change the ordering of the feature. Instead of List Definitions first, I decided to set the List Instances first. And you know what, It worked.

After enabling the Web Feature again, I could run the New Site creation perfectly.

Leave a Comment more...

SQL Server 2008 R2 Service Pack 1 is released (SharePoint info)

by on Jul.30, 2011, under maintenance, Reporting Services, SharePoint 2010, SharePoint Foundation, sql server, Update

So after some time Microsoft just released there first Service Pack for SQL Server 2008 R2. This package contains alot of improvements regarding to performances for Analysis Services.

You can download SP1 here: http://www.microsoft.com/download/en/details.aspx?id=20302

Also when you’ve running SharePoint Server 2010 with Reporting Services integrated you should update your Reporting Services to the latest Service Pack. Also an important notice to this, you should also download the SQL Server 2008 R2 SP1 Feature Pack to accomplish some other improvements.

You can download SP1 Feature Packs here: http://www.microsoft.com/download/en/details.aspx?id=26728

When you’ve downloaded the Feature Packs you should also install the following components to all SharePoint Servers:

  • rsSharePoint.msi
  • sqlncli.msi
  • SQLSERVER2008_ASADOMD10.msi

The first one is the SQL Server 2008 r2 Reporting Services Add-In for SharePoint Server 2010

The second is the SQL Server Client 2008 which you also have to install when you install the prerequisites for SharePoint Server 2010.

The third is also a component which is used in the prerequisite for SharePoint Server 2010.

 

 

Leave a Comment :, , , , , , , , , more...

Windows 7 Installation

by on Oct.12, 2009, under Hardware, maintenance, Software

Well finally I had the time to make a clean install for Windows 7 Ultimate x64.

It took me 1,5 half hour to be up and running again… that means Install Windows 7, full updates, Office 2007 Ultimate and MSN to work with.
Well that wasn’t to hard, except for the Realtek RTL8111 drivers for my LAN. The drivers supplied by Microsoft Update ruined the LAN connection, so I had to download new drivers from Realtek by itself.

After that I was happy that I finally installed it 🙂

Update: 10/15/2009 12:16 AM

So the first important things I’ve noticed is:

  • Network connections are stable, and no disconnected FTP transfers
  • System is not slow when going out of sleep mode
  • VMWare workstation seems to working better
  • When doing multiple processes like decompressing (WinRar) and opening a Solution with Visual Studio 2008 doesn’t cause any lack on WinRar
  • No unresponsive mouse when updating(installing) Windows patches and what so ever
  • Java seems not using big amounts of memory like in Windows Vista
  • Now let’s keep playing with Windows 7.

    Owwh yeah my system configuration:

    CPU: AMD Phenom II X4 940
    Mainboard: Gigagyte GA-MA790GP-DS4H RF3
    Memory: OCZ DDR2-800 Reaper 4x2GB CL4 OCZ2RPR800C44GK
    Graphics cards: 2xSapphire 4850 1GB
    Disk config: 3x320gb RAID 5 for OS
    Disk config 2: 3x1TB RAID 5 for DATA
    Sound: Soundblaster 2 Audigy 24bit Advanced
    Screens: 2x IIyama 26″

    Leave a Comment :, more...

    Moved site to Hosting

    by on Oct.10, 2009, under maintenance

    I used to host my own sites, but since KPN disconnected every port I’d used I had to get some Hosting party to host my sites and email.

    Damnit, there goes my own stuff..

    Leave a Comment :, , more...

    Server went down for some reason

    by on Aug.03, 2009, under blog, maintenance

    A strange thing happend last day is that for some reason my Web Server went down in action… I couldn’t explain why it happend, but I managed to gave it a rebirth of the server.

    After 30 days without reboot, wow :-S It went down, and yet I cannot figure out why. Nothing changed, and I saw my logfiles and even there it didn’t show anything. So, what happened then? I don’t know.

    Leave a Comment :, , , more...

    SQL Server DB Log File truncating…

    by on Jan.31, 2008, under maintenance, sql server

    Well alot of database administrators forget to truncate their database daily before backing the database up. Well I don’t understand why they are forgetting it. Because it’s a simple procedure you can add before you backup the database. Today I received a database of 5 gigabytes and with a log file of yes you don’t how of 21 gigabytes. So I was using the standard features of SQL Server 2000, but this tool does not his work with the normal truncating options of the database.

    After a good search I found out it isn’t that much fun to truncate the database with a procedure. After a search on google it was easy to find the simplest script for database maintenance. I used this script and it really did work. Below you can find out yourself:

    1.  
    2. SET NOCOUNT ON
    3.  
    4. DECLARE @LogicalFileName sysname, @MaxMinutes INT, @NewSize INT
    5.  
    6. — *** MAKE SURE TO CHANGE THE NEXT 4 LINES WITH YOUR CRITERIA.
    7.  
    8. *** USE [DATABASE] — This is the name of the database — for which the log will be shrunk.
    9. SELECT @LogicalFileName = 'LOGFILENAME', — Use sp_helpfile to identify the logical file — name that you want to shrink.
    10. @MaxMinutes = 10, — Limit on time allowed to wrap log.
    11. @NewSize = 10 — in MB — Setup / initialize
    12. DECLARE @OriginalSize INT
    13.  
    14. SELECT @OriginalSize = SIZE — in 8K pages FROM sysfiles WHERE name = @LogicalFileName
    15.  
    16. SELECT 'Original Size of ' + DB_NAME() + ' LOG is ' + CONVERT(VARCHAR(30),@OriginalSize) + ' 8K pages or ' + CONVERT(VARCHAR(30),(@OriginalSize*8/1024)) + 'MB' FROM sysfiles WHERE name = @LogicalFileName
    17.  
    18. CREATE TABLE DummyTrans (DummyColumn CHAR (8000) not null) — Wrap log and truncate it.
    19.  
    20. DECLARE @Counter INT, @StartTime DATETIME, @TruncLog VARCHAR(255)
    21.  
    22. SELECT @StartTime = GETDATE(), @TruncLog = 'BACKUP LOG ['+ DB_NAME() + '] WITH TRUNCATE_ONLY' — Try an initial shrink.
    23.  
    24. DBCC SHRINKFILE (@LogicalFileName, @NewSize) EXEC (@TruncLog) — Wrap the log if necessary.
    25.  
    26. WHILE @MaxMinutes > DATEDIFF (mi, @StartTime, GETDATE()) — time has not expired
    27. AND @OriginalSize = (SELECT SIZE FROM sysfiles WHERE name = @LogicalFileName) — the log has not shrunk
    28. AND (@OriginalSize * 8 /1024) > @NewSize — The value passed in for new size is smaller than the current size.
    29.  
    30. BEGIN — Outer loop.
    31.  
    32. SELECT @Counter = 0 WHILE ((@Counter > @OriginalSize / 16) AND (@Counter > 50000))
    33. BEGIN — update
    34. INSERT DummyTrans VALUES ('Fill Log') — Because it is a char field it inserts 8000 bytes.
    35. DELETE DummyTrans SELECT @Counter = @Counter + 1 END — update
    36. EXEC (@TruncLog) — See if a trunc of the log shrinks it.
    37. END — outer loop
    38. SELECT 'Final Size of ' + DB_NAME() + ' LOG is ' + CONVERT(VARCHAR(30),SIZE) + ' 8K pages or ' + CONVERT(VARCHAR(30),(SIZE*8/1024)) + 'MB' FROM sysfiles WHERE name = @LogicalFileName
    39. DROP TABLE DummyTrans PRINT '*** Perform a full database backup ***'
    40. SET NOCOUNT OFF

    Voila, fill in the database name and the logfile name and you’re done. Run the script within query analyser or other usefull tool. I used this script with SQL Server 2000 and SQL Server 2005. This script can also be used with SQL Server 7. So with the major databases of Microsoft you can use this script. Have fun!!

    Leave a Comment :, , , , more...

    Looking for something?

    Use the form below to search the site:

    Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

    Blogroll

    A few highly recommended websites...