Links
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
Reply:
Hi,
Thanks for sharing. We really appreciate your time and efforts. Hope your experience will help other community members facing similar problems.
Leo Huang
TechNet Community Support
------------------------------------
Reply:
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Software Updates
Hi,
I have created a software update deployment.
this deploys 4 bulletin idms to a collectio nand works fine
the problem I have is that I can locate when I can have a status of this like I can do with any other advertisement.
ie. how can i get a status of software updates ?
I have no bother in getting a status of a non software update
Reply:
Hi
Apologies, to correct the grammar mistakes.
I have inherited a collect with runs a software update deployment, it works fine , For the life of me I can not see the advertisement where I can get a status of who has got it etc etc.
All other advdertisements I can get a status
This is driving me crazy
------------------------------------
Reply:
Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund
------------------------------------
Reply:
Kent,
thanks for your reply.
Two ?????
Is that the only way to check for a status on a software deployment ?
Am I correct in saying that there is not an option to right click and get a status of this deployment as SCCM buries that advertisement within ?
------------------------------------
Reply:
Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund
------------------------------------
SUP Deployment limitations
I know that best practices say you shouldn't have more than 500 updates in a single deployment package.
But I can't find any information about having more than 500 updates in a single deployment (by deployment I mean the object under Software Updates > Deployment Management). Is is also best practice that a deployment should have less than 500 updates or doesn't this apply to the deployment object?
cogu
- Changed type Sabrina Shen Friday, March 16, 2012 9:44 AM
Reply:
Hi,
You can have more than 500 updates in an update list and deployment management no problem. Just spilt them up into multiple deployment packages as it is only the Software Updates apckages that has the 500 updates limitiation.
Regards,
jörgen
-- My System Center blog ccmexec.com -- Twitter @ccmexec
------------------------------------
Reply:
Though... Microsoft say something that is a little bit conflicting in their best practice documentation.
http://technet.microsoft.com/en-us/library/bb932162.aspx
"To avoid possible performance issues, we recommend that you do not add more than 500 software updates to a single software update deployment or deployment package."
I take it that by "single software update deployment or deployment package" they mean the deployment management object and the deployment package. If that's the case, it goes against what you said Jörgen. Can you clarify please?
cogu
------------------------------------
Reply:
Apparently as of at least 1st April 2011 the best practice has changed from "less than 500 updates to a single software update deployment" to "less than 500 updates to a single deployment package or software update deployment", as seen on both the following documents:
http://technet.microsoft.com/en-us/library/bb932162.aspx
http://technet.microsoft.com/en-ca/library/bb693754.aspx
Thank you.
------------------------------------
Reply:
Hi,
yes you are correct, I have had more thtn 500 in a deployment amny times, but is not Best Practice as you say.
I normally divide the updates per operating system or product to limit the number of updates per deployment/ deployment package. In some cases I move the update to a 2010 package as well so I have update deployments and packages per year to limit the number as well.
There are many different ways.
Regards,
Jörgen
-- My System Center blog ccmexec.com -- Twitter @ccmexec
------------------------------------
Reply:
I think dividing them by years makes it a little more managable: ensures you don't accidently leave out any updates that you're not quite sure which product to place them in and lets the workstation do the job of deciding what to install, not you. It does make it slightly harder to look at though, I'll admit to that.
Another question about deployments: I know it's not a good idea to "re-use" deployments as the reporting might then be a bit wierd. I can see how that would be the case if you're removing updates from the deployment. However, is that also the case if you are adding more updates to a deployment or advertising it to more workstations?
The idea was to have a monthly deployment which gets deleted at the end of the month and never re-used, and an yearly deployment which contains all updates for the current year excluding the monthly patches. As we move into a new month, the updates from the previous month would then be added to the current year deployment and a new deployment created for the new month. That way, we'd have a current year deployment that contains all current year updates except the ones for the current month but that would imply constantly adding more updates to a deployment.
cogu
------------------------------------
Need the paid services of a SQL expert - where should I go??
Not sure if this is the right place to ask this question, so apologies if I should be asking somewhere else.
I need to find a SQL expert, to look at our SQL databases, and investigate performance issues, indexing, see if the setup of the databases is appropriate/correct, etc etc. General maintenance I suppose. The company who installed SQL for us, well I have lost faith in them a long time ago, as all they seem to be interested in is making money but not providing a quality service. The database is used by our enterprise application, Microsoft Dynamics AX, and also used for Reporting Services. I had to set up Reporting Services myself in the end, as they were willing to 'look at it', but for an ridiculous fee. So I suppose I need that checked out as well, as we are get issues with Reporting Services report manager website timing out a few times a day and needing an IISRESET.
Any ideas of where I can go, where I can look for someone? Ideally someone based in north west of manchester, but anywhere UK based should be okay I suppose. Thanks for any and all help.
Naz
Reply:
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
------------------------------------
How to disable the Save Embedded Files Dialog
Hi all.
I need to turn off Save Embedden Files dialog.
I have set "Set Action" to "Don't Save this file. Use the current file on disk.". Unfortunately, SPD asks me the same question each time I save the file again. I'm using links to images (from my other website, format http://img.jpg), and i don't want to save images to my new project.
in Expression Web 4 I can do that with Registry key:
HKEY_CURRENT_USER\Software\Microsoft\Expression\Web\4.0\SaveEmbeddedFilesDisabled
but in SPD that doesn't work for me.
Anybody can help me with this problem?
[Solved] Troubles with Routing and IP-Spoofing
Hi,
I have a virtual cluster of UAG working with unicast NLB (Sp1 update 1). They are in a DMZ and Each node has only two interfaces: intern and extern (both through the firewall).
I can observe the following problem:
While accessing an UAG portal (https connection) from some external connection (like 178.x.x.x or 84.x.x.x for instance), the TMG firewall sees the packets as coming from outside but considers them as being spoofed, and thus drops them.
Obviously, those IP ranges are not defined in the intern network object. Furthermore, the issue doesn't happen when I access the portal from 3G connection.
As a workaround, I can add the IP ranges as a static route with the default gateway (extern). Still, it is a really unclean solution, does anybody have any idea?
Here's a screenshot of the "workaround" for a specific subnet, which should normally be included in the 0.0.0.0 route.
Thanks,
Pierre
- Edited by PierreMonier Monday, March 5, 2012 11:16 AM
Reply:
Hi,
Please check this link,
http://www.msserverpro.com/view/1015
I hope this will help you.
Thanks,
Best Regards, ----Naresh Man Maharjan,Nepal---- www.msserverpro.com
------------------------------------
Reply:
Hi Naresh,
first thank you for your answer, I'm sorry I answer that late, just didn't had a lot of time to work on that case.
Truth is, we solved the problem. The whole issue came from the configuration of the interfaces: the external interface was coming before the internal (advanced configuration of the adapters), provoking this absurd behaviour.
Thank you for your help.
Pierre
------------------------------------
Create a degenerate dimension
Hi all,
I want to create a degenerate dimension using a column from my fact table. How can i do that in BIDS?
Thanks in advance,
Anish Tuladhar
Anish Tuladhar -Do not forget to mark as answer, only if helpful.:)
Reply:
------------------------------------
Reply:
hi Anish,
we can create a degenerate dimension from the dimension usage tab in the cube.
Click on create new dimension option , then the same dimension wizard opens.
Then we can do as we need...
regards ,
dhwani
PLEASE MARK AS ANSWER IF IT RESOLVES.
s dhwani
------------------------------------
Web pages slow to load with TMG 2010 acting as Proxy
Hi Everyone,
I've run into an interesting problem with a new installation of TMG 2010. Basically everything seems to work fine; however, several websites load very slowly (slowly meaning they could take up to 5 minutes to load on a 100-Mb internet line). However, when we take TMG 2010 out of the equation the sites run smooth and quite snappy. Has anyone seem something similar with other installations?
Here's the configuration
· Windows 2008 R2 All Updates Applied
· Microsoft TMG 2010 with SP1 and Rollups installed "up to date windows updates"
· Front-End to Back-End Configuration
· Backend Server has single NIC
· Frontend Server has dual NICs, one nic internal and one external
· Frontend Server has DNS entries only on the internal NIC per best practice and no DNS entries on the external
· Backend server forwards proxy requests to front end through standard Web Proxy Chaining configuration
· Base rule set for Web Filtering with URL Categories "base configuration meaning wizard built - Default"
· Web Caching is Disabled
· Malware Inspection is disabled for testing purposes
· HTTP compression is turn off
· Web Chaining points at the internal network card inside the DMZ
· Normal web traffic passes however the below websites just load extremely slow
Sites in question which seem to load really slow
Thanks
Michael Cronin
- Edited by Michael T. Cronin Wednesday, February 23, 2011 11:35 PM Addition of more information
- Changed type Michael T. Cronin Monday, February 28, 2011 2:25 PM
Reply:
Hi Michael
I have the Same issues with TMG 2010, i have got all the rollup and updates installed till now but i still have the same internet slow browing issue.
Hope this link is to any help for you. http://technet.microsoft.com/en-us/library/ff358607.aspx
If you have found the solution to the above issues you have please let me know as well. I ahve about 4 sites, ia m experiencing the same issues.
Thanks
Ronald
------------------------------------
Metadata Column mapping and values missing in Publishing farm
Hi,
We have a Authoring farm and Publishing farm. There exist a custom list from which items are moved from Authoring farm to Publishing farm through content deployment. This custom list contains a column of Managed Metadata type. However, recently we found that, the mapping for this column was missing in Publishing farm.
We remapped the column in Publishing farm, added some items with value in this column in Authoring farm and moved these items to Publishing farm through Content Deployment. Now everything works fines, except for the items that existed before remapping was done, Some of these items do not show values in the Metadata column. We tried editing one such item in Authoring farm and then moving it to Publishing farm through Content Deployment. This item now shows value in the Custom Column. However, this is not a feasible solution, the number of such items being huge and also as the issue is occurring in Production environment.
Can anyone help us to know what could be the reason why this mapping was lost on Publishing farm, or steps that we need to take in order to ensure that this does not happen again? Also is there any other solution to above issue instead of editing, checking in and then moving all such items again to Publishing farm?
How to omplement google map locator webpart in sharepoint
Hey, I want to implement google map locator webpart in sharepoint and this webpart should not be based on lattitude and longitude. I have found many solution on this. But my requirement is to develop a webpart which will search on "My Places".
Means i want to provide a text box and it will take a string(place name) and which will point to the location directly.
Any suggestion on this ?
"The Only Way To Get Smarter Is By Playing A Smarter Opponent"
Reply:
Hi,
You can you google API on this link http://code.google.com/apis/maps/documentation/geocoding/ which help you in loacating the lattitude and longitude based on your input.
Thanks
------------------------------------
Reply:
Hey Ravi,
you can use Google Map V3 JavaScript API
http://code.google.com/apis/maps/documentation/javascript/reference.html#MapTypeControlOptions
http://code.google.com/apis/maps/documentation/javascript/examples/index.html
Ismail Al-Kiswani
Ismail Kiswani
------------------------------------
Windows updates + controls
Windows update arrange lots of updates nicely like a package. It's better than having all kinds of individual system parts looking for updates now and then. So maybe it is possible to include none microsoft products like fx. when you click control-panel -> admin -> Systemconfiguration | Services you see all those services that will launch at system startup and you can click Hide all Microsoft-services because other products are allowed calls on system startup also.
So maybe windows update could have a similar button to show other products. Because that would be a better user interface if seperate programs like graphics card drivers, thx truestudio, etc etc just with the press of one button together with windows update would look for updates ...
Reply:
------------------------------------
TCP loss under load?
Hi, i have a tower running windows server 2008, and it is a media/storage server.
When i am writing to the server, which has a 2TB external drive attached via USB, the server drops connection alltogeather. If i ping the server (ie ping 192.168.2.2) i receive a 100% success. When i am attempting to write to the shared storage, i get a 100% packet loss! and the transfer sticks on time remaining: Calculating.
This has never happened. I have replaced the switch but with very little experiance troubleshooting network failure im not sure where i can trace the packet loss or if its the server itself.
I have a NIC and a wireless card installed on the server, the NIC (192.168.2.2) and wifi (192.168.2.254) both loss connection. (unable to ping) until i cancel the file transfer, then the server, both addresses are reachable again!
Thanks!
Reply:
------------------------------------
Reply:
Hi deanfourie,
Thanks for posting here.
So will system responses properly if we write to the shared folder where stored on its local storage ?
Try to disable one of active NIC on this server ( wireless NIC maybe )and set it single homed , after that please try to see if we can still reproduce the phenomenon.
Expected Behavior of Multiple Adapters on Same Network
http://support.microsoft.com/kb/175767
Thanks.
Tiger Li
Tiger Li
TechNet Community Support
- Edited by Tiger LiMicrosoft employee Monday, March 5, 2012 8:27 AM
------------------------------------
Distrib.exe error
According to http://msdn.microsoft.com/en-us/library/ms147343.aspx I need to provide -PublisherLogin as one of my command line parameters when using SQL authentication. However, it get the following error:
Agent message code 20030. A syntax error occurred near parameter '-PublisherLogin'.
According to http://msdn.microsoft.com/en-us/library/ms147328.aspx there is no -PublisherLogin parameter ...
Any ideas on how to solve this?
Regards Des Norton
Reply:
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
------------------------------------
Reply:
I removed the Publisher Login and got another error:
SET Publisher=PPWAPPSRV01
SET Publication=VHS
SET PublicationDB=HBH_VHS
SET PublisherLogin=sa
SET Publisherpass=******
SET Subscriber=HBH\VHS
SET SubscriptionDB=VHS
"C:\Program Files\Microsoft SQL Server\100\COM\DISTRIB.EXE" -Publisher %Publisher% -PublisherDB %PublicationDB% -Publication %Publication% -Distributor %Publisher% -DistributorLogin %PublisherLogin% -Distributorpassword %Publisherpass% -DistributorSecurityMode 0 -Subscriber %Subscriber% -SubscriberDB %SubscriptionDB% -SubscriberSecurityMode 1 -SubscriptionType 1 -OutputVerboseLevel 2 >> InitVHS.log
2012-02-21 13:46:25.038 OLE DB Distributor 'PPWAPPSRV01': execute sp_server_info 18
2012-02-21 13:46:25.084 ANSI codepage: 1
OLE DB Distributor 'PPWAPPSRV01': select datasource, srvid from master..sysservers where upper(srvname) = upper(N'PPWAPPSRV01')
2012-02-21 13:46:25.194 OLE DB Distributor 'PPWAPPSRV01': select datasource, srvid from master..sysservers where upper(srvname) = upper(N'HBH\VHS')
2012-02-21 13:46:25.256 Agent message code 20053. Server 'HBH\VHS' is not registered at server 'PPWAPPSRV01'.
2012-02-21 13:46:25.365 ErrorId = 8, SourceTypeId = 2
ErrorCode = '20053'
ErrorText = 'Server 'HBH\VHS' is not registered at server 'PPWAPPSRV01'.'
2012-02-21 13:46:25.428 Adding alert to msdb..sysreplicationalerts: ErrorId = 8,
Transaction Seqno = , Command ID = -1
Message: Replication-Replication Distribution Subsystem: agent (null) failed. Server 'HBH\VHS' is not registered at server 'PPWAPPSRV01'.OLE DB Subscriber 'HBH\VHS': exec dbo.sp_MSupdatelastsyncinfo N'PPWAPPSRV01',N'HBH_VHS', N'VHS', 1, 6, N'Server ''HBH\VHS'' is not registered at server ''PPWAPPSRV01''.'
Regards Des Norton
------------------------------------
Reply:
You need to create an alias for this subscriber. Go to SQL Server Configuration Manager and create an alias to this subscriber. Expand the SQL Native Client Configuraton , right click on alias, for server enter HBH and for alias name enter HBH\VHS.
Then try again.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
------------------------------------
Reply:
Thanks Hilary
I created the alias on the subscriber machine, and get the following errors:
Protocol = TCP/IP ... PortNo = [blank]
- 2012-02-22 06:48:33.628 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 06:48:33.628 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 10061
Message: TCP Provider: No connection could be made because the target machine actively refused it.
Protocol = TCP/IP ... PortNo = 0
- 2012-02-22 06:51:00.440 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 06:51:00.440 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 87
Message: SQL Server Network Interfaces: Connection string is not valid [87].
Protocol = TCP/IP ... PortNo = 1433
- 2012-02-22 06:53:41.167 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 06:53:41.167 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 10061
Message: TCP Provider: No connection could be made because the target machine actively refused it.
Protocol = Named Pipes ... Pipe Name = \\HBH\pipe\sql\query
- 2012-02-22 07:01:01.181 Agent message code 20084. The process could not connect to Subscriber 'HBH\VHS'.
2012-02-22 07:01:01.181 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 2
Message: Named Pipes Provider: Could not open a connection to SQL Server [2].
My topology is as follows.
PUBLISHER/DISTRIBUTOR
Windows Server 2008 R2 Standard (x64) - Workgroup
SQL Server 2008 R2 Enterprise (x64) - Mixed Mode
Public facing with Static IP
SUBSCRIBER
SQL Server 2008 R2 Developer (x64) - Mixed Mode (Inst = HBH - Unable to uninstall)
SQL Server 2008 R2 Express (x64) - Mixed Mode (Inst = HBH\VHS)
Regards Des Norton
------------------------------------
Reply:
Regards Des Norton
------------------------------------
Mouse works in one VM but not the other - Keyboard does work
I'm trying to run a Hyper-V network on a Windows Server 2008 R2 Standard machine. I have two VMs running these respective OSs: Windows Server Core 2008 and Windows 7. The Windows Server Core is operating with no problems, but I cannot get the mouse to work inside the Windows 7 VM. The keyboard works fine [tab, space, arrow keys, enter, etc.], but I cannot get the mouse to work properly.
When I click on the Windows 7 desktop or a window, any open windows will disappear. When I click again the windows reappear.
Running Integration Services doesn't correct the problem.
Any troubleshooting step or recommendations would be appreciated.
- Changed type Vincent Hu Thursday, March 8, 2012 10:36 AM
Reply:
2. Please check the Event Viewer within the problematic Windows 7 virtual machine to see whether you can find any errors.
3. Please check the Event Viewer within the Hyper-V host machine to see whether you can find any Hyper-V related errors.
Vincent Hu
TechNet Community Support
------------------------------------
Multiple Playback Devices
Multiple or Dual Playback Devices - Seriously. You cannot use 2 playback devices simultaneously? That's nonsense. I LOVE Windows 7... except for this one reason. People NEED this feature of the old XP very badly. To tell you the truth, this is such a basic feature, I'm really surprised Microsoft missed it!!
Windows 7 Microsoft people, you need to fix this with the next update.
This is absolutely crucial to me because I use my computer for an HTPC (home theatre PC) & I'm a dj / producer also.
In order for me to switch between headphones or headset for talking and listening using Realtek AND HTPC output.... I have to restart my computer. ANNOYING. I don't need to switch at all, I need them both to play at the same time!
Lets just keep it simple here and say I wanted to play iTunes to three different devices at once (1 default playback device & 2 additional devices)
Using only 1 communication device. Windows 7 can't do that. This is BASIC stuff to audio noobs, but especially sound mixing professionals. Are we forced to go Linux? Mac? Really? I applaud Windows 7, it's really really great. This is my only problem with it, but it's a big one. Even if it was a maximum of TWO playback options with ONE communication device I would be ok with it. But ONE dedicated playback device is extremely limiting for this stage of technology. I mean come on guys.
PLEASE UPDATE WINDOWS 7 FOR MULTIPLE PLAYBACK DEVICES!!!
Does anyone know of a workaround for this?
- Edited by mrscottybizzer Wednesday, September 14, 2011 11:04 PM
- Changed type Miya Yao Friday, September 16, 2011 6:32 AM
Reply:
Hi mrscottybizzer,
I noticed you've already seen this thread: http://social.technet.microsoft.com/Forums/en-US/w7itpromedia/thread/d6644d1b-c660-437c-aa52-b73c2ee3900b
We've reported this and appreciate your patience.
Thanks for your understanding and cooperation!
Regards,
Miya
This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
------------------------------------
Reply:
While I think Win 7 should have a feature built in to control which application gets output on which audio device it doesn't. How ever it does allow it to be application controlled. Unfortunately the only application I can find that allows this is Win Media Player:
While in WMP press ALT -> Tools -> Options -> Devices -> Speaker -> Select Audio Device
This allows WMP to playback on and alternative device instead of Default Playback Device. So Music or Video can be on another sound device while you game or watch YouTube on default.
I found that DivX Player could be trick by setting Default Playback to Device you want to here the sound on and after DivX is up and running change Default to another Device for all other sound. Doesn't work for iTunes and most other applications.
------------------------------------
Server 2008R2 stops authenticating to domain, cannot browse, Cannot map, Can ping by hostname, Reboot fixes it for a day
Hello, I have a real annoying problem with a VMWare Virtual 2008R2 server that really needs to go into production.
After anywhere from an hour to a day the server seems to lose SMB completely, it cannot browse the network or the internet, It can ping by hostname, I can VNC to it (RDP fails to authenticate), existing mapped drives say "An error occurred while reconnecting: Microsoft Windows Network:The local device name is already in use (which is not the case) There are other network services which continue to function, the big issue is it's inability to talk to the domain (group policy obviously fails also).
Application & System logs show nothing of any use
Security logs show event 4656 twice every 2 seconds. I have disabled RSS Scaling & Chimnet offload to no avail.
I have replaced the virtual NIC, removed & rejoined the domain, ran all windows updates. Still nothing.
I just ran the "Microsoft Products Support Reports" tool while the problem is occurring, where do I upload the output for somebody smarter than me to look at? I've been doing this stuff for 15 years, never have I seen this problem and I am baffled.
I hate computers, That's why I'm in I.T.
Edit: The "RPC Dump Utility has stopped working" error message while the MS Diag tool is running, this is not going to help me...
- Edited by Timothy Cox Friday, March 2, 2012 1:51 PM New Info
- Moved by Tiger LiMicrosoft employee Monday, March 5, 2012 6:59 AM (From:Network Infrastructure Servers)
- Changed type Tiger LiMicrosoft employee Wednesday, March 7, 2012 2:20 AM
Reply:
Tried disabling the antivirus and the Windows Firewall?
Was this machine created from a cloned, non-Sysprep image?
.
Is the time service on the VMWare host disabled? It must be disabled. The following is about DCs, but it applies to any guest machine in a VM host.
Virtualizing Domain Controllers and the Windows Time Service
http://msmvps.com/blogs/acefekay/archive/2011/08/23/virtualizing-domain-controllers-and-the-windows-time-service.aspx
.
Kerberos has a 5 minute skew tolerance. Check the time to see if it matches the DC that logged it on (echo %logonserver%). If it's they're skewed more than 5 minutes, it will cause numerous problems.
.
I would suggest re-enabling RSS.
.
Ace Fekay
MVP, MCT, MCITP Enterprise Administrator, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php
This posting is provided AS-IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
Hi,
Thanks for posting here.
Is this VM domain controller or just a member host? is it multihomed ? have we recently modified any settings on this VM ?
Please try to restart netlogon service and see if it will go to normal:
Net stop NetLogon
Net start Netlogon
Things to consider when you host Active Directory domain controllers in virtual hosting environments
http://support.microsoft.com/kb/888794
Thanks.
Tiger Li
Tiger Li
TechNet Community Support
------------------------------------
Autogrow of file 'SharePoint_Config_log' in database 'SharePoint_Config' took 91047 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
Autogrow of file 'SharePoint_Config_log' in database 'SharePoint_Config' took 91047 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
sql server 2005 64 bit sp1
How to fix the problem
- Changed type supportsib Saturday, March 3, 2012 11:51 AM
Reply:
Hi, the message is informational and advising that the 'SharePoint_Config_log' log file took 91 seconds to grow.
The reason the message is raised, is that while the log file is growing, no modifications e.g. deletes, updates or inserts can be made in the database.
You have a couple of options
1. as per the message you could review the current autogrowth of the 'SharePoint_Config' log file (look at database properties, files page) and set the autogrowth to a smaller number. and/or
2. review the initial size of the log file and set to be larger, (max size it gets to) so that it doesn't grow as often and typically grows only when the SQL Server starts. and/or
3. If the database 'SharePoint_Config' is using the Full or Bulk-logged recovery model, look at reducing the transaction log backup interval and this may help keep the log file growths down.
------------------------------------
Reply:
Thanks
I did a transcation log backup , but it seems the log is not truncating after the backup
------------------------------------
Reply:
To be clear, when you perform a transaction log backup it allows committed transactions in the log file to be overwritten. It doesn't shrink the log file, but does allow transactions to use the current uncommitted space in the log file after the log backup. The more often you perform log backups, the more often there is free space in the log file and this helps minimises log growth.
You can check how much space is free in the log file by using DBCC SQLPERF(LOGSPACE)
You can shrink the log file using http://support.microsoft.com/kb/907511
------------------------------------
Reply:
Autogrowth is a option which sets the increment level for the files to grow. Shrinking the database is not the solution here. You should revisit the sizing and check if the current disk and database properties such as max size , and autoincrement are sufficient to meet to the additional number of transactions being performed on your database.
If you shrink the database you will simply increase fragmentation and the database will still throw the same error when a large number of transactions are being performed and it needs to grow again. Check fill factors on tables as well as perform bulk operations by switching the recovery model to reduce the impact of such operations.------------------------------------
Corrupt Windows Server 2008 R2 Standard, Enterprise, Datacenter, and Web with Service Pack 1 Debug/Checked Build (x64) - DVD ?
I recently downloaded above iso from MSND website.
<label class="detailtitle">File Name: </label><label id="filenameLabel">en_windows_server_2008_r2_standard_enterprise_datacenter_and_web_with_sp1_debug_checked_build_x64_dvd_619600.iso</label>
<label class="detailtitle">Languages: </label><label id="languagesLabel">English</label>
<label class="detailtitle">SHA1: </label><label id="sha1Label">B525BA6B34C7F3701907AE7FAE70D244B5591B70</label>
<label class="detailtitle"></label>
I installed it inside a VM on Hyper-V but I'm getting Ie8 carsh error due to mshtml.dll library.
The program iexplore.exe version 8.0.7601.17514 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
Process ID: 484
Start Time: 01ccf75fb32b5bbe
Termination Time: 31
Application Path: C:\Program Files (x86)\Internet Explorer\iexplore.exe
I'm also getting other weird errors. Looks like ISO is corrupted (based on some responses on web) but I could be wrong here. Any suggestion to resolve this?
- Changed type Niki Han Friday, March 9, 2012 8:23 AM
Reply:
Hi,
Please understand here is Windows 7 forum. I notice the issue is related to Windows Server 2008 R2, to get better assistances, I suggest posting in Server Forum.
http://social.technet.microsoft.com/Forums/en-US/category/windowsserver
Niki Han
TechNet Community Support
------------------------------------
Open provisioninng stantard like SPML
Hi,
Is FIM 2010 support Open provisioninng stantard like SPML if yes please prvide valid link.
Thanks
khalid
- Moved by Brent Serbus Wednesday, February 29, 2012 11:48 PM fim q (From:Forums Issues (not product support))
- Changed type Markus VilcinskasMicrosoft employee Sunday, March 17, 2013 8:31 AM
Reply:
------------------------------------
Reply:
I don't think it can do it directly, as my understanding of SPML implementations is that they are done as a push, but FIM works via a pull from the data source. I'm not that familiar with ECMA 2.0, but I don't believe that fundamental behavior has changed. If you are talking file format processing, FIM does do DMSL 2.0 but that's as close as it would get and that's not necessarily what you've got in SPML.
What we've done with ILM (and likely FIM when we are able to upgrade) is the SPML from the ERP vendor's system is sent to a custom web service which writes the data into an AD/LDS instance that the sync engine reads from. It may sound sort of Rube Goldberg-ish but it's worked well for us in the production environment for nearly two years. It lets the ERP system remain transactional and send updates as it has them, and the sync engine can run in its scheduled way and we don't have to do any special effort to calculate deltas.
Chris
------------------------------------
Reply:
Is it a general question regarding capabilities of FIM 2010 or do you have a need to integrate with systems talking SPML?
Because from my point of view, you should not invest in SPML direction if you don't have to.
Check the new SCIM protocol who is promising as Google, SalesForce, Cisco (Webex), Sailpoint, PingIdentity, Courrion, UnbundID, (and us) are all looking at this direction and implementing SCIM.
Just my point of view...
Cordialement,
Emmanuel Dreux
http://www.bcpsoft.fr
Formation FIM 2010
------------------------------------
Reply:
Thanks for reply.
Regards
khalid
------------------------------------
get error for my store procedure
Hi, I got the error message says that "
Msg 245, Level 16, State 1, Line 127
Conversion failed when converting the varchar value 'Systemation' to data type int.
I attached the codeUSE [dbMarketing] GO /****** Object: StoredProcedure [ui].[spNationalTESReportVerbatimsFacilitator] Script Date: 03/02/2012 09:55:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --This is the main details for the SP for the NPS report /*Name: spNPSReportSummaryDetails Description: SP for the AD listing on the NPS Summary Report Author: Mark Poirot Description Date Changed By ALTERd procedure 2/7/2009 Mark Poirot */ /* Exec [ui].[spNPSReportSummaryDetails] @CommaDelimitedString = 'New Psychology of Selling-NPOS', @CourseStartParameter= '1/1/2009', @CourseEndParameter = '4/1/2009' *//* ALTER PROCEDURE [ui].[spNationalTESReportVerbatimsFacilitator] --DECLARE @CourseNameParameter VARCHAR(200) @CommaDelimitedString VARCHAR (max), @CourseStartParameter SMALLDATETIME, @CourseEndParameter SMALLDATETIME, @StartValueScore TinyInt, @EndValueScore TinyInt, @SupervisorLevelParameter VarChar(Max), @NTIDArea Varchar(20) AS SET NOCOUNT ON */ DECLARE @CommaDelimitedString VARCHAR (max) DECLARE @CourseStartParameter SMALLDATETIME DECLARE @CourseEndParameter SMALLDATETIME Declare @StartValueScore TinyInt declare @EndValueScore TinyInt declare @SupervisorLevelParameter VarChar(Max) DECLARE @NTIDArea Varchar (20) DECLARE @NationalTESEmployeeCourseVarSUP TABLE (SurveyFacilitatorName INT, SurveyLocationName VARCHAR(200)) DECLARE @NationalTESEmployeeCourseVarCalc TABLE (CalcFacilitator varchar (20), CalcCourseDate SMALLDATETIME, CalcCourseName VARCHAR(200), CalcCommentScore VARCHAR(10), CalcLocationName VARCHAR(200), CalcManagementScore Varchar(10), CalcPresentationScore Varchar(10), CalcEngagementScore Varchar(10), CalcExplanationScore Varchar(10), CalcJobSkillsScore Varchar(10), CalcImprovementScore Varchar(4000), CalcLearningObjectives Varchar(10),/* CalcLogicallyOrganized Varchar(10),*/ CalcLearningEffectiveness Varchar(10), CalcTimeToLearn Varchar(10), CalcJobEffectiveness Varchar(10), CalcIncreasedSuccess Varchar(10) ) SET @CommaDelimitedString = 'Fraud Awareness: Classroom Training' SET @CourseStartParameter = '2/1/2012' SET @CourseEndParameter = '2/24/2012' SET @StartValueScore = '1' SET @EndValueScore = '5' SET @SupervisorLevelParameter = '110975' SET @NTIDArea = 'foxga' Declare @AreaFilter Varchar(20) set @AreaFilter = (select AreaID from dbEmployee.Summary.tblEmployeeSnapshot WITH (NOLOCK) where networkID = @NTIDArea) DECLARE @FacilitatorEmpID INT SET @FacilitatorEmpId = (Select EmployeeID from dbEmployee.Summary.tblEmployeeSnapshot where NetworkID = @NTIDArea) /* Test Section for the comma delimited string */ DECLARE @CharCount INT DECLARE @CommaDelimitedResults TABLE (CommaDelimitedString VARCHAR (max)) --SET @CommaDelimitedString = 'Blackberry Storm,Foundations for Business' -- Add a comma to the end if it is not there already: IF (SELECT SUBSTRING (@CommaDelimitedString, LEN (@CommaDelimitedString), 1)) <> ',' BEGIN SET @CommaDelimitedString = @CommaDelimitedString + ',' END -- ALTER a table to hold results after the data is parsed: -- Loop and parse the comma delimited string(s): WHILE (SELECT LEN (@CommaDelimitedString)) >= 1 BEGIN SET @CharCount = CHARINDEX (',', @CommaDelimitedString, 1) INSERT INTO @CommaDelimitedResults SELECT REPLACE (SUBSTRING (@CommaDelimitedString, 1, @CharCount), ',', '') SET @CommaDelimitedString = SUBSTRING (@CommaDelimitedString, @CharCount + 1, 50000) END --SELECT * FROM @CommaDelimitedResults ---------------------------------------------------------------------------------------------------------- /* Test Section for the comma delimited string of Supervisor Ids*/ DECLARE @CharCountIDs INT DECLARE @CommaDelimitedResultsIDs TABLE (SupervisorID VARCHAR (max)) --SET @CommaDelimitedString = 'Blackberry Storm,Foundations for Business' -- Add a comma to the end if it is not there already: IF (SELECT SUBSTRING (@SupervisorLevelParameter, LEN (@SupervisorLevelParameter), 1)) <> ',' BEGIN SET @SupervisorLevelParameter = @SupervisorLevelParameter + ',' END -- ALTER a table to hold results after the data is parsed: -- Loop and parse the comma delimited string(s): WHILE (SELECT LEN (@SupervisorLevelParameter)) >= 1 BEGIN SET @CharCountIDs = CHARINDEX (',', @SupervisorLevelParameter, 1) INSERT INTO @CommaDelimitedResultsIDs SELECT REPLACE (SUBSTRING (@SupervisorLevelParameter, 1, @CharCountIDs), ',', '') SET @SupervisorLevelParameter = SUBSTRING (@SupervisorLevelParameter, @CharCountIDs + 1, 30000) END --SELECT * FROM @CommaDelimitedResultsIDs /* This is the code that will determine the distinct facilitator that has taught class X, this will determine the comparison for the rest of the information*/ INSERT INTO @NationalTESEmployeeCourseVarSUP (SurveyFacilitatorName, SurveyLocationName) (SELECT DISTINCT Facilitator1, LocationName FROM Detail.tblNationalTESSurvey as A, @CommaDelimitedResults as B WHERE (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION (SELECT DISTINCT Facilitator2, LocationName FROM Detail.tblNationalTESSurvey as A, @CommaDelimitedResults as B WHERE (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION (SELECT DISTINCT Facilitator3, LocationName FROM Detail.tblNationalTESSurvey as A, @CommaDelimitedResults as B WHERE (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) --select * from @NationalTESEmployeeCourseVarSUP /* This is the code that will determine the facilitator score for course X and just for the specific instance, this will determine the comparison for the rest of the information*/ INSERT INTO @NationalTESEmployeeCourseVarCalc (CalcFacilitator, CalcCourseDate, CalcCourseName, CalcLocationName, CalcManagementScore, CalcPresentationScore, CalcEngagementScore, CalcExplanationScore, CalcJobSkillsScore, CalcImprovementScore, CalcLearningObjectives,/* CalcLogicallyOrganized,*/ CalcLearningEffectiveness, CalcTimeToLearn, CalcJobEffectiveness, CalcIncreasedSuccess) (SELECT Facilitator1, CourseDate, CourseName, LocationName, FirstFacilitatorManagement, FirstFacilitatorPresentation, FirstFacilitatorEngagement, FirstFacilitatorExplanation, FirstFacilitatorJobSkills, FirstFacilitatorImprovement, CourseLearningObjectives,/* LogicallyOrganized,*/ LearningEffectiveness, TimeToLearn, JobEffectiveness, IncreasedSuccess FROM Detail.tblNationalTESSurvey as A inner Join @CommaDelimitedResults as B ON /*WHERE*/ (a.CourseName = b.CommaDelimitedString) AND (a.CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION all (SELECT Facilitator2, CourseDate, CourseName, LocationName, SecondFacilitatorManagement, SecondFacilitatorPresentation, SecondFacilitatorEngagement, SecondFacilitatorExplanation, SecondFacilitatorJobSkills, SecondFacilitatorImprovement, CourseLearningObjectives,/* LogicallyOrganized,*/ LearningEffectiveness, TimeToLearn, JobEffectiveness, IncreasedSuccess FROM Detail.tblNationalTESSurvey as A inner Join @CommaDelimitedResults as B ON /*WHERE*/ (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION all (SELECT Facilitator3, CourseDate, CourseName, LocationName, ThirdFacilitatorManagement, ThirdFacilitatorPresentation, ThirdFacilitatorEngagement, ThirdFacilitatorExplanation, ThirdFacilitatorJobSkills, ThirdFacilitatorImprovement, CourseLearningObjectives,/* LogicallyOrganized,*/ LearningEffectiveness, TimeToLearn, JobEffectiveness, IncreasedSuccess FROM Detail.tblNationalTESSurvey as A inner Join @CommaDelimitedResults as B ON /*WHERE*/ (a.CourseName = b.CommaDelimitedString) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) --Select * from @NationalTESEmployeeCourseVarCalc /* This is the block of code that determines the heirarchy of the dataset by AD/Sup/Fac */ Declare @BaseCalcTable table ( BaseCalcDirector VARCHAR(300), BaseCalcFacilitator VARCHAR(300), BaseCalcFacilitatorID VARCHAR(20), BaseCalcDirectorID VARCHAR(20), BaseCalcADName VARCHAR(300), BaseCalcADID VARCHAR(20), BaseCalcManagerID VARCHAR(20), BaseCalcManagerName VARCHAR(300), BaseCalcSupID VARCHAR(20), BaseCalcSupName VARCHAR(300), BaseCalcCourseName VARCHAR(300), BaseCalcCourseDate SMALLDATETIME, BaseCalcLocationName VARCHAR(300), BaseCalcCourseLearningObjectives Varchar(10), --BaseCalcCourseLogicallyOrganized varchar (10), BaseCalcCourseLearningEffectiveness varchar (10), BaseCalcCourseTimeToLearn varchar(10), BaseCalcCourseJobEffectiveness varchar (10), BaseCalcCourseIncreasedSuccess Varchar (10), BaseCalcFacilitatorManagementScore Varchar(10), BaseCalcFacilitatorScoreCount Varchar(10), BaseCalcFacilitatorPresentationScore Varchar(10), BaseCalcFacilitatorEngagementScore Varchar(10), BaseCalcFacilitatorExplanationScore Varchar(10), BaseCalcFacilitatorJobSkillsScore Varchar(10), BaseCalcFacilitatorImprovementScore Varchar(4000) ) Insert into @BaseCalcTable( BaseCalcDirector, BaseCalcFacilitator, BaseCalcFacilitatorID, BaseCalcDirectorID, BaseCalcADName, BaseCalcADID, BaseCalcManagerID, BaseCalcManagerName, BaseCalcSupID, BaseCalcSupName, BaseCalcCourseName, BaseCalcCourseDate, BaseCalcLocationName, BaseCalcCourseLearningObjectives, --BaseCalcCourseLogicallyOrganized, BaseCalcCourseLearningEffectiveness, BaseCalcCourseTimeToLearn, BaseCalcCourseJobEffectiveness, BaseCalcCourseIncreasedSuccess, BaseCalcFacilitatorManagementScore, BaseCalcFacilitatorScoreCount, BaseCalcFacilitatorPresentationScore, BaseCalcFacilitatorEngagementScore, BaseCalcFacilitatorExplanationScore, BaseCalcFacilitatorJobSkillsScore, BaseCalcFacilitatorImprovementScore ) SELECT Level24Name, dbo.udfEmployeeIDtoEmployeeName(SurveyFacilitatorName) AS FacilitatorName, SurveyFacilitatorName, Level24ID, Level20Name, Level20ID, Level16ID, Level16Name, Level04ID, Level04Name, CalcCourseName, CalcCourseDate, CalcLocationName, CalcLearningObjectives, --CalcLogicallyOrganized, CalcLearningEffectiveness, CalcTimeToLearn, CalcJobEffectiveness, CalcIncreasedSuccess, ------------------------------------------------------------------------------------------------------------- --New Questions ------------------------------------------------------------------------------------------------------------- CalcManagementScore, Case When CalcManagementScore != 0 Then 1 Else 0 End as FacCount, CalcPresentationScore, CalcEngagementScore, CalcExplanationScore, CalcJobSkillsScore, CalcImprovementScore FROM @NationalTESEmployeeCourseVarSUP AS a inner join (Select Employeeid, Level24ID, Level24Name, Level20Name, Level20ID, Level16ID, Level16Name, Level04ID, Level04Name, AreaID from dbEmployee.Summary.tblEmployeeSnapshot WITH (NOLOCK), @CommaDelimitedResultsIDs as d Where ((Level24ID = d.supervisorID) Or (Level20ID = d.supervisorID) OR (Level16ID = d.supervisorID) Or (Level04ID = d.supervisorID)) Group by Employeeid, Level24ID,Level24Name ,Level20Name,Level20ID, Level16ID,Level16Name,Level04ID,Level04Name,AreaID) as b on a.SurveyFacilitatorName = b.EmployeeID inner join @NationalTESEmployeeCourseVarCalc as c on a.SurveyFacilitatorName = c.CalcFacilitator Where c.CalcLocationName = a.SurveyLocationName And b.AreaID = @AreaFilter --select @AreaFilter --select * from @BaseCalcTable Declare @AveTable table ( AveCalcDirector VARCHAR(300), AveCalcFacilitator VARCHAR(300), AveCalcFacilitatorID VARCHAR(20), AveCalcDirectorID VARCHAR(20), AveCalcADName VARCHAR(300), AveCalcADID VARCHAR(20), AveCalcManagerID VARCHAR(20), AveCalcManagerName VARCHAR(300), AveCalcSupID VARCHAR(20), AveCalcSupName VARCHAR(300), AveCalcCourseName VARCHAR(300), AveCalcCourseDate SMALLDATETIME, AveCalcLocationName VARCHAR(300), OverallAveScore int, OverallAveCourseScore int, AveCalcCourseLearningObjectives Varchar(10), --AveCalcCourseLogicallyOrganized Varchar(10), AveCalcCourseLearningEffectiveness Varchar(10), AveCalcCourseTimeToLearn Varchar(10), AveCalcCourseJobEffectiveness Varchar(10), AveCalcCourseIncreasedSuccess Varchar(10), AveCalcFacilitatorManagementScore Varchar(10), AveFacilitatorScoreCount Varchar(10), AveCalcFacilitatorPresentationScore Varchar(10), AveCalcFacilitatorEngagementScore Varchar(10), AveCalcFacilitatorExplanationScore Varchar(10), AveCalcFacilitatorJobSkillsScore Varchar(10), AveCalcFacilitatorImprovementScore Varchar(4000) ) Insert into @AveTable ( AveCalcDirector, AveCalcFacilitator, AveCalcFacilitatorID, AveCalcDirectorID, AveCalcADName, AveCalcADID, AveCalcManagerID, AveCalcManagerName, AveCalcSupID, AveCalcSupName, AveCalcCourseName, AveCalcCourseDate, AveCalcLocationName, OverallAveScore, OverallAveCourseScore, AveCalcCourseLearningObjectives, --AveCalcCourseLogicallyOrganized, AveCalcCourseLearningEffectiveness, AveCalcCourseTimeToLearn, AveCalcCourseJobEffectiveness, AveCalcCourseIncreasedSuccess, AveCalcFacilitatorManagementScore, AveFacilitatorScoreCount, AveCalcFacilitatorPresentationScore, AveCalcFacilitatorEngagementScore, AveCalcFacilitatorExplanationScore, AveCalcFacilitatorJobSkillsScore, AveCalcFacilitatorImprovementScore ) select BaseCalcDirector, BaseCalcFacilitator, BaseCalcFacilitatorID, BaseCalcDirectorID, BaseCalcADName, BaseCalcADID, BaseCalcManagerID, BaseCalcManagerName, BaseCalcSupID, BaseCalcSupName, BaseCalcCourseName, BaseCalcCourseDate, BaseCalcLocationName, (cast(BaseCalcFacilitatorManagementScore as int) + cast(BaseCalcFacilitatorPresentationScore as int) + cast(BaseCalcFacilitatorEngagementScore as int) + cast(BaseCalcFacilitatorExplanationScore as int) + cast(BaseCalcFacilitatorJobSkillsScore as int)) / 5 as AveScore, (/*cast(BaseCalcCourseLogicallyOrganized as int) + */cast(BaseCalcCourseLearningObjectives as int) + cast(BaseCalcCourseLearningEffectiveness as int) + cast(BaseCalcCourseTimeToLearn as int) + cast(BaseCalcCourseJobEffectiveness as int) + cast(BaseCalcCourseIncreasedSuccess as int)) / 6 as AveCourseScore, BaseCalcCourseLearningObjectives, --BaseCalcCourseLogicallyOrganized, BaseCalcCourseLearningEffectiveness, BaseCalcCourseTimeToLearn, BaseCalcCourseJobEffectiveness, BaseCalcCourseIncreasedSuccess, BaseCalcFacilitatorManagementScore, BaseCalcFacilitatorScoreCount, BaseCalcFacilitatorPresentationScore, BaseCalcFacilitatorEngagementScore, BaseCalcFacilitatorExplanationScore, BaseCalcFacilitatorJobSkillsScore, BaseCalcFacilitatorImprovementScore from @BaseCalcTable --select * from @BaseCalcTable select * from @AveTable where OverallAveScore between @StartValueScore and @EndValueScore /* select AveCalcDirector, AveCalcFacilitator, AveCalcFacilitatorID, AveCalcDirectorID, AveCalcADName, AveCalcADID, AveCalcManagerID, AveCalcManagerName, AveCalcSupID, AveCalcSupName, AveCalcCourseName, AveCalcCourseDate, AveCalcFacilitatorScore, AveCalcLocationName, OverallAveScore, case when OverallAveScore <= 6 Then 1 Else 0 End as OverallDetractor, case when OverallAveScore > 6 and OverallAveScore <= 8 Then 1 Else 0 End as OverallPassive, case when OverallAveScore > 8 Then 1 Else 0 End as OverallPromoter, AveCalcCourseScore, case when OverallAveCourseScore <= 6 Then 1 Else 0 End as OverallCourseDetractor, case when OverallAveCourseScore > 6 and OverallAveCourseScore <= 8 Then 1 Else 0 End as OverallCoursePassive, case when OverallAveCourseScore > 8 Then 1 Else 0 End as OverallCoursePromoter, AveCalcCourseLearningObjectives, AveCalcFacilitatorManagementScore, AveCalcFacilitatorBalanceScore, AveCalcFacilitatorPracticeScore, AveCalcFacilitatorApplicationScore from @AveTable ----------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------*/ --select * from @NEATNPSEmployeeCourseVarSUP --select * from @NEATNPSEmployeeCourseVarCalc --WHERE --(a.SurveyFacilitatorName = (b.EmployeeID)) AND (c.CalcFacilitator = (b.EmployeeID)) AND (a.SurveyFacilitatorName = (c.CalcFacilitator)) --ORDER BY SurveyFacilitatorName --Attempts at getting the count for the faciltators, passives, and detractors /* SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '0' AND '6') SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '7' AND '8') SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc as a, detail.tblSurvey as b WHERE (a.CalcCourseName=b.CourseName) AND (CalcCourseDate = b.CourseDate) AND (CalcFacilitator = b.Facilitator1) AND (CalcFacilitatorScore BETWEEN '0' AND '6') /*SELECT DISTINCT Level16ID, Level16Name FROM @NEATNPSEmployeeCourseVarSUP AS a, dbEmployee.Summary.tblEmployeeSnapshot AS b WITH (NOLOCK) WHERE (a.SurveyFacilitatorName = (b.EmployeeID)) AND (b.Level20ID = ('199394'))*/ */ --Select * from #NEATNPSEmployeeCourseVar --Select * --from detail.tblsurvey --where coursename='test 3' /* @CourseNameParameter VARCHAR(200), @CourseStartParameter SMALLDATETIME, @CourseEndParameter SMALLDATETIME AS DECLARE @NEATNPSEmployeeCourseVarSUP TABLE (SurveyFacilitatorName INT, SurveyFacilitatorCourseName VARCHAR(200), SurveyFacilitatorCourseDate SMALLDATETIME, SurveyFacilitatorLocationName VARCHAR(200)) DECLARE @NEATNPSEmployeeCourseVarCalc TABLE (CalcFacilitator INT, CalcCourseDate SMALLDATETIME, CalcCourseName VARCHAR(200), CalcFacilitatorScore INT, CalcCommentScore INT) /* This is the code that will determine the distinct facilitator that has taught class X, this will determine the comparison for the rest of the information*/ INSERT INTO @NEATNPSEmployeeCourseVarSUP (SurveyFacilitatorName, SurveyFacilitatorCourseName, SurveyFacilitatorCourseDate, SurveyFacilitatorLocationName) (SELECT DISTINCT Facilitator1, CourseName, CourseDate, LocationName FROM Detail.tblSurvey WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION (SELECT DISTINCT Facilitator2, CourseName, CourseDate, LocationName FROM Detail.tblSurvey WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION (SELECT DISTINCT Facilitator3, CourseName, CourseDate, LocationName FROM Detail.tblSurvey WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) /* This is the code that will determine the facilitator score for course X and just for the specific instance, this will determine the comparison for the rest of the information*/ INSERT INTO @NEATNPSEmployeeCourseVarCalc (CalcFacilitator, CalcCourseDate, CalcCourseName, CalcFacilitatorScore, CalcCommentScore) (SELECT Facilitator1, CourseDate, CourseName, FirstFacilitatorScore, ContentScore FROM Detail.tblSurvey WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION ALL (SELECT Facilitator2, CourseDate, CourseName, SecondFacilitatorScore, ContentScore FROM Detail.tblSurvey WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) UNION ALL (SELECT Facilitator3, CourseDate, CourseName, ThirdFacilitatorScore, ContentScore FROM Detail.tblSurvey WHERE (CourseName IN (@CourseNameParameter)) AND (CourseDate BETWEEN @CourseStartParameter AND @CourseEndParameter)) --Select * from #NEATNPSEmployeeCourseVar /* This is the total query block that will determine the overall dataset*/ /*SELECT DISTINCT SurveyFacilitatorName, CourseName, CourseDate, ContentComment, (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorCount, (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '9' AND '10') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS PromoterCount, JobEffectivenessComment, --(select count() from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorFacilitatorCount, --(select count(ContentScore) from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS PromoterFacilitatorCount, DeliveryMethodPreferred, AdditionalComments FROM @NEATNPSEmployeeCourseVarSUP AS a, detail.tblSurvey as b WHERE (((a.SurveyFacilitatorName = b.Facilitator1) OR (a.SurveyFacilitatorName = b.Facilitator2) OR (a.SurveyFacilitatorName = b.Facilitator3)) AND ((b.CourseName = 'test 2') AND (b.CourseDate = '1/19/2009'/*BETWEEN '1/1/2009' AND '3/1/2009'*/)))*/ /* This is the block of code that determines the heirarchy of the dataset by AD/Sup/Fac */ SELECT DISTINCT Level36Name, dbo.udfEmployeeIDtoEmployeeName(SurveyFacilitatorName) AS FacilitatorName, SurveyFacilitatorName, Level24ID, Level20Name, Level20ID, Level16ID, Level16Name, Level04ID, Level04Name, SurveyFacilitatorCourseName, SurveyFacilitatorCourseDate, SurveyFacilitatorLocationName, CalcFacilitatorScore, Case When CalcFacilitatorScore <= 6 Then 1 Else 0 End as FacilitatorDetractor, Case When CalcFacilitatorScore >6 and CalcFacilitatorScore <=8 Then 1 Else 0 End as FacilitatorPassive, Case When CalcFacilitatorScore >8 Then 1 Else 0 End as FacilitatorPromoter, CalcCommentScore, Case When CalcCommentScore <= 6 Then 1 Else 0 End as CourseDetractor, Case When CalcCommentScore >6 and CalcCommentScore <=8 Then 1 Else 0 End as CoursePassive, Case When CalcCommentScore >8 Then 1 Else 0 End as CoursePromoter -- (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorCount, -- (select count(ContentScore) from detail.tblSurvey where ((ContentScore Between '9' AND '10') AND (coursename = 'test 2') AND CourseDate between '1/1/2009' and '2/3/2009')) AS PromoterCount --(select count(CalcFacilitatorScore) from @NEATNPSEmployeeCourseVarCalc AS where (ContentScore Between '0' AND '6') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS DetractorCount, -- (select count(ContentScore) from detail.tblSurvey where (ContentScore Between '9' AND '10') AND (coursename = 'test 2' AND CourseDate = '1/19/2009')) AS PromoterCount FROM @NEATNPSEmployeeCourseVarSUP AS a, dbEmployee.Summary.tblEmployeeSnapshot AS b WITH (NOLOCK), @NEATNPSEmployeeCourseVarCalc as c WHERE ((a.SurveyFacilitatorName = (b.EmployeeID)) AND (c.CalcFacilitator = (b.EmployeeID)) AND (a.SurveyFacilitatorCourseDate = c.CalcCourseDate)) --Attempts at getting the count for the faciltators, passives, and detractors /* SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '0' AND '6') SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc WHERE (CalcCourseName='test 3') AND (CalcCourseDate = '1/27/2009') AND (CalcFacilitator = '309296') AND(CalcFacilitatorScore BETWEEN '7' AND '8') SELECT COUNT(CalcFacilitatorScore) FROM @NEATNPSEmployeeCourseVarCalc as a, detail.tblSurvey as b WHERE (a.CalcCourseName=b.CourseName) AND (CalcCourseDate = b.CourseDate) AND (CalcFacilitator = b.Facilitator1) AND (CalcFacilitatorScore BETWEEN '0' AND '6') /*SELECT DISTINCT Level16ID, Level16Name FROM @NEATNPSEmployeeCourseVarSUP AS a, dbEmployee.Summary.tblEmployeeSnapshot AS b WITH (NOLOCK) WHERE (a.SurveyFacilitatorName = (b.EmployeeID)) AND (b.Level20ID = ('199394'))*/ */ --Select * from #NEATNPSEmployeeCourseVar --Select * --from detail.tblsurvey --where coursename='test 3' */ "
Reply:
I presume you are getting this error when you are passing parameters from a report to this stored procedure...
Check the data types of the parameters you have for the report to be matching correctly with the mapped parameters of the dataset.
------------------------------------
No comments:
Post a Comment