Sharepoint 2007 如何找出占用儲存空間大的清單或文件庫?
要如何找出 Sharepoint 2007 占用磁碟空間的兇手呢?
簡要的說:
1.管理中心->應用程式管理->網站集合配額與鎖定:設定配額
2.網站設定->網站集合管理->儲存空間配置來查詢
http://guru-web.blogspot.tw/2009/04/storage-space-allocation-reports.html
About SharePoint , WSS , .Net , SQL , Oracle ...
要如何找出 Sharepoint 2007 占用磁碟空間的兇手呢?
簡要的說:
1.管理中心->應用程式管理->網站集合配額與鎖定:設定配額
2.網站設定->網站集合管理->儲存空間配置來查詢
http://guru-web.blogspot.tw/2009/04/storage-space-allocation-reports.html
標籤: SharePoint
Redmine 裝在 WEBrick 1.9.3 上面,某些電腦有可能出現速度很慢的問題,這是因為 WEBrick 有進行 DNS 反查的動作,若有電腦開啟防火牆,不允許反查的話,就有可能會發現 Retry。
可以解決茶包的方法, Windows 是在 ruby 安裝目錄裡面,例如:C:\Ruby\v1.9.3\lib\ruby\1.9.1\webrick
=============
Having the same issue here (even a year later). Under linux you have to do the following:
Look for the file /usr/lib/ruby/1.9.1/webrick/config.rb and edit it.
Replace the line
:DoNotReverseLookup => nil,
with
:DoNotReverseLookup => true,
Restart webrick and it'll work like a charm :)
http://www.redmine.org/projects/redmine/wiki/RedmineInstall
The required Ruby versions for a given Redmine version is:
Redmine version | Supported Ruby versions | Rails version used |
---|---|---|
current trunk | ruby 1.8.72, 1.9.2, 1.9.3, 2.0.01, jruby-1.6.7, jruby-1.7.2 | Rails 3.2.13 |
2.3.0 | ruby 1.8.72, 1.9.2, 1.9.3, 2.0.01, jruby-1.6.7, jruby-1.7.2 | Rails 3.2.13 |
2.2.4 | ruby 1.8.72, 1.9.2, 1.9.3, jruby-1.6.7 | Rails 3.2.13 |
For use with Ruby 1.8.7 and 1.9.3:http://rubyinstaller.org/downloads/
gem install rdoc
gem install rails -v=3.2.13
gem install bundler
D:\redmine-2.3.3>rake generate_secret_token
[31mCould not find gem 'nokogiri (< 1.6.0) x86-mingw32' in the gems available o
n this machine.[0m
[33mRun `bundle install` to install missing gems.[0m
gem install nokogiri -v=1.5.10
D:\redmine-2.3.3>rake generate_secret_token
[31mCould not find gem 'rmagick (>= 2.0.0) x86-mingw32' in the gems available o
n this machine.[0m
[33mRun `bundle install` to install missing gems.[0m
set CPATH=”C:\Program Files (x86)\ImageMagick-6.8.7-Q16\include”
set LIBRARY_PATH=C:\Program Files (x86)\ImageMagick-6.8.7-Q16\lib
D:\redmine-2.3.3>bundle install --without development test rmagick
Fetching source index from https://rubygems.org/
Could not verify the SSL certificate for https://rubygems.org/.
There is a chance you are experiencing a man-in-the-middle attack, but most
likely your system doesn't have the CA certificates needed for verification
information about OpenSSL certificates, see bit.ly/ruby-ssl. To connect wit
using SSL, edit your Gemfile sources and change 'https' to 'http'.
Notepad.exe Edit Gemfile
source 'http://rubygems.org'
D:\redmine-2.3.3>gem install rmagick
ERROR: Error installing rmagick:
The 'rmagick' native gem requires installed build tools.
Please update your PATH to include build tools or download the DevKit
from 'http://rubyinstaller.org/downloads' and follow the instructions
at 'http://github.com/oneclick/rubyinstaller/wiki/Development-Kit'
download DevKit & run devkitvars.bat to add PATH
D:\redmine-2.3.3>d:\share\RubyDevKit\devkitvars.bat
gem install rmagick --platform=ruby -- --with-opt-lib=c:/ImageMagick/lib --with-opt-include=c:/ImageMagick/include
D:\redmine-2.3.3>rake generate_secret_token
[31mCould not find gem 'jquery-rails (~> 2.0.2) x86-mingw32' in t
ble on this machine.[0m
[33mRun `bundle install` to install missing gems.[0m
SET HTTP_PROXY=http://<ip>:<port>
Fetching source index from https://rubygems.org/
Could not verify the SSL certificate for https://rubygems.org/.
There is a chance you are experiencing a man-in-the-middle attack, but most
likely your system doesn't have the CA certificates needed for verification
information about OpenSSL certificates, see bit.ly/ruby-ssl. To connect wit
using SSL, edit your Gemfile sources and change 'https' to 'http'.
Notepad.exe Edit Gemfile
source 'http://rubygems.org'
剪貼簿貼上
https://github.com/peclik/clipboard_image_paste
RedmineCRM:Check List
http://redminecrm.com/projects/checklist/pages/1
http://redminecrm.com/pages/plugins
win32-service
+ taskill
approach)
sc create redmine binPath= "C:\Ruby193\bin\rubyw -C D:\redmine\ service.rb"
參考連結
http://crboy.logdown.com/posts/141615-install-redmine-on-windows
http://www.imagemagick.org/script/binary-releases.php#windows
剛剛換了 Oulook 2013 ,寫信寫到一半,插入表格後,想利用尺規來調整表格欄寬,結果一直找不到藏到那邊去了,後來還是 Google 後才找到解決方式。
解決方式如下圖
原文網址
最近需要將一台NB搬進虛擬化的世界,之前經驗上使用了 Acronis True Image 來進行實體轉虛擬的動作,
本次使用了微軟的 Disk2VHD 的工具,這個工具的介紹,蘇老寫得很仔細,我就先跳過。
結果使用了自動修復程序仍無法成功開機,後來使用了安全模式來移除不必要的驅動程式,方法如下:
開始 > 執行 > cmd, 然後在command prompt 內鍵入:
set devmgr_show_nonpresent_devices=1
之後再鍵入:
devmgmt.msc
這時會開啟裝置管理員,在工具列的檢視內選取「顯示隱藏的裝置」,然後在這裡會看到一些灰色的裝置,這些就是以往安裝了的驅動程式,確認沒用後就可以將它移除掉了。
http://stackoverflow.com/questions/7428052/suggestions-for-troubleshooting-slow-tfs-server
C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe.config
<system.net>
<defaultProxy enabled="false"/>
<settings>
<ipv6 enabled="true"/>
</settings>
</system.net>
安裝 ImageMagick for windows
http://www.imagemagick.org/script/binary-releases.php#windows
安裝 Ghostscript for windows
http://www.ghostscript.com/download/gsdnld.html
寫一支 pdf2tiff.bat 檔,轉出格式為「高解析度的傳真用 TIFF」也就是俗稱的 TIFF G3/G4 Format
C:\ImageMagick\convert -density 204x196 -monochrome -compress Fax %1 %2
接下來就可以呼叫產生
tiff2pdf.bat d:\temp\a.pdf d:\0temp\a.tif
看一下檔案內容,沒錯,就是 FAX TIFF 的格式
之前本來有打算採用 Reporting Service 來產生 FAX TIFF ,但是不通,因為不是 FAX 使用的 TIFF 格式(壓縮方式不同)
如果沒有安裝 Ghostscript 的話,會出現
While reading gs_lev2.ps:
%%[ Error: invalidaccess; OffendingCommand: put ]%%
標籤: GhostScript, How To, ImageMagick, PDF, TIFF
今天遇到要輸入 HSI 恒生指數的代碼,結果 Excel 就一直幫我換成 HIS ,後來發現,檔案->選項->校訂->自動校正->自動取代字串,有一個 hsi –> his,但是明明我寫的是大寫,應該要忽略才對,只好將「自動取代字串」取消後就正常… Orz…
今天發現一個錯誤訊息
The process could not be created for step 1 of job reason 1314
尋線追查後發現,若 SQL Agent 帳號有變更,需加入群組 SQLServer2005SQLAgentUser$<machine_name>,再重啟 SQL Agent 服務後排除問題
1314 = "A required privilege is not held by the client."
It is the SQL Agent account with the trouble perhaps, and not just the proxy account.
Make sure you reset the SQL Server service account by using the Configuration Manager, so that the service account you choose gets added into SQLServer2005SQLAgentUser$<machine_name>. If the current service account for SQL Agent is not in that group, add it to that group manually, or swap the service account to local system, save, then swap it back again to the desired account and type the password (using configuration manager)
You may have missed a couple of the user rights (administrators group may not include these privileges)
http://msdn.microsoft.com/en-us/library/ms143504(SQL.90).aspx
- Log on as a service (SeServiceLogonRight)
- Act as part of the operating system (SeTcbPrivilege) (only on Windows 2000)
- Log on as a batch job (SeBatchLogonRight)
- Replace a process-level token (SeAssignPrimaryTokenPrivilege)
- Bypass traverse checking (SeChangeNotifyPrivilege)
- Adjust memory quotas for a process (SeIncreaseQuotaPrivilege)
標籤: KB, SQL Agent, SQL Server
若帳號只屬於 db_reader,不是屬於 db_owner 角色時,語法中含有 store procedure or function 時,會出現此類錯誤訊息
The EXECUTE permission was denied on the object ????, database ????, schema 'dbo'
解決方式:
1.建立角色
CREATE ROLE [myRole] AUTHORIZATION [dbo]
2.設定執行預存程序或函式權限給與角色
GRANT EXEC ON dbo.usp_Michael TO myRole
3.將登入帳號加入角色
EXEC sp_addrolemember N'myRole', N'login_user'
標籤: KB, SQL Server, Tips
---------------------------
Microsoft Visual Studio
---------------------------
TF10151: 無法鎖定項目 $/xxxx.Wcf.dll 以簽出。項目 $/xxxx.dll 已在工作區 xxxxxx 中由 xxxx 簽出。
---------------------------
OK
---------------------------
---------------------------
Microsoft Visual Studio
---------------------------
The command you are attempting cannot be completed because the file xxxx.dll' that must be modified cannot be changed. If the file is under source control, you may want to check it out; if the file is read-only on disk, you may want to change its attributes.
---------------------------
OK
---------------------------
發生的原因在於 VS2010 在 WebSite Project 的 Reference DLL 會自動 check out,加上 TFS 針對 DLL 這個類型是不允許合併(non-mergable),所以就會自動 Lock 鎖定。
目前我解決的方式是將 Team Project Collection 中,針對 dll 這種型別 check out 時,不需進行鎖定
Event code: 3008
Event message: A configuration error has occurred.
Event time: 2013/3/18 下午 04:36:49
Event time (UTC): 2013/3/18 上午 08:36:49
Event ID: 14538e1dd6d04500b57f0eaee698b821
Event sequence: 103
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/TEST/xxxxx
Trust level: Full
Application Virtual Path: /TEST/xxxxx
Application Path: D:\WEB\TEST\xxxxx\
Machine name: MichAdelPC
Process information:
Process ID: 38460
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: ConfigurationErrorsException
Exception message: 在應用程式組態中找不到連線名稱 'OraAspNetConString', 或者連線字串空白. (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 284)
at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
at System.Web.Configuration.ProvidersHelper.InstantiateProviders(ProviderSettingsCollection configProviders, ProviderCollection providers, Type providerType)
at System.Web.Configuration.SiteMapSection.get_ProvidersInternal()
at System.Web.SiteMap.Initialize()
at System.Web.SiteMap.get_Providers()
at Admin.Menu.BindMenu() in d:\WEB\TEST\xxxxx\admin\menu.ascx.cs:line 85
at Admin.Menu.OnLoad(EventArgs e) in d:\WEB\TEST\xxxxx\admin\menu.ascx.cs:line 60
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.default_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\xxxxxx\1cb83f19\15321ffe\App_Web_4cg0xawa.8.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在應用程式組態中找不到連線名稱 'OraAspNetConString', 或者連線字串空白.
at Oracle.Web.Util.ReadConnectionString(NameValueCollection config)
at Oracle.Web.SiteMap.OracleSiteMapProvider.Initialize(String name, NameValueCollection config)
at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
原因: Oracle Client 於 11gR5 之後,提供 ASP.NET Membership for Oracle,但是在安裝 Oracle 時,會要再進階設定才會正常
修正方式:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
<system.web>
<membership><providers>:移除
<add name="OracleMembershipProvider" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
<profile><providers>:移除
<add name="OracleProfileProvider" type="Oracle.Web.Profile.OracleProfileProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" />
<roleManager><providers>:移除
<add name="OracleRoleProvider" type="Oracle.Web.Security.OracleRoleProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" />
<siteMap><providers>:移除
<add name="OracleSiteMapProvider" type="Oracle.Web.SiteMap.OracleSiteMapProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" securityTrimmingEnabled="true" />
<webParts><personalization><providers>:移除
<add name="OraclePersonalizationProvider" type="Oracle.Web.Personalization.OraclePersonalizationProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" />
<healthMonitoring><providers>:移除
<add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />
(重要:請將設定檔放在一個安全的地方,例如 c:\windows\)
格式:
<PPPoE名稱>【tab】<撥接使用者名稱>【tab】<撥接密碼>
說明:
<PPPoE名稱>:要跟下圖撥接名稱相符
==========================================================
@echo off
setlocal enabledelayedexpansion
::rasinfo.txt
:: one line
:: <connection name><tab><username><tab><password>
:: Nothing else!!
for /F "tokens=1-3 delims= " %%a in (c:\windows\rasinfo.bin) do (
set ras_connect=%%a
set ras_user=%%b
set ras_pass=%%c
)
for /f "tokens=1* delims=:" %%a in ('ipconfig') do set exclude=%%b
set exclude=%exclude:~1,-1%
:loop
ping google.com -n 1|find /v "%exclude%"|>nul find /i "reply"
if not errorlevel 1 (
echo Connected ^^ sleep 10 sec...
>nul ping 0.0.0.0 -n 10
) else (
ping google.com -n 1|find /v /i "%exclude%"|>nul find /i "reply"
if errorlevel 1 (
echo "PACKETS NOT BEING RECIEVED Orz..."
rasdial %ras_connect% /disconnect
rasdial %ras_connect% %ras_user% %ras_pass%
)
)
goto loop
===================================================
說明:此批次檔會去 ping 0.0.0.0 若是沒有收到封包時就會撥接 PPPoE
啟動時間有兩個,一個是開機時跑,另一個是每小時跑一次
這樣子做就可以省一些錢去買自動撥接的軟體囉
遇到 TF14045 識別(Identity)錯誤,原本以為是 TFS2012 Update1的錯誤,但是與微軟連繫後,取得 hotfix 安裝後,仍是無法解決。
後來直接使用 SQL Profiler 抓取 TFS 的動作後,發現有以下指令
↓SQL Profilier請抓取 SP:Completed 及 RPC:Completed 這兩個事件
declare @p3 dbo.typ_GuidInt32Table insert into @p3 values('<IDENTITY-GUID>',0) exec prc_ReadIdentities @partitionId=1,@descriptors=default,@ids=@p3 declare @p2 dbo.typ_GuidTable insert into @p2 values('<IDENTITY-GUID>') exec prc_ReadGroupMembership @partitionId=1,@identityIds=@p2,@childrenQuery=0,@parentsQuery=0,@includeRestricted=0,@minInactivatedTime=NULL,@scopeId='<SCOPE-GUID>',@returnVisibleIdentities=1;
1: declare @p3 dbo.typ_GuidInt32Table
2: insert into @p3 values('<IDENTITY-GUID>',0)
3:
4: exec prc_ReadIdentities @partitionId=1,@descriptors=default,@ids=@p3
5:
6: declare @p2 dbo.typ_GuidTable
7: insert into @p2 values('<IDENTITY-GUID>')
8:
9: exec prc_ReadGroupMembership @partitionId=1,@identityIds=@p2,@childrenQuery=0,@parentsQuery=0,@includeRestricted=0,@minInactivatedTime=NULL,@scopeId='<SCOPE-GUID>',@returnVisibleIdentities=1;
LINE4,會出現結果,但是 LINE9就回傳空的結果集,這就有可能造成爆炸的原因。
解決的方式為:
在專案中加入此使用者,再查詢後就會 Active=1 的結果,若不需要此使用者繼續參與專案的話,可以再移除,此時會出現 Active=0
參考資訊:
升级TFS2012查看SOURCE-history部分提示TF14045: The identity xxx is not a recognized identity
升级TFS2012查看SOURCE-history部分提示TF14045: The identity xxx is not a recognized identity
遇到了一個怪現象, VS2012 的 Publish 不動作,開啟茶包訊息輸出也找不到原因
3> Done building target "GatherAllFilesToPublish" in project "xxxx.csproj".
3>Done building project "xxxx.csproj".
3>Publishing folder /...
3>
========== Build: 0 succeeded or up-to-date, 0 failed, 2 skipped ==========
========== Publish: 1 succeeded, 0 failed, 0 skipped ==========
Publish Profiles 有放在專案裡面,設定檔砍掉再試試看一次,結果…成…功…了!!
找了一下網路的解決方式,似乎對我沒有用,我已經將我的解決方法丟至 StackOverFlow。
http://stackoverflow.com/questions/12201146/visual-studio-2012-web-publish-doesnt-copy-files
1.下載 Android SDK
http://developer.android.com/sdk/index.html
http://dl.google.com/android/adt/adt-bundle-windows-x86_64.zip
2.用 Android Virtual Device Manager 設定 Device
…adt-bundle-windows-x86_64\sdk\tools>android.bat avd
啟動模擬器
adt-bundle-windows-x86_64\adt-bundle-windows-x86_64\sdk\tools>emulator.exe -avd note2
參考資訊
Using the Android Emulator
Franma已經寫得很清楚,如何利用VSSConvert 工具將 VSS 2005 移轉至 TFS 2010
黑大也有一篇文章補充,VSSConverter匯入TFS之SQL需求補充
這邊只是補充一些遇到的狀況:
問題:本機安裝的不是 SQL Express 該怎麼辦?
訊息:
TF60022: Unable to connect to Microsoft SQL Server .\SQLEXPRESS. A network-rela
ted or instance-specific error occurred while establishing a connection to SQL S
erver. The server was not found or was not accessible. Verify that the instance
name is correct and that SQL Server is configured to allow remote connections. (
provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Spe
cified)
解決方式:VSSConverter匯入TFS之SQL需求補充
撰寫 Setting File 所需要的小工具
小工具一:列舉出 VSS DB $/ 底下的目錄(Project),請注意,列舉出來目錄是 $ATM,但是設定檔會需要 $/ATM 這樣子的格式。
SET SSDIR=c:\vssdb
C:\Program Files (x86)\Microsoft Visual SourceSafe\SS.exe dir
小工具二:刪除VSS DB 中不需要的目錄(Prject),重點在於 -I-Y ,
若執行過程中有錯誤訊息會出現 continue?(Y/N),要一直按 Y 也很煩人,這個指令就很好用!!
SET SSDIR=c:\vssdb
C:\Program Files (x86)\Microsoft Visual SourceSafe\SS.exe Delete $/delete-me -I-Y
小工具三:UltraEdit or Excel
UltreEdit 可以用來行列編輯,另外 Excel 也可拿來產生設定檔,例如下圖:
公式也不難寫,例如C2這一格的公式為:="<Project Source="""&A2&""" Destination="""&"$\temp\"&A2&"""></Project>"