Tuesday, March 29, 2022

This forum has migrated successfully on December 10, 2008

This forum has migrated successfully on December 10, 2008

As  part of the migration, posting of new threads and messages is no longer allowed on the Forums 2.x platform. 

For reporting bugs on the Forums 3.x Platform, visit:  http://social.msdn.microsoft.com/Forums/en-US/reportabug/threads/

For making suggestions on the Forums 3.x Platform,  visit:  http://social.msdn.microsoft.com/Forums/en-US/suggest/threads/

Thank you for your patience during the migration.


Alicia


Reply:
Maybe it would been nice to know WHEN migration is done?

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

SSIS connection errors from local machine

Hi

I had a SQL server SQL 2005 SP2 running  and added SSIS after the install, the install went fine but I cant connect from the local machine the error is  connect to ssis service failed:error loading type library/DLL.

The strange thing is can connect from Remote computer fine. Then registered the DTS.dll file and could now connect but when opening the folders get more errors lomng ones which signifies something else missing

Any help?

AP
  • Changed type Tony Tang_YJ Thursday, December 18, 2008 7:54 AM no response

Reply:
Can you post the error message that you are now getting? Also do you have the default instance or named instance of sql server installed?

 


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

As this thread has been quiet for a while we will be changing the issue type to 'General Discussion'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

Yao Jie Tang -Microsoft Online Community

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

deadlock issue with DTS 2000 package

 

hi,

i have one dts 2000 package which get called through ssis package(sql server 2005).i am scheduling this package using sql server agent.while running this package i m getting error of deadlock. something resource which using is in use with another resouce.when i run this package manually,it runs fine.

 

can anyone help me on this?

 

 

thanx,

Chetan S. Raut.

  • Changed type Tony Tang_YJ Thursday, December 18, 2008 7:33 AM no response

Reply:
Well, are there any other tasks in the SSIS package besides the DTS task?  What table is the deadlock on and might the SSIS package be touching that table as well?

What does the DTS package do?

We need more information.

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

As this thread has been quiet for a while we will be changing the issue type to 'General Discussion'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

Yao Jie Tang -Microsoft Online Community

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

SQLExtendedFetch failed

 

Hello I am facing " SQLExtendedFetch failed " error while trying to retrieving data using JD Edward.

Please help me understand what the error exactly and what are possible causes for the error is.

 

 

  • Changed type Tony Tang_YJ Thursday, December 18, 2008 7:30 AM no response

Reply:
Looks like there might be some kind of error on some row coming through the connection.  I'm assuming you're using ODBC?  Can you access the data using another tool, other than SSIS, and using the same ODBC connection?

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

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

Yao Jie Tang -Microsoft Online Community

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

Biztalk 2009 issue

I started Biztalk application in Biztalk 2009 administrator, application started, but in context menu I saw "start" start as active and "stop" unactive.
fvv

Reply:
So I need to open 2 Biztalk Administrators - one to start application, another - to stop
fvv

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

Hello, 

Thank you for your post!  I would suggest posting your question in one of the MSDN > Forums Home > BizTalk Server > BizTalk Server General 

located here:  

http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/threads/

Have a great day!


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

AD Attribute Collection Associate To System Names

I have been experimenting with creating collections in SCCM using AD Attributes associated with user info.  Example, I have a collection that consists of users using the AD attribute "display name".  Is there a way to now associate this collection to actual system names?  I am trying to experiment with queries against the collection, but I can't figure out how to include system data into the query.  Any tips or help that anybody could provide would be appriciated.  This is in preperation for a project that I am tasked to tackle in early January.  Kind of pressed for time.  Thanks in advance. 

Reply:
 select SMS_R_System.LastLogonUserName,SMS_R_System.Name,SMS_R_System.ResourceId
 ,SMS_R_System.ResourceType
from  SMS_R_System inner join SMS_R_User on SMS_R_User.Username= SMS_R_System.LastLogonUserName inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
--------------------------------
Here is an extended query.  You will need to modify this for a collection membership query. I have it just as a basic query.  but the answer is yes you can do this.  Realize that you must base the info on either lastlogged on user or the username (pulled at inventory time).

I am sure others will post the queries they have created.  This is a popular subject with many different solutions.
http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

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

Disaster Recovery Plan - SCCM

Hi Guys,

I am writing a SCCM - disaster recovery plan for our environment. We have a central site server that is linked to few primary site servers and every primary servers are supporting around 50 secondary sites. Entire structure is up and running, now i have to create a doco for disaster recovery. I thought to put this case infront of SCCM champs and gather ideas, experiences  that can benefit everyone here in relation with this context.

Looking forward to everyone for their valuable inputs.

Thanks
Veday


Server Engineer

Reply:
In the afterbackup.bat file make sure you have it configured to backup no only the console extensions folder under the XMLStorage folder but if you have it running programs and code in say c:\programs files\extensions get this backedup.

It is a shame to only restore HALF of the console extension.
http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

------------------------------------
Reply:
Hi Matthew

Can you please elaborate on that.?

Thanks
Server Engineer

------------------------------------
Reply:
Sure.

x:\Program Files\SCCM2007\AdminUI\XmlStorage\Extensions\Actions\GUID\

Here is where your console extensions are saved.   The tools point to another folder

x:\program files\SCCM Tools\XXXX

That contains the executible. 

Lastly you have the standard backup folder that has the Database and Site Settings
X:\sccmbackup (as we call it)

The Actions folder and SCCM Tools folder are backup to a safe location (x:\sccmbackup )for our standard backup procedure. 
Now all the data is backuped in a single spot for recovery. 

Does this make better sense?
http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

------------------------------------
Reply:
I didn't think anyone used afterbackup.bat anymore?

I just use the SMS Backup task and then back the servers up with backupexec

------------------------------------
Reply:
veday001, you don't have to worry about the afterbackup.bat if you haven't added any custom console extensions on your siteserver.

------------------------------------
Reply:
Ohh thats good...

What i did till now to backup.

Backup Site Server under Site Maintenance task  and perform NTBACKUP utility to backup Systemstate and System drive.


thanks


 


Server Engineer

------------------------------------
Reply:
Thanks Matthew .. i learned something from ur post
Server Engineer

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

Data flow task fail as query against ssas database too frequently

This is the continue of my post in
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1c8b3c3f-93ca-4257-aa05-22c973db8685/

I guess this is a connection issue. Because I log my error MDX query. It is working when I do time delay for one second or just manually rerun the data flow. I am wondering if I can change my connection string to avoid this problem. So far I just add format=tabular in my connection string. Does someone can fiure out which option can keep this connection stable?

Thanks in advance.
:)

Want to test RSS

Sorry, I just want to test rss so I post this message
fvv

Reply:
This is RSS reply
fvv

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

SQL Server 2008 Developers Edition

My SQL Server 2008 evaluation edition is due to expire, so i am upgrading to SQL Server 2008 Developers edition, retail box.

Does this edition come ready to use, out the box, and does it give you 30 days to get a license ?

I know i need a license, i am not sure if i must have it on day one ?  

Thanks

Reply:
The developer edition comes licenced as such, and is a fully featured version of sql server (exactly the same as the Enterprise Edition, minus the production use licence) and is not time limited.

------------------------------------
Reply:
Thanks.

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

New Home Page URL Not Accepted in Forum User Information

Recently, Time Warner's Roadrunner migrated all of its home page users to a different URL that contained the tilde (~) as part of the address.  This forum users' information page does not accept a URL with this symbol and displays an error when it's entered.  My home page is now
http://home.roadrunner.com/~bobengel
and it will not work without the tilde symbol before "bobengel". 

I suggest that the forum page designers change this restriction as many Roadrunner users who must migrate to their new home page system will have this symbol assigned to them in their URL.  I admit that I find this rather unusual but when I tried to access my home page without the tilde, it didn't work; however, I have no choice but to accept Roadrunner's requirements at this time.

Bob
Robert M. Engelbardt

My new threads don't shown on My Threads

I've just submitted a new thread on Visual C++ Language, but it didn't show on My Threads. I presume this thread will do the same !!!

As I assumed before, this thread also didn't show on My Threads.



Voila ! It seems to be working now !

Thanks.

Reply:
They seem to be showing now. We are having some deadlocking issues that are affecting replication, so sometimes they don't show immediately.

Thanks, we're looking into the replication delays.
Matt Fraser, STO Forums Software Developer

------------------------------------
Reply:
I don't know why, but I don't have the option "Mark as an answer" in your last reply.

Thanks anyway.

------------------------------------
Reply:
It's because you created the thread as a "General Discussion" thread and not an "Ask a Question" thread.  "General Discussions" don't have an "answer", so they've disabled the answer functionality.
Aaron Alton | thehobt.blogspot.com

------------------------------------
Reply:
Thanks for your reply

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

Windows vista update error code solution

Joy of all joy when i finally got the vista update issue fixed...so to speak.  I finally got a hold of someone at microsoft security, they gave me a download that added a link to my windows update page.  It basically bypasses all the wsus and gpo issues and goes directly to the website and downloads updates with no issues.  I am not exactly sure what was downloaded, but it basically just adds a link to the windows update page that says search for updates.  good luck


Reply:

 

we'd like some details about it pls Smile

------------------------------------
Reply:
Can you please share the link.  I have been unable to install any updates and this is on a fresh install of vista ultimate.

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

 

Why does everyone do that? Say they got a link and their problems fixed then leaves. Why not help someone else?

------------------------------------
Reply:
Hello,

Could you pass me the link with the download?

Thanks,

Gabriel

------------------------------------
Reply:
Please help me. I just read your posting on the fix for updating windows vista. Everything I go to the update window it just doesn't do anything. I am thinking my computer will run better if I can get the updates downloaded.
Please help..
David

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

Stored Procedure is taking time to execute

Hi,

I am using SQL Server 2005. I have one table named as tblData. I am

inserting records in this table after every 1 minute and this

system will be running 24X7, so the number

of records for one day will be 1400.

I want to Select all data for selected date range.

To achieve this I have created stored procedure to select data from tblData.

Here I have declared cursor to select data from tblData for selected date

range. I have created one temporary table #tblAllData to store records. If

any data is missing I am inserting NULL

value and .

After all data is inserted into tblData I am slecting records and dropping the

table.

But the problem is that, this process is time consuming.

This may be because of Im using cursor and checking for missing data. And

inserting to #tblAllData table.

So can anyone help me to avoid this steps.

 

 

Regards,

Sagar S. Nannaware

How does UDF functions behave?

I have read that UDFs are deterministic in this article:

http://weblogs.sqlteam.com/jeffs/articles/1490.aspx

User Defined Functions (UDF's) are just about my favorite thing in SQL 2000.  I thought the possibilities to be endless, until I realized that they were designed to be completely deterministic:  each call to a UDF with the same arguments should always return the same value...

My problem here is, how does SQL server handles calls to a UDF that opens a cursor? It is ok to assume that it will cache the result but for how much time? Will it flush the cache if the function uses a table that was changed since it was called?

All this is in an effort to minimize impact in the development i'm doing. I'm calling a UDF to get a value from a table. If i call the UDF with different params it returns different values, but if i call it with the same params over and over again it does return the same value, wathever the case. But if the table it works on changes (not really often anyway) then, it must be able to change it's return value because the return value is not always deterministic it can be considered non-derterministic in some cases...

Please help.
Groupe-CDGI Developper

Reply:
Hi there,

UDF's are NOT necessarily deterministic.  For instance, take a look at the following:

CREATE FUNCTION dbo.GetNewDate()  
RETURNS datetime  
AS 
BEGIN 
    RETURN GetDate()  
END 
 
SELECT dbo.GetNewDate()  
 
SELECT  Is_Deterministic  
FROM    INFORMATION_SCHEMA.ROUTINES  
WHERE   ROUTINE_TYPE = 'FUNCTION' 
AND     ROUTINE_NAME = 'GetNewDate' 

As you can see, the udf is just a wrapper for GetDate(), which is a NON-deterministic function.  SELECT dbo.GetNewDate() works, and you can see by querying INFORMATION_SCHEMA.ROUTINES that the function is not deterministic.

As an aside, a cursor inside a udf is scary for performance and concurrency reasons.  If you're actually using a cursor (and it wasn't just an example), you can post the code and we'll help you rewrite it without a cursor.

Does this help?
Aaron Alton | thehobt.blogspot.com

------------------------------------
Reply:
It's a highly optimized cursor already don't worry... but here goes:

ALTER FUNCTION [dbo].[AvailabilityCalculation](@PriorityState INT, @StartDate DATETIME, @Delay FLOAT) RETURNS DATETIME AS
BEGIN
    DECLARE @TotalSpent FLOAT, @FinalDate DATETIME;
    DECLARE @RequiredEntries INT;
    IF @Delay IS NULL SET @Delay = 1;
    SET @RequiredEntries = @Delay * 2;
    IF @RequiredEntries <= 0 SET @RequiredEntries = 100;
    IF @RequiredEntries > 9999 SET @RequiredEntries = 9999;
    SET @TotalSpent = 0;
    DECLARE AvailableTime CURSOR FOR SELECT TOP(@RequiredEntries) dayid, stateavailtime FROM calendar WHERE prioritystate = @PriorityState AND dayid > @StartDate AND stateavailtime > 0
    OPEN AvailableTime
        DECLARE @dayid DATETIME, @stateavailtime FLOAT;
        FETCH NEXT FROM AvailableTime INTO @dayid, @stateavailtime
        WHILE (@@FETCH_STATUS <> -1)
        BEGIN
            SET @TotalSpent = @TotalSpent + @stateavailtime
            IF @TotalSpent > @Delay
            BEGIN
                SET @FinalDate = @dayid
                BREAK
            END
            FETCH NEXT FROM AvailableTime INTO @dayid, @stateavailtime
        END
    CLOSE AvailableTime
    DEALLOCATE AvailableTime
    RETURN @FinalDate
END
Groupe-CDGI Developper

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

Calling SCMDM cmdlet from .NET app fails - [0] = {Invalid Operation: There is an error in XML document (4, 6)..}

If I run Get-MDMDevice from the Mobile Device Manager Shell all owrks as expected, I'm returned the two devices enrolled on my SCMDM server.

If I try to run the same cmdlet from a .NET 2.0 project...


RunspaceConfiguration rc = RunspaceConfiguration.Create();  
 
            PSSnapInException warning;  
            PSSnapInInfo info = rc.AddPSSnapIn("Microsoft.MobileDeviceManager.Tasks", out warning);  
            if (warning != null)  
            {  
                System.Console.Write(warning.Message);  
            }  
 
            Runspace r = RunspaceFactory.CreateRunspace(rc);  
            r.Open();  
 
            RunspaceInvoke ri = new RunspaceInvoke(r);  
 
            IList errors = null;  
            ICollection<PSObject> devices = ri.Invoke("Get-MDMDevice", null, out errors); 


...i have the following object in the errors IList (i.e. Powershell error, not .NET exception) with the following properties:

  • BaseObject = {Invalid Operation: There is an error in XML document (4, 6)..}
  • CategoryInfo = {WriteError: (0:Int32) [Get-MDMDevice], InvalidOperationException}
  • FullyQualifiedErrorId = "Invalid Operation: There is an error in XML document (4,6)..,Microsoft.MobileDeviceManager.GetYonaManagedDeviceCmdlet" string

I've googled the error message and found some issues related to malformed/invalid xml documents.

Any ideas? 

Thanks in advance,

Matt


Reply:
I haven't tried using PowerShell through .Net to interface with SCMDM yet. As far as I understand there are issues with using PowerShell remotely in it's current version, which makes it seems like extra hassle to me. (Not saying it's a bad solution though as I haven't tried it out, and if running on the server this would not be an issue.)

But do you need to use the PowerShell cmdlets? Some problems can be solved through the web services interface of SCMDM. And while I don't know what the license says you're allowed to, you could probably use the dlls from SCMDM in your own .Net project.

------------------------------------
Reply:
I didn't know there was an SDK, I thought you could only use Powershell like Exchange 2007.

Any links/info on the SDK?

------------------------------------
Reply:
Well, there's not an SDK in the same sense as with Exchange Web Services and WebDAV. I have covered some of the web services on my blog (http://mobilitydojo.net/2008/12/02/scmdm-2008-web-services-introduction/), as for using the dlls you'll have to just locate the ones with names that seem relevant to what you want to do, and include in your project.

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

User facing problem to post a question on migrated forums

Hi,
have a look at this post from Old Forums
http://forums.microsoft.com/MSDN/ShowPost.aspx?Post&Site


I'm not sure what exactly is the probelm, so thought of sharing it with you.
Mangal Pardeshi. You can turn off the sun, but I'm still gonna shine. ;)
  • Edited by Mike Walsh FIN Monday, December 15, 2008 5:24 AM () added for clarity
  • Edited by Mangal Pardeshi Wednesday, December 17, 2008 9:00 AM changed for more clarity

Reply:
Same user still facing the problem

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=4241867&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=4247848&SiteID=1


I think he/she posting it for 3-4 days, but nobody is looking into the matter.   Please have a look.
Mangal Pardeshi. You can turn off the SUN, but I'm still gonna shine. ;)

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

Failed AD migration

Ok, I got this problem:
Windows 2000 server that used to be PDC, but after an failed migration to 2003 Server now it seems both are in the DC configurations. When i run DCpromo on the 2000 server it says it already is DC, but in the AD - Domain Controllers i only find the 2003 server. I can't add or modify anything in the AD.
The tech that did the migration dident see what had happend (the migration tool dident compleate so he thought nothing had changed) and reinstalled the 2003 server for another project. There is no SDC either.
Is there anyway to save the AD?  

  • Changed type Morgan Che [MSFT] Thursday, December 18, 2008 8:12 AM No reply from Cu

Reply:
How was the migration suppose to work? How did you migrate? Can you share the dcpromo.log and see whether there's an error message? Any hints from the eventlog?

cheers,

Florian
Microsoft MVP - Group Policy -- blog: http://www.frickelsoft.net/blog

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

UPDATE CUBE

I would like to know,what exactly happens when i fire Update Cube.
This is only for my knowledge i am asking.

For Ex-

IF i am having one Parent-Child hierarchy as below;

A-
 |--A1
 |--A2
      |--A21
      |--A22

where A,A1,A2,A21,A22 are my Entities. and each Entity is associated with some custom rollup formula.
now my confussion is here ;when i update value for Entity A22, is it updates value at the same time for
Entity A,A1 etc (i.e .Cube Updates data from leaf to higher level at the same time) as it is in Parent Child hierarchy. or
it updates only for 
entity A22 and later on when user fire
MDX for retrieving data for entity A it updates and show it to user.
Ani

Reply:
If you want to know how it works exactly, check at the content of your writeback table (in database engine),
you'll see that only the differences between old values and the new ones of update measures are referenced...

So you just update the measure for the A22 Entity, all values linked to the hierachy changed, but only because the formula uses values of leaf levels.

Hope that helps


Flo
http://www.techheadbrothers.com/Auteurs.aspx/florent-merel

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

do you have any article over this, so that i will study this in details.

Ani

------------------------------------
Reply:
Do you work on 2005 or 2008 ? My answer was for 2005...
http://www.techheadbrothers.com/Auteurs.aspx/florent-merel - please mark correct answers MCTS: SQL Server 2005 Business Intelligence ABS Technologies

------------------------------------
Reply:
i am using SQL server 2008
and MOLAP for WriteBack Partition.
Ani

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

OWA - Config

 

Does anyone know what the best practice is for deploying OWA, should we put the CAS in the DMZ or just have the firewall NAT to it internally?

Thanks


Reply:

Hi,

Actually CAS is not designed to put in DMZ, the only server should be in DMZ is Edge Transport server.

Best parctice is to publish CAS features (OWA) using application-aware or application-layer firewall/SSL VPN like ISA Server.

Nice discussions on "why not CAS in DMZ?":
http://exchangepedia.com/blog/2007/05/cas-in-dmz-redux-time-for-owa-appliance.html
http://smtp25.blogspot.com/2008/08/placing-cas-client-access-servers-in.html

References on publishing OWA with ISA 2006:
Using ISA Server 2006 with Outlook Web Access
http://technet.microsoft.com/en-us/library/aa996545.aspx
Publishing Exchange 2007 OWA with ISA Server 2006
http://www.msexchange.org/tutorials/Publishing-Exchange-2007-OWA-ISA-Server-2006.html

Amit Tank || MVP - Exchange || MCITP - Exchange 2007 || http://ExchangeShare.WordPress.com

------------------------------------
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...