TMG Reports - Using SSRS - What constitutes a session or time spent?!

Hi, I have been poking around the forum for a few days regarding reporting. I have been taking a look at the in built TMG Reporting and MSDE, and basically its messy... (Why MS seems to have made this so hard is confusing to understand but hey...)

Anyways instead of modifying the MSDE/ISA_RS_Db combination, I would like to log to a seperate SQL server and then run SSRS reports on top of that. Anyways what I am trying to emulate is a report that instead of showing simply the user, category, site and amount downloaded... shows the following:

User, category, site and start and end of session information (And therefore can calculate time spent on a site)...

Now before anyone jumps on me... I know this is not 100% accurate (Whereas amount downloaded is), but what I am looking for is any info to understand how other proxy products/proxy log analysis products, can calculate this value? TMG does not store a session time, merely a log time for each individual request... I assume some kind of grouping is done to determine a session? (i.e. user access site at 1:00:00PM, and again at 1:00:30PM therefore same session?) or is it something different?!

Nested sets

I'm attempting to add users manually to an existing set. To make management of these users easier, I thought I would create separate sets based on department and add users to these sets. I would then add these sets to my target set as subsets to allow permissions to my target groups. This does not appear to be working as I'd hoped. When I add users manually to my existing set, everything works fine. When I add users to a set then add the set as a subset, permissions are not applied as expected. Does FIM 2010 support having sets as members of a set?

Changed type Markus VilcinskasMicrosoft employee Sunday, March 17, 2013 2:05 PM

Reply:

You can't add a people to a set in this way. Insetad use "ResourceID in <other set>" to add the members of the other set.

http://www.wapshere.com/missmiis

Edited by Carol Wapshere Wednesday, January 25, 2012 8:24 AM

------------------------------------
Reply:

- No need of using set, the same thing can be achieved by creating a manually managed group and nested the group to the main group that is allowing the permission. The manually managed group can be used to add members manually.

Correct me if I misunderstood it.

__________
Regards,
Anirban(India)

------------------------------------
Reply:

Carol,

Thank you for the suggestion. I attempted to create my first set (called Desktop Support) and added my members to it. I then selected my second set and added the Desktop Support set to it using the Desktop Support set's ResourceID value. After removing my Desktop Support person from the second set and verifying that he still existed in the first set (which is now nested in the second set), I asked him to see if they can access the screens he was able to access before when added directly to the second set. No luck. It appears that even adding the set using the ResourceID did not work.

Did I misunderstand your suggestion?

Lukinagin

Jesse Santana Enterprise Services Lead CSU Long Beach – Network Services 1250 Bellflower Blvd. Long Beach, CA 90840

------------------------------------
Reply:

Anirban,

Thank you for the reply but I am not dealing with AD groups. I am dealing with FIM sets and am hoping to be able to nest them to assist in administering superset memberships.

lukinagin

Jesse Santana Enterprise Services Lead CSU Long Beach – Network Services 1250 Bellflower Blvd. Long Beach, CA 90840

------------------------------------

How offline Address books works in Exchange 2010

How offline Address books works in Exchange 2010.

This Should help People who are unclear how offline address book works

htttp://careexchange.in/?p=250

If people have some Explanations please add to the Post

Reply:

Hi,
Some comments:

>For Users where Outlook is in Cache mode, They got to have their Outlook Address book when they are offline.
Comment Nr1: I'm pretty sure that the users want to have an updated OAB when connected to Exchange too.

>Outlook Downloads the latest updates on Offline address book , whenever they go online.
Comment Nr2: That is not true. Outlook will only automatically download the OAB once every 24 hours.

>So that they can use their updated address book when they are offline.
Comment Nr3: See comment nr 1

>Earlier Exchange Versions Outlook Connects to the Mailbox Server
Comment Nr4: Outlook 2003 downloads the OAB from Public Folders.

>But From Exchange 2010 Outlook Connects only to the Client Access Server.
Comment Nr5: Even Outlook 2007 downloads the OAB from the webdistributionpoint.

I think your blog post need some more work.

Martina Miskovic

------------------------------------
Reply:

Thanks for your Time Martina.. !!

Will Review it !!

------------------------------------
Reply:

Hi Martina,

I updated it with your Feedback.

Let me know ,

How is it now

Regards

Satheshwaran Manoharan

------------------------------------

How to use MeasureGroupBinding with AMO ?

I want using AMO (c#) to change the Advanced settings of a Regular type dimension usage.

I want to set the Null Processing to UknownMember.

Can anybody help ?

Thank u

Dimitris

Reply:

solved

------------------------------------

TMG with single NIC to allow PoP3 & SMTP

I am using TMG 2010 with single NIC & clients are configured with web proxy & Firewall clients. Though access rule for the PoP3 & SMTP made & outlook is being set to disable 1 to disable 0 in application setting of TMG server I am unable to connect to PoP3 server from the clients. Please help!!

Reply:

Hi,

not supported in Single NIC:
http://technet.microsoft.com/en-us/library/cc995236.aspx

regards Marc Grote aka Jens Baier - www.it-training-grote.de - www.forefront-tmg.de - www.nt-faq.de

------------------------------------

SCSM - EndUser Portal Features

I was able to hide the "request software" from the EndUser Portal and I was able to change the reset password to a go to a different URL. Is there a way for me to change the text "reset password" to say, something else? If so, how?

Reply:

Hi Mary,

Yes, you can download the source code for the portal, change the display strings, recompile and deploy.

http://www.microsoft.com/download/en/details.aspx?id=1983
http://www.microsoft.com/download/en/details.aspx?id=26505

Regards
//Anders

Anders Asp | Lumagate | www.lumagate.com | Sweden | My blog: www.scsm.se

------------------------------------

ProductVersion not reporting correctly within GUI

Ran into an fascinating issue today where a exe didnt report the correct string value of the productversion field due to letters being within the value if looking with the GUI . This only occured on 2008 server . no issues with 2008 R2, Win 7, WinXP etc. If you copied the exe to the other OS's we were able to see the text correctly . Was able to resolve this by using the following powershell script. kudos to mr tubiot for this. ...

get-childitem c:\foldername\*.exe | %{ $_.VersionInfo } |fl

Reply:

Hi,

Please try to contact the developer of the exe file to get the further support. Thanks for your understanding.

Best Regards,

Vincent Hu

------------------------------------
Reply:

Thanks for the suggestion but i can duplicate this issue with any exe .

This is not caused by the developer other than the developer of the Windows GUI : Microsoft .

I can take any exe, use a tool (resource tuner worked well) to tweak the productversion field to include letters and then the version does not display those letters within the Windows GUI.

Windows GUI truncates the field to only display string prior to the letters.

Since as I previously mentioned this information is still present and can be displayed via powershell, the data is still present in the field, just not displayed within the Windows GUI .

Since this is not an issue with Windows 2008 R2 there is clearly some difference within the OS responsible.

------------------------------------

Snippets

I just have to say, I've started to use them more, and they are awesome...

I've got a snippet for working with my EMC unit for VM, rather than type in naviseccli -h 192.168.1.100 I just type ctrl+j nav<tab> and type the navi cmd I want... I've done the same for select calculated statements.. wish tab worked for 'fields' tho, maybe that’s a connect worthy item

New-Snippet -Title "Navi" -Description "Bring up Navi default" -Text "naviseccli -h 192.168.1.111 "  New-Snippet -title '@HASH' -Description 'used for calculated selete fields' -Text '@{n='';e=''}' -CaretOffset 5    New-Snippet -title 'AD Search' -Description 'basic AD Searcher' -Text '[adsisearcher]"(objectclass=)"' -CaretOffset 28

still trying to build the list and the habit, but i can see it could be very helpful... i know there is some code some place to hook in to Poshcode.org, but i've missplaced it....

Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Edited by jrich Tuesday, January 24, 2012 6:41 PM

Reply:

Here's one I use for object creation if you want it:

http://mjolinor.wordpress.com/2011/10/08/new-object-from-a-hash-table-in-a-script-block/

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

------------------------------------
Reply:

I use PowerGUI (and Powershell ISE) and build them for all sorts of stuff. Basic templates (my generic script layout), help snippets, specific project tasks, etc. Anything I can automate is getting nailed down! Including my automation.

------------------------------------
Reply:

automate the automation? :)

Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

------------------------------------
Reply:

I need two bumper stickers:

If only infinite recursion worked on life.
Meta-meta-meta-conversations rock!

------------------------------------
Reply:

Are you running the V3 ISE?

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

------------------------------------
Reply:

I am, yeah... for the most part its been great... few weird crashes that I

cant reproduce..

Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

------------------------------------
Reply:

As long as your "automating the automation":

http://mjolinor.wordpress.com/2012/01/16/ps-v3-ise-add-on-for-splatting-updated/

http://mjolinor.wordpress.com/2011/12/31/clip-toarray-for-ps-v3-ise/

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

------------------------------------
Reply:

I'm going to write a function

Fix-Everything -HashIt MjolinorStyle

One click, I'm done. Forever. Mwwahahaha.

Seriously, though, you don't hear much about it in the normal channels. I had to get into some of the PowerGUI forums to figure out the Powershell ISE does it. And, I only guessed correctly. Perhaps some public storage for common snippets, the way scripts are currently shared, would be a useful edition to the Technet repository or the like.

Edited by Will Steele Tuesday, January 24, 2012 8:59 PM extra comment

------------------------------------
Reply:

I expect you'll see more about it as it approaches RTM. Right now I think people are reluctant to put too much time into something that might change soon.

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

------------------------------------
Reply:

I had a script for posh that would load snippets... I have no idea where it

went and I swear I tossed it in but I guess I didn't save it... so... maybe

it was only a dream.. because I cant find it anywhere.

Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

------------------------------------

Using PowerShell to check your MPR configuration for synchronization

FIM ScriptBox

Wiki Page: How to Use PowerShell to Check Your MPR Configuration for Synchronization

Go to the FIM ScriptBox

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

Edited by Markus VilcinskasMicrosoft employee Wednesday, January 12, 2011 9:36 PM

Reply:

I cannot begin to say how cool this is! Great work!

------------------------------------
Reply:

Does this work with the RTM version. Why I'm asking is I'm running it on a new fresh install and I'm getting the following error.

------------------------------------
Reply:

I am not aware of a reason this would not work with RTM.

------------------------------------
Reply:

Try the latest version above.
Do you still get the error?

Cheers,
Markus

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

------------------------------------
Reply:

This was the version I was using but I copied it again and get the same error.

Just just found this error was posted in another thread http://social.technet.microsoft.com/Forums/en-US/ilm2/thread/b62a2a4e-717c-4879-8b13-bf6e62427325 but no resolution.

I've been trying to provision users to AD from a Oracle HR MA. I've followed both the "Publish Active Directory Users From Two Authoritative Data Sources" and your new document "How do I Provision Users to Active Directory Domain Services". I can provision the accounts into metaverse but can't export to AD. The ExpectedRulesList is not getting populated. I thought I'd try your script to make sure all the required MPR's were enabled.

Error: Cannot convert value "<export-flow-set cd-object-type="DetectedRuleEntry" mv-object-type="detectedRuleEntry"><exp
ort-flow cd-attribute="SynchronizationRuleID" id="{AFA36F08-7F70-4AEB-A3D2-26C08E86BC8B}" suppress-deletions="true"><dir
ect-mapping><src-attribute>synchronizationRuleID</src-attribute></direct-mapping></export-flow><export-flow cd-attribute
="DisplayName" id="{A2DE2756-36DB-4C28-9E86-690337F6C77A}" suppress-deletions="true"><direct-mapping><src-attribute>disp
layName</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="Connector" id="{3666739C-6233-4E69-9802
-628F1033464B}" suppress-deletions="true"><direct-mapping><src-attribute>connector</src-attribute></direct-mapping></exp
ort-flow><export-flow cd-attribute="ResourceParent" id="{9B7A4D8E-B2B2-4ADB-B310-1983F2D7F806}" suppress-deletions="true
"><direct-mapping><src-attribute>resourceParent</src-attribute></direct-mapping></export-flow><export-flow cd-attribute=
"dn" id="{25D515EC-ABAA-49D5-80F2-291851D15F93}"><sync-rule-mapping mapping-type="expression" sync-rule-id="{A4B7236E-86
4F-458A-9D85-B11BBD1097E3}" sync-rule-mapping-id="{A4B7236E-864F-458A-9D85-B11BBD1097E3}" initial-flow-only="true"><sync
-rule-value><export-flow><dest>dn</dest><src><attr /></src><fn id="Guid" /></export-flow></sync-rule-value></sync-rule-m
apping></export-flow><export-flow cd-attribute="MVObjectID" id="{997C2114-7F07-40F5-9BDB-15899EDCCD1D}" suppress-deletio
ns="true"><direct-mapping><src-attribute intrinsic="true">object-id</src-attribute></direct-mapping></export-flow></expo
rt-flow-set><export-flow-set cd-object-type="ExpectedRuleEntry" mv-object-type="expectedRuleEntry"><export-flow cd-attri
bute="StatusError" id="{BF043208-4538-4A33-80BA-9C446C8C1DD1}" suppress-deletions="true"><direct-mapping><src-attribute>
statusError</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="SynchronizationRuleStatus" id="{5CC
FB4BB-48CD-44AD-A8B6-860457B4B78C}" suppress-deletions="true"><direct-mapping><src-attribute>status</src-attribute></dir
ect-mapping></export-flow></export-flow-set><export-flow-set cd-object-type="Person" mv-object-type="person"><export-flo
w cd-attribute="dn" id="{90C0CF0A-2314-4585-BEFF-86D9BAB3CF3C}"><sync-rule-mapping mapping-type="expression" sync-rule-i
d="{03D67684-A9E8-4030-97CE-4001F9A904D5}" sync-rule-mapping-id="{03D67684-A9E8-4030-97CE-4001F9A904D5}" initial-flow-on
ly="true"><sync-rule-value><export-flow><dest>dn</dest><src><attr /></src><fn id="Guid" /></export-flow></sync-rule-valu
e></sync-rule-mapping></export-flow><export-flow cd-attribute="MVObjectID" id="{F79A72B6-EA0C-4F24-9A3F-1052A2FFE2DF}" s
uppress-deletions="true"><direct-mapping><src-attribute intrinsic="true">object-id</src-attribute></direct-mapping></exp
ort-flow><export-flow cd-attribute="AccountName" id="{0AF8B502-54F6-463A-AFAF-78F515BC6BA5}" suppress-deletions="true"><
direct-mapping><src-attribute>accountName</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="Displ
ayName" id="{6CF045B7-453D-46BF-A234-568D8405335C}" suppress-deletions="true"><direct-mapping><src-attribute>displayName
</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="Domain" id="{D4836171-EC2A-470C-8CFA-6F90EB1C2
389}" suppress-deletions="true"><direct-mapping><src-attribute>domain</src-attribute></direct-mapping></export-flow><exp
ort-flow cd-attribute="EmployeeID" id="{BD78D9C7-8C69-45A0-AE48-910CF2F8D5DF}" suppress-deletions="true"><direct-mapping
><src-attribute>employeeID</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="EmployeeType" id="{9
6E361FB-347E-4168-A0BD-A0C2D2EA56D9}" suppress-deletions="true"><direct-mapping><src-attribute>employeeType</src-attribu
te></direct-mapping></export-flow><export-flow cd-attribute="FirstName" id="{0CB5E1AC-3D4F-4D87-88B9-24227DB78CEA}" supp
ress-deletions="true"><direct-mapping><src-attribute>firstName</src-attribute></direct-mapping></export-flow><export-flo
w cd-attribute="LastName" id="{0DDBC48D-F742-4410-A80C-EEDE400CD5A9}" suppress-deletions="true"><direct-mapping><src-att
ribute>lastName</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="ObjectSID" id="{5A748A55-4FEF-4
DCC-9810-730DF7A386C4}" suppress-deletions="true"><direct-mapping><src-attribute>objectSid</src-attribute></direct-mappi
ng></export-flow><export-flow cd-attribute="Email" id="{6DE72687-02AD-475A-BA1A-742949D17588}" suppress-deletions="true"
><direct-mapping><src-attribute>email</src-attribute></direct-mapping></export-flow></export-flow-set>" to type "System.
Xml.XmlDocument". Error: "There are multiple root elements. Line 1, position 1545."

System.Management.Automation.PSInvalidCastException

------------------------------------
Reply:

Markus, I think I ran into this error but haven't circled back to confirm - I think this somehow has something to do with the same attribute bound to multiple object types; i.e "ADDN" bound to both Person and Group.

The error you should focus on is:

"There are multiple root elements. Line 1, position 1545."

Brad Turner, ILM MVP - Ensynch, Inc - www.identitychaos.com

------------------------------------
Reply:

Try ist again.
This time, it should work...

Cheers,
Markus

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

------------------------------------
Reply:

Thanks Markus, that worked beautifully. The MPR's look OK.

Now if I can just get the Oracle MA -> FIM -> AD account provisioning to work I'd be laughing.

------------------------------------
Reply:

Cool - good to know...

Let us know - in a separate post :-) - if you are runnig into issues with this scenario.

Cheers,
Markus

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

Edited by Markus VilcinskasMicrosoft employee Friday, April 2, 2010 6:41 PM

------------------------------------
Reply:

Will do. Again thanks.

Cheers,
Bruce

------------------------------------
Reply:

Hi,

When i run the above script i get the following message:

Error: Cannot convert value "" to type "System.Xml.XmlDocument". Error: "Root element is missing."

System.Management.Automation.PSInvalidCastException

------------------------------------
Reply:

Fixed.

Cheers,
Markus

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

------------------------------------
Reply:

Hello Markus,

I was running your script today, but I'm getting the same error above. My particular error output is:

Error: Cannot convert value "<export-flow-set cd-object-type="DetectedRuleEntry" mv-object-type="detectedRuleEntry"><exp
ort-flow cd-attribute="SynchronizationRuleID" id="{9E5B6888-F81A-4E0D-B0F6-78FFFBB4DA1A}" suppress-deletions="true"><dir
ect-mapping><src-attribute>synchronizationRuleID</src-attribute></direct-mapping></export-flow><export-flow cd-attribute
="DisplayName" id="{6DC4D010-36BB-4151-BFB5-01B283F8441C}" suppress-deletions="true"><direct-mapping><src-attribute>disp
layName</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="Connector" id="{16570D09-B191-4DB5-833D
-A5A5C7E06EF6}" suppress-deletions="true"><direct-mapping><src-attribute>connector</src-attribute></direct-mapping></exp
ort-flow><export-flow cd-attribute="ResourceParent" id="{5E1DBF1A-AC7B-4993-A9D4-7E57B0437749}" suppress-deletions="true
"><direct-mapping><src-attribute>resourceParent</src-attribute></direct-mapping></export-flow><export-flow cd-attribute=
"dn" id="{69A74462-9C5B-4120-A584-D6F4FCDF094B}"><sync-rule-mapping mapping-type="expression" sync-rule-id="{745C6BFC-82
91-4039-8042-4DCCAAB2BC4B}" sync-rule-mapping-id="{745C6BFC-8291-4039-8042-4DCCAAB2BC4B}" initial-flow-only="true"><sync
-rule-value><export-flow><dest>dn</dest><src><attr /></src><fn id="Guid" /></export-flow></sync-rule-value></sync-rule-m
apping></export-flow><export-flow cd-attribute="MVObjectID" id="{A97F345C-21C7-4524-A60F-C69713531C80}" suppress-deletio
ns="true"><direct-mapping><src-attribute intrinsic="true">object-id</src-attribute></direct-mapping></export-flow></expo
rt-flow-set><export-flow-set cd-object-type="ExpectedRuleEntry" mv-object-type="expectedRuleEntry"><export-flow cd-attri
bute="StatusError" id="{65DBDBB0-7AF0-40B8-83D8-DC92328EE088}" suppress-deletions="true"><direct-mapping><src-attribute>
statusError</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="SynchronizationRuleStatus" id="{2D1
A6CA5-061E-4F36-8F9D-C8B6498CC2C8}" suppress-deletions="true"><direct-mapping><src-attribute>status</src-attribute></dir
ect-mapping></export-flow></export-flow-set><export-flow-set cd-object-type="Person" mv-object-type="person"><export-flo
w cd-attribute="dn" id="{7BF6E688-10E0-46A5-980B-3AA2B0047430}"><sync-rule-mapping mapping-type="expression" sync-rule-i
d="{B3E7473A-7B00-4880-B3F8-7FB7A877FF5A}" sync-rule-mapping-id="{B3E7473A-7B00-4880-B3F8-7FB7A877FF5A}" initial-flow-on
ly="true"><sync-rule-value><export-flow><dest>dn</dest><src><attr /></src><fn id="Guid" /></export-flow></sync-rule-valu
e></sync-rule-mapping></export-flow><export-flow cd-attribute="MVObjectID" id="{EC6EC36D-5B3B-4FDA-9B37-C45679F146A1}" s
uppress-deletions="true"><direct-mapping><src-attribute intrinsic="true">object-id</src-attribute></direct-mapping></exp
ort-flow><export-flow cd-attribute="AccountName" id="{0C5027BB-591F-4641-B6EC-D84AE3DC3A6D}" suppress-deletions="true"><
direct-mapping><src-attribute>accountName</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="Compa
ny" id="{28542EC5-BA16-423E-9C8B-6FF57C7A4800}" suppress-deletions="true"><direct-mapping><src-attribute>company</src-at
tribute></direct-mapping></export-flow><export-flow cd-attribute="DisplayName" id="{16C6BA62-12D5-4B5F-AC1D-22910A9B3937
}" suppress-deletions="true"><direct-mapping><src-attribute>displayName</src-attribute></direct-mapping></export-flow><e
xport-flow cd-attribute="Domain" id="{E4A8CD0F-F188-4BE8-998C-1EBF727AC696}" suppress-deletions="true"><direct-mapping><
src-attribute>domain</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="EmployeeID" id="{2FD5E17F-
7DE1-4478-870A-D0D1FE73FD54}" suppress-deletions="true"><direct-mapping><src-attribute>employeeID</src-attribute></direc
t-mapping></export-flow><export-flow cd-attribute="EmployeeType" id="{E83CFDEF-EC68-404F-AF0D-673CDCF0BDAF}" suppress-de
letions="true"><direct-mapping><src-attribute>employeeType</src-attribute></direct-mapping></export-flow><export-flow cd
-attribute="FirstName" id="{E8976E8B-A42C-4201-842A-DBC8A3CD209C}" suppress-deletions="true"><direct-mapping><src-attrib
ute>firstName</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="LastName" id="{DCCE9E95-8DFB-482C
-A00A-D96309274257}" suppress-deletions="true"><direct-mapping><src-attribute>lastName</src-attribute></direct-mapping><
/export-flow><export-flow cd-attribute="Manager" id="{ACB4C363-F651-4D33-985B-262EBCE1CC12}" suppress-deletions="true"><
direct-mapping><src-attribute>manager</src-attribute></direct-mapping></export-flow><export-flow cd-attribute="ObjectSID
" id="{C4722080-D607-4A4D-952E-7D4D1AAA939E}" suppress-deletions="true"><direct-mapping><src-attribute>objectSid</src-at
tribute></direct-mapping></export-flow></export-flow-set>" to type "System.Xml.XmlDocument". Error: "There are multiple
root elements. Line 1, position 1545."

System.Management.Automation.PSInvalidCastException

Regards,

Gene

------------------------------------
Reply:

We must have a ghost :o)
I have fixed this issue several times and it always comes back.

This script is a bit too big to be managed in a forum post.

I have uploaded the latest version to the FIM ScriptBox in the MSDN library.
Let me know if it works now.

Cheers,
Markus

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

------------------------------------
Reply:

Hello Markus,

Thanks for that. I downloaded your script and ran it. It came back with "Your current MPR configuration meets all requirements". However when I run the Export profile on the FIMMA agent to create AD accounts, I still get a "failed-creation-via-web-service" and the error detail gives a "Message: Fault Reason: Policy prohibits the request from completing"

_____________________________________________________________________________

There is an error executing a web service object creation request.
Type: Microsoft.ResourceManagement.WebServices.Client.PermissionDeniedException

Message: Fault Reason: Policy prohibits the request from completing.

Fault Details: <RequestFailures xmlns="http://schemas.microsoft.com/2006/11/ResourceManagement" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"></RequestFailures>

Stack Trace:    at Microsoft.ResourceManagement.WebServices.ResourceFactoryClient.Create(Message request)
   at Microsoft.ResourceManagement.WebServices.ResourceFactoryClient.Create(Create createBody)
   at Microsoft.ResourceManagement.WebServices.Client.ResourceTemplate.CreateResource()

Inner Exception: Policy prohibits the request from completing.

______________________________________________________________________________

Thanks,

Gene

------------------------------------
Reply:

Are you running the RTM FIM bits?
In the FIM Portal, under Search Requests, see whether you can find request with a status of denied.
In the request details, you can find the MPR that has blocked you.

Cheers,
Markus

Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation

------------------------------------
Reply:

I just used this in an environment and it is a great and wonderful thing.

Thank you so much!

Aaron Sankey, Virteva

------------------------------------
Reply:

Hello Markus, I'm getting the following message when I run the script I'm just wondering if you could explain to me what this means (NOTE: the 'bnr' prefixed attributes are my custom attributes). I looked at the MPR in question and I can't see what this is trying to tell me.

FIM MPR Configuration For Synchronization Check
===============================================

Missing attributes of Synchronization: Synchronization account controls users it synchronizes:

-MVObjectID
-DetectedRulesList
-AccountName
-FirstName
-LastName
-MiddleName
-DisplayName
-Domain
-EmployeeType
-MailNickname
-bnrProvisionedAccount
-ObjectSID
-bnrAccountContext
-bnrEmployeeExchangeMailbox
-EmployeeID
-Email
-bnrStudentInd

Caution: Your current MPR configuration requires your attention!

------------------------------------
Reply:

I actually have a lot more attributes in my list, but when i check the MPRs, they are set for "All Attributes". So how can they be missing?

Also...does this check all MPRs or just the ones listed in the script? how can more be added if thats the case?

Opper ...don't stop.

Edited by Opper Wednesday, January 25, 2012 12:47 PM

------------------------------------

Correlation error

We have developed an infopath form with some C# code (visual studio 2005) and published that in SP 2010.

So when we are trying to upload the published form in Central Admin -> Upload from Template ,we are getting this error,(not able to figure put why this is coming)

object reference not set to an instance of an object

Troubleshoot with Microsoft Sharepoint Foundation:

Correlation ID : 3bbc65e0-ac76-4aaa-956c-950c1dfb4e67

Let me what needs to be done in this case to solve the problem.

Reply:

Hi, please check out the correlation ID, here is a post of how to do this: http://www.maartenpeeters.nl/MyBlog/?p=115

Kind regards,

Nico Martens - MCTS, MCITP
SharePoint 2010 Infrastructure Consultant
Blog: SharePoint Related
E-mail: Nico Martens

------------------------------------

How do I create a folder for SSIS package in MSDB with T-SQL?

[This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]

Question:

When I logon to Integration Services from SQL Server Management Studio, I can create a package folder to store the package under the MSDB folder. But can I programmatically create a folder with T-SQL?

Answer:

Yes, you can directly insert a record into the user table dbo.sysssispackagefolders in your msdb database with the T-SQL statement as follows:

INSERT INTO dbo. sysssispackagefolders (  folderid  ,parentfolderid  ,foldername)  VALUES (NEWID(), '<Parent folder GUID>', '<Folder name>')

For example, if you want to create a folder named “Packages” under the MSDB folder, you can run the following T-SQL:

INSERT INTO dbo. sysssispackagefolders (  folderid  ,parentfolderid  ,foldername)  VALUES (NEWID(), '00000000-0000-0000-0000-000000000000','Packages')

Please remember to mark the replies as answers if they help and unmark them if they provide no help

Reply:

Charles - you should be blogging these tips. Search engines and other blogs will find them more readily...

Talk to me now on

------------------------------------
Reply:

Its better you create some blog, and use it in your footer while answering the questions...

------------------------------------
Reply:

Hi Todd and bal123,

Thanks very much for your feedbacks. Some colleagues and I collected about 20 SSIS and 20 SSAS forum FAQs and need to post them in the SSIS and SSAS forums in the following days.

I had thought that blog is a good way, however based on our investigation and statistics from other forums like .NET development, windows server etc, posting the FAQs in forums has better better search possibility than a blog. For example, if you search a technical question vial Bing or Google, forum posts are often ranked very top. So we follow the best practice from other forums and post these FAQs in forums.

To align the FAQs publication manner with other forums, I am afraid that currently these 40 coming FAQs will be published in SSIS and SSAS forums. However we really appreciate your feedbacks. We will further discuss on the FAQ publication and figure out a better way for doing this next time, maybe creating a blog or KB or something else.

Really appreciate your understanding on this. Thank you guys.

Please remember to mark the replies as answers if they help and unmark them if they provide no help

------------------------------------
Reply:

My two cents:

It may or may not be the case that forum posts get ranked higher - in my experience, blog posts get ranked equally. However, I tend to click on blog posts in preference to those - because forum posts tend to be rambling and not always applicable. From a blog post title, I can easily see if the post will apply, and blog posts tend to be very straightforward, to the point, and complete.

Pages get ranked on relevance and links to them (I think) - which may mean that forum posts get linked to comparably to blog posts... which may the case.

If/when yo do compile those posts into a FAQ, I hope you don't copy the entirety of the posts into the FAQ. You should just place a link to the relevant post in there.

However, I think you can get the best of both: Publish your articles on a blog - perhaps the SSIS Team blog, under a "How To" tag, and link to those posts in the FAQ. You'll benefit from the rankings that the SSIS Team blog already has - plus the fact that it's already on a ton of peoples' reader lists.

Talk to me now on

------------------------------------
Reply:

Thanks Todd. We will change the way of FAQ publication next time. For this time, let us just bear them in forums.

Thank you!

Please remember to mark the replies as answers if they help and unmark them if they provide no help

------------------------------------
Reply:

Wouldn't it be cleaner/safer to use the appropriate system stored proc for that?

The example would come down to:

exec msdb.dbo.sp_ssis_addfolder   @parentfolderid = '00000000-0000-0000-0000-000000000000'   ,@name = 'Packages';

Additional info: the third parameter, @folderid, is optional and NEWID() will be used when not provided.

MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)

Edited by Valentino Vranken Wednesday, January 25, 2012 12:36 PM added additional info

------------------------------------

Cube Deployment error

HI Team,

iam working on a project which was already existing.
I copied the solution and tried to deploy the cube in my development server. i followed the following steps to deploy the cube.

1] i deployed the cube.
2] When i deploy the cube there are some processing error.

3] during the process i ignored the errors on all conditions.

4] the cube while processing is throwing the following error. [sorry for pastng a big and confusing err] but please help me in solving this one.

<KeyNotFound>IgnoreError</KeyNotFound>

<NullKeyNotAllowed>IgnoreError</NullKeyNotAllowed>

</ErrorConfiguration>

<DatabaseID>xclude3</DatabaseID>

<CubeID>BASEL BB 6</CubeID>

<MeasureGroupID>Security Analysis Obligor Vw</MeasureGroupID>

<PartitionID>Security Analysis Obligor Vw</PartitionID>

</Object>

<Type>ProcessFull</Type>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

</Batch>

Processing Cube 'CRAS' failed.

Start time: 25/01/2012 09:20:52; End time: 25/01/2012 09:34:32; Duration: 0:13:40

Processing Measure Group 'Security Analysis Obligor' failed.

Start time: 25/01/2012 09:20:57; End time: 25/01/2012 09:34:32; Duration: 0:13:35

Processing Partition 'Security Analysis Obligor Vw' failed. 3990000 rows have been read.

Start time: 25/01/2012 09:20:57; End time: 25/01/2012 09:34:32; Duration: 0:13:35

SQL queries 1

SELECT [dbo_security_analysis_obligor_vw].[indexed_asset_value] AS [dbo_security_analysis_obligor_vwindexed_asset_value0_0],[dbo_security_analysis_obligor_vw].[asset_value] AS [dbo_security_analysis_obligor_vwasset_value0_1],[dbo_security_analysis_obligor_vw].[asset_lend_val] AS [dbo_security_analysis_obligor_vwasset_lend_val0_2],[dbo_security_analysis_obligor_vw].[cust_lend_val] AS [dbo_security_analysis_obligor_vwcust_lend_val0_3],[dbo_security_analysis_obligor_vw].[enrv] AS [dbo_security_analysis_obligor_vwenrv0_4],[dbo_security_analysis_obligor_vw].[enrv_indexed_current] AS [dbo_security_analysis_obligor_vwenrv_indexed_current0_5],[dbo_security_analysis_obligor_vw].[enrv_indexed_default] AS [dbo_security_analysis_obligor_vwenrv_indexed_default0_6],[dbo_security_analysis_obligor_vw].[enrv_indexed_downturn] AS [dbo_security_analysis_obligor_vwenrv_indexed_downturn0_7],[dbo_security_analysis_obligor_vw].[no_of_contracts] AS [dbo_security_analysis_obligor_vwno_of_contracts0_8],[dbo_security_analysis_obligor_vw].[indexed_best_estimate_enrv] AS [dbo_security_analysis_obligor_vwindexed_best_estimate_enrv0_9],[dbo_security_analysis_obligor_vw].[historic_enrv_secured_debt] AS [dbo_security_analysis_obligor_vwhistoric_enrv_secured_debt0_10],[dbo_security_analysis_obligor_vw].[indexed_current_enrv_secured_debt] AS [dbo_security_analysis_obligor_vw0_11],[dbo_security_analysis_obligor_vw].[indexed_default_enrv_secured_debt] AS [dbo_security_analysis_obligor_vw0_12],[dbo_security_analysis_obligor_vw].[indexed_downturn_enrv_secured_debt] AS [dbo_security_analysis_obligor_vw0_13],[dbo_security_analysis_obligor_vw].[historic_enrv_secured_exposure] AS [dbo_security_analysis_obligor_vw0_14],[dbo_security_analysis_obligor_vw].[indexed_current_enrv_secured_exposure] AS [dbo_security_analysis_obligor_vw0_15],[dbo_security_analysis_obligor_vw].[indexed_default_enrv_secured_exposure] AS [dbo_security_analysis_obligor_vw0_16],[dbo_security_analysis_obligor_vw].[indexed_downturn_enrv_secured_exposure] AS [dbo_security_analysis_obligor_vw0_17],[dbo_security_analysis_obligor_vw].[historic_enrv_unsecured_debt] AS [dbo_security_analysis_obligor_vwhistoric_enrv_unsecured_debt0_18],[dbo_security_analysis_obligor_vw].[indexed_current_enrv_unsecured_debt] AS [dbo_security_analysis_obligor_vw0_19],[dbo_security_analysis_obligor_vw].[indexed_default_enrv_unsecured_debt] AS [dbo_security_analysis_obligor_vw0_20],[dbo_security_analysis_obligor_vw].[indexed_downturn_enrv_unsecured_debt] AS [dbo_security_analysis_obligor_vw0_21],[dbo_security_analysis_obligor_vw].[historic_enrv_unsecured_exposure] AS [dbo_security_analysis_obligor_vw0_22],[dbo_security_analysis_obligor_vw].[indexed_current_enrv_unsecured_exposure] AS [dbo_security_analysis_obligor_vw0_23],[dbo_security_analysis_obligor_vw].[indexed_default_enrv_unsecured_exposure] AS [dbo_security_analysis_obligor_vw0_24],[dbo_security_analysis_obligor_vw].[indexed_downturn_enrv_unsecured_exposure] AS [dbo_security_analysis_obligor_vw0_25],[dbo_security_analysis_obligor_vw].[lending_value_secured_exposure] AS [dbo_security_analysis_obligor_vw0_26],[dbo_security_analysis_obligor_vw].[lending_value_unsecured_exposure] AS [dbo_security_analysis_obligor_vw0_27],[dbo_security_analysis_obligor_vw].[lend_val_sec_debt] AS [dbo_security_analysis_obligor_vwlend_val_sec_debt0_28],[dbo_security_analysis_obligor_vw].[lend_val_unsec_debt] AS [dbo_security_analysis_obligor_vwlend_val_unsec_debt0_29],[dbo_security_analysis_obligor_vw].[time_month_key] AS [dbo_security_analysis_obligor_vwtime_month_key0_30],[dbo_security_analysis_obligor_vw].[customer_age_band1_key] AS [dbo_security_analysis_obligor_vwcustomer_age_band1_key0_31],[dbo_security_analysis_obligor_vw].[customer_security_class_key] AS [dbo_security_analysis_obligor_vwcustomer_security_class_key0_32],[dbo_security_analysis_obligor_vw].[default_reason_key] AS [dbo_security_analysis_obligor_vwdefault_reason_key0_33],[dbo_security_analysis_obligor_vw].[entity_type_key] AS [dbo_security_analysis_obligor_vwentity_type_key0_34],[dbo_security_analysis_obligor_vw].[retail_split_key] AS [dbo_security_analysis_obligor_vwretail_split_key0_35],[dbo_security_analysis_obligor_vw].[segment_key] AS [dbo_security_analysis_obligor_vwsegment_key0_36],[dbo_security_analysis_obligor_vw].[exposure_band1_key] AS [dbo_security_analysis_obligor_vwexposure_band1_key0_37],[dbo_security_analysis_obligor_vw].[limits_band1_key] AS [dbo_security_analysis_obligor_vwlimits_band1_key0_38],[dbo_security_analysis_obligor_vw].[sic_code_level6_key] AS [dbo_security_analysis_obligor_vwsic_code_level6_key0_39],[dbo_security_analysis_obligor_vw].[licensed_entity_key] AS [dbo_security_analysis_obligor_vwlicensed_entity_key0_40],[dbo_security_analysis_obligor_vw].[business_unit_comb_key] AS [dbo_security_analysis_obligor_vwbusiness_unit_comb_key0_41],[dbo_security_analysis_obligor_vw].[control_type_key] AS [dbo_security_analysis_obligor_vwcontrol_type_key0_42],[dbo_security_analysis_obligor_vw].[ukrb_gms_band1_key] AS [dbo_security_analysis_obligor_vwukrb_gms_band1_key0_43],[dbo_security_analysis_obligor_vw].[wib_gms_band1_key] AS [dbo_security_analysis_obligor_vwwib_gms_band1_key0_44],[dbo_security_analysis_obligor_vw].[reaged_key] AS [dbo_security_analysis_obligor_vwreaged_key0_45],[dbo_security_analysis_obligor_vw].[indexed_best_estimate_enrv_vs_exposure_key] AS [dbo_security_analysis_obligor_vw0_46],[dbo_security_analysis_obligor_vw].[customer_key] AS [dbo_security_analysis_obligor_vwcustomer_key0_47],[dbo_security_analysis_obligor_vw].[indexed_downturn_enrv_vs_exposure_key] AS [dbo_security_analysis_obligor_vw0_48],[dbo_security_analysis_obligor_vw].[balances_band1_key] AS [dbo_security_analysis_obligor_vwbalances_band1_key0_49]

FROM [dbo].[security_analysis_obligor_vw] AS [dbo_security_analysis_obligor_vw]

Error Messages 1

OLE DB error: OLE DB or ODBC error: Warning: Null value is eliminated by an aggregate or other SET operation.; 01003; The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases; 42000. Errors in the OLAP storage engine: An error occurred while processing the 'Security Analysis Obligor Vw' partition of the 'Security Analysis Obligor' measure group for the 'CRAS' cube from the xclude3 database.

Errors and Warnings from Response

Errors in the OLAP storage engine: An error occurred while processing the 'Security Analysis Obligor Vw' partition of the 'Security Analysis Obligor' measure group for the 'CRAS' cube from the xclude3 database.

Internal error: The operation terminated unsuccessfully.

Server: The operation has been cancelled.

thanks in advance.

baskar k

Reply:

Hi Baskar K,

It does not seem to be an Analysis Services issue.
As the error message says, your tempdb transaction log is full - the disk might be full (where the ldf file of the tempdb is stored), or maximum size might have been set for this file.

Please first check the SQL instance where the data is loaded from.

Kind regards,
Zoli

(Admins/Moderators: could you please set the type of this this entry to "question" instead of "discussion"?)

-- Zoltán Horváth
-- MCITP SQL Server Business Intelligence Developer 2005, 2008
-- MCITP Database Developer 2008, Database Administrator 2008
-- Please mark posts as answered or helpful where appropriate.

Edited by Zoltán HorváthMVP Wednesday, January 25, 2012 11:00 AM corrected typo

------------------------------------
Reply:

Hi Baskar

Can you remove TempItem from your C Drive OR Create Space in your C drive. After creating some space in C Drive. Deploy & Process the cube.

Suhas | MCP | MCTS

Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

------------------------------------
Reply:

HI All,

Thanks for the quick reply.

thanks.

baskar k

------------------------------------

Scope for Lotus Notes to SharePoint Projects?

Hi,

I am currently working on Lotus Notes to SharePoint 2010 migration project. Here I am accessing Lotus Notes database and migrating all the content from LN database to SharePoint 2010 list using third party tool named “Quest Migrator for Sharepoint Designer”.

Now I am concerned about my skills updations and future scope related to the project. In simple words my question is “Is there any scope for Lotus notes to Sharepoint migration in industries?”. I heard that LN is old tool so its now nowhere used in market and this is the reason I am anxious. I am not much bothered about pay packages but more opportunity oriented. Please help.

Note: I am Sharepoint developer with 3 years of exp

Sachin D - Sharepoint Developer

Moved by litdev Tuesday, November 15, 2011 6:10 PM (From:Small Basic)
Changed type Sachin ShareApoint Tuesday, January 24, 2012 3:13 PM I suspect it's not visible to users

Reply:

This was moved out of the Small Basic forum. You should post your question in a Lotus or SharePoint forum.

Let me know if you want me to move this question to another forum.

Thanks!

Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)

------------------------------------
Reply:

Yes Ed, I want this to be moved under other forum category. I really want some replies on this thread so kindly move it under the category where user will read it.

I believe this question would be useful for others too.

Thanks in Advance.

Sachin D - Sharepoint Developer

------------------------------------
Reply:

Yes Ed, I want this to be moved under other forum category. I really want some replies on this thread so kindly move it under the category where user will read it.

I believe this question would be useful for others too.

Thanks in Advance.

Sachin D - Sharepoint Developer

I don't know why I didn't get an alert for this thread. Anyway, Lotus isn't Microsoft, so I'm thinking SharePoint. Can you take a look at the different SharePoint forums and then tell me which one you want it moved to?

Thanks!

Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)

------------------------------------
Reply:

Hi ED,

None of the user is replying on the thread. Is something I need to be changed in the same.

I am concerned wheather it's visible to everyone or not :(

Sachin D Sharepoint Developer

Edited by Sachin ShareApoint Tuesday, January 24, 2012 3:13 PM

------------------------------------
Reply:

Hi ED,

None of the user is replying on the thread. Is something I need to be changed in the same.

I am concerned wheather it's visible to everyone or not :(

Sachin D Sharepoint Developer

Yes. It was moved out of SmallBasic because it's off topic. Currently it's in a forum where no one responds.

It would be best to ask the question in another forum that is on topic or to move this thread there.

Thanks!

Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)

------------------------------------
Reply:

> You should post your question in a Lotus or SharePoint forum.

I'd be grateful, Ed, if you would specify the set of SharePoint forums to be posted to. This is a SP 2010 question and so the reference should have been to a SharePoint 2010 forum. (The alternative is a pre-SharePoint 2010 forum - and that seems far to often to be the default choice even for SP 2010 questions)

The other thing is that the poster will have a hard time trying to find a Lotus forum here in the Microsoft forum system. Perhaps noting that Lotus forum would be somewhere in an IBM site would have helped.

Mike

SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
Both also have links to extensive book lists and to (free) on-line chapters

------------------------------------

BPA tells me my TEMP directory is not on a local drive?

I have the TEMP and TMP directories set to be on D instead of C. When I run the BPA, it tells me my TMP directory appears to be invalid. Says it doesn't appear to be a local drive. But it is a local drive. It's part of the RAID array. I have a single RAID 5.

Changed type Sean Zhu - Friday, January 27, 2012 8:05 AM no response

Reply:

is this on an SBS system of any kind?

I haven't actually bothered with the temp location on SBS08/11 but would suggest a certain folder structure be implemented. D:\Temp\User & D:\Temp\System

------------------------------------
Reply:

Yes, it's an SBS 2011. But I have about 6 of them running with similar setups and this is the only one that is giving me the error. They are all Dell's with PERC 6i cards.

------------------------------------
Reply:

Hi abrrymnvette, what's the exact error showing in SBSBPA? Have you tried SG's suggestion?

Sean Zhu

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Sean Zhu

TechNet Community Support

------------------------------------

Complex query on grouping and ranking data

Facts:

1 An SQL table contains records for 50 Sales units with their respective sales orders.

For Ex Sales Unit 1 has 10000 record ($1,000,000), Sales Unit 2 has 20000($3,000,000) records with sales order numnber and sales values for each order

Problem: I am required to pull information on orders for Top 30% order value for each sales unit

Ex wrt to sales unit 1. The first 3000 records might constitute 30% of order value (i.e $300,000) when retrieved on desc on order value

and sales unit 2. The first 500 records might constitute 30% of order value (i.e $1,000,000) when retrieved on desc on order value individually.

I want to have a single table with records for all the 50 sales units.

Issues:

1 the number of record keep changing for each sales unit.

2 The 30% of ordervalue is for the respective sales unit and not the entire data

Any help is highly appreciated

PS: I am currently thinking of have cumilative % for each unit and use sp to loop through each country ( however i dont know how to loop using a sp)

Solved.

I cannot run any application (except for web browsers) that require access to the C:/user/(user name)/appdata folders. here is an error report from the program Drop box:

Mozilla Thunderbird will not run, neither will TurboTax.
I have tried changing the permissions of both user and administrator without effect. If there is any more information I can provide, I will be happy to do so.\

Thank you in advance for your help!

Woops.... Here I was ramming my head into a brick wall when I noticed that the folders and sub folders were labeled: "Read-Only." Haha! I must have clicked it while changing a setting or some other such thing, so I guess I solved my own stupidity. I am sorry for wasting your time.

Changed type 27Matt27 Wednesday, January 25, 2012 6:53 AM Problem solved. :P
Edited by 27Matt27 Wednesday, January 25, 2012 9:29 AM

Reply:

Unable to view the error.Attach the error snapshot.

Regards, Kalyan.

------------------------------------

Failing to download

My current WSUS configuration is, I have a WSUS server that connects to MS for the updates. I have a downstream server configured as a replica, at a remote site. On the replica server, I recently moved the WSUS data from a local disk to a network share because of disk space. To move the data, I used the wsusutil movecontent command line tool. Everthing moved fine. The WSUS console showed syc successful. Everthing looked good.

But now the following message is logged in the Apps log every 6 hours:

------------------------------------------------------------------------------------------------------------------

Event Type:    Error
Event Source:    Windows Server Update Services
Event Category:    Core
Event ID:    10032
Date:        1/24/2012
Time:        5:09:48 AM
User:        N/A
Computer:    INFLOW1
Description:
The server is failing to download some updates.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

--------------------------------------------------------------------------------------------------------------------

I have checked the rights of the share to be sure the account WSUS uses has full access network share. I have verified that endusers have read access to the network share. I have cleared updates on the replica server that were showing unapproved, but were approved on the upstream server. The WSUS console shows sychronization success full for manual and scheduled syc's between the two servers. I am at a loss of what else to even look for. Anyone have any ideas?

Reply:

On the replica server, I recently moved the WSUS data from a local disk to a network share

Storing content on a network share is not a supported configuration.

This is the root cause of your error.

Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2012)
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin

------------------------------------

"A disk read error occured" on VM

Hi All,

On Dell blade server we have installed 4 VM, where SQL, SCCM SCOM server installed. Everything is working fine suddenly we found that SQL server offed. when we try to restart it show "A disk error occured" Press Alt+Ctl+Del to restart.

We are having all database of SCCM, SCOM on SQL server.

Thanks in Advance Amol Shirke

Reply:

Hi,

Have you tried to restart the problematic VM?

If the issue continues, please try to mount the VHD of the problematic VM to other VM to see whether you can access the data within the VHDs.

Best Regards,

Vincent Hu

------------------------------------
Reply:

Hi,

Did same thing no luck.....!

Thanks in Advance Amol Shirke

------------------------------------
Reply:

Hi,

What did you get when you attach the VHDs to other VM? Please provide details.

Best Regards,

Vincent Hu

------------------------------------
Reply:

Hi,

On blade server we are having 4 vms, some one has attached external HDD to blade server. After that Database server got down. We are trying to recover OS but there is no option come for repaire because of no HDD found for VM.

Thanks in Advance Amol Shirke

------------------------------------
Reply:

Hi,

It’s a virtual machine, so you may assign a VHD or pass-through disk to it. So please check whether the disk is configured properly for the virtual machine. You can right click on the virtual machine to open Settings.

By the way, you mentioned “because of no HDD found for VM”, I would like to know the way you identified this symptom. Please take some screenshots and upload here.

In addition, if you are using Windows Server 2008 or the later operating system, there isn’t a repair option like Windows Server 2003.

Best Regards,

Vincent Hu

------------------------------------

windows server 2003

Microsoft SQL Server extends Microsoft Windows Server 2003 by?

<input id="answer_3" class="wpss_radio" name="wpss_ans_radio_q_1" type="radio" value="wpss_ans_3" /><label for="answer_3">adding internet-connection/proxy server services.</label>

<input id="answer_4" class="wpss_radio" name="wpss_ans_radio_q_1" type="radio" value="wpss_ans_4" /><label for="answer_4">adding a data exchange layer which can be used to share information with UNIX computers.</label>

<input id="answer_10" class="wpss_radio" name="wpss_ans_radio_q_1" type="radio" value="wpss_ans_10" /><label for="answer_10">adding database functionality to the operating system</label>

<input id="answer_11" class="wpss_radio" name="wpss_ans_radio_q_1" type="radio" value="wpss_ans_11" /><label for="answer_11">providing e-mail services for clients.</label>

which one is correct?

Changed type moktadir Wednesday, January 25, 2012 6:13 AM Microsoft SQL Server extends Microsoft Windows Server 2003 by?

Reply:

For SQL Server queries, I would have ask here.

http://social.msdn.microsoft.com/Forums/en/category/sqlserver

Thanks

------------------------------------

Using Lookup vs T-SQL query when target is database

I am reading about Lookup transformation. Never needed to use it for anything yet.

The thought that comes to mind: why not just import data in temporary table and perform final data processing using T-SQL script instead of using Lookup component? In my opinion T-SQL is more flexible than whatever SSIS provides (I may be wrong). Plus I wouldn't be surprised if it turned out to be faster too.

Reply:

I prefer to bring data into a staging table then join the rows using standard SQL.

Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008

------------------------------------
Reply:

Avoid manipulating with temporary objects while performing data operations in the SSIS pipeline. Create physical objects and later drop them.

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

------------------------------------

Ms Support forum

Wednesday, March 2, 2022