I found it from http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/721bec39-2d32-4bbc-9094-a021a0d06dcb
0 - GLOBAL (SetupPath=global) - "Global template"
1 - STS - "windows SharePoint Services Site", "Team Site", "Blank Site", "Document Workspace"
2 - MPS - "Basic Meeting Workspace", "Blank Meeting Workspace", "Decision Meeting Workspace", "Social Meeting Workspace", "Multipage Meeting Workspace"
3 - CENTRALADMIN - "Central Admin Site"
4 - WIKI - "Wiki Site"
7 - BDR - "Document Center"
9 - BLOG - "Blog"
20 - SPS (OBSOLETE) - "SharePoint Portal Server Site"
21 - SPSPERS - "SharePoint Portal Server Personal Space"
22 - SPSMSITE - "Personalization Site"30 - SPSTOC (OBSOLETE) - "Contents area Template"
31 - SPSTOPIC (OBSOLETE) - "Topic area template"
32 - SPSNEWS (OBSOLETE) - "News area template"
33 - SPSNHOME (SubWebOnly) - "News Home template"
34 - SPSSITES - "Site Directory area template"
36 - SPSCOMMU (OBSOLETE) - "Community area template"
38 - SPSREPORTCENTER - "Report Center Site"
39 - CMSPUBLISHING (SetupPath=SiteTemplates\PUBLISHING) - "Publishing and Team Collaboration Site"
40 - OSRV (SetupPath=SiteTemplates\OSRV) - "Shared Services Administration Site"
47 - SPSPORTAL - "Corporate Intranet Site"
50 - SRCHCEN - "Search Center"
51 - PROFILES - "Profiles"
52 - BLANKINTERNETCONTAINER - "Internet Presence Web Site"
53 - BLANKINTERNET - "Publishing Site", "Press Releases Site", "Publishing Site"
54 - SPSMSITEHOST - "My Site Host"
90 - SRCHCENTERLITE (SetupPath=SiteTemplates\SRCHCENTERLITE) - "Search Center Lite"
6221 - PWA (SetupPath=SiteTemplates\PWA) - "Project Web Access Site"
6215 - PWS (SetupPath=SiteTemplates\PWS) - "Project Workspace"
14483 - OFFILE - "Records Repository", "Records Repository"
Sunday, May 31, 2009
Tuesday, May 19, 2009
Let's Talk about .. MOSS2007-Runtime Error without any details
Yesterday, I found a Runtime Error page instead of web site showing. A support engineer from Microsoft suggested me to modify web.config of my MOSS in C:\Inetpub\wwwroot\wss\VirtualDirectories\[YOUR_PORT] as following
-in SafeMode tag, set Attribute CallStack="True"
-in customErrors, set Attribute Mode="Off"
I found that my web.config already be set like that. Then, he checked again and found that there are 2 locations of web.config since I have 2 Server: MOSS and DB which I also set both of them as Web Front End server (by installing MOSS to both of them). Thus, two web.config(s) had to be modified. Then, I could see what the error was.
-in SafeMode tag, set Attribute CallStack="True"
-in customErrors, set Attribute Mode="Off"
I found that my web.config already be set like that. Then, he checked again and found that there are 2 locations of web.config since I have 2 Server: MOSS and DB which I also set both of them as Web Front End server (by installing MOSS to both of them). Thus, two web.config(s) had to be modified. Then, I could see what the error was.
Tuesday, May 12, 2009
Let's Talk about .. MOSS2007-Back up SharePoint FULL with Scheduled Tasks
Yesterday, I was assigned to perform a back up schedule for MOSS.
The concept is full backing up for SharePoint and Site Collection backing up for each site collection.
P’Pop Wantit Tangrugsasut, senior system analyst from CS division, teached me about a concept and how to do it.
The instruction to back up Site Collection as Scheduled Task
-Create a shared folder name “ERP_MOSS_Backup”. It must be shared and added permission to write the files to the Admin account.
-Write a script at the Database server for creating folder.
[Batch file]
@ECHO OFF
FOR /F "tokens=1-4 delims=/ " %%I IN ('DATE /t') DO SET mydate=%%J%%K%%L
cd \
F:
cd "Moss_Backup"
mkdir "Moss_Backup_%mydate%"
-Save it at that Folder
-Set the Scheduled Task for the script by this instruction http://natttech.blogspot.com/2009/05/lets-talk-about-windows-server-2003.html
-Write a script to Back up MOSS (FULL)
[Batch file]
@ECHO OFF
FOR /F "tokens=1-4 delims=/ " %%I IN ('DATE /t') DO SET mydate=%%J%%K%%L
cd \
c:
cd "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\"
STSADM.exe -o backup -directory \\[SERVER_NAME]\[FOLDER_NAME]\Moss_Backup_%mydate% -backupmethod full
Where [SERVER_NAME] is your server name to put the backup files there
And [FOLDER_NAME] is your folder you wanna put the backup files
-Or Write a script to Back up Site Collection MOSS
[Batch file]
@ECHO OFF
FOR /F "tokens=1-4 delims=/ " %%I IN ('DATE /t') DO SET mydate=%%J%%K%%L
cd \
c:
cd "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\"
stsadm.exe -o backup -url http://[MOSSWebApp]/Sites/[SiteCollection_NAME] -filename "\\[SERVER_NAME]\[FOLDER_NAME]\Moss_Backup_%mydate%\[FILE_NAME].dat" –overwrite
Where [SERVER_NAME] is your server name to put the backup files there
And [FOLDER_NAME] is your folder you wanna put the backup files
And [FILE_NAME] is your backup file name
The concept is full backing up for SharePoint and Site Collection backing up for each site collection.
P’Pop Wantit Tangrugsasut, senior system analyst from CS division, teached me about a concept and how to do it.
The instruction to back up Site Collection as Scheduled Task
-Create a shared folder name “ERP_MOSS_Backup”. It must be shared and added permission to write the files to the Admin account.
-Write a script at the Database server for creating folder.
[Batch file]
@ECHO OFF
FOR /F "tokens=1-4 delims=/ " %%I IN ('DATE /t') DO SET mydate=%%J%%K%%L
cd \
F:
cd "Moss_Backup"
mkdir "Moss_Backup_%mydate%"
-Save it at that Folder
-Set the Scheduled Task for the script by this instruction http://natttech.blogspot.com/2009/05/lets-talk-about-windows-server-2003.html
-Write a script to Back up MOSS (FULL)
[Batch file]
@ECHO OFF
FOR /F "tokens=1-4 delims=/ " %%I IN ('DATE /t') DO SET mydate=%%J%%K%%L
cd \
c:
cd "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\"
STSADM.exe -o backup -directory \\[SERVER_NAME]\[FOLDER_NAME]\Moss_Backup_%mydate% -backupmethod full
Where [SERVER_NAME] is your server name to put the backup files there
And [FOLDER_NAME] is your folder you wanna put the backup files
-Or Write a script to Back up Site Collection MOSS
[Batch file]
@ECHO OFF
FOR /F "tokens=1-4 delims=/ " %%I IN ('DATE /t') DO SET mydate=%%J%%K%%L
cd \
c:
cd "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\"
stsadm.exe -o backup -url http://[MOSSWebApp]/Sites/[SiteCollection_NAME] -filename "\\[SERVER_NAME]\[FOLDER_NAME]\Moss_Backup_%mydate%\[FILE_NAME].dat" –overwrite
Where [SERVER_NAME] is your server name to put the backup files there
And [FOLDER_NAME] is your folder you wanna put the backup files
And [FILE_NAME] is your backup file name
Let's Talk about .. Windows Server 2003-Scheduled Task
Today, P’Pop Wantit Tangrugsasut teached me about how to set the Scheduled Task in Windows Server.
The instruction to set Scheduled Task
-Go to Start->Control Panel->Scheduled Tasks
-Double Click at Add Scheduled Task
-Click Next button
-Click Browse
-Select your script file’s location
-Select Perform this task, for me, I chose Weekly
-Click Next button
-Set the Start time:, Every weeks, and Select the day(s)
-Click Next button
-Enter the user name and password
-Click Next button
-Click Finish button
-For best practice, enter your task again, and go to Settings tab.
-Set the Stop the task if it runs for XX hour(s) XX minute(s) as your suitable time.
The instruction to set Scheduled Task
-Go to Start->Control Panel->Scheduled Tasks
-Double Click at Add Scheduled Task-Click Next button
-Click Browse
-Select your script file’s location
-Select Perform this task, for me, I chose Weekly
-Click Next button
-Set the Start time:, Every weeks, and Select the day(s)
-Click Next button
-Enter the user name and password
-Click Next button
-Click Finish button
-For best practice, enter your task again, and go to Settings tab.
-Set the Stop the task if it runs for XX hour(s) XX minute(s) as your suitable time.Friday, April 24, 2009
Let's Talk about .. MOSS2007-Content Type
Yesterday, I joined the wrap up day of my division meeting with Mr.Chatree, counsult from Microsoft. He talked about Content Type of MOSS2007 that make me understand clearer about it.
The content type is like a group of metadata that are separated via the type of documents. The content type can be used with any (Document Library of) site if it is located at the top level site.
The content type is like a group of metadata that are separated via the type of documents. The content type can be used with any (Document Library of) site if it is located at the top level site.
Tuesday, March 31, 2009
Let's Talk about .. MOSS2007&Reporting Service-Error The request failed with HTTP status 401 : Unauthorized
After I managed integration settings and granted database access, I clicked at Set server defaults in Reporting Services of Application Management. Then, I got an error page "An unexpected error occured while connection to the report server. Verify that the report server is available and configured for SharePoint integrated mode. -> Server was unable to process request. ---> The request failed with HTTP status 401 : Unauthorized" as shown in the figure.
After I managed integration settings and granted database access, I clicked at Set server defaults in Reporting Services of Application Management. Then, I got an error page "An unexpected error occured while connection to the report server. Verify that the report server is available and configured for SharePoint integrated mode. -> Server was unable to process request. ---> The request failed with HTTP status 401 : Unauthorized" as shown in the figure.
We discussed and connected live meeting with a support engineer from Microsoft. He said that the cause was the authentication mode of ReportServer host website. The way he used to solve this problem was running the command
We discussed and connected live meeting with a support engineer from Microsoft. He said that the cause was the authentication mode of ReportServer host website. The way he used to solve this problem was running the command
[CMD]
cd c:\Inetpub\Adminscriptscscript adsutil.vbs set w3svc\c:\Inetpub\Adminscrpts cscript
cd C:\Inetpub\Adminscripts cscript adsutil.vbs set w3svc/XXXXXXXXX/root/NTAuthenticationProviders "NTLM“cscript adsutil.vbs set w3svc/XXXXXXXXX/NTAuthenticationProviders "NTLM"
cd C:\Inetpub\Adminscripts cscript adsutil.vbs set w3svc/XXXXXXXXX/root/NTAuthenticationProviders "NTLM“cscript adsutil.vbs set w3svc/XXXXXXXXX/NTAuthenticationProviders "NTLM"
where XXXXXXXXX is the identifier of the ReportServer host website.
Sunday, March 15, 2009
Let's Talk about .. SQL Server 2005 & 2008
Last Thursday, I participated the meeting of MS SQL Server 2008 Presentation by Mr.Nicolas and Mr.Jason , engineers from Microsoft.
Because my office member have started using Reporting Services in our systems, thus we would like to discuss about it and the problems we found.
The first one they suggested is "Scale Out". They recommended us to use many report servers to point to the report catalog.
The important one they suggested us to use was Report Catalog. The Report Catalog consists of Reporting Services Database (RSDB) and Reporting Services Tempolary Database (RSTempDB). It has a lot of I/O of transaction.
1.RSDB stores the report's metadata, including snapshots. It is long living, thus it should be backed up.
2.RSTempDB stores tempolary snapshot while running reports. It is highly volatile. And since its volatile, we need the report lifetime policy of data by setting session timeout value (10 min): Clean up Cycle Minutes guides background clean up thread.
Then, how different between RS2005 and RS2008.
For RS2005,
-Many insert to Chunk Data
-Many insert to Snapshot Data
-Many insert to Session Data Table
For RS2008,
-Many insert to Segment; take majority of transation of RSTempDB
Some trip to optimize the Report Performance
-Remove the unnecessary columns
-Bring rendered report to user, for example, doc, pdf, etc.
They showed us the new tool, MS SQL Server 2008 Report Builder. It looks like MS Office 2007 Application because of its theme. In the future, users can design and use the reports themselves. I asked them if there are any features that we still need Visual Studio 2008 to develop the report. They answered me that the Report Builder can do anything VS2008 can except debugging and creating and using several data sources.
Because my office member have started using Reporting Services in our systems, thus we would like to discuss about it and the problems we found.
The first one they suggested is "Scale Out". They recommended us to use many report servers to point to the report catalog.
The important one they suggested us to use was Report Catalog. The Report Catalog consists of Reporting Services Database (RSDB) and Reporting Services Tempolary Database (RSTempDB). It has a lot of I/O of transaction.
1.RSDB stores the report's metadata, including snapshots. It is long living, thus it should be backed up.
2.RSTempDB stores tempolary snapshot while running reports. It is highly volatile. And since its volatile, we need the report lifetime policy of data by setting session timeout value (10 min): Clean up Cycle Minutes guides background clean up thread.
Then, how different between RS2005 and RS2008.
For RS2005,
-Many insert to Chunk Data
-Many insert to Snapshot Data
-Many insert to Session Data Table
For RS2008,
-Many insert to Segment; take majority of transation of RSTempDB
Some trip to optimize the Report Performance
-Remove the unnecessary columns
-Bring rendered report to user, for example, doc, pdf, etc.
They showed us the new tool, MS SQL Server 2008 Report Builder. It looks like MS Office 2007 Application because of its theme. In the future, users can design and use the reports themselves. I asked them if there are any features that we still need Visual Studio 2008 to develop the report. They answered me that the Report Builder can do anything VS2008 can except debugging and creating and using several data sources.
Subscribe to:
Posts (Atom)