tag:blogger.com,1999:blog-74570285964231652852024-03-04T21:10:29.415-08:00IT DiariesOva (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.comBlogger57125tag:blogger.com,1999:blog-7457028596423165285.post-13316308654051042692011-06-16T11:03:00.000-07:002011-06-16T11:03:00.852-07:00About Setting up a Developer Workstation for SharePoint 2010You "can" install SharePoint Foundation to Windows 7 but... You have to own Professional edition.<br />
<br />
Unfortunately, with my new Windows 7 Home Premium edition laptop I was not able to set up SharePoint Foundation. I found out that on Win 7 Home Premium IIs supports only Basic authentication and SP Foundation does not work...<br />
<br />
I am really angry to Microsoft folks; who forgot to mention about this little issue! I can't use it on my new system, thanks guys...I owe you one :)Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-53440131322601826532011-04-11T02:26:00.000-07:002011-05-11T00:00:36.045-07:00How to move reusable workflows between SharePoint farmsReusable workflows, which are introduced in SharePoint 2010, are cool!<br />
You can create your workflow in development / test environments and then move it to production like a solution, it is very easy.<br />
<br />
You should create the workflow as a reusable workflow from the start if you want to use it on other farms.<br />
When you finish your workflow:<br />
<br />
1- you have to export the Resuable workflow via SharePoint Designer. this could be done using the ribbon. select the Workflow you want to export.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiq3lrmzDJqSr4HQLVjypmylq4nLWiWPdr6OnSqzen9xDp70900F79GDWMRBYiZHbSiRPXpp37qFqnP1_BlHWzzl3EVGXLmJ3L7SWvOKXLIyNLSa-3ecMD4AUT6ZRyXK0sGTBV9Vv2uzEo/s1600/save.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiq3lrmzDJqSr4HQLVjypmylq4nLWiWPdr6OnSqzen9xDp70900F79GDWMRBYiZHbSiRPXpp37qFqnP1_BlHWzzl3EVGXLmJ3L7SWvOKXLIyNLSa-3ecMD4AUT6ZRyXK0sGTBV9Vv2uzEo/s320/save.jpg" width="320" /></a></div><br />
<br />
Click <b>save as template</b> from the ribbon (as shown in the screenshot above)<br />
Save it on your computer.<br />
<br />
<br />
2. Open the site you want to import your reusable workflow.<br />
Navigate to Site settings > Galleries > Solutions<br />
Click upload solution from the Solution Ribbon. Select your solution and upload it.<br />
<br />
3. Activate the solution you have just uploaded.<br />
<br />
4. Now go to the site settings, site features. Activate the feature as well.<br />
<br />
and your reusable workflow is ready to go!Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com4tag:blogger.com,1999:blog-7457028596423165285.post-57329942515102933682010-12-22T03:57:00.000-08:002010-12-22T03:59:10.563-08:00How to delete a Search Service Application in Moss 2010After I installed Sharepoint 2010, I tried to figure out how certain services work without Search Services Provider. As we already know, there are no SSP's anymore in 2010 architecture.<br />
<br />
So I configured a FAST Search Connector. But It didnt work quite allright so I tried to delete it. No luck! There were no options in Central Administration to delete a Search Service Application after creating it.<br />
<br />
After a quick search on the internet I find that you can remove the SSA by using<br />
<br />
<b>stsadm -o deleteconfigurationobject</b> <b>-id *GUID*<guid></guid></b><br />
<b><br />
</b><br />
command. This command works by using object id(GUID). In order to get the object ID; the GUID of SSA, I just copied it from IE, central administration Search Service Application URL.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZkDB5U21C1rxbKcrk9V5I20Ao104f_LngR75HwcV1Go2kta6Z7fojiBCVkPwK2eViJnjYyOqepvspasqfmpJjccA8901XazRzqrbqsL-3aqNTCiWC3ZHgWhpYuUFp2nF1pUqqghz_hH4/s1600/22.12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="141" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZkDB5U21C1rxbKcrk9V5I20Ao104f_LngR75HwcV1Go2kta6Z7fojiBCVkPwK2eViJnjYyOqepvspasqfmpJjccA8901XazRzqrbqsL-3aqNTCiWC3ZHgWhpYuUFp2nF1pUqqghz_hH4/s400/22.12.jpg" width="400" /></a></div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-20168700042308675802010-12-20T03:20:00.000-08:002010-12-22T03:57:21.818-08:00How to deal with faulty featuresBefore upgrading to SharePoint 2010, you should run preupgradechecker and Test:SpContentDatabase..<br />
<br />
Preupgrade checker should be run on the 2007 instance and Test:spcontentdatabase should be run on Sharepoint 2010.<br />
<br />
After you run the preupgradechecker, it creates an html file containing your farm details. In my case, there were lots of missing features!<br />
The entries were like these:<br />
<blockquote><br />
</blockquote><br />
<br />
<li><blockquote>Name = [Unknown], Feature id = [5ac519ce-6bf2-842c-485c-04efe522a2dc], Reference count = [1], Scope = [Web], Status = [Missing]</blockquote></li><br />
<br />
<br />
<br />
<li><blockquote>Name = [Unknown], Feature id = [c5e293c8-a4c6-8607-5505-7a2a77a9800e], Reference count = [1], Scope = [Web], Status = [Missing]</blockquote></li><br />
<br />
<br />
<br />
<li><blockquote>Name = [Unknown], Feature id = [68f713c6-1fc8-d110-e819-ce7d59518f60], Reference count = [1], Scope = [Web], Status = [Missing]</blockquote></li><br />
<br />
<br />
<br />
<li><blockquote>Name = [Unknown], Feature id = [564a2b98-aec8-e5f5-7e94-8096d64fe16c], Reference count = [1], Scope = [Web], Status = [Missing]</blockquote></li><br />
<br />
<br />
<br />
<li><blockquote>Name = [Unknown], Feature id = [a28a2e77-9525-4c9c-ad79-e0b6252395e8], Reference count = [1], Scope = [Web], Status = [Missing]</blockquote></li><br />
<br />
<br />
<br />
<br />
While searching on the internet, I found that tool which is very handy to remove problematic features:<br />
<a href="http://featureadmin.codeplex.com/">http://featureadmin.codeplex.com/</a><br />
<br />
Of course, test it before you try it ;)<br />
In my case I perform a database attach upgrade so it's easier to test.Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-53845338540739063792010-12-01T01:16:00.000-08:002010-12-01T01:16:55.692-08:00Page viewer web part problem in Sharepoint 2010After upgrading SharePoint 2010, the page viewer web parts does not show up. Instead a dialog appears and it tries to download the html file.<br />
<br />
This is because of the security settings in Sharepoint 2010<br />
To solve this; you have to navigate to Central administration:<br />
<br />
Application Management> Manage Web Applications> select your web aplication & open General Settings<br />
<br />
Change "Browser File Handling" to "Permissive.<br />
<br />
Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-90939231124821608302010-12-01T00:58:00.000-08:002010-12-22T03:57:42.211-08:00upgrade sp1 content database by adding it with stsadmIf you have a Sharepoint service pack1 content database which you want to move to SP2 environment all you have to do is to run a stsadm command..<br />
<br />
stsadm -o addcontentdb -url http://new-site-address -databaseserver your_server -databasename<br />
<br />
This will upgrade the SP1 content database to sP2. This is very handy when you want to upgrade a 32-bit SP1 sharepoint 2007 to Sharepoint 2010. First you move it to a sp2 farm by using this command, after upgrade is successful then you detach/attach it again to sql 2008 & sharepoint 2010 backend.Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-74440563506223160952010-10-06T01:29:00.000-07:002010-10-06T01:29:23.663-07:00Failure trying to synch web application after attaching new content database to a web applicationAfter restoring a content database from prod to test , and make the web application point to this new database, I started to see errors on Server Event log.<br />
<br />
<b><span class="Apple-style-span" style="color: red;"><br />
</span></b><br />
<b><span class="Apple-style-span" style="color: red;">ERROR 1:</span></b><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Event Type:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>Error</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Event Source:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>Office SharePoint Server</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Event Category:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>User Profiles </b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Event ID:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>5555</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Date:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>06.10.2010</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Time:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>11:00:03</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>User:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>N/A</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Computer:</b></i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i><b> </b></i></span></span><span class="Apple-style-span" style="font-size: small;"><i><b>xxxxxxxx</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Description:</b></i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><b>Failure trying to synch web application 7621f35a-0df2-4c88-8f03-0ce546db94bd, ContentDB d9248f2a-523c-4d86-b149-9ccfc08c6466 Exception message was A duplicate site ID e10eb63c-01dd-4227-98db-9fbfa1285ce9(http://xxxxxxx) was found. This might be caused by restoring a content database from one server farm into a different server farm without first removing the original database and then running stsadm -o preparetomove. If this is the cause, the stsadm -o preparetomove command can be used with the -OldContentDB command line option to resolve this issue.</b></i></span><br />
<br />
<b><span class="Apple-style-span" style="color: red;">ERROR 2:</span></b><br />
<br />
<br />
<span class="Apple-style-span" style="font-size: small;"><i>Event Type:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>Error</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Event Source:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>Office SharePoint Server</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Event Category:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>User Profiles </i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Event ID:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>5553</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Date:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>06.10.2010</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Time:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>11:00:07</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>User:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>N/A</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Computer:</i></span><span class="Apple-tab-span" style="white-space: pre;"><span class="Apple-style-span" style="font-size: small;"><i> </i></span></span><span class="Apple-style-span" style="font-size: small;"><i>TUP03SRV74</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>Description:</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i>failure trying to synch site 1eeae3e9-9412-4f73-a4df-b752d88c0329 for ContentDB 6a7a4d13-adc5-4605-a056-ae5216498ffe WebApp 3b98938e-c823-4c24-a19f-7c60a73bd306. Exception message was Cannot complete this action.</i></span><br />
<span class="Apple-style-span" style="font-size: small;"><i><br />
</i></span><br />
<br />
<div><b>Solution:</b></div><div><br />
</div><br />
<br />
<b>C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa</b><br />
<b>dm -o sync -deleteolddatabases 0</b><br />
<br />
<i>For my case the output was:</i><br />
<br />
Deleted sync information for DB a416fe1d-600d-46ff-a176-8f2fd3f7d454<br />
Deleted sync information for DB 6a7a4d13-adc5-4605-a056-ae5216498ffe<br />
Deleted sync information for DB 208737f0-6795-42ee-badd-dbfcaf0e5d02<br />
Deleted sync information for DB b53fe383-2f27-499b-b612-f09748d90ae2<br />
<br />
Then I listed the old databases to make sure that there were none left..<br />
<br />
<br />
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa<br />
dm -o sync -listolddatabases 0<br />
<br />
Shared Service Provider SharedServices1<br />
No databases match the criteria for this Shared Service ProviderOva (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com1tag:blogger.com,1999:blog-7457028596423165285.post-73510145186816062922010-09-29T23:31:00.000-07:002010-09-29T23:33:02.969-07:00Make your notebook a development platform for SharePoint 2010For SharePoint 2007 or WSS it is nearly impossible to install on something other than Windows Server ..there were some articles explaining how to install WSS 3.0 on windows 7 by using some tools but honestly, I try and I could not be able to get it work.<br />
<br />
When I find out that SharePoint Foundation (the new name of WSS in SharePoint 2010 platform) could be installed on Windows 7 I was very happy. At last I can use my own machine for development purposes without having to use any virtual machine.<br />
<br />
What you need is explained detailly over here:<br />
<br />
http://msdn.microsoft.com/en-us/library/ee554869.aspx<br />
<br />
Good luck!Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-39887517716988591022010-09-21T00:32:00.000-07:002010-09-21T00:34:12.319-07:00How to keep Workflow History data more than 60 days in SharePointI am not sure if it is officially declared by Microsoft or not, but SharePoint is set to delete/purge workflow history from database after 60 days. That means you can't find anything more than 60 days old in Workflow history list by default setting.<br />
<br />
If you are using custom developed workflows that could be annoying because you'll have to keep approval workflow info vs. more than 60 days according to your company policies etc.<br />
<br />
There is a simple way to prevent this behaviour. Just log on to Central Administration and Go to Timer Job Definitions on Operations page.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4Y4PF_azAVW9iwmroCy6e0y0uDwoNg77YA3gskw7yhmHhQiJyWBWITksqsUnRazCI7cjjM7a_RtzQ-h9j7F2yoPPs7yYmr0pHEacaZdOFnJ3z8B0SJnnenRS6QmK4CgaaqlIsQlXnoAU/s1600/21.09.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4Y4PF_azAVW9iwmroCy6e0y0uDwoNg77YA3gskw7yhmHhQiJyWBWITksqsUnRazCI7cjjM7a_RtzQ-h9j7F2yoPPs7yYmr0pHEacaZdOFnJ3z8B0SJnnenRS6QmK4CgaaqlIsQlXnoAU/s640/21.09.jpg" width="640" /></a></div><br />
Find the "Workflow Auto Cleanup" timer job that belongs to the web application you want to preserve.<br />
Disable it, thats it..Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-61100613746189926732010-09-17T05:32:00.000-07:002010-09-17T05:32:52.418-07:00Create New item in a custom list leads to "Unknown error"Last week we had a nasty problem. In a custom list of a custom site, new items were not getting created. The "new form" aspx was customized as well. When you click new item (it was a custom content type also) SharePoint gave a big nice "Unknown error" screen.<br />
<br />
we discovered two anomalies:<br />
<br />
1. the first thing I got suspicious was the item count. Sharepoint hard limits are really annoying..I was right about getting suspicioous over item count, we deleted some of items from the list, the error vanished! But the list had to grow..<br />
<br />
2. When you sign on as the "Site Collection Administrator" magically, you have no errors, everything worked fine. It does not even work when you have the full control permission level on list or site..Just being in "site collection administrators" group keeps the error away.<br />
<br />
We dig the ULS and found out that kind of errors:<br />
<br />
"<span class="Apple-style-span" style="font-family: 'Times New Roman', serif; font-size: 16px;">Application error when access /_layouts/unit/forms.aspx, Error=Must declare the table variable "@_scopeTbl". Must declare the table variable "@_scopeTbl". Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at..........................."</span><br />
<span class="Apple-style-span" style="font-family: 'Times New Roman', serif; font-size: 16px;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Times New Roman', serif; font-size: 16px;">So after a quick googling, I found that cumulative update: </span><a href="http://support.microsoft.com/kb/973410">http://support.microsoft.com/kb/973410</a><br />
(Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package)<br />
Although it seems to be curing the render failed error messages.<br />
<br />
I never liked patching my farm on place, if we have custom development on it .. I usually do install a new farm, attach content db, and upgrade. Then re-deploy the custom solutions on it...<br />
<br />
I did this in order again and the Cumulative update really worked for the problem but unfortunately, It caused other things to crash... Now some of the custom built workflows are not working and its a complete pain to seek a way to fix them.Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-56613207655459413232010-08-09T01:17:00.000-07:002010-08-09T01:18:47.431-07:00Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content.<div class="separator" style="clear: both; text-align: center;">After Adding a new index server to the farm - made that a dedicated indexer-</div><div class="separator" style="clear: both; text-align: center;">after that when I tried a full crawl the crawl stopped immediately and the following error is recorded to crawl log:</div><div class="separator" style="clear: both; text-align: center;"><b><br />
</b></div><div class="separator" style="clear: both; text-align: center;"><span class="Apple-style-span" style="color: #333333; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 21px; line-height: 26px;"><b>Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content.</b></span></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">also, on the indexer windows event log there was this warnings:</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><blockquote>event id :2436 The start address <http://portalurl> cannot be crawled. </http://portalurl>Context: Application 'SharedServices1', Catalog 'Portal_Content' Details: <span class="Apple-tab-span" style="white-space: pre;"> </span>Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (0x80041205)</blockquote><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">So I googled and find this brilliant forum topic on msdn</div><div class="separator" style="clear: both; text-align: center;"><a href="http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/52877c8f-ac38-4cd3-813e-87f8f7a6882f">http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/52877c8f-ac38-4cd3-813e-87f8f7a6882f</a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><span class="Apple-style-span" style="font-family: inherit;"><span class="Apple-style-span" style="font-size: small;">Applied the solution and it worked like a charm.</span></span></div><div class="separator" style="clear: both; text-align: center;"><span class="Apple-style-span" style="color: #333333; line-height: 26px;"><span class="Apple-style-span" style="font-family: inherit;"><span class="Apple-style-span" style="font-size: small;">1. Click Start, click Run, type regedit, and then click OK.<br />
2. In Registry Editor, locate and then click the following registry key:<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa<br />
3. Right-click Lsa, point to New, and then click DWORD Value.<br />
4. Type DisableLoopbackCheck, and then press ENTER.<br />
5. Right-click DisableLoopbackCheck, and then click Modify.<br />
6. In the Value data box, type 1, and then click OK.<br />
7. Quit Registry Editor, and then restart your computer.</span></span></span></div><div class="separator" style="clear: both; text-align: center;"><span class="Apple-style-span" style="color: #333333; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 21px; line-height: 26px;"><br />
</span></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSxZhNuf6aQCsN4Exd7naP4oLo-q6TDreHaHdyaPU8jIFs-xyl9-NJ0lLlf24UFV7LDO1bBYB17wdF85ds1pRR3VAbEcc7CDu6nHeh3YaRtkkx_ASalifSP9LpYmJt6WWEkZ9_tQz2JgU/s1600/09.08.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSxZhNuf6aQCsN4Exd7naP4oLo-q6TDreHaHdyaPU8jIFs-xyl9-NJ0lLlf24UFV7LDO1bBYB17wdF85ds1pRR3VAbEcc7CDu6nHeh3YaRtkkx_ASalifSP9LpYmJt6WWEkZ9_tQz2JgU/s640/09.08.jpg" width="640" /></a></div><br />
Can be seen on the screenshot..Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-20554532956734613012010-07-21T23:26:00.000-07:002010-07-21T23:26:53.387-07:00SharePoint trying to login deleted SSP database!Yesterday I realized a very strange issue, on SharePoint Db server event log. Sharepoint admin user was continuosly throwing login failed errors on server event log<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnQKsHI80-5nJ2_v_kZKDBxEX38e33I8Qj_cjGweBUHN-kJVhzpxioEZB5Z46t5BnVjGzTL_Z39kCSBHUjdX4TwxY0uxHAoehyphenhypheniScfOc3wGhXAunimbhRImMkm1JopAvjGXUdgnK1BEuQ/s1600/failureaudit.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="262" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnQKsHI80-5nJ2_v_kZKDBxEX38e33I8Qj_cjGweBUHN-kJVhzpxioEZB5Z46t5BnVjGzTL_Z39kCSBHUjdX4TwxY0uxHAoehyphenhypheniScfOc3wGhXAunimbhRImMkm1JopAvjGXUdgnK1BEuQ/s400/failureaudit.jpg" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">See? This event id= 18456 errors were not stopping and "Failure Audit" part panicked me. But one moment.. Everything was working ok? no service interruption, moss was fine!</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">So i just logon to SQL Server Management Studio to Sharepoint DB see what was going on on SQL error logs.</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGrHMeq8aAEHwjKWBNWCY3_tz2pelcKV8yb2Ivc0rw-cIMHOhyphenhyphenqkwit3L3YxnM3whuqww5x4ngjyMOSbSJEBgzWwsl33YJfBpxIDv_xAXf-92Q2p0IyoPpAwrIoAiwTWfoYSJT0cbYOSc/s1600/sqlservererrorlog.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="139" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGrHMeq8aAEHwjKWBNWCY3_tz2pelcKV8yb2Ivc0rw-cIMHOhyphenhyphenqkwit3L3YxnM3whuqww5x4ngjyMOSbSJEBgzWwsl33YJfBpxIDv_xAXf-92Q2p0IyoPpAwrIoAiwTWfoYSJT0cbYOSc/s640/sqlservererrorlog.jpg" width="640" /></a><br />
<div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">Login failed to Genelssp_db!!</div><div class="separator" style="clear: both; text-align: center;">But.. Genelssp_db belonged to a <b>Shared Services Provider (SSP)</b> which we deleted a few days ago!</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">Then with further investigation, found out that there is a job belonging to those dead and long gone ssp which was trying to delete expired sessions. <b><i>GenelSSp_DB_Job_DeleteExpiredSessions</i></b></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">I disabled it and everything went fine..</div><div class="separator" style="clear: both; text-align: center;">The errors are gone.</div><div class="separator" style="clear: both; text-align: center;">I dont know why moss orphaned those job because I deleted this SSP via central administration and it was a succesfull deletion.. </div><div class="separator" style="clear: both; text-align: center;"><br />
</div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-62934365699112417472010-07-06T00:44:00.000-07:002010-07-06T00:44:38.418-07:00IE 8 Datasheet view problem in SharePoint 2007On windows 7, with Internet Explorer 8 I was unable to switch the datasheet view in Sharepoint Lists.<br />
<div><br />
</div><div>When I tried to open the list in datasheet view IE8 crashes, closes the tab and reopens it by declaring "this tab has been recovered". however, it cannot open the url and says "We were unable to return you to the page you were viewing".</div><div><br />
</div><div>I tried several solutions offered on the net - but they were proposed to different IE8/Sharepoint problems. </div><div><br />
</div><div>It was obvious that this problem was related with Microsoft Office ...Finally, I tried running Office Diagnostics (which could be found under start menu> programs> microsoft office> tools) and it worked like a charm! </div><div><br />
</div><div>I cant believe IE8 causing this many problems, if you try googling "ie8 sharepoint problems" you came across a huge pool of unsolved problems, maybe you should think twice upgrading to IE 8 when using SharePoint..</div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-52197799048674295232010-06-23T00:23:00.000-07:002010-06-23T00:23:49.970-07:00Domain Controller Reboot problemYesterday we had a very strange problem.<br />
<br />
Last week our dns and DC's were upgraded to Win 2008<br />
<br />
Yesterday, After the DC reboot, Sharepoint crashed. trying to understand what happened, I saw that SQL server was unable to accept new connections and was continuously throwing this errors:<br />
<br />
<br />
<b><i>Event Type:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>Error</i></b><br />
<b><i>Event Source:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>MSSQLSERVER</i></b><br />
<b><i>Event Category:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>(4)</i></b><br />
<b><i>Event ID:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>17806</i></b><br />
<b><i>Date:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>6/23/2010</i></b><br />
<b><i>Time:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>10:05:26 AM</i></b><br />
<b><i>User:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>N/A</i></b><br />
<b><i>Computer:</i></b><span class="Apple-tab-span" style="white-space: pre;"><b><i> </i></b></span><b><i>SRV29</i></b><br />
<b><i>Description:</i></b><br />
<b><i>SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.3.0.49]</i></b><br />
<b><i><br />
</i></b><br />
<b><i>For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.</i></b><br />
<b><i><br />
</i></b><br />
<b><i>---</i></b><br />
<b><i></i></b><br />
<b><i>Event Type:<span class="Apple-tab-span" style="white-space: pre;"> </span>Failure Audit<br />
Event Source:<span class="Apple-tab-span" style="white-space: pre;"> </span>MSSQLSERVER<br />
Event Category:<span class="Apple-tab-span" style="white-space: pre;"> </span>(4)<br />
Event ID:<span class="Apple-tab-span" style="white-space: pre;"> </span>18452<br />
Date:<span class="Apple-tab-span" style="white-space: pre;"> </span>6/23/2010<br />
Time:<span class="Apple-tab-span" style="white-space: pre;"> </span>10:05:26 AM<br />
User:<span class="Apple-tab-span" style="white-space: pre;"> </span>N/A<br />
Computer:<span class="Apple-tab-span" style="white-space: pre;"> </span>SRV29<br />
Description:<br />
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.3.0.49]<br />
<br />
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.<br />
<br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;">I was panicked, that was really trouble! The first thing I did was to restart the SQL Server service, and an IIS reset on the WFE of Sharepoint side..</span><br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;"><br />
</span><br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;">But it didnt work. So I reboot both the WFE and SQL Server of Sharepoint farm and everything started to work again.</span><br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;"><br />
</span><br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;">After a little investigation, we saw that our technician had entered only the first DNS , forgot the second. After he entered both DNS we reboot the DC machines again and everything went fine. -Actually, there was a 5 seconds of interruption, which could be seen on SQL server's event log but it did not cause any service interruption and SharePoint & other applications was not affected.-</span><br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;"><br />
</span><br />
<span class="Apple-style-span" style="font-style: normal; font-weight: normal;">So If you encounter this errors after DC reboots, check if the dns name resolving is working..</span><br />
<div><br />
</div></i></b>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-65030862321439415882010-06-18T01:04:00.000-07:002010-06-18T01:04:57.761-07:00Upgrade to MOSS 2010To upgrade my existing Moss 2007 installation, which is completely sitting on a 32 Bit Windows 2003 system, first step was to install a clean Moss 2007 on Windows 2008 Server (64-bit)<br />
<br />
After installing the brand-new Sharepoint 2007, I simply created a new Web Application and attached my content database to it. (You can find a detailed how-to <a href="http://it-diaries.blogspot.com/2010/01/how-to-change-web-applications-content.html">here</a>.)<br />
<br />
After ensuring everything was working on the new installation, I started the SharePoint 2010 installation. Not very suprisingly, it required tones of stuff to be installed on the machine. which are:<br />
<br />
- 2007 Office Server SP2 (Its a shame we're still on SP1)<br />
- Windows Identity Foundation (which requires Windows Update service to be started to be installed!)<br />
- Microsoft Sync Framework Runtime v.1.0<br />
- SQL Server Native Client -very simple to install <3<br />
- Enable Windows Server Roles- Features (just enabling Web Server and Application roles should do it)<br />
- MS Filter Pack 2.0 (Which is very annoying to install, because on the net you find Filter Pack 1.0 only. the trick is that the real name of this package is Microsoft Office 2010 Filterpack. you should seek this package for installing Filter Pack 2.0)<br />
- Hotfix KB976394<br />
- PowerShell v.2.0<br />
- Ms Chart controls for .net 3.5<br />
<br />
<div style="border-collapse: collapse; font-family: 'Times New Roman'; font-size: medium; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br />
</div><div style="border-collapse: collapse; font-family: 'Times New Roman'; font-size: medium; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">After completing this steps you are ready to run the setup.exe of SharePoint 2010.. But beware the language packs! For example we had Turkish Language Pack installed on our old 2007 system.. But the release of Turkish Lang. pack for SharePoint 2010 will approximately be in July..So the upgrade will fail if you have Turkish Language Package installed on your 2007 SharePoint..</div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-35153848285652177722010-06-11T00:32:00.000-07:002010-06-11T00:32:58.857-07:00Deleting IIS logsIIS logs are residing under c:\windows\system32\logfiles by default. (on windows 2003 server)<br />
It should be named like W3SVCxxx<br />
<br />
I have an internal website, and its used by SharePoint, so I dont really need to store IIS logs older than 1 week. There is no way to automatically delete this logs. They can grow up to 50 gb in 1 year!<br />
<br />
Its safe to delete them, just keep the recent.Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-75153927492060434072010-06-11T00:05:00.000-07:002010-06-11T00:07:42.935-07:00SQL server Restore ErrorI got this error when trying to restorea database from the SQL Server Management Studio..<br />
<div><span style="color: blue;"><span style="color: blue;"> </span></span><br />
<span style="color: blue;"><span style="color: blue;"></span></span><br />
<span style="color: blue;"><span style="color: blue;"><div align="left"><br />
</div><div align="left"><span class="Apple-style-span" style="font-size: small;">An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)</span></div><div align="left"><span class="Apple-style-span" style="font-size: small;">------------------------------<br />
ADDITIONAL INFORMATION:</span></div><div align="left"><span class="Apple-style-span" style="font-size: small;">The media family on device '\\tup03srv32\Backup\SQL\tup03srv06\</span><span class="Apple-style-span" style="font-family: Times, 'Times New Roman', serif;">WSS_Content_backup_201006100000.bak</span>' is incorrectly formed. SQL Server cannot process this media family.<br />
<span class="Apple-style-span" style="font-size: small;"> RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)</span></div><div align="left"><span class="Apple-style-span" style="font-size: small;">For help, click: </span><span style="color: #003399;"><a href="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476"><span class="Apple-style-span" style="font-size: small;">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476</span></a></span></div><div align="left"><br />
</div><div align="left"><span class="Apple-style-span" style="color: black;">Then I run the restore command via Query Editor and it worked!</span></div><div align="left"><span class="Apple-style-span" style="font-size: x-small;"><br />
</span></div><div align="left"><br />
</div></span></span><span style="color: blue;"><span style="color: blue;"><span class="Apple-style-span" style="color: black;"><span style="color: blue;"><span style="color: blue;">RESTORE</span></span></span><span class="Apple-style-span" style="color: black;"> <span style="color: blue;"><span style="color: blue;">DATABASE</span></span> [WSS_Content] <span style="color: blue;"><span style="color: blue;">FROM</span></span> <span style="color: blue;"><span style="color: blue;">DISK</span></span> <span style="color: grey;"><span style="color: grey;">=</span></span> N<span style="color: red;"><span style="color: red;">'\\Tup03srv32\backup\SQL\tup03srv06\WSS_Content_backup_201006100000.bak' </span></span><span style="color: blue;"><span style="color: blue;">WITH</span></span> <span style="color: blue;"><span style="color: blue;">FILE</span></span> <span style="color: grey;"><span style="color: grey;">=</span></span> 1<span style="color: grey;"><span style="color: grey;">,</span></span> <span style="color: blue;"><span style="color: blue;">MOVE</span></span> N<span style="color: red;"><span style="color: red;">'WSS_Content'</span></span> <span style="color: blue;"><span style="color: blue;">TO</span></span> <span style="color: red;"><span style="color: red;">'c:\evrak\WSS_Content.mdf'</span></span><span style="color: grey;"><span style="color: grey;">,</span></span> <span style="color: blue;"><span style="color: blue;">MOVE</span></span> N<span style="color: red;"><span style="color: red;">'WSS_Content_log'</span></span> <span style="color: blue;"><span style="color: blue;">TO</span></span> N<span style="color: red;"><span style="color: red;">'C:\evrak\WSS_Content.ldf'</span></span><span style="color: grey;"><span style="color: grey;">,</span></span> NOUNLOAD<span style="color: grey;"><span style="color: grey;">,</span></span> <span style="color: magenta;"><span style="color: magenta;">REPLACE</span></span><span style="color: grey;"><span style="color: grey;">,</span></span> STATS <span style="color: grey;"><span style="color: grey;">=</span></span> 10</span></span></span> GO<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span></div><br />
<div><br />
</div><div><br />
</div><div><br />
</div><div><br />
</div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-67556595185317338962010-06-10T23:36:00.000-07:002010-06-10T23:36:35.696-07:00Add new content database error<span id="ctl00_PlaceHolderMain_LabelMessage">I normally prefer to do my operations from central administration. But this morning when I tried to add a new content database to a web application i got the error:</span><br />
<span id="ctl00_PlaceHolderMain_LabelMessage"><br />
</span><br />
<span id="ctl00_PlaceHolderMain_LabelMessage"><b>Attaching this database requires upgrade, which could time out the browser session. You must use the STSADM command 'addcontentdb' to attach this database.</b></span><br />
<br />
So I connected to the SERVER02 -which is the wfe hosting Central Admin-<br />
<br />
And run this command:<br />
<br />
<b>C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o addcontentdb -url http://SERVER02:81 -databasename WSS_Content_01 -databaseserver SERVER01</b><br />
<br />
<div><br />
</div><div>It worked!</div><div><br />
</div><div><br />
</div><div><br />
</div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-68102978550110534982010-05-24T01:03:00.000-07:002010-12-22T03:57:52.019-08:00The difference between WFE, Application Server and Database Server in a SharePoint FarmThe Web Front end Server is the server that is hosting IIS and serves the websites.<br />
An Application Server has services on it, for example, like Excel services, Project server, etc..<br />
A database server simply hosts the SharePoint core db's and the other Content databases.. It just has SQL Server installation on it.<br />
<br />
So you have to install Sharepoint to WFE's and App. Servers.. You dont need to install Sharepoint to the database servers on your farms.Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-23241801308657599292010-05-11T06:52:00.000-07:002010-05-11T06:52:46.235-07:00Removing an Oracle Database from WindowsIf you removed a database but it's services are still showing up at services.mcsi then;<br />
suppose the database name is demodb<br />
<br />
oradim -delete -sid demodb<br />
<br />
deletes the services, etc. related to this database.<br />
<br />
oradim is an oracle utility for windows only!Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-17238743858369467872010-04-29T05:42:00.000-07:002010-04-29T05:43:24.805-07:00Forcing Internet Explorer Language Settings to a certain valueWhen working on multilingual platforms with browser-based applications, language settings are subject to change frequently..<br />
<br />
So we had a problem about <a href="http://it-diaries.blogspot.com/2010/03/search-results-differ-from-computer-to.html">moss search</a> and we had to set the language settings of our users to include both english & turkish (as seen in the screen below)<br />
<br />
In our environment, the default value was only turkish<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgXyuMvKT3cwuOCUt5bASo6lZQyqBWMtQBLLLTn8z9UoxQC8pM752T8DaC3__SeRLnrlbGwDukxGHOaX3i6fyVP_bqhQuvkWzcUOXU4hvAvjs7V147xx529NeKQr6W_u4zavuSToieEBw/s1600/29.04.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgXyuMvKT3cwuOCUt5bASo6lZQyqBWMtQBLLLTn8z9UoxQC8pM752T8DaC3__SeRLnrlbGwDukxGHOaX3i6fyVP_bqhQuvkWzcUOXU4hvAvjs7V147xx529NeKQr6W_u4zavuSToieEBw/s400/29.04.jpg" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"> it is very hard to apply this to all users; because there is NO policy setting for this configuration.</div><div class="separator" style="clear: both; text-align: center;">this is a nightmare, especially if you have >100 users</div><div class="separator" style="clear: both; text-align: center;">moreover, after you set the value the user can reset the IE settings </div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">so I explored a little bit and found out that this setting has a registry value.</div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; text-align: center;">"<b>HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\International</b>"</div><div><br />
</div><br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;">create a file called langsetting.reg file containing this:</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;">[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\International]</div><div class="separator" style="clear: both; text-align: center;">"AcceptLanguage"="en-US,tr-TR;q=0.5"</div><div><br />
</div><div>and put it in a bat file which will run during win logon by </div><div><b><i><span style="font-family: Calibri, sans-serif;">regedit/s langsetting.reg</span></i></b></div><div><i><span style="font-family: Calibri, sans-serif;">and you are done :)</span></i></div><br />
<div class="separator" style="clear: both; text-align: center;"><br />
</div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-7977109672043098772010-04-13T00:57:00.000-07:002010-04-13T01:01:04.516-07:00Database Creation Assistant Fails during 2% complete with ora-12560<span class="Apple-style-span" style="font-family: Verdana, sans-serif;">I was installing Oracle 10g to a Windows 2003 server yesterday and the installation went okay. But at the confuguration phase, dbca failed to create a general purpose database at %2 complete with tns errors: ora-12560 and ora-12514.</span><br />
<span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br />
</span> <br />
<span class="Apple-style-span" style="font-family: Verdana, sans-serif;">So I cancelled the installation and head through metalink. After a few searches I first tried to remove / comment</span><br />
<span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br />
</span> <br />
<span class="Apple-style-span" style="font-family: Verdana, sans-serif;">SQLNET.AUTHENTICATION_SERVICES= (NTS)</span><br />
<div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">row from sqlnet.ora file. (Note </span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 6px; -webkit-border-vertical-spacing: 6px;"><strong><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">164930.1</span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-weight: normal;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">)Then tried the dbca again; but no luck.</span></span></strong></span></div><div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br />
</span> </div><div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">Then I found another note(Note </span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 6px; -webkit-border-vertical-spacing: 6px;"><strong><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">747243.1</span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-weight: normal;"><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">) stating that some policies could prevent the creation of oradba user and ora_dba group on windows. So the note suggested that I should manually create them and give it a try again. That was exciting because I found out that there was a ORA_DBA group but no ORADBA user. So I immediately created a ORADBA user and add it to administrators group on the server. But unfortunately, this did not change anything, the error was still showing up at the exact same stage..</span></span></strong></span></div><div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br />
</span> </div><div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">I hit google search and find that forum post, thankfully..</span></div><div><a href="http://forums.oracle.com/forums/thread.jspa?threadID=317706"><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">http://forums.oracle.com/forums/thread.jspa?threadID=317706</span></a><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"> (merope is me at that page :))</span></div><div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;"><br />
</span> </div><div><span class="Apple-style-span" style="font-family: Verdana, sans-serif;">Finally, changing the Regional settings of the server solved the problem. To change it, navigate to control panel, regional settings and change the language to US English in the regional options tab.. </span></div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-87004870132696441602010-04-12T04:42:00.000-07:002010-04-12T06:33:46.695-07:00Enable Archive Logging in Oracle 10gUnlike 9i, log_archive_start does not have a meaning in oracle 10g. You should do the following to enable the archive logs:<br />
<br />
Open sql*plus<br />
<br />
<b>shutdown immediate</b><br />
<div><b><br />
</b></div><div><b>startup mount</b></div><div><b><br />
</b></div><div><b>alter database archivelog</b></div><div><b><br />
</b></div><div><b>alter database open</b><br />
<br />
It can be seen on the screen below, sorry that its local language, Turkish but you can still follow it, though<br />
<br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc6_01HDyAL5hu729cOMQxL48BDTZCoEdaFrKxyvhrFDTKtTp4mM8CkRg1HSdJGmWYKzMZF-G-Vgsiah2uw_ApsninMRV8mQVcSTEw_T2qWcvSMJJuS1zsomau_Us90NDHjGTozpfP-DE/s1600/12.04.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="435" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc6_01HDyAL5hu729cOMQxL48BDTZCoEdaFrKxyvhrFDTKtTp4mM8CkRg1HSdJGmWYKzMZF-G-Vgsiah2uw_ApsninMRV8mQVcSTEw_T2qWcvSMJJuS1zsomau_Us90NDHjGTozpfP-DE/s640/12.04.jpg" width="640" /></a></div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-46006509601834041862010-04-12T03:51:00.000-07:002010-12-22T03:58:06.408-08:00User profile synchronization problemThis morning I was told that some people's profiles were showing old data in SharePoint.<br />
<div>Ooops! What does that mean: Profiles are not synchronized with Active Directory.<br />
<br />
</div><div> I immediately checked the Central Administration > Operations > Timer Job Definitions for profile sync, and saw that the jobs were hourly (by default) and they were all succeeding...<br />
<div><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNiWNHWFtBvt7kcPvId9cW8-Cg4yIFj1GhHAFNK3W5DeAxtEZNSOftxBiK26zs8OJ4BmRLNZ6YkyzMk1BH-5fLQ3EdZp1QwSy7DskWo1IaiDL6DNuG_xqrN5XrYGFrReUmejFPdzQPyTw/s1600/12.04.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="128" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNiWNHWFtBvt7kcPvId9cW8-Cg4yIFj1GhHAFNK3W5DeAxtEZNSOftxBiK26zs8OJ4BmRLNZ6YkyzMk1BH-5fLQ3EdZp1QwSy7DskWo1IaiDL6DNuG_xqrN5XrYGFrReUmejFPdzQPyTw/s640/12.04.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div>So I did a full import and it worked, the profiles started to show the new-correct data. </div><div>I scheduled the full import to be run every evening.<br />
<br />
I know this is not a complete solution but a workaround, but sometimes you have to solve it quickly :)</div></div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0tag:blogger.com,1999:blog-7457028596423165285.post-79615607170503443952010-04-01T03:46:00.000-07:002010-04-01T03:46:26.066-07:00how to create a new temporary tablespace<i><b>First create a new temp tablespace. Yes, unlike the undo tablaspace, you can have more than one temp tablespace -but only one of them could be database default temporary tablespace at once.</b></i><br />
<div><br />
</div><div>CREATE TEMPORARY TABLESPACE <strong>TEMP4 </strong>TEMPFILE '/oracleAS/TPRS/oradata/TPRS/temp4.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited <br />
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;</div><div> </div><div><i><b>now change the database default tablespace </b></i></div><div><i><b><br />
</b></i></div><div>alter database default temporary tablespace <strong>TEMP4;</strong></div><div><strong></strong> </div><div><b><i>get rid of the the old one!</i></b></div><div>drop tablespace TEMP1 including contents </div>Ova (Excuse My Reading)http://www.blogger.com/profile/06272388401733786586noreply@blogger.com0