Quick Impression: System Center Stærð Skipuleggjandi fyrir SharePoint

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

Mér fannst það auðvelt í notkun og fljótt fyrirmynd viðskiptavinur umhverfi ég vann á þessu síðasta sumar.

Með sumum trepidation, Ég sótti endanlega lagi hnappinn og það er mælt með eitthvað sem er nokkuð svipað og það sem við gáfum viðskiptavinur okkar (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, o.fl.), 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:

  • Leita: 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.

</enda>

Technorati Tags:

Lausn: System.IO.FileNotFoundException á “SPSite = new SPSite(url)”

UPDATE: ÉG staða þessa spurningu til MSDN hér (http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=2808543&SiteID=1&mode=1) and Michael Washam of Microsoft responded with a concise answer.

Ég bjó til vefur þjónusta til að starfa sem BDC-vingjarnlegur framhlið to a SharePoint list. When I used this from my development environment, það í uppnámi fínn. Þegar ég flytja þetta til nýja miðlara, Ég fundur this villa:

System.IO.FileNotFoundException: The Web umsókn á http://localhost/sandbox Ekki var hægt að finna. Staðfestu að þú hefur slegið inn vefslóð rétt. Ef slóðina skal þjóna núverandi innihald, kerfisstjóri getur þurft að bæta við nýjum beiðni URL kortlagning á fyrirhugaða notkun. á Microsoft.SharePoint.SPSite .. ctor(SPFarm bæ, Uri requestUri, Boolean contextSite, SPUserToken userToken) á Microsoft.SharePoint.SPSite .. ctor(String requestUrl) á Conchango.xyzzy.GetExistingDocument(String minId, String maxId, String titill síu) í C:\Documents and Settings Paul My Documents Visual Studio 2005 Verkefni xyzzy BDC_DocReview BDC_DocReview DocReviewFacade.asmx.cs:lína 69

Hér er lína 69:

með (SPSite síða = new SPSite("http://localhost/sandbox"))

Ég reyndi mismunandi afbrigði á vefslóðinni, þ.mt overusing raunverulegt nafn miðlarans, IP tölu þess, slóð rista á vefslóðina, o.fl.. I always got that error.

Ég notaði The Google to research it. Lots of people face this issue, eða afbrigði af henni, en enginn virtist tvö hafa það leyst.

Tricksy MOSS veitt svo nákvæma villa að það var ekki komið að mér tvo athuga 12 hive logs. Lokum, um 24 klukkustundum eftir samstarfsmaður minn mælt ég gera það, Ég skoðaði út 12 Hive þig og fann þetta:

Undantekning kom upp þegar reynt tvö Fá staðbundin bæ:
System.Security.SecurityException: Umbeðin skrásetning aðgangur er ekki leyft.
á System.ThrowHelper.ThrowSecurityException(ExceptionResource úrræði) á
(String nafn, Boolean skrifanleg) á
(String nafn) á
() á
() á
(SPFarm& bæ, Boolean& isJoined)
The Zone á þingi sem ekki var:  MyComputer

Þetta opnaði nýjar leiðir rannsóknir, svo það var aftur til Google. Það leiddi mig til þessa vettvangur staða: HTTP://forums.codecharge.com / posts.php?post_id = 67.135. 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 er Connell 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. Hins, samstarfsmaður minn fór og gaf laug app kennimark reikning fullan aðgang að SQL.

Um leið og hún gerði þessi breyting, everything started working.

Hvað gerðist næst er best lýst sem Haiku ljóð:

Vandamál hækka hendur þeirra.
You swing and miss. Try again.
Velgengni! But how? Hvers vegna?

Hún vildi ekki láta hlutina einn svona, preferring að gefa nauðsynlegar eru leyfi (og sennilega með auga til að skrifa bloggfærslu; Ég barði hana til að kýla, muhahahahaha!).

Hún fjarlægt röð leyfi frá laug app sjálfsmynd reikning þar … 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.

Svo, að ágrip: we gave the app pool identity full access and then took it away. The web service started working and never stopped working. Bizarre.

Ef einhver veit hvers vegna það ætti að hafa unnið, vinsamlegast eftir athugasemd.

</enda>

Technorati Tags:

Lausn (konar): Setja áherslu á verkefni nota SharePoint Designer

I have a business scenario like this:

  • A user uploads a document to a document library.
  • She selects a content type and enters meta data as needed. One of the meta data fields is a flag, "Urgent".
  • This triggers a SharePoint Designer workflow that, m.a., uses the "Collect Data from a User" aðgerð.

"Collect Data from a User" creates an item in a task list requesting approval for that document.

I needed to create a view of the task list that showed urgent requests for approval.

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

I would have preferred to specify the priority field directly. Hins, I was unable to do that for several reasons:

  1. The collect data action does not provide a mechanism to update any field other than title (and those additional fields for which you want to collect data).
  2. The "assign a to do item" action has the same problem.
  3. It’s possible to insert an item into a list (i.e. insert an item into the task list directly) but this not a blocking action. That means that the workflow will not wait for the user to complete that task.

I considered a few approaches before (thankfully) realizing we could just put "urgent" in the title.

  1. Start a workflow on the task list itself so that when a new task is created, it somehow cross references back to the document that started the first workflow, pull out the urgent flag value and update priority as needed.
  2. Do something similar with an event receiver. On create of the task, locate the associated document and update priority as needed.
  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. (For some reason, I had more or less settled on this approach before wisely deciding to walk away for a while).

There is a drawback to my solution (aside from the obvious fact that only the text of the title indicates urgency). Since "collect feedback" only accepts hard coded title names, I need to use two different collect feedback actions whose only difference is that hard coded title.

En, at least there’s a solution that does not require event receivers or custom SPD actions.

If someone has solved this in a more clever way, please let me know.

</enda>

Sunnudagur Fyndið: Keeping Your Son On His Toes

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:

===

Misconstrue his questions:

Son: What day is it?

Pabbi: One day before Wednesday.

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

D: Ó, 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." Þá, 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. Til dæmis, "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" ofan), ascribe improbable motives to the evil character. Til dæmis, 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?

</enda>

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- Janúar 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, o.fl., 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 og þá. I’m also trying to publish a "Sunnudagur Fyndið" 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 🙂

</enda>

Technorati Tags:

Þetta er hverju mér líkar ekki að nota tæki degi núll

http://groups.google.com/group/microsoft.public.sharepoint.portalserver.development/browse_thread/thread/41e8cbe4f15e8b4c/76506ea401403e35?#76506ea401403e35

Ef tæki er að gera efni sem þú skilur ekki og þá er það ekki í takt n af óþekktum fjölda af skrefum, þú ert dauður í vatninu…

</enda>

Technorati Tags:

Lausn til BDC ADF Innflutningur Bilun: “Eftirfarandi villa kom upp:”

Ég var einu sinni föndur BDC ADF skrá af hendi (þannig að ég get byggt upp mína "fá burt grasið mitt!" Ég) og högg þetta yndislega villa:

mynd

"Application definition import failed. Eftirfarandi villa kom upp:"

Eins og þú sérð, það er villa, en … það er ekki að fara að segja mér hvað það er.

Í mínu tilfelli, 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, en ekki tekist að uppfæra <LobSystem>’s Type attribute. I switched it to "WebService" og ég flutti hamingjusamlega á að nýrri og meira spennandi innflutnings villur, sem voru meðhöndlaðir í fyllingu tímans.

Hér er rangt LobSystem:

<LobSystem
xmlns:Xsi =HTTP://www.w3.org/2001/XMLSchema-instance
Xsi: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">

Þetta er rétt:

<LobSystem
xmlns:Xsi =HTTP://www.w3.org/2001/XMLSchema-instance
Xsi: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">

</enda>

Technorati Tags:

BDC Virðast raunhæfur skipti fyrir leit

UPDATE: Þetta MSDN staða hefur nokkrar áhugaverðar athugasemdir frá JXJ byggt á hans, aðallega neikvæð, reynslu að fara niður þessa leið: 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" sviði.

We often use a lookup column to implements links like this. There are several drawbacks to lookup columns, three of which are:

  1. Only one column from the lookup lookup library can be linked.
  2. Performance: The source library could contain hundreds of entries. That’s too many entries in the lookup.
  3. Leita: There is no integrated search. I don’t mean in the MOSS sense of search, but there’s no way to search / filter on multiple columns from the source document library and locate the link you want.

Backed by 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.

I’ve had some preliminary success with this approach and plan to write more about it.

If you’ve worked this angle before and have any comments, please share!

</enda>

Technorati Tags:

Lausn til BDC Import Villa: “Gat ekki hlaðið lýst með TypeName TypeDescriptor er …”

Ég hef verið að vinna með BDC dag, coding ADF files by hand and generating myself some errors. One such error:

Umsókn skýring innflutningur mistókst. Eftirfarandi villa kom upp: Gat ekki hlaðið lýst með TypeName TypeDescriptor er. Viðfang nafn: typeName Villa kom upp við eða rétt fyrir Line: '35’ og afstaða: ’20’.

MOSS displayed this error when I tried to import the ADF XML file.

I researched the Internets and found that I was referencing the LOB instance name (from the <LobSystemInstance>) in my <TypeDescriptor> node when I should have referenced the LOB name itself (frá <LobSystem>).

Wrong:

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

Correct:

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

Hope this one saves someone an hour or two of time.

</enda>

Gerast áskrifandi að bloggið mitt!

Technorati Tags: