AcquireConnections Crashing

Feb 17, 2008

Hello,

I am trying to programatically create an SQL Server destination in SSIS. I am creating the connection string, then initiating a connection, and then call AcquireConnections(nothing).

When running in debug mode or in command line, all works perfect. However, when running from within a Windows Service, I get the following exception:

System.Runtime.InteropServices.COMException (0xC020801C): Exception from HRESULT: 0xC020801C at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object pTransaction) at ...

Any ideas ?

Thanks,
Hanan.

View 1 Replies


ADVERTISEMENT

Getting Problem In AcquireConnections

Aug 27, 2007



Hi All,
I just started looking at the SSIS programming, wanted to created a package having table to table data transfer. My source and destination databases are in Oracle.
I gone throught the code samples and started creating the source component. And the whatever samples i've seen the code i have written (copied) looks correct to me but still getting following error.
The basic questions i have is,
1. Do i need to setup something to start programming in SSIS. I am using 'Microsoft Visual C# Express Edition' for programming.
I have all the dll's in place.



And after compiling the code the exception i got is,


{"Exception from HRESULT: 0xC020801C"} System.Runtime.InteropServices.COMException was caught

Message="Exception from HRESULT: 0xC020801C"

Source="Microsoft.SqlServer.DTSPipelineWrap"

ErrorCode=-1071611876

StackTrace:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object pTransaction)



The Code is as Follows:

public static void CreateSource()

{

Microsoft.SqlServer.Dts.Runtime.Package package = new Microsoft.SqlServer.Dts.Runtime.Package();

Executable e = package.Executables.Add("DTS.Pipeline.1");

Microsoft.SqlServer.Dts.Runtime.TaskHost thMainPipe = e as Microsoft.SqlServer.Dts.Runtime.TaskHost;

MainPipe dataFlow = thMainPipe.InnerObject as MainPipe;

// Add an OLEDB connection manager that is used by the component to the package.

ConnectionManager cm = package.Connections.Add("OLEDB");

cm.Name = "OLEDB ConnectionManager";

cm.ConnectionString = @"Data Source=pqdb9i;User ID=srcDbUserId;Provider=MSDAORA.1;Persist Security Info=False;Integrated Security=SSPI;Auto Translate=False;";

package.DelayValidation = true;

cm.DelayValidation = true;

component = dataFlow.ComponentMetaDataCollection.New();

component.Name = "OLEDBSource";

component.ComponentClassID = "DTSAdapter.OleDbSource.1";

// Get the design time instance of the component.

CManagedComponentWrapper instance = component.Instantiate();

// Initialize the component

instance.ProvideComponentProperties();

// Specify the connection manager.

if (component.RuntimeConnectionCollection.Count > 0)

{

component.RuntimeConnectionCollection[0].ConnectionManagerID = package.Connections[0].ID;

component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[0]);

}

// Set the custom properties.

//instance.SetComponentProperty("AlwaysUseDefaultCodePage", false);

instance.SetComponentProperty("AccessMode", 2);

instance.SetComponentProperty("SqlCommand", "Select * from srcTable");

// Reinitialize the metadata.

try

{

instance.AcquireConnections(null);

instance.ReinitializeMetaData();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

Console.WriteLine(component.InputCollection.Count);

}



///End Code


Thanks in advance
-Yuwaraj

View 1 Replies View Related

Error While Invoking AcquireConnections(null)

Sep 3, 2007

Hi, I have a windows service which is configured to login under the "local System Account". and the windows service is actually creating a SSIS package and running it. however, it was running good with out any problem. but we had to uninstall and again reinstall the windows service and after that it is generating an error "Exception from HRESULT: 0xC020801C" when ever it is invoking the


Instance.AcquireConnections(null);

The connection string that is given for the connection manager is as follows

Data Source=ORIONOFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;User Id=;Password=;Provider=SQLNCLI.1;Auto translate=false"

What is the wrong here-can any body kindly suggest? I have tried with the following too

Data Source=ORIONOFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto translate=false"


Does SSIS need to have a connection string with SSPI always? is there any way to use a sql authenlication for this purpose? like using sql user name and password in connection string? Please suggest me. I need it badly.

View 7 Replies View Related

C# Pgm: BOL: Instance.AcquireConnections(null) HRESULT: 0xC020801C

Oct 21, 2005

I'm working on developing a C# application using an SSIS package.  I'm using the code example from BOL: "Adding and Configuring a Component".  When I run the sample I get the above error.  This could be one of several things, including:

View 7 Replies View Related

CManagedComponentWrapper.AcquireConnections Is Not Working In Case Of Remote Server

May 16, 2007

Hello Every one,

here to food for SSIS gurus,



I am preparing SSIS package programmetically using C#, in a web wethod, to perform fuzzy lookup and other transformations in to sql server data.



now situaltion is like this,



there are three system (independent m/cs)



m/c 1 :- webserver

m/c 2 :- sql database (sqlserver)

m/c 3 :- client (it can be any where , we are using onc click deplyment)



Now case is like this.



A user sitting at m/c no. 3 (a thin client) has one-click-deployed application, clicks the button "Create SSIS Package" , which sends this message to webserver (i.e. m/c 2 ) where C# code constructs the package programmatically,

there are three component inside package

1. oldedb Source (a sql server table -- sqlserver is at m/c no 3)

2. fuzzylookup component

3. oledb destination (a sql server table -- sqlserver is at m/c no 3)

Now 1 and 3 component of the package need to connect to sqlserver for initialization there metadata from actual tables.



here is code :

public IDTSComponentMetaData90 oledbDest = null;

oledbDest = dataFlowTask.ComponentMetaDataCollection.New();

oledbDest.Name = "Destination";

oledbDest.ComponentClassID = "DTSAdapter.OLEDBDestination.1";

CManagedComponentWrapper srcDesignTime = oledbDest.Instantiate();

srcDesignTime.ProvideComponentProperties();

oledbDest.RuntimeConnectionCollection[0].ConnectionManagerID = package.Connections[connName].ID;

oledbDest.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[connName]);



srcDesignTime.SetComponentProperty("AccessMode",0);

srcDesignTime.SetComponentProperty("OpenRowset",tableName);



// Tries to connect to sqlserver hosted at different m/c

srcDesignTime.AcquireConnections(null);

srcDesignTime.ReinitializeMetaData();

srcDesignTime.ReleaseConnections();





now the 3rd last line which says srcDesignTime.AcquireConnections(null);



tries to open the connection to the selserver (in order to get information abt actual table and its columns) which is installed at another m/c, and this is possible cause of error (i think !!)



there are two cases in one case i am getting an error and in second case it is working just fine..



case 1. If i use (local webservice) web service to create package it works.

case 2 if i use published (on local IIS ) webservice to create package, It fails (at the code srcDesignTime.AcquireConnections(null); )



so i think problem is related to some authorization, may be i am wrong !!1





Please help me.



thanks in advance

Pradeep



(I am really looking for a reply for MR. Jamie Thomson )

View 3 Replies View Related

DTC Crashing

Dec 19, 2005

Has anybody here seen and resolved the following error?

The MS DTC Transaction Manager is in an inconsistent state and cannot proceed. Please contact Microsoft Product Support. (null)

File: . mtx.cpp, Line: 2570.

We've had this just crop up on a server over the last week. Not finding a lot.

View 4 Replies View Related

Help, My Sql Server Keeps Crashing

Jul 30, 2001

I am running SMS ontop of SQL 7. I keep getting these SQL dump files and cant figure out where to begin. Can somebody help and put me on the right path?

2001-07-22 12:08:55.46 spid12 Process ID 12 attempting to unlock unowned resource PAG: 7:1:507423..
2001-07-22 12:13:21.29 spid8 Error: 1203, Severity: 20, State: 1
2001-07-22 12:13:21.29 spid8 Process ID 8 attempting to unlock unowned resource PAG: 7:1:505802..
2001-07-22 15:15:48.20 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084
Stack Dump being sent to D:MSSQL7logSQL02866.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 07/22/01 15:16:00 spid 11
*
* Input Buffer 417 bytes -
* INSERT INTO Summarizers_Status (SiteCode, MessageDLL, MessageID, Status,
* Updated, GUID_ID) SELECT DISTINCT SiteCode, "SMS_RES1.DLL", 40, (SELECT
* ISNULL(MAX(x.Status), 0) FROM Summarizer_SiteSystem x WHERE x.SiteCode
* = a.SiteCode), (SELECT ISNULL(MAX(x.TimeReported), '1/1/1998 01:00') FRO
* M Summarizer_SiteSystem x WHERE x.SiteCode = a.SiteCode), "{78B42510-ABB
* D-11d1-BB12-3A84C6000000}" FROM Summarizer_SiteSystem a
*
************************************************** *****************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f)
0x005b572c Module(sqlservr+1b572c) (ExecutionContext::Cleanup+9d)
0x004eb421 Module(sqlservr+eb421) (ExecutionContext::Purge+45)
0x004eb182 Module(sqlservr+eb182) (stopsubprocess+e5)
0x004e9d4e Module(sqlservr+e9d4e) (subproc_main+174)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+138)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
2001-07-22 15:16:01.24 kernel SQL Server Assertion: File: <proc.c>, line=1927
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
2001-07-22 15:16:01.31 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084
Stack Dump being sent to D:MSSQL7logSQL02867.dmp

View 1 Replies View Related

Help!! Sql Server Keeps Crashing...

Nov 7, 2000

Help!!!
our sql server (7.0) crashed today because it's running out of space, apparently as a result of some process(es) loading data onto it that left less than one mb of free space on the C/ drive. Most of the data and backups are on the D/ drive which has tons of free space. The swap file was on C/ but the dba moved it after today's episode. His diagnosis is that there are files being created in the server's cache that are clogging it up.
What I really need to find out if there are any temp files generated by scheduled packages that could cause this to happen? We are relatively new to executing jobs on the sql server, so this was not an anticipated situation. Essentially, this server has about 12 jobs that import and transform data from an AS/400 server onto the SQL Server every week. We've been running the jobs for about 4 months and just about 3 weeks ago I noticed a big degradation in the server's performance. Also, how can I find out which physical drive the jobs are residing on? Could anyone suggest on the best course of action please?

Irene
out if there are some sort of temp files that are generated when the scheduler executes jobs on the server.

View 2 Replies View Related

Mmc Crashing With SQL7.0

Dec 2, 1999

Has anybody had any problems with mmc crashing when running Enterprise Manager on SQL Server 7.0/SP1? This occurs on a fairly regular basis on several of our development NT client machines (NT SP4 and SP5). We are running Version 1.1 of mmc. Is there a later version (or service pack) we need to be using?

Any comments on this would be appreciated.

Thanks

View 1 Replies View Related

Server Crashing

Apr 3, 2006

Hi All
Last to last friday, the server crashed.We had to restart the machine to bring up the sql server.Initially we thought this as a one odd instance.This friday, almost the same time, it crashed again. By the time users complained saying they are not able to acces the application, the server froze.I was not able to see the processes running during this time.
Now I realised there is a potential problem.
I check all the logs - > SQL Server log, SQL Agent log, Event viewer.
I dont see any error messages related to this.
Since both weekends it happened at the same time, I assume that there might be some job running on the friday evening which is bringing the server down.
I checked for all the scheduled jobs and didnt find anything. So I assume this might be because of some adhoc jobs ran from the application which is causing this issue.
This have been highly escalated by the users and I have to act :mad:
I am planning to put a trace to see the happenings during this time.
Questions
1) What all parameters(in the profiler) should i take into consideration
2) Any other ways of troubleshooting the same.
3) Any whitepapers / documents to similar issues
Plz respond,my job is at stake :(
Thanks
Sree

View 10 Replies View Related

Replmerg.exe Crashing!

Feb 14, 2005

:eek:

OK, I'm having fun here. I have 3 anonymous subscribers using merge replication all, including the server, on SQL 2000 Server SP3a.

2 of the 3 subscribers crash during the merge process, a Dr Watson error log comes up saying that the replmerg.exe has died.

I have checked for orphaned processes of the same name to no avail. Just in case I made a mistake, I rebooted the server to ensure that any orhpaned processes were killed. No Joy.

Does anyone have any idea what this would happen?

View 2 Replies View Related

BIDS Keeps Crashing

Feb 1, 2007

All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix?

thanks

John

View 6 Replies View Related

Crashing Server - Emergency!!!!!

Mar 22, 2000

Please direct me to detailed causes of SQL server crashing after a 17805 Invalid Buffer Received From Client. Our production server goes down, following this msg.
We applied service pack 5a, and it is still crashing. It crashes using either NAMED PIPES or TCP/IP protocol (via ODBC) The driver versions are older, ODBC 3.0 and SQL Server 2.65, respectively.
I need some direction on this. I'm leaning towards the possibility that this is an application problem.
Any help, any configuration setting changes, upgrades, workarounds, will be accepted. Thank you much!

View 1 Replies View Related

BDE/SQL Causing GENERAL_SQL_ERROR And Crashing App

Aug 27, 2007

Dear Folks:

I am currently engaged in finding the reason why a certain SQL client application (now running under XP SP2) fails when it attempts to query an sql database. This "failure" happens after the nth operation of the same. The application can run anywhere between 2 seconds and 2 hours before it displays a GPF dialog window and is terminated by the user. The application was developed more than 10 years ago using Borland c++ 4.52 (I am using 5.01) and was deployed as a 16 bit windows app. Since then, they've the client) "apparently" had some success running it under Win95/Win98 and 32 bit OSs like W2K and XP.

At this time, I (think I) know that a specific query operation (runing through the KDBF framework) that returns a 13059 BDE code before the returned object is accessed and the KERNAL reports a NULL Handle error. Inside the KBDEF framework, the query function translates to a DbiQExecDirect(,,) function call to the BDE. I have looked at the code and can not find anything wrong.. nor would i expect too. The application worked at one time. But,clearly, something has changed in the environment of both the test system I have, and one installed at a customer site. I have modifed just about every modifiable parameter I can think of. The system in question is an IBM branded machine running XP pro with SP2 applied. I do not know if the app run under XP SP1 correctly, however.

Any suggestions would be greatly appreciated. (i know.. stop using BDE)

Thank you
JRC

View 1 Replies View Related

Reporting Services Keeps Crashing!

Dec 19, 2006

I have two datasets, each of which are pretty much exactly alike. Each
dataset has a corresponding matrix on the report and thats all there is.
When I run each query they work fine but when i preview the report I get the
following:

An error occurred during local report processing. An internal error occurred
on the report server. See the error log for more details.

My query is as follows:

SELECT dbo.SR_Service.SR_Service_RecID,
CASE WHEN sr_type.description LIKE 'Internal' THEN sr_service_recid END AS
internal,
CASE WHEN sr_type.description LIKE 'Incident' OR
sr_type.description LIKE 'scheduled maintenance' OR
sr_type.description LIKE 'support email' THEN
sr_service_recid END AS incident,
CASE WHEN sr_type.description LIKE 'projects' THEN sr_service_recid END AS
project,
(SELECT period FROM TE_Period WHERE (CONVERT(varchar(10),SR_Service.
Date_Entered,101) BETWEEN TE_Period.Date_Start AND TE_Period.Date_End) AND
TE_Period_Setup_RecID =106) AS period
FROM dbo.SR_Service INNER JOIN
dbo.SR_Type ON dbo.SR_Service.SR_Type_RecID = dbo.
SR_Type.SR_Type_RecID
WHERE (DATEPART(yyyy, dbo.SR_Service.Date_Entered) = '2006')
ORDER BY period

I am able to run all the other reports I have created, including those with
subquerys.

What the heck could be making Reporting Services crash? Where can I even
find the error log?

View 1 Replies View Related

Crashing Application, WinCE501bException

May 9, 2008

I have a mobile application that uses a sql mobile database.
The problem I am encountering is that when I created a data adapter and execute the update command of the dataadapter the application crashes.
This is the third form in the application, the other forms also have code that interacts with the database and everything works up to this update command. I have tried the update command manually using SQL Management Studio and it runs without problems.
I am using the a database Provider Factory to allow me to choose between using the Mobile Database or the SQL Server Database. When I run the code using the SQL Server Database it will run without any problems.

The line of code that causes it to crash is located inside a TRY/CATCH block, but it doesn't catch the error. The application simple crashes and ends. I get an Error Report that has the following information.

Here is the part of the code that is causing the problem:





Code Snippet

Dim myAdapter As IDbDataAdapter = pf.CreateDataAdapter()

myAdapter.UpdateCommand = pf.CreateCommand()
myAdapter.UpdateCommand.Connection = cn
myAdapter.UpdateCommand.CommandType = CommandType.Text
myAdapter.UpdateCommand.CommandText = updateCmd

Try
myAdapter.UpdateCommand.ExecuteNonQuery()
Catch err As Exception
MessageBox.Show("An error occurred - " & err.Message)
Finally
cn.Close()
End Try


Bucket Parameters:

EvntType: WinCE501bException
AppName: ltc.exe
AppVer: 5.1.0.0
AppStamp: 48248053
ModName: sqlceqp30.dll
ModVer: 3.0.5300.0
ModStamp: 458ac2af

Any help will be greatly appreciated.

View 3 Replies View Related

Aspnet_wp.exe Crashing Intermittently

Mar 2, 2007

I have an application which is providing printing facility using a custom hardware interface device.
Whenever a print is required user punches in his ID number into the hardware device, and hence an underlying application gets the event and it calls a managed DLL, which inturn calls the Reporting services webservice on the same server. Problem starts after some days (typically after 2 -3 days), when the server response becomes slow and the aspnet_wp.exe restarts every now and then and after this sequence of happening, finally it crashes with some event in application in event log which reads:
The server was unable to allocate from the system nonpaged
pool because the pool was empty.

Also many times the applications log file reads :
There is an error in XML document (1, 948).
I think this error starts when the aspnet_wp.exe is restarting, but I am not sure.

The server operating system is Windows 2000 SP-4, MS SQL Server 2000 Standard Edition SP-4, MS Reporting Services 2000 Standard SP-2 with .Net Framework v1.1
The Server is running many applications apart from the ones listed above and there is a moderate usage of TCP/IP sockets for communicating with certain hardware devices.
Please help me out!

View 1 Replies View Related

Random Crashing In SqlCE

Aug 31, 2007

I have a program that works perfectly...until it crashes. It basically logs info into a SqlCE local file database. After a random time (15 seconds to ~5 minutes) it crashes with the following exception. I cannot find much correleation in the code I've written, except that it seems to crash less often in debug mode...


-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.20706.1

System.Transactions Critical: 0 :
<TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical">
<TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier>
<Description>Unhandled exception</Description>
<Exception>
<ExceptionType>System.AccessViolationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
<Message>Attempted to read or write protected memory. This is often an indication that other memory is corrupt.</Message>
<StackTrace>
at System.Data.SqlServerCe.NativeMethods.SafeRelease(IntPtr&amp;amp; ppUnknown)
at System.Data.SqlServerCe.SqlCeCommand.ReleaseNativeInterfaces()
at System.Data.SqlServerCe.SqlCeCommand.Dispose(Boolean disposing)
at System.Data.SqlServerCe.SqlCeCommand.Finalize()
</StackTrace>
</Exception></TraceRecord>

View 4 Replies View Related

Enterprise Manager Crashing SQL Server

Mar 17, 2004

Hi

We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables.
Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied.
However our enterprise manager clients are registered with SA so I dont think that is an issue.
Can anyone give me some help with this and/or direct me to the hotfix please.

Cheers

Louise

View 2 Replies View Related

Server Crashing With Mutiple Database

May 20, 2004

I got a server that Crashed. My network group was able to get it up and running but it's vary fragile. One of the disk is done. What's the best way to get the my database:tables,views,stored procedured,dts packages, jobs off the bad server without crashing it again? I used the databae copy utility but found out that some of the database are replicated and it wont allow it to copy.

Thanks


Just another day in the life of a dba

View 2 Replies View Related

Events Log Crashing SQL Server 2005

May 24, 2007

i have my SQL server 2005 crashing when Events log is full



I have a hacker attacking my DB with a brut force tool but whereas he does not have the password, event log registers his access attempts as Failure Audit.



I have thousands of lines of "Failure Audit" in my event log



The event logs are set to be overwritten automatically when they reach 16Mb but it's not working correctly, they r not overwriting their content.



in SQL 2005 ERRORLOG file i see:



2007-05-14 01:57:11.57 spid80 Error: 17054, Severity: 16, State: 1.

2007-05-14 01:57:11.57 spid80 The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full.



SQL Agent cannot starts because it's not able to write in the event log that it's starting and when it cannot write in event log, it does not start and my sql server crashed



My Question is simply how to fix this issue once for all

View 3 Replies View Related

SQLGetDiagField() Crashing With Access Violation

Feb 15, 2007

After an error trying to connect to a database, I am trying to query the number of status records using SQLGetDiagField() and am getting an access violation? I am trying to open a connection to data in an Excel file using the Excel ODBC driver. Any hints?

View 1 Replies View Related

CLR Stored Procedure Crashing SQL Server

Mar 29, 2007

I had the following erroneous code in a SQL Server stored C# procedure:



class P

{

private DateTime? e;

public P(

DateTime? e)

{

this.e= e;

}

public DateTime? E

{

get

{

return E; // correction return e;

}

set

{

E= value; // correction e = value;

}

}

}



Calling the getter of E of the class P creates an infinite number of method calls. This causes the .NET stack overflow. This sometimes caused our SQL crash. Here's the log:



29.3.2007 9:46:08 A fatal error occurred in .NET Framework runtime. The server is shutting down.

29.3.2007 9:46:10 Microsoft SQL Server 2005 - 9.00.2153.00 (X64)

May 9 2006 13:58:37

Copyright (c) 1988-2005 Microsoft Corporation



In my opinion an error in SQL server CLR stored procedure must not be able to crash the whole SQL Server, as it seems to do. Could someone verify this?



What makes finding problems like this problematic is that the only error is like ".NET stack overflow". No pointer to where in the code the error occured. It took hours for me to find the problem

View 11 Replies View Related

Help! Site Crashing On Data Access When Busy!

Dec 4, 2007

Clearly, my code isn't written as well as it should be.  I don't understand enough about data access and could use some help.I have several database tables, but one primary table that is the most accessed.  Generally, I need to build a list from the data based on some filter.  I'm using a repeater control, since all I need to display per record is a name, maybe a city or birthday, and possibly a little graphic, and my customer doesn't want a grid type of display.   The filter is determined by the page requested.   The exception is a search page where the user builds the filter and a grid is used to display the results.The results always contain a link to a page that has more detail on the selected record.  What is the best way to handle this?  I'm still trying to get a handle on different ways to get data and I'm not doing much with caching.  Would it make sense to keep the data in memory from the page that displays the list (or search page) to the detail page?  What if the detail page is accessed directly, say from a bookmark?  How do I cache this?I'm currently using strongly typed datasets.Below is an example of what I'm doing - this is from the code behind of one of the list pages - members with birthdays this month.    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        Dim theMonth As String = DateTime.Now.ToString("MMMM")        Me.LabelMonth.Text = theMonth        Dim MemberAdapter As New WAPTableAdapters.membersTableAdapter        Repeater1.DataSource = MemberAdapter.GetBirthday("Female", DatePart("m", Today))        Repeater1.DataBind()        Repeater2.DataSource = MemberAdapter.GetBirthday("Male", DatePart("m", Today))        Repeater2.DataBind()    End Sub    Protected Sub Repeater1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater1.ItemDataBound        If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then            Dim LabelIcon As Label = CType(e.Item.FindControl("LabelIcon"), Label)            Dim person As WAP.membersRow = CType(CType(e.Item.DataItem, System.Data.DataRowView).Row, WAP.membersRow)            If System.IO.File.Exists(Server.MapPath("~/images/picts/" & person.FILE2 & ".jpg")) Then                LabelIcon.Visible = True            End If        End If    End Sub     Protected Sub Repeater2_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater2.ItemDataBound        If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then            Dim LabelIcon As Label = CType(e.Item.FindControl("LabelIcon"), Label)            Dim person As WAP.membersRow = CType(CType(e.Item.DataItem, System.Data.DataRowView).Row, WAP.membersRow)            If System.IO.File.Exists(Server.MapPath("~/images/picts/" & person.FILE2 & ".jpg")) Then                LabelIcon.Visible = True            End If        End If    End Sub It seems pretty simple and straightforward to me, but these pages shouldn't be crashing when the site gets busy, so I have to be doing something wrong. Diane 

View 5 Replies View Related

Sql Server 2000 Enterprise Manager Crashing

Nov 15, 2000

I've installed the client tools on my notebook, and EM normally works properly. However, sometimes Enterprise Manager will crash on me for no obvious reason(it generates errors, but this takes forever, so i kill it). It is not consistent, nor can I reproduce the error, but it happens about once a day, never at the same time. Anyone else see this? My pc has win2K professional on it.

View 1 Replies View Related

SQL Server 2005 Studio Crashing Laptop (BSD)

Jan 31, 2007

I just recently replaced my old HP laptop with a Sony VAIO. I installed all of my development software on it, including SQL Server 2005 and the studio. At some point when I am using the studio on this new laptop, if I try to resize any of the columns to better fit the data, it crashes my laptop. I get the infamous Blue Screen of Death.

The laptop is a Sony Vaio BX670P and it has Win XP SP2 with all of the latest and greatest updates loaded on it.

The BSD blames a driver for causing the crash and points out "win32k.exe" specifically. This has never happened to me before.

Does anyone know why this might be happening?

- - - -
- Will -
- - - -
http://www.strohlsitedesign.com

View 20 Replies View Related

Sql2005 Crashing ? Memory Usuage Dropping?

Apr 17, 2007

Hi,

I've been running SQL2000 for the past few years with 2gb of RAM and just recently upgraded to SQL2005 with 4 gigs.

My old system would always have the sqlservr.exe process using as much RAM as it could, this number would never really drop, maybe if it did it was in the single digit percentages.

I was just setting up new maintenance plans on my server, and I noticed from the time I started to the time I finished the SQLSERVR.EXE process dropped from using 3.5gb of RAM to just 1.5GB of RAM right now. It's pretty steadily going up too.

Does sql2005 have some new advanced memory management features? Did creating a sql maintenance plan release some memory? Did sqlserver crash ? I've never seen this before.


Thanks very much! :)
mike123

View 2 Replies View Related

Updating A Chunk Of Data Without Crashing Transaction Log

Nov 2, 2005

Here is my dilema. I have a 120 GB database that I need to mask customercredit card numbers in. The field is a varchar (16). I need to updatethe field so that we only store the first 4 numbers and the last 4numbers of the credit card and insert * to fill in the rest of thecredit card number.I was going to do this as a loop using the following code:While Exists (Select Top 10 * From Header Where IsNumeric(CCNbr) = 1)BeginBegin Transaction T1UpdateHeaderSetHeader.CCNbr = Left (D1.CCNbr, 4) + '********' + Right (D1.CCNbr, 4)From(Select Top 10 * From Header Where IsNumeric(CCNbr) = 1) as D1Commit Transaction T1If Not Exists(Select Top 10 * From Header Where IsNumeric(CCNbr) = 1)BreakElseContinueEndIn theory this only selects the top 10 rows, updates them, dumps the logand moves on to the next 10 until all the rows are updated.I tried running this on my test database and it fills up the transactionlog.Can anyone tell me the best way to go about doing what I need?Thanks*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

Crashing Pivot Tables In Excel 2007 (SP 1)

May 22, 2008

We are using MS Excel 2007 Pivot tables to access en SSAS 2005 Cube. Farly often when we reopen an excel spreadsheet with one or more pivot tables we get an error like this:

Excel found unreadable Content. Do you wish to repair

When we click yes the following log is shown:
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition2.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable2.xml part (PivotTable view)
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
And all the pivot tables are converted to plain text.
I have read about this in KB 929766 but this do not apply since KPIs are not used.
The KB 943088 is more interesting but after upgrading all user with SP 1 the problem is still there, mostly when we open old excel-files that has been created without SP 1 but opened and saved once with SP 1. After that we are not able to open them at all, either with or without SP 1 installed.
Is there some way to €œsave€? pivot tables from destruction? I can€™t ask the users to rebuild all there spreadsheets that have been created prior SP1. What will happen when there is a new SP for Excel? Rebuild all spreadsheets and pivot tables again?

View 18 Replies View Related

Reporting Services Crashing When Deploying A Project

Mar 31, 2008

Hi,
I'm having an issue with reporting services installed on a Win2000 machine.
I was able to install RS successfully on the server. Everything worked fine, but when I try to deploy a project, SS BIDS keeps asking for a valid password, no matter if I enter any valid password or not. After that if I try to access reporting service, the web interface says:


€œThe report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help €?


In order to get it back working I have to go to Reporting Services Configuration Manager and mark €œApply default settings€? in Report Server Virtual Directory and Report Manager Virtual Directory.
It is worth to say that no matter what project I try to deploy, it is always the same behavior, and that no error log is generated either in event viewer or in the reporting services log directory.
Any idea what is happening?
Regards,
Germán.

View 6 Replies View Related

Designing Report In VS.NET2003 - Studio Is Crashing

Apr 19, 2007

I am using reporting services 2000 already for 2 years. This problem is occurring on 2-3 reports, I can't say exactly what is the reason.

How I use the report designer is pretty simple and consistent. Report data is usualy produced by calling a stored procedure (on SLQ server 2000), I have a few parameters. Some of Paramaters are dates with a default values calculated to give yesterday's date or today - 7 days. And that is the only code in the report itselft. As soon as I click on Yes/No paramater, that doesn't have default, and is int in proc and report, then complete Visual Studio Environment starts flashing, making bip-bip noise, and is blocked, no access and reponse. I can't close it for a while, I can't bring up task manager, and in general this crash is very much resource intensive, Outlook is freezing, can't open IE, new spreadsheet. I am working on windows Xp platform. Eventually I would manage to close VS thru task manager.

As soon as this report is uploaded to Report Manager, the place where all the reports are available to users, on different server, the same report works fine.

Has anyone experienced this and what would be the reason.


Thanks in advance,
Elizabeta R

View 1 Replies View Related

SQL Server 2005 Crashing On Write Access - ARGH!

May 30, 2006

Hi,I'm accessing a pair of databases with ASP/ADO,and using stored procedures on the first access.The first access works OK - everything gets writtento where it's supposed to be.On attempting to write to a pair of database tablesin the second database (second access attempt),the server crashes, as does the app, and I get the following error:--------------------------------------------------------------------Server Error in '/Webfolder01' Application.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)--------------------------------------------------------------------After this, I have to go into the services panel and restart SQL 2005.This doesn't happen if I use small test data sets in the first access,and I can comment out the second access attempt, and the first accessexecutes just fine with both the large and small data sets,so I'm thinking that this has something to do with synchronisation:Perhaps the second attempt is being made before the server is ready.Is there something that I need to do to make certain that SQL 2005is ready to receive data?I'm using SqlBulkCopy with both accesses, but I don't see how thatcould be a problem.--------------------------------------------------------------------[SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)]   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188   System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +556   System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164   System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +34   System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +30   System.Data.SqlClient.TdsParserStateObject.ReadByte() +17   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,                     TdsParserStateObject stateObj) +59   System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() +1327   System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer (Int32 columnCount) +916   System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState) +176   System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table) +6   Database_control.DB_ctrl_class.load_datatable_to_DB_table(DB_ref_class src_table) in i:Virtual WebfoldersDBctrl.cs:978--------------------------------------------------------------------THANK YOU VERY MUCH!!!

View 4 Replies View Related

SQL Service Management Studio Express (x64) Crashing On Startup

Mar 20, 2007

hopefully, the subject addresses my problem. the server is running like a charm.

Service pack 2 has been installed. The only connection I remember creating after the initial installation is a remote connection.

I've checked to make sure I am allowing multiple protocols.

I am not able to get a response from the following:


C:Usersamfrizzell>SQLCmd -S .aaron-toshiba -E -Q "SELECT @@Version"
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

The instance is running as I can connect to it through Visual Studio 2005.

What did I do wrong? I could really use this application in order for me to develop websites. It's sort of a pain to go to another computer to use the more powerful features of SQL Server 2005 Server management Studio (standard edition).

Help me... somebody please help me.

Thanks.

Aaron

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved