Monthly Archives: January 2014

ORA-55610: Invalid DDL Statement on history-tracked table

You will get this error if you are trying to Truncate or perform the Shrink Space operation on a table that is connected to a Flash Archive

If unless totally necessary to do above operation; you will need to detach the table from the Flashback Archive using below command

ALTER TABLE tablename NO FLASHBACK ARCHIVE;
Advertisements

Opening PDF files in a browser from Sharepoint 2010

If you are facing an issue wherein your Sharepoint users are having to download PDF files onto their local machines to view the files; the below post has got just the solution you are looking for.

Below Step by Step Powershell commands can be run to get the functionality working

From your Sharepoint Application Server; proceed to Start – All Programs – Microsoft Sharepoint 2010 Products – Sharepoint 2010 Management Shell and type below commands

$webApp = Get-SPWebApplication("http://yourwebapplicationurl")
$webApp.AllowedInlineDownloadedMimeTypes.Add("application/pdf")
$webApp.Update()

Once the above commands have been successfully run, you can confirm that the PDF application has been added to the MIME Type list using below command

$webApp.AllowedInlineDownloadedMimeTypes

The result is immediate and you can test the solution right away.

Changing the Background and Accent color in Windows 8.1

This might not be the most important feature that one gets to use on a daily basis. Color schemes on Windows Desktop OS was not even an option until the Windows 8 arrived. It’s just something that users see when they set up their devices (Laptop, Desktop or tablet) for the first time. Later on, they just get used to seeing the background color in the default or the modified color scheme.

With Windows 8.1, changing the background color has become a mystery. For days I tried to change the background color on my laptop after the upgrade to Windows 8.1. What seemed to be a very straight forward procedure with Windows 8 seemed to be a very difficult task to do in Windows 8.1. Well, everything can be changed but with a small trick.

  • Press Start or the Windows button on the keyboard. This should take us to the Start screen with the tiles.
  • Point the mouse to the Right hand top corner of the screen or just press Windows button + C. This should open the charm bar.
  • Click Settings.
  • Click Personalize and there you go! Change the background and the accent colors to your like!!

ORA-01810: format code appears twice

An uncommon error as this may keep you wondering. Well there is a common practice of defining both Month and Minutes as MM and this is what usually causes this error. Below is a typical example.

SQL> ALTER SESSION SET NLS_DATE_FORMAT='dd/mm/yyyy hh24:mm:ss';
ERROR:
ORA-01810: format code appears twice

Change the date format accordingly you resolve the issue

SQL> ALTER SESSION SET NLS_DATE_FORMAT='dd/mm/yyyy hh24:mi:ss';

Sorry, it looks like this PC can’t run Windows 8.1. This might be because the Users or Program Files folder is being redirected to another partition

Most Windows 8 users might not face this issue, but the smarties will surely have faced this issue. I too was one among them until a few days back, but I too have managed to upgrade my OS from Windows 8 to Windows 8.1. This error appears, each time you try to download and upgrade from the Windows store. The download goes fine but when it enters the installation stage, the doomed message appears. Most users love to tweak their brand new laptops a little. This includes moving the Users folder to the D or E drive (the second partition). This is being done to save space for the OS partition, commonly known as the C partition or the C Drive. Some users even install programs (Games or bigger applications) on their secondary partition so as to save space. Either ways, this affects the upgrade to Windows 8.1 and you are all but lost.

After having gone through a lot of forums and sitting for days in front of my laptop to find an answer to this problem, I had the final laugh. I too had redirected all my Users folder and also had installed a game on the D drive of my laptop. At the time of installation I encountered this error message and tried reversing all the changes that I had made. That didn’t help. Before we get into all this, please note that my secondary partition was D but that need not be the case for all. The letters could change for different users. Please make a note of the letter on your secondary partitionThe steps that I followed are as follows:

  • On your PC or laptop, type in “regedit” (without quotes). This opens the regedit window. Go to HKLM/SOFTWARE/Microsoft/Windows NT/CurrentVersion/ProfileList/ProfilesDirectory and change the value of it back to “%SystemDrive%\Users” (without quotes again). Close this window.
  • Go to control panel and click User Accounts. Click on “Manage Another Account”. In this windows, click on the option “Add a new user in PC Settings”.
  • This will take us to another window asking us to “Add an account”.
  • Click on it but please make sure to click on the bottom most option, “Sign in without a Microsoft Account (not recommended)”. It says not recommended but at this stage I feel it is better to go without one. Click on the option “Local Account”. Create a username of your choice with password and click Finish.
  • Once the account is created, go back to User Accounts in Control Panel and click “Manage Accounts”. Click the new account that was just created and click on “Change the Account type”. Change it to Administrator.
  • Sign out from the current user account.
  • Sign in with the newly created user.
  • The new account will created in C:\Users.
  • In the new account, type in “cmd” (without quotes) and right click on it and click “Run as Administrator”. We now need to make a Junction from the C: profile folders to the D: profile folders.This is done by running the command mklink /J C:\Users\Username D:\Users\Username
  • Once this is done, you are returned with a success status.
  • Open “regedit” again as described in the first step and go to HKLM/SOFTWARE/Microsoft/Windows NT/CurrentVersion/ProfileList/S-1-5-xx-xxxxxxxx-xxxxxxxxxxxxxx/ProfileImagePath. We need to change all the keys that point to D:\Users\Username to C:\Users\Username.
  • Once this is done, we need to check if we are able to log on to the old user account again.
  • Log out of the old user account and log in back to the newly created user account.
  • The steps above needs to be repeated for every account which has its profile folders on the D partition.
  • If there are any pending updates, install them and restart the laptop or PC. The restart makes sure that all the Users that are current logged in are logged out and also to make sure that no user on D partition is logged in.
  • After the restart log on to the new user account. Go to Windows Store, download and install the 8.1 update.

The attempted operation is prohibited because it exceeds the list view threshold

Sharepoint 2010  – Changing the List View Threshold

Reason for Error : The Web Application Settings of your Sharepoint Site has been configured to allow list content below the number that you wish to store in it

If you are the Sharepoint Administrator; the below settings will get you through

1. Open Central Administration from your Sharepoint Server

2. Proceed to Application Management – Manage Web Application and click on your web application to select it.

3. From the top Ribbon, click on General Settings drop-down and choose Resource Throttling

4. In the List View Threshold field, increase the value to the desired amount and click OK.

5. Try to replicate the error. If the error persists, increase the value again until the error goes away.

Migrate Sharepoint 2007 List to Sharepoint 2010

Lets say you have a List in Sharepoint 2007 with Large Content and Views which you would want to replicate in Sharepoint 2010.

You can achieve this with Powershell Commands; but I will illustrate in the most simplest manner to achieve desired result

  1. From your Sharepoint 2007 List; Click Settings –  List Settings
  2. Save your list as a template (.stp); ensure that you select the Include Content CheckboxList_Settings
  3. From the Parent Site; proceed to Site Actions – Site Settings – List Templates and download the new template to local machine folder
  4. Change the extension of the downloaded file from .STP to .CAB
  5. Extract the content of the CAB file (manifest.xml) to a local folder; lets call it c:\sp2007_template\
  6. Edit the manifest.xml file; search for the ProductVersion element. This should have a value of 3; change its value to 4 and save the file
  7. Repackage the manifest.xml into a .CAB by using makecab.exe in the C:\Windows\System32 folder
    Syntax: makecab.exe c:\sp2007_template\manifest.xml c:\sp2007_template\{template-name}.cab
  8. Change the newly generated cabinet file extension from .CAB to .STP
  9. From the parent site of your Sharepoint 2010 Site;  proceed to Site Actions – Site Settings – List TemplatesSite_Settings
  10. Upload the newly created .STP file to the List Template directory
  11. When creating a new list in Sharepoint 2010; the new template will show up for selection.

Reading Pane in Outlook – do not mark as read when mail selection changes

Applies to Outlook 2007 and above

Some people prefer to keep the reading pane turned on; but find it annoying when the messages get marked as read when they merely scroll through their mails

You can overcome this; with the below option in Outlook

Outlook 2010

File – Options – Advanced – Reading Pane

Outlook_Options

 

Reading_Pane

Ensure the you Uncheck  the second checkbox; Mark item as read when selection changes

Outlook 2007

Tools – Options – Other – Reading Pane

 

OPW-00001:Unable to open password-file

If you overcome this error when creating the password file for your Oracle Database; kindly recheck your syntax

Sample Syntax

orapwd file=%ORACLE_HOME%\database\PWDtest.ora entries=5 ignorecase=y

Kindly do not use single quotes to contain the file location

Sharepoint 2010 Backup – Automated Backup with Powershell

You can run powershell commands directly from the Sharepoint 2010 Management Shell window; but that does not suit the purpose when you require a daily backup

Start - All Programs - Sharepoint 2010 Management Shell

Its’ surprising why Sharepoint themselves could not come out with an easy automated tool. Nevertheless; the below post would guide you through

Firstly, we need to define a backup location.

  • Is your Sharepoint Farm and SQL Server on different Servers? If yes, kindly ensure that the Backup Location that you define is a Share Drive (\\sharedrive\backupfolder) and has full Write Access for both the Sharefoint Farm Admin Account and SQL Server Account

Farm Backup is best done as both a Full and subsequent Incremental Backups

Full Backup

Create a File with the extension ps1 (denotes a powershell command file)

Add-PsSnapin Microsoft.SharePoint.Powershell
Backup-SPFarm -Directory \\sharedrive\backupfolder -BackupMethod Full

Setting up a Windows Task Schedule for the Farm Backup

Start – All Programs – Administrative Tools – Task Scheduler – Create Task

Give an appropriate name and under Actions tab; click New

Type powershell under Program field and state the ps1 file that you created above under the Add Arguments field

Task_Schedule

Specify an appropriate time under the Trigger tab for your task to run.  Since its a full backup its best to set a time after regular office hours

Incremental Backup (Daily backup of changed data since the last backup)

Create a File with the extension ps1 (denotes a powershell command file)

Add-PsSnapin Microsoft.SharePoint.Powershell Backup-SPFarm -Directory \\sharedrive\backupfolder -BackupMethod Differential

Use the Task Scheduler as illustrated earlier to define the daily backup