Mjesečni arhiv: Veljača 2008

Nedjelja Zabavno: “NIJE ZA IZVOZ”

Povratak oko 1998, the company I worked for at the time received some funding to create a new e-commerce product. We had the full gamut of business requirements to meet. It had to be fast, lako za krajnje korisnike, neukusan, multi-language, itd.. Sad to say, I probably haven’t had as an ambitious set of work to accomplish since those heady days.

This effort pre-dated Microsoft.NET. Plain vanilla ASP was still somewhat new (or least very unfamiliar to my company). "Brick and mortar" companies were doomed. Doomed! This is to say that it was pioneering work. Not Hadron Collider pioneering work, but for us in our little world, it was pioneering work.

We were crazy busy. We were doing mini POC’s almost every day, figuring out how to maintain state in an inherently stateless medium, figuring out multi-language issues, row-level security. We even had create a vocabulary to define basic terms (I preferred state-persistent but for some reason, the awkward "statefull" won the day).

As we were madly inventing this product, the marketing and sales people were out there trying to sell it. Somehow, they managed to sell it to our nightmare scenario. Even though we were designing and implementing an enterprise solution, we really didn’t expect the first customer to use every last feature we built into the product day zero. This customer needed multi-language, a radically different user interface from the "standard" system but with the same business logic. Multi-language was especially hard in this case, because we always focused on Spanish or French, but in this case, it was Chinese (which is a double-byte character set and required special handling given the technology we used).

Fast forward a few months and I’m on a Northwest airlines flight to Beijing. I’ve been so busy preparing for this trip that I have almost no idea what it’s like to go there. I had read a book once about how an American had been in China for several years and had learned the language. One day he was walking the city and asked some people for directions. The conversation went something this:

  • American: "Could you tell me how to get to [XX] street?"
  • Chinese: "Sorry, we don’t speak English".
  • American: "Oh, well I speak Mandarin." and he asked them again in Chinese, but more clearly (as best he could).
  • Chinese: Very politely, "Sorry, we don’t speak English".

The conversation went on like that for bit and the American gave up in frustration. As he was leaving them he overheard one man speaking to the other, "I could have sworn he was asking for directions to [XX] street."

I had picked up a few bits and pieces of other China-related quasi-information and "helpful advice":

  • A Korean co-worked told me that the I needed to be careful of the Chinese because "they would try to get me drunk and take advantage of you" in the sense of pressuring me into bad business decisions.
  • We were not allowed to drive cars (there was some confusion as to whether this was a custom, a legal requirement or just the client’s rule).
  • There were special rules for going through customs.
  • We were not allowed to use American money for anything.
  • You’re not supposed to leave tips. It’s insulting if you do.

I na kraju, I had relatively fresh memories the Tiananmen massacre. When I was at college, I remember seeing real-time Usenet postings as the world looked on in horror.

In short, I was very nervous. I wasn’t just normal-nervous in the sense that I was delivering a solution that was orders of magnitude more complicated than anything I had ever done before. I was also worried about accidentally breaking a rule that could get me in trouble.

I’m on this 14 hour flight and though it was business class, 14 hours is a damned long time. There are only so many ways to entertain yourself by reading, watching movies or playing with the magnetized cutlery. Even a really good book is hard to read for several hours straight.

Konačno, I started to read the packaging material on a piece of software I was hand-carrying with me to the client, Netscape’s web server. I’m reading the hardware/software requirements, the marketing blurbs, looking at the pretty picture and suddenly, I zero in on the giant "NOT FOR EXPORT" warning, something about 128 bit encryption. I stuffed the box back into my carry bag, warning face-down (as if that would have helped) and tried to keep visions of Midnight Express out of my head.

Looking back on it now, I should have been worried, if at all, when I left the U.S., not when I was entering China 🙂 Nothing untoward happened and I still consider that to be the best and most memorable business trip I’ve had the pleasure of making.

</kraj>

Pretplatite se na moj blog!

Technorati Tags: ,

Otopina: SPQuery ne traži mape

Ovaj prošli tjedan sam bio provedbi "razvija" solution for a client that uses BDC and SPQuery and ran into some difficulty using SPQuery against a document library containing folders. Bottom line: dodijeliti "rekurzivni" s pogledom na atribut upita.

Moj scenarij:

  • U ponedjeljak,, Ću uploadati dokument i dostaviti neke meta podatke.
  • Sljedeći tjedan, I upload a new document. Much of this new document’s meta data is based on the document I uploaded on Monday (which we call the "master document").
  • Napravili smo fasadu web servis koji pruža BDC-friendly sučelje na popisu, tako da korisnici mogu jednostavno pronaći taj dokument ponedjeljak putem naslova pretraživanje.
  • A BDC data column provides a friendly user interface. (To je dio mog pokušaja na korištenje BDC za više prijateljski Potraži stupac).

Konačna BDC fasada usluga koristi upita ovako raditi pretraživanja:

 // Koristi U2U alat za pomoć u stvaranju ovog CAML upit.
      oQuery.Query =
        "<Gdje>";

      ako (titleFilter.Length > 0)
        oQuery.Query   =
          "  <I>";

      oQuery.Query   =
        "    <I>" +
        "      <Geq>" +
        "        <FieldRef Name=\"DocumentId\" />" +
        "        <Value Type=\"Text\">" + minId + "</Vrijednost>" +
        "      </Geq>" +
        "      <Leq>" +
        "        <FieldRef Name=\"DocumentId\" />" +
        "        <Value Type=\"Text\">" + maxId + "</Vrijednost>" +
        "      </Leq>" +
        "    </I>";

      ako (titleFilter.Length > 0)
        oQuery.Query   =
          "    <Sadrži>" +
          "      <FieldRef Name=\"Title\" />" +
          "      <Value Type=\"Text\">" + titleFilter + "</Vrijednost>" +
          "    </Sadrži>" +
          "  </I>";
      oQuery.Query   =
        "</Gdje>";

U početnoj fazi razvoja, this worked great. Međutim, uveli smo mape u mapu za rješavanje nekih problema i odjednom, my BDC picker wouldn’t return any results. I tracked this down to the fact that the SPQuery would never return any results. We used folders primarily to allow multiple files with the same name to be uploaded but with different meta data. When the file is uploaded, smo izradili mapu na temelju popisa stavke ID, a zatim premjestiti datoteku postoji (O tome sam pisao ovdje; imali smo mješovite rezultate s ovim pristupom, ali u cjelini, to je rad i). The user don’t care about folders and in fact, don’t really understand that there are any folders. We have configured all the views on the library to show items without regard to folders.

I hit this problem twice as the technical implementation evolved and solved it differently each time. The first time, I wasn’t using the CONTAINS operator in the query. Without a CONTAINS operator, I was able to solve the problem by specifying the view on the SPQuery’s contructor. Instead of using the default constructor:

SPList oList = web.Lists["Documents"];

SPQuery oQuery = novi SPQuery();

I umjesto da se konstruktor koji navedenu pogled:

SPList oList = web.Lists["Documents"];

SPQuery oQuery = novi SPQuery(oList.Views["All Documents"]);

To je riješilo problem i počeo sam da se moje rezultate.

I then added the CONTAINS operator into the mix and it broke again. It turns out that the CONTAINS operator, koliko ja mogu reći, ne radi s pogledom na isti način kao jednostavniji geq / LEQ operators. I did some searching and learned that the query’s ViewAttributes should be set to "Recursive", kao u:

oQuery.ViewAttributes = "Scope=\"Recursive\"";

That solved the problem for CONTAINS. Zapravo, to također riješio moj izvorni pretragu problem i ako sam bio naveden rekurzivna značajke prvi put, Ne bih se izvoditi u pitanju opet.

Činjenica da je pogled na bazi SPQuery radi za neke operatere (Geq / Leq) a ne drugima (SADRŽI), zajedno s činjenicom da KPI ne čini uopće raditi s mape koje sadrže bibliotekama dokumenata vodi me da vjerujem da ima neke SPQuery ortogonalnost pitanja.

Posebne Hvala:

  • Dobri ljudi u U2U i njihov upit alat.
  • Michael Hoffer je super "učenje kroz rad" blog post, komentari i odgovori.

</kraj>

Pretplatite se na moj blog!

MOSS KPI bug? Popis Pokazatelj vezan za biblioteku dokumenata s mapama

UPDATE 02/29/08: I solved this problem by creating a folder and then assigning a content type to the folder which has the meta data I need for the KPIs. Sam opisao da je u malo više detalja ovdje.

We have implemented a technical solution where users upload documents to a document library. An event receiver creates a directory and moves the file to that directory (tehnikom slično onome što sam pisao o ovdje). We’ve successfully navigated around the potential issues caused by event receivers that rename uploaded files (mainly because users never start their document by clicking on "New" ali umjesto toga stvaraju dokumente na lokalnoj razini, a zatim ih prenijeti).

The meta data for these documents includes a Yes/No site column called "Urgent" and another site column called "Status". We need to meet a business requirement that shows the percentage of "Urgent" documents whose status is "Pending".

To je obično jednostavan za napraviti i ja opisao nešto vrlo slično kao ovaj na SharePoint Beagle s puno zaslon metak ako vas zanima.

Ukratko, Ja sam sljedeće:

  • Create a view on the doc library called "Pending".
  • Konfiguracija pogled ignorirati strukturu mapa.
  • Napravite popis ključnih pokazatelja uspješnosti.
  • Create an indicator in the list that points to the doc lib and that "Pending" pogled.

This simply does not work. The KPI shows my target (e.g. pet hitnih dokumenti) but always shows the actual number of urgent documents as zero. Paradoxically, ako dođite do pojedinosti, it shows the five urgent documents in the list. I created a very simple scenario with two documents, one in a folder and one not. Here is the screen shot:

slika

The above screen shot clearly shows there are two documents in the view but the "value" is one. The "CamlSchema" with blank document Id is in the root folder and the other is in a folder named "84".

Čini mi se da, iako ste odredili pogled, the KPI doesn’t honor the "show all items without folders" postavljanja i umjesto toga, ograničava na korijenske mape.

Ako sam u krivu, molimo ispadne mi linija ili komentiranje.

</kraj>

Pretplatite se na moj blog!

Technorati Tags:

SPD Workflow “Prikupljanje podataka od korisnika”: Izmjena generirani obrazac zadataka

I’m working on a project that uses five different SharePoint Designer work flows to handle some document approvals. SPD provides the "collect data from a user" akcija, tako da možemo brz korisnik za različite bitova informacija, kao što su to oni odobre, neki komentari i možda pitati što su imali za večeru druge noći.

The forms are perfectly functional. They are tied to a task list as a content type. Oni su 100% system-generated. This is their strength and weakness. If we can live with the default form, then we’re good to go. Međutim, we don’t have too much control over how SPD creates the form. If we don’t like that default behavior, moramo posegnuti za raznim trikovima kako bi dobili oko njega (na primjer, postavljanja prioriteta na zadatku).

Morao sam dati link na tim radnim obrascima koji je otvorio se pogled svojstva (dispform.asxp) of the "related item" in a new window. This provides one-click access to the meta data of the related item. This is what I mean:

slika

Srećom, we can do that and it’s not very hard. Broadly speaking, ložiti SPD, navigate to the directory that houses the workflow files and open the ASPX file you want to modify. These are just classic XSL transform instructions and if you’ve mucked about with itemstyle.xsl, Traženje ili drugih XSL scenarija, this will be easy for you. Zapravo, Otkrio sam da se općenito lakše jer generira oblik je nešto lakše pratiti odnosu na temeljne rezultata pretraživanja web-dijela (ili noćne more CWQP).

Naravno, there is one major pitfall. SPD’s workflow editor expects full control over that file. If you modify it, SPD will happily overwrite your changes give the right set of circumstances. I did two quick tests to see how bad this could get. They both presuppose that you’ve crafted a valid SPD workflow that uses the "collect data from a user" korak.

Test 1:

  • Izmjena ASPX datoteku rukom.
  • Testirajte ga (provjeriti da vaše promjene su spremljene ispravno i ne razbiti ništa).
  • Otvoriti tijek rada i dodati nepovezanih akciju (such as "log to history").
  • Spremi tijek rada.

Rezultirati: U tom slučaju, SPD nije ponovno stvoriti oblik.

Test 2:

  • Učiniti isto kao #1 except directly modify the "collect data from a user" akcija.

Rezultirati: Ovo ponovno stvara obrazac ispočetka, tijekom pisanja-promjena.

Završne napomene:

  • Najmanje dva SPD akcije stvoriti obrasce kao što je ovaj: "Collect Data From a User" and "Assign To Do Item". Both of these actions’ obrasci mogu se mijenjati ručno.
  • Bio sam u mogućnosti generirati svoju vezu, jer dispform.aspx, u ovom slučaju, the relate item always has its ID embedded in the related item’s URL. I was able to extract it and then build an <href> based on it to provide the one-click meta data access feature. It’s unlikely that your URL follows this rule. There may be other ways to get the ID of the related item but I have not had to cross that bridge, tako da ne znam da li dobiva na drugu stranu ponora.
  • Nisam istragu, ali ne bih se iznenadio ako postoji neka vrsta datoteke predloška u 12 košnica koje sam mogao utjecati na to kako se mijenjati SPD stvara zadane obrasce (baš kao što možemo mijenjati predložaka upozorenja).

</kraj>

Pretplatite se na moj blog!

Technorati Tags: ,

Jesu li “Unknown Error” Poruke stvarno bolje nego Stack Trace?

Čitao sam Madhur je blog post o tome kako omogućite slagati u tragovima prikazuje i sad ja pitam: zašto ne bismo uvijek pokazuju stog trag?

Tko je došao gore sa tog pravila i zašto smo ga slijediti?

End users will know something is wrong in either case. At least with a stack trace, mogu pritisnite tipku PrintScreen Kontrola-, copy/paste into an email and send it to IT. That would clearly reduce the time and effort required to solve the issue.

</kraj>

Technorati Tags:

Nedjelja (Posramljujući) Smiješan: “Moje ime je Paul Galvin”

Hrpa godina, my boss asked me to train some users on a product called Results. Results is an end user reporting tool. It’s roughly analogous to SQL Server Reporting Service or Crystal. U vrijeme, to je dizajniran za rad na zelenim cijevima (e.g. Wyse 50 terminal) connected to a Unix box via telnet.

My default answer to any question that starts with "Can you … " is "Yes" i to je mjesto gdje sve nevolje započeo.

Klijent je kemijska tvrtka u južnoj Kaliforniji, a upravo o zavrsio veliki ERP provedbu na temelju QAD je MFG/PRO. The implementation plan now called for training power end users on the Results product.

I wasn’t a big user of this tool and had certainly never trained anyone before. Međutim, Imao sam provela niz drugih trening klase i bio brz na nogama, so I was not too worried. Dennis, pravi punim radnim vremenom Rezultati instruktor, had given me his training material. Looking back on it now, it’s really quite absurd. I didn’t know the product well, had never been formally trained on it and had certainly never taught it. What business did I have training anyone on it?

Za komplicirati stvari logistički, I was asked to go and meet someone in Chicago as part of a pre-sales engagement along the way. The plan was to fly out of New Jersey, ići u Chicagu, meet for an hour with prospect and then continue on to California.

Dobro, I got to Chicago and the sales guy on my team had made some mistake and never confirmed the meeting. Tako, I showed up and the prospect wasn’t there. Awesome. I pack up and leave and continue on to CA. Somewhere during this process, Ja saznali da klijent uči manje od 24 hours before my arrival that "Paul Galvin" predaje razred, not Dennis. The client loves Dennis. They want to know "who is this Paul Galvin person?" "Why should we trust him?" "Why should we pay for him?" Dennis obviously didn’t subscribe to my "daju lošu vijest rano" philosophy. Awesome.

Ja stići u zračnu luku i za neke nevjerojatno glupe razloga, I had checked my luggage. I made it to LAX but my luggage did not. Za mene je, gubitka prtljage je puno poput prolazi kroz sedam faza tuge. Eventually I make it to the hotel, bez prtljage, umoran, gladni i nosi moje (do sada, vrlo zgužvao) business suit. It takes a long time to travel from Newark — do O'Hare — za klijenta — natrag na O'Hare — i na kraju LAX.

Napokon sam pronaći sebe sjedi u hotelskoj sobi, munching na snickers bar, exhausted and trying to drum up the energy to scan through the training material again so that I won’t look like a complete ass in front of the class. This was a bit of a low point for me at the time.

Probudio sam se sljedeći dan, did my best to smooth out my suit so that I didn’t look like Willy Loman on a bad day and headed on over to the client. As is so often the case, osobno ona je bila lijepa, polite and very pleasant. This stood in stark contrast to her extremely angry emails/voicemails from the previous day. She leads me about 3 miles through building after building to a sectioned off area in a giant chemical warehouse where we will conduct the class for the next three days. The 15 ili 20 Studenti se polako okupljaju, most them still expecting Dennis.

Uvijek sam krenuti moje tečajeve obuke po sebi predstavlja, giving some background and writing my contact information on the white board. As I’m saying, "Good morning, my name is Paul Galvin", Pišem moje ime, email and phone number up on the white board in big letters so that everyone can see it clearly. I address the fact that I’m replacing Dennis and I assure them that I am a suitable replacement, itd.. I have everyone briefly tell me their name and what they want to achieve out of the class so that I can tailor things to their specific requirements as I go along. The usual stuff.

We wrap that up and fire up the projector. I go to erase my contact info and … I had written it in permanent marker. I was so embarrassed. In my mind’s eye, izgledalo je ovako: There is this "Paul Galvin" osoba, last minute replacement for our beloved Dennis. He’s wearing a crumpled up business suit and unshaven. He has just written his name huge letters on our white board in trajni biljeg. What a sight!

Sve je završilo sretno, međutim. This was a chemical company, uostalom. A grizzled veteran employee pulled something off the shelf and, Vjerojatno u kršenje propisa EPA, cleared the board. I managed to stay 1/2 day ahead of the class throughout the course and they gave me a good review in the end. This cemented my "pinch hitter" reputation at my company. My luggage arrived the first day, tako da sam bio puno više naočit dana dva i tri.

Kao što sam bio uzimajući crvenih očiju vratiti kući, I was contemplating "lessons learned". There was plenty to contemplate. Communication is key. Tell clients about changes in plan. Don’t ever check your luggage at the airport if you can possibly avoid it. Bring spare "stuff" in case you do check your luggage and it doens’t make it. I think the most important lesson I learned, međutim, bio je to: Uvijek testirati marker u donjem lijevom kutu bijelom brodu prije pisanja, u ogromnim slovima, "Paul Galvin".

</kraj>

Technorati Tags: ,

Vjerojatnost: SharePoint vs. Large Hadron Collider

Due to some oddball United Airlines flights I took in the mid 90’s, I somehow ended up with an offer to transform "unused miles" into about a dozen free magazine subscriptions. That is how I ended up subscribing to Scientific American magazine.

Kao softvera / savjetovanje osoba, we encounter many difficult business requirements in our career. Most the time, volimo ispunjava ove zahtjeve i zapravo, it’s probably why we think this career is the best in the world. I occasionally wonder just what in the world would I have done with myself if I had been born at any other time in history. How terrible would it be to miss out on the kinds of work I get to do now, u ovo vrijeme i mjesto u svjetskoj povijesti? Mislim: prilično strašno.

Tijekom godina, some of the requirements I’ve faced have been extremely challenging to meet. Complex SharePoint stuff, izrada web obrada okviri temelje na ne-web-friendly tehnologiju, complex BizTalk orchestrations and the like. We can all (nadajmo se) izgleda ponosno vratiti na naše karijere i reći, "yeah, to je teško pitanje za rješavanje, ali na kraju sam pwned da sumbitch!" Better yet, još zanimljivih i zabavnih izazovi čekaju.

Ja osobno mislim da je moj životopis, u tom pogledu, je prilično duboko, a ja sam prilično ponosan na nju (iako znam da moja žena nikada neće shvatiti 1/20th od njega). But this week, Čitao sam članak o Large Hadron Collider in my Scientific American magazine and had one of those rare humbling moments where I realized that despite my "giant" status u nekim krugovima ili koliko duboko mislim da mi je dobro iskustvo, there are real giants in completely different worlds.

The people on the LHC team have some really thorny issues to manage. Consider the Moon. I don’t really think much about the Moon (iako sam bio vrlo sumnjičav o tome jer sam saznao da je usporavanje Zemljine rotacije, koji ne može biti dobra stvar za nas ljude u dugom roku). Ali, the LHC team does have to worry. LHC’s measuring devices are so sensitive that they are affected by the Moon’s (Zemlje-rotacije usporavanje-a-vremenom-ubijanje-sve-život) gravity. That’s a heck of a requirement to meet — proizvesti ispravne mjerenja unatoč Mjesečeve smetnji.

Razmisljao sam taj problem kad sam pročitao ovu rečenicu: "The first level will receive and analyze data from only a subset of all the detector’s components, from which it can pick out promising events based on isolated factors such as whether an energetic muon was spotted flying out at a large angle from the beam axis." Really … ? I don’t play in that kind of sandbox and never will.

Sljedeći put sam se s nekim prijateljima, Ja ću podići zdravicu s dobrim ljudima koji rade na LHC-u, hope they don’t successfully weigh the Higgs boson particle and curse the Moon. I suggest you do the same. Bit će to pravi tost 🙂

</kraj>

Technorati Tags:

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: