Showing posts with label common. Show all posts
Showing posts with label common. Show all posts

Wednesday, March 21, 2012

Please assist with common error 2147467259

I'm not sure if I'm even starting at the right place.

We have a web portal that we use to send email TSN Templates. When we press this link, it queries our SQL database but then times out. When we go to our logs to see waht has happened, this is what we get: Can anyone point me in the right direction?

Timestamp: 15/08/2007 9:00:13 AM
Message: HandlingInstanceID: 5228cfc1-fbc3-4c64-98ab-468d0a99ba85
An exception of type 'System.Web.HttpException' occurred and was caught.

08/15/2007 19:00:13
Type : System.Web.HttpException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Message : Request timed out.
Source :
Help link :
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite :
Stack Trace : The stack trace is unavailable.
Additional Info:

MachineName :
TimeStamp : 15/08/2007 9:00:13 AM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.0.2697.40343, Culture=neutral, PublicKeyToken=d6be776f5b1b3d1f
AppDomainName : /LM/W3SVC/1/ROOT-1-128316415134243452
ThreadIdentity :

WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine:

Application Domain: /LM/W3SVC/1/ROOT-1-128316415134243452
Process Id: 36976
Process Name: C:\WINDOWS\SysWOW64\inetsrv\w3wp.exe
Win32 Thread Id: 35804
Thread Name:
Extended Properties:

For more information, see Help and Support Center at

This is an asp.net / enterprise library problem.

You may want to post in these links.

http://forums.asp.net

http://www.codeplex.com/entlib/Thread/List.aspx


But from the message all I can see is that the application is timing out either when connecting to database or when sending email, I cannot tell for sure, with the limited information above.

Thanks

Wednesday, March 7, 2012

pivot t-sql adding a percentage column

in a cross table result is very common to add a percentage column in respect

of the sum of another column

for example

x z%

a 2 0,46 = 2/(2+5+6)

b 5 0,38 = 5/(2+5+6)

c 6 0,15 = 6/(2+5+6)

is there an easy way to do that in t-sql using the pivot command ?

This was going to be my first answer

"Not easily that I can think of because it requires knowledge of the other rows in the result set and that is where SQL is not very good. That is performing calculations at two levels one aggregate is across th

You need to find the total and then calculate the percentage. This is normally done using a derived table"

However in digging I looked into windowing. This is a new feature that can be used with the new ranking functions as well as the normal aggregates.

In your situation you can do

select x, 1.0*x / sum(x) over (parition by 1) percentage

from mytable

What this does is that it performs a sum of x over the partition of 1 (as this is the same for each row it does a sum across the whole resultset).

Pivot Transformation Editor

Why isn't there an editor for the Pivot Transformation? It is one of the most common transforms I use and the Advanced Editor is a pain in the rear.

Is there a friendly editor available somewhere? =\

Unfortunately there is no custom UI for SSIS Pivot transform,yet (we do have one for unPivot, though), sorry.

SQL BOL should give enough information on how to config this transform, you can also check out Ash's blog http://sqljunkies.com/Article/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk to see whether that helps. If any questions please let us know and we'd like to help.

thanks

wenyang

|||I know how to use it, it's just not very user friendly.|||When do you plan to release a friendly pivot editor?

Saturday, February 25, 2012

Pivot Transformation Editor

Why isn't there an editor for the Pivot Transformation? It is one of the most common transforms I use and the Advanced Editor is a pain in the rear.

Is there a friendly editor available somewhere? =\

Unfortunately there is no custom UI for SSIS Pivot transform,yet (we do have one for unPivot, though), sorry.

SQL BOL should give enough information on how to config this transform, you can also check out Ash's blog http://sqljunkies.com/Article/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk to see whether that helps. If any questions please let us know and we'd like to help.

thanks

wenyang

|||I know how to use it, it's just not very user friendly.|||When do you plan to release a friendly pivot editor?