Brzi Impression: System Center Capacity Planner za SharePoint

I just fired up the capacity planning tool that’s all the rage these days.

Našao sam ga jednostavan za korištenje i brzo po uzoru klijenta okruženje sam radio na ovom prošlog ljeta.

S nekim strahom, Ja pritisne konačnu tipku OK i to preporučeno nešto što je prilično slično onome što mi je dao naš klijent (we actually threw in a second application server for future excel use). I take that to be a good sign and increases my confidence in the tool.

It seems pretty powerful stuff a much better starting point than a blank page.

I like that lets you get into some good detail about the environment. How many users, how you project they will use the system (publishing, collaboration, itd.), branch office and connectivity / network capacity between them and the mama server. Good stuff.

It asks broad based questions and then lets you tweak the details for a pretty granular model of your environment.

I hesitated downloading it because I have so many other things to look at it, read and try to digest. I’m glad I did.

It’s an easy two-step process. Download system center capacity planner and then download the SharePoint models. It runs nicely on Windows XP.

Based on my quick impression, I don’t see how it might account for:

  • Traži: Total documents, maybe types of documents, languages.
  • Excel server: how much, if at all?
  • Forms server: how much, if at all?
  • BDC: how much, if at all.

Those may be modeled and I just didn’t see them in the 10 minute review.

I will definitely use it at my next client.

If I were not a consultant and instead working for a real company :), I’d model my current environment and see how the tool’s recommended model matches up against reality. That would be pretty neat. It could lead to some good infrastructure discussion.

</kraj>

Technorati Tags:

Otopina: System.IO.FileNotFoundException na “SPSite = new SPSite(url)”

UPDATE: Sam objavio ovo pitanje na MSDN ovdje (http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=2808543&SiteID=1&mode=1) and Michael Washam of Microsoft responded with a concise answer.

I stvorio je web servis da djeluju kao BDC-friendly fasada to a SharePoint list. When I used this from my development environment, Internet izrađen prekid. Kada sam doselila to na novi server, Naišao sam ovu pogrešku:

System.IO.FileNotFoundException: Web aplikacija na http://localhost/sandbox nije mogao biti pronađen. Provjerite jeste li ispravno upisali URL. Ako URL treba posluživanje postojeći sadržaj, Administrator sustava možda ćete morati dodati novi URL mapiranje zahtjev za namjeravanu primjenu. na Microsoft.SharePoint.SPSite .. ctor(SPFarm farma, Uri requestUri, Booleova contextSite, SPUserToken userToken) na Microsoft.SharePoint.SPSite .. ctor(String requestUrl) na Conchango.xyzzy.GetExistingDocument(String minId, String maxId, String titleFilter) u C:\Documents and Settings Paul My Documents Visual Studio 2005 Projects xyzzy BDC_DocReview BDC_DocReview DocReviewFacade.asmx.cs:linija 69

Ovdje je linija 69:

pomoću (SPSite stranica = new SPSite("http://localhost/sandbox"))

Pokušao sam različite varijacije na URL, uključujući i korištenje poslužitelja pravo ime, njegova IP adresa, prateći kose na URL, itd.. I always got that error.

Koristio sam Google to research it. Lots of people face this issue, ili varijante njega, ali nitko se činilo da su to riješiti.

Vragolast MOSS dostavi detaljan pogreška da to nije palo na pamet provjeriti 12 hive logs. Konačno, oko 24 sata nakon moj kolega preporučio bih učiniti, Provjerio sam iz 12 Grozd dnevnik i našli ovo:

Iznimka se dogodila dok je pokušavao steći lokalnu farmu:
System.Security.SecurityException: Traženi registra pristup nije dopušten.
na System.ThrowHelper.ThrowSecurityException(ExceptionResource resursima) na
(String ime, Booleova pisati) na
(String ime) na
() na
() na
(SPFarm& farma, Booleova& isJoined)
Zona skupštini da nije bilo:  MyComputer

To je otvorilo nove putove istraživanja, tako da je povratak na Google. To me dovelo do toga Post foruma: http://forums.codecharge.com / posts.php?post_id = 67135. That didn’t really help me but it did start making me think there was a database and/or security issue. I soldiered on and Andrew Connell je post finally triggered the thought that I should make sure that the application pool’s identity account had appropriate access to the database. I thought it already did. Međutim, moj kolega je otišao i dao identiteta app bazen račun puni pristup SQL.

Čim je napravio tu promjenu, everything started working.

Što se dogodilo sljedeća najbolja izražava se kao haiku pjesma:

Problemi podići svoje ruke.
You swing and miss. Try again.
Uspjeh! But how? Zašto?

Ona nije željela ostaviti stvari samo tako, radije dati minimalnu potrebnu dozvolu (i vjerojatno s okom na pisanje blogu; Sam je pobijedio na punch, muhahahahaha!).

Ona uklanja uzastopnih dozvole od identiteta app pool račun sve dok … there was no longer any explicit permission for the app pool identity account at all. The web service continued to work just fine.

We went and rebooted the servers. Everything continued to work fine.

Tako, da recap: we gave the app pool identity full access and then took it away. The web service started working and never stopped working. Bizarre.

Ako itko zna zašto se to trebalo radio, molimo vas da ostavite komentar.

</kraj>

Technorati Tags:

Otopina (vrsta): Postavite prioritet zadatka pomoću SharePoint Designer

Imam poslovni scenarij kao što je ovaj:

  • Korisnik slike dokumenta u biblioteku dokumenata.
  • Ona odabire vrstu sadržaja i ulazi u meta podatke prema potrebi. Jedno od područja meta podataka je zastava, "Urgent".
  • To pokreće tijek rada SharePoint Designer da, između ostalog, uses the "Collect Data from a User" akcija.

"Collect Data from a User" stvara stavku u popisu zadataka traži odobrenje za taj dokument.

Morao sam stvoriti pogled na popis zadataka koji je pokazao hitnih zahtjeva za odobrenje.

Otopina: Put the word "URGENT:" into the title of these tasks.

I would have preferred to specify the priority field directly. Međutim, Bio sam u mogućnosti to učiniti za nekoliko razloga:

  1. Prikupiti podaci akcija ne pružaju mehanizam za ažuriranje bilo koje polje, osim naslova (i one dodatne stavke za koje želite da prikupljamo podatke).
  2. The "assign a to do item" akcija ima isti problem.
  3. Moguće je umetanje stavke u popisu (i.e. umetanje stavke u popisu zadataka izravno) but this not a blocking action. That means that the workflow will not wait for the user to complete that task.

Smatrao sam nekoliko pristupa prije (srećom) realizing we could just put "urgent" u naslovu.

  1. Početak tijeka rada na popisu zadataka sama, tako da kada novi zadatak je stvorio, to nekako prijeći reference natrag u dokumentu koji je započeo prvi radni tijek, pull out the urgent flag value and update priority as needed.
  2. Do something similar with an event receiver. On create of the task, pronađite pripadajući dokument i ažurirati prioritet po potrebi.
  3. Use the "create list item" action in conjunction with the "wait for field change" action and an event receiver. If we create a list item, we can specify all the fields we want. Use an event receiver to update the original item when the user completes the task and the "wait for field change" action’s condition would be met and the workflow would proceed. (Iz nekog razloga, Imao sam više ili manje naselili na ovom pristupu prije mudro odluči otići na neko vrijeme).

Tu je nedostatak moje rješenje (osim očitih činjenica da je samo tekst pod naslovom ukazuje hitnost). Since "collect feedback" prihvaća samo tvrdi kodirani naslov imena, I need to use two different collect feedback actions whose only difference is that hard coded title.

Ali, barem postoji rješenje koje ne zahtijeva događaja prijemnike ili prilagođene SPD akcije.

Ako je netko riješio ovaj u više pametan način, javite mi.

</kraj>

Nedjelja Zabavno: Imajući vaš sin na prstima

One of the many joys I take in being the parent of a ten year old boy is finding new ways to make him laugh or think a little differently about questions and things in the world. I’ve used these techniques over the years:

===

Pogrešno protumačiti njegova pitanja:

Njegov: Koji je dan?

Tata: Jedan dan prije srijede.

S: Ne, what day of the month is it?

D: Oh, it’s 4 days after Jan 25.

===

Tickle him and tell him you’ll stop when he stops laughing.

===

Go down stairs to the TV room and announce, "It’s good to be the daddy." Tada, pick him up to get the warm spot on the couch and change the channel to something good, like the Scifi channel.

===

Read stories out loud. Insert ridiculous sentences in the middle of the story. My favorite is to add "killing him instantly" when the main characters encounters some minor trouble. Na primjer, "the knife slipped in his hand, cutting his index finger, killing him instantly." Nothing quite gets your son out of a complacent and passive listening mode as the main character being killed instantly.

===

Read stories incorrectly. Read sentences backward. The best part of this is that the first couple of times I did this, my son thought he was helping me out by pointing out that I wasn’t reading the words in the right order. The down side is that he really doesn’t want me to read to him any more.

===

Go to Burger King for lunch. My son would eat BK morning, night and day if we let him. When going, tell him, "I know you hate going there, but we simply have no choice." When he tries to explain that he loves BK, talk over him and say things like "We don’t have time to argue about it! We’re going and I don’t want to have a discussion!"

(This reminds me of my favorite Borg joke: "Borger King: We do it our way. Your way is irrelevant." hahaha!)

===

Open a book to page 9 and say, "hmm, that’s an odd page".

===

Fill the world with arch enemies. "We’re going to run quick over toe 7-11, arch-enemy of 11-7".

"Your aunt lives in Ringwood, arch enemy to the town of Squarewood."

===

We drive up to Massachusetts from New Jersey several times a year and it often takes about 5 hours door to door. As we arrive home and pull into the driveway say, "oh, I forgot, we need to make a quick dash to Home Depot."

===

When watching a violent episode in a TV show (such as Heroes), tell your son, "some times, at work, I need to destroy my enemies by burning them alive using the powers of my mind. I don’t like doing it, but you gotta do what you gotta do."

===

When watching bad horror movies (see "It’s good to be the Daddy" gore), ascribe improbable motives to the evil character. Na primjer, tell your son that the reason Jason is so angry is because he wants some cake and they won’t let him have any.

===

Explain phone numbers incorrectly. Instead of telling your son to dial "201-111-2222", tell him it’s "2-011-1-12222".

===

What tricks do you use?

</kraj>

Technorati Tags:

Guest Blogging?

It seems fairly common in the political blogging world for a given blog to host a "guest blogger". When I’m in political blog land I must be wearing a different pair of eye glasses because it never occurred to me that "guest blogging" might make sense for a technical blog like mine. That is, until I read this post by Kanwal Khipple over at The Best of SharePoint Buzz- Siječanj 2008.

Thinking on it, I believe there could be a lot of people out there in SharePoint land that have the itch to put together an article, short or long, technical or more business oriented, itd., but don’t run their own blog for all the usual reasons. If you’re one of those people, I’d be happy to host it. You can reach me via email or leave a comment. I haven’t thought through any kind of guidelines, but I suppose that I’d want it to be oriented around SharePoint, but I also like to throw in some personal observations about consulting now i zatim. I’m also trying to publish a "Nedjelja Zabavno" every week and I’m bound to run out of ideas for that.

If you’re a regular blogger already but would like to experiment with guest blogging, I’m definitely open to that too, either as a host or a guest 🙂

</kraj>

Technorati Tags:

Rješenje za BDC ADF-Import neuspjeh: “Sljedeća greška:”

Bio sam jednom lukavost BDC ADF datoteke rukom (tako da mogu izgraditi my "Silazim moj travnjak!" Ja) i pogodio ovu lijepu pogreške:

slika

"Application definition import failed. Sljedeća greška:"

Kao što možete vidjeti, postoji greška, ali … to ne ide mi reći što je to.

U mom slučaju, the issue turned out that I had started off with a functional ADF for a different project that connected to a database and executed a SQL query against a view. In this new project, I am calling a method on a web service. I had stripped out the DB specific stuff and added my web service stuff, , ali nije uspio ažurirati <LobSystem>’s Type attribute. I switched it to "WebService" i ja rado preselio na novije i uzbudljivije uvoznih pogrešaka, koje su obrađene u dogledno vrijeme.

Ovdje je u krivu LobSystem:

<LobSystem
xmlns:Rebel =http://www.w3.org/2001/XMLSchema-instance
Rebel:schemaLocation =http://schemas.microsoft.com/office/2006/03/BusinessDataCatalogBDCMetadata.xsd
Type="Database"
Version="1.0.0.0" Name="xyzzy"
xmlns="
http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">

To je ispravan:

<LobSystem
xmlns:Rebel =http://www.w3.org/2001/XMLSchema-instance
Rebel:schemaLocation =http://schemas.microsoft.com/office/2006/03/BusinessDataCatalogBDCMetadata.xsd
Type="WebService"
Version="1.0.0.0" Name="xyzzy"
xmlns="
http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">

</kraj>

Technorati Tags:

BDC Čini Održive zamjena za lookups

UPDATE: Ovaj MSDN objavljivanja ima neke zanimljive primjedbe iz JXJ na temelju njegove, uglavnom negativno, Iskustva ide dolje ovaj put: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2623565&SiteID=1

We have a business scenario where we need to link two documents libraries via a common "document ID" polje.

We often use a lookup column to implements links like this. There are several drawbacks to lookup columns, od kojih su tri:

  1. Only one column from the lookup lookup library can be linked.
  2. Performanse: The source library could contain hundreds of entries. That’s too many entries in the lookup.
  3. Traži: There is no integrated search. I don’t mean in the MOSS sense of search, ali ne postoji način da se traži / filtrirati po više stupaca iz knjižnice izvorni dokument i pronađite link koji želite.

Potpomognuti BDC, we can use a "business data" column type and it provides a superior search and even allows multiple columns of data to appear in list views.

Ja sam imao neke preliminarne uspjeh s ovom pristupu, a planiramo pisati više o tome.

Ako ste radili ovaj kut prije i imate bilo kakve komentare, molimo udjela!

</kraj>

Technorati Tags:

Rješenje za BDC Pogreška pri uvozu: “Ne mogu učitati Vrsta opisao TypeDescriptor je TypeName …”

Radio sam s BDC danas, coding ADF files by hand and generating myself some errors. One such error:

Primjena definicija uvoz nije uspio. Sljedeća greška: Ne mogu učitati Vrsta opisao TypeDescriptor je TypeName. Naziv parametra: typeName Greška je naišao na ili neposredno prije Line: '35’ i pozicija: ’20’.

MOSS prikazuju ovu pogrešku kada sam pokušao uvesti datoteku ADF XML.

Ja istraživao internets i utvrdili da sam bio s pozivom na ime LOB instance (od <LobSystemInstance>) u mom <TypeDescriptor> čvora kad sam trebala upućuje uspijeva samo ime (od <LobSystem>).

Pogrešno:

<TypeDescriptor TypeName="Conchango.KeyValue, LOB Ime instance" Name="KeyValue">

Ispravite:

<TypeDescriptor TypeName="Conchango.KeyValue, LOB Ime" Name="KeyValue">

Nadam se da ovo netko štedi sat ili dva vremena.

</kraj>

Pretplatite se na moj blog!

Technorati Tags: