Excel Import: process

Showing posts with label process. Show all posts

Monday, March 26, 2012

Exec Process Task problem

I am trying to use a variable in an Execute Process Task

Here is my code that I use to set the variable and it works and has the right information:

Public Sub Main()

Dim serverNamePart As String = Mid(CStr(System.Environment.MachineName()), 1, 5)

Dts.Variables.Item("gvServerName").Value = (CStr(System.Environment.MachineName()))

Select Case serverNamePart

Case "ATCDE" 'Development server

Dts.Variables.Item("gvAppServer").Value = "ATCDEVRPNAPP01"

Case "ATCIN" 'Intergration server

Dts.Variables.Item("gvAppServer").Value = "ATCINTRPNAPP01"

Case "ATCDE" 'Development server

Dts.Variables.Item("gvAppServer").Value = "ATCQARPNAPP01"

Case "LTC1P" 'Development server

Dts.Variables.Item("gvAppServer").Value = "LTC1RPNAPP01 LTC1RPNAPP02 LTC1RPNAPP03 LTC1RPNAPP04"

End Select

' MsgBox(Dts.Variables.Item("gvServerName").Value)

MsgBox(Dts.Variables.Item("gvAppServer").Value)

Dts.TaskResult = Dts.Results.Success

End Sub

On my Execute Process task I have User::gvAppServer as my StandardInputVariable but when I execute the task I get

[Execute Process Task] Error: In Executing "D:\RPNUtility\bin\AutoTransmitCall.exe" "" at "", The process exit code was "1" while the expected was "0".

If I take out the StandardInputVariable and hard code the value in Arguments it works. What am I doing wrong?

Phil, I believe you want to parameterize your "Arguments" property rather than your StandardInputVariable property. Use the Expressions page of the Execute Process Editor to use your gvAppServer variable for Arguments.

Your StandardInputVariable would be used for data that is processed by an executable, rather than a parameter for it.

|||That looks like it worked. Thanks.

EXEC keyword

I am in the process of importing an Oracle database into SQL Server.
Once of the tables has a field called "EXEC".
SQL Server seems to reject any queries that include that particular
field because EXEC is a keyword. For eg.
SELECT ID, EXEC from USERS
results in a syntax error near keyword EXEC.
I can't change the fieldname becuase it will require reworking of a
whole bunch of scripts.
What can I do to adjust the query?
Bijoy
You can use square brackets as delimiters:
select [EXEC] from ...
See "Delimited Identifiers" and "Using Identifiers" in Books Online for
more information.
Simon
|||Try
SELECT [ID], [EXEC] FROM Users
Regards
Steen
b_naick@.yahoo.ca wrote:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
> Bijoy
|||(b_naick@.yahoo.ca) writes:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
Rather than using [] as suggested in other posts, "" may be better.
SELECT ID, "EXEC" FROM USERS
[] is usually preferred on SQL Server. However, that is proprietary syntax,
whereas quoting with "" is ANSI-compliant, and may thus work on Oracle as
well.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
sql

EXEC keyword

I am in the process of importing an Oracle database into SQL Server.
Once of the tables has a field called "EXEC".
SQL Server seems to reject any queries that include that particular
field because EXEC is a keyword. For eg.
SELECT ID, EXEC from USERS
results in a syntax error near keyword EXEC.
I can't change the fieldname becuase it will require reworking of a
whole bunch of scripts.
What can I do to adjust the query?
BijoyYou can use square brackets as delimiters:
select [EXEC] from ...
See "Delimited Identifiers" and "Using Identifiers" in Books Online for
more information.
Simon|||Try
SELECT [ID], [EXEC] FROM Users
Regards
Steen
b_naick@.yahoo.ca wrote:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
> Bijoy|||(b_naick@.yahoo.ca) writes:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
Rather than using [] as suggested in other posts, "" may be better.
SELECT ID, "EXEC" FROM USERS
[] is usually preferred on SQL Server. However, that is proprietary synt
ax,
whereas quoting with "" is ANSI-compliant, and may thus work on Oracle as
well.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

EXEC keyword

I am in the process of importing an Oracle database into SQL Server.
Once of the tables has a field called "EXEC".
SQL Server seems to reject any queries that include that particular
field because EXEC is a keyword. For eg.
SELECT ID, EXEC from USERS
results in a syntax error near keyword EXEC.
I can't change the fieldname becuase it will require reworking of a
whole bunch of scripts.
What can I do to adjust the query?
BijoyYou can use square brackets as delimiters:
select [EXEC] from ...
See "Delimited Identifiers" and "Using Identifiers" in Books Online for
more information.
Simon|||Try
SELECT [ID], [EXEC] FROM Users
Regards
Steen
b_naick@.yahoo.ca wrote:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
> Bijoy|||(b_naick@.yahoo.ca) writes:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
Rather than using [] as suggested in other posts, "" may be better.
SELECT ID, "EXEC" FROM USERS
[] is usually preferred on SQL Server. However, that is proprietary syntax,
whereas quoting with "" is ANSI-compliant, and may thus work on Oracle as
well.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

EXEC keyword

I am in the process of importing an Oracle database into SQL Server.
Once of the tables has a field called "EXEC".

SQL Server seems to reject any queries that include that particular
field because EXEC is a keyword. For eg.

SELECT ID, EXEC from USERS

results in a syntax error near keyword EXEC.

I can't change the fieldname becuase it will require reworking of a
whole bunch of scripts.

What can I do to adjust the query?

BijoyYou can use square brackets as delimiters:

select [EXEC] from ...

See "Delimited Identifiers" and "Using Identifiers" in Books Online for
more information.

Simon|||Try

SELECT [ID], [EXEC] FROM Users

Regards
Steen

b_naick@.yahoo.ca wrote:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?
> Bijoy|||(b_naick@.yahoo.ca) writes:
> I am in the process of importing an Oracle database into SQL Server.
> Once of the tables has a field called "EXEC".
> SQL Server seems to reject any queries that include that particular
> field because EXEC is a keyword. For eg.
> SELECT ID, EXEC from USERS
> results in a syntax error near keyword EXEC.
> I can't change the fieldname becuase it will require reworking of a
> whole bunch of scripts.
> What can I do to adjust the query?

Rather than using [] as suggested in other posts, "" may be better.

SELECT ID, "EXEC" FROM USERS

[] is usually preferred on SQL Server. However, that is proprietary syntax,
whereas quoting with "" is ANSI-compliant, and may thus work on Oracle as
well.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Wednesday, March 21, 2012

excluding a package from the build process

There is some way to exclude a package from the build process of a SSIS project ?

Cosimo

cosimog wrote:

There is some way to exclude a package from the build process of a SSIS project ?
Cosimo

I don't think so. it would be nice though wouldn't it? Try submitting the request at http://connect.microsoft.com/sqlserver/feedback

-Jamie

Friday, March 9, 2012

EXCEPTION_FLT_UNDERFLOW

Hi,
I'm getting the message 'SqlDumpExceptionHandler: Process 12 generated fatal
exception c0000093 EXCEPTION_FLT_UNDERFLOW. SQL Server is terminating this
process.' and my connection is terminated.
what causes this error and how is it fixed.
using sql2k with sp3.
thanks.> Hi,
> I'm getting the message 'SqlDumpExceptionHandler: Process 12
> generated fatal exception c0000093 EXCEPTION_FLT_UNDERFLOW. SQL
> Server is terminating this process.' and my connection is terminated.
> what causes this error and how is it fixed.
> using sql2k with sp3.
Try checking the table with DBCC CHECKTABLE. DBCC DBREINDEX sometimes fixes
the problem. If it does not, it looks like a MS PSS case for me
(http://support.microsoft.com/defaul...estion.asp&SD=G
N&FR=0)
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||thanks Sebastian,
I've been messing with the data and it appears that earlier versions of MSSQ
L were not strict with what you entered into a float column - you could over
load the datatype.
thanks for your help though.

EXCEPTION_ACCESS_VIOLATION While Excecuting Select Query.

Dear Freinds,

While Excecuting select Query in my client place ,the following error is coming.

SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

When i got same database , i try restore in my pc and run the same...query its excecuting properly..with out giving any error..i tried lot of things ..nothing is working out..i am not able to find the root cause itself..why the exception is coming..

I attaching the Error log with this post.

Note: Check For the Keyword 'EXCEPTION_ACCESS_VIOLATION' in the Error Log File.

Any body can help me out in sorting this issue...then :beer: other wise i will be:eek:

With Reg,
Sathesh.Mapply service pack 3a or service pack 4 of Sql server 2000

Wednesday, March 7, 2012

EXCEPTION_ACCESS_VIOLATION

Hi,
I am getting the following error when I am trying to
execute a Query through an ASP page.
SqlDumpExceptionHandler: Process 54 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
If somebody knows anything about this, please let me
know.
Thanx,
InderMake sure you have applied all of the current Service Packs for SQL
Server... AVs are generally bugs in the product... If you can't find
anything recent on MS web site (KB article, etc) you may wish to open a call
to PSS.
"Inder" <inderpal@.expresscolour.com> wrote in message
news:06f701c37117$416a0700$a301280a@.phx.gbl...
> Hi,
> I am getting the following error when I am trying to
> execute a Query through an ASP page.
> SqlDumpExceptionHandler: Process 54 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> If somebody knows anything about this, please let me
> know.
> Thanx,
> Inder

Exception handling in Triggers.

If we can get away from the trigger for a second.
One of the least documented aspects on how transactions
work are to do with the process id that its running from.
So if you open up QA do transaction mock statement, open
up another window in QA and do rollback you will get an
error, why, becasue the process in the second window is
different to the first.
The reason why this is important is that a rollback as you
found out will effect EVERY transaction in that process
even though it maybe nested. Try this yourself, you will
get some very interesting answers.
So to get back to your question.
SQL Server will automatically rollback transactions if the
error is serious enough.
If there is no transaction then there will be no
transaction count, there is a handy little global variable
called @.@.TRANCOUNT you may want to look at. So if that is
set to anything but a 0 it will automatically rollback the
transaction irrespective on whether it is done in trigger
or something else.
From application programs then it depends on the error. If
you had a connection object and you application (not SQL)
failed then it would be up to your application to repair
the DB by sending it up a rollback.
If you application using the same connection as the begin
transaction sent some SQL that caused an error then yes it
would automatically roll back.
Anyway that it. I sugest you have a play on QA.
If you have any questions then don't hesitate to email me
on peternolan67REMOVETHIS@.hotmail.com (though I am a bit
busy tonight)
Peter
"You can always count on Americans to do the right thing -
after they've tried everything else."
Winston Churchill

>--Original Message--
>Can anybody point me to a good text about
>exception handling in triggers (errors and rollbacks) ?
>From 'Inside' :
>ROLLBACK (because of a fatal error or an
>explicit ROLLBACK command), the entire batch is aborted.
>
>As I read this :
>From within a trigger any FK or relational constraint
>violation results in a fatal error aborting the complete
>batch (and complete transaction).
>Is this correct ?
>What if there was no transaction start ?
>In the QA, does the QA supply a transaction
>(increase the transaction count) if no transaction
>was started ?
>When sending several statements, it appears
>that all statements are rolled back. (Are handled
>as one transaction).
>Does something similar happen when doing
>similar statements from application programs ?
>Thanks for your attention,
>ben brugman.
>
>.
>
My email is
stbraslenscap@.lenscaphiscom.nl
(Both lenscaps should be removed).
I tried to reply to your mail, but that bounced,
so now in the thread.
thanks in advance,
ben brugman
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:4ff601c49104$6e437d70$a301280a@.phx.gbl...[vbcol=seagreen]
> If we can get away from the trigger for a second.
> One of the least documented aspects on how transactions
> work are to do with the process id that its running from.
> So if you open up QA do transaction mock statement, open
> up another window in QA and do rollback you will get an
> error, why, becasue the process in the second window is
> different to the first.
> The reason why this is important is that a rollback as you
> found out will effect EVERY transaction in that process
> even though it maybe nested. Try this yourself, you will
> get some very interesting answers.
> So to get back to your question.
> SQL Server will automatically rollback transactions if the
> error is serious enough.
> If there is no transaction then there will be no
> transaction count, there is a handy little global variable
> called @.@.TRANCOUNT you may want to look at. So if that is
> set to anything but a 0 it will automatically rollback the
> transaction irrespective on whether it is done in trigger
> or something else.
> From application programs then it depends on the error. If
> you had a connection object and you application (not SQL)
> failed then it would be up to your application to repair
> the DB by sending it up a rollback.
> If you application using the same connection as the begin
> transaction sent some SQL that caused an error then yes it
> would automatically roll back.
> Anyway that it. I sugest you have a play on QA.
> If you have any questions then don't hesitate to email me
> on peternolan67REMOVETHIS@.hotmail.com (though I am a bit
> busy tonight)
> Peter
> "You can always count on Americans to do the right thing -
> after they've tried everything else."
> Winston Churchill
>
>

Sunday, February 26, 2012

Exception handling in Triggers.

If we can get away from the trigger for a second.
One of the least documented aspects on how transactions
work are to do with the process id that its running from.
So if you open up QA do transaction mock statement, open
up another window in QA and do rollback you will get an
error, why, becasue the process in the second window is
different to the first.
The reason why this is important is that a rollback as you
found out will effect EVERY transaction in that process
even though it maybe nested. Try this yourself, you will
get some very interesting answers.
So to get back to your question.
SQL Server will automatically rollback transactions if the
error is serious enough.
If there is no transaction then there will be no
transaction count, there is a handy little global variable
called @.@.TRANCOUNT you may want to look at. So if that is
set to anything but a 0 it will automatically rollback the
transaction irrespective on whether it is done in trigger
or something else.
From application programs then it depends on the error. If
you had a connection object and you application (not SQL)
failed then it would be up to your application to repair
the DB by sending it up a rollback.
If you application using the same connection as the begin
transaction sent some SQL that caused an error then yes it
would automatically roll back.
Anyway that it. I sugest you have a play on QA.
If you have any questions then don't hesitate to email me
on peternolan67REMOVETHIS@.hotmail.com (though I am a bit
busy tonight)
Peter
"You can always count on Americans to do the right thing -
after they've tried everything else."
Winston Churchill

>--Original Message--
>Can anybody point me to a good text about
>exception handling in triggers (errors and rollbacks) ?
>From 'Inside' :
>ROLLBACK (because of a fatal error or an
>explicit ROLLBACK command), the entire batch is aborted.
>
>As I read this :
>From within a trigger any FK or relational constraint
>violation results in a fatal error aborting the complete
>batch (and complete transaction).
>Is this correct ?
>What if there was no transaction start ?
>In the QA, does the QA supply a transaction
>(increase the transaction count) if no transaction
>was started ?
>When sending several statements, it appears
>that all statements are rolled back. (Are handled
>as one transaction).
>Does something similar happen when doing
>similar statements from application programs ?
>Thanks for your attention,
>ben brugman.
>
>.
>My email is
stbraslenscap@.lenscaphiscom.nl
(Both lenscaps should be removed).
I tried to reply to your mail, but that bounced,
so now in the thread.
thanks in advance,
ben brugman
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:4ff601c49104$6e437d70$a301280a@.phx.gbl...[vbcol=seagreen]
> If we can get away from the trigger for a second.
> One of the least documented aspects on how transactions
> work are to do with the process id that its running from.
> So if you open up QA do transaction mock statement, open
> up another window in QA and do rollback you will get an
> error, why, becasue the process in the second window is
> different to the first.
> The reason why this is important is that a rollback as you
> found out will effect EVERY transaction in that process
> even though it maybe nested. Try this yourself, you will
> get some very interesting answers.
> So to get back to your question.
> SQL Server will automatically rollback transactions if the
> error is serious enough.
> If there is no transaction then there will be no
> transaction count, there is a handy little global variable
> called @.@.TRANCOUNT you may want to look at. So if that is
> set to anything but a 0 it will automatically rollback the
> transaction irrespective on whether it is done in trigger
> or something else.
> From application programs then it depends on the error. If
> you had a connection object and you application (not SQL)
> failed then it would be up to your application to repair
> the DB by sending it up a rollback.
> If you application using the same connection as the begin
> transaction sent some SQL that caused an error then yes it
> would automatically roll back.
> Anyway that it. I sugest you have a play on QA.
> If you have any questions then don't hesitate to email me
> on peternolan67REMOVETHIS@.hotmail.com (though I am a bit
> busy tonight)
> Peter
> "You can always count on Americans to do the right thing -
> after they've tried everything else."
> Winston Churchill
>
>
>

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no changes
have been made to the jobs.
Any help is appreciated. Thanks
In this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks
|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no change
s
have been made to the jobs.
Any help is appreciated. ThanksIn this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no changes
have been made to the jobs.
Any help is appreciated. ThanksIn this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

my sql server give me a error log,who can help me?

2007-07-06 09:58:46.09 spid56 SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
*******************************************************************************
*
* BEGIN STACK DUMP:
* 07/06/07 09:58:46 spid 56
*
* Exception Address = 00402484
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 199A0F64
* Input Buffer 190 bytes -
* delete from cms_paramdb1..Param where PatientiID = 427 and Occurtime =
* '2007-06-12 17:51:39'
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 7C920000 7C9B3FFF 00094000
* kernel32 7C800000 7C91BFFF 0011c000
* ADVAPI32 77DA0000 77E48FFF 000a9000
* RPCRT4 77E50000 77EE0FFF 00091000
* USER32 77D10000 77D9EFFF 0008f000
* GDI32 77EF0000 77F35FFF 00046000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 77BE0000 77C37FFF 00058000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 00300000 00310FFF 00011000
* ShimEng 5CC30000 5CC55FFF 00026000
* AcSpecfc 71540000 71580FFF 00041000
* ole32 76990000 76ACBFFF 0013c000
* SHELL32 773A0000 77B90FFF 007f1000
* SHLWAPI 77F40000 77FB5FFF 00076000
* WINMM 76B10000 76B39FFF 0002a000
* DDRAW 736D0000 73718FFF 00049000
* DCIMAN32 73B30000 73B35FFF 00006000
* USERENV 759D0000 75A7DFFF 000ae000
* MPR 71A90000 71AA1FFF 00012000
* PSAPI 76BC0000 76BCAFFF 0000b000
* comdlg32 76320000 76366FFF 00047000
* COMCTL32 5D170000 5D206FFF 00097000
* IMM32 76300000 7631CFFF 0001d000
* WS2_32 71A20000 71A36FFF 00017000
* WS2HELP 71A10000 71A17FFF 00008000
* LPK 62C20000 62C28FFF 00009000
* USP10 73FA0000 7400AFFF 0006b000
* comctl32 77180000 77281FFF 00102000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 5FDD0000 5FE23FFF 00054000
* wmi 76D00000 76D03FFF 00004000
* SSNETLIB 42CF0000 42D05FFF 00016000
* WSOCK32 71A40000 71A4AFFF 0000b000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 71F00000 71F03FFF 00004000
* SECUR32 77FC0000 77FD0FFF 00011000
* crypt32 765E0000 76671FFF 00092000
* MSASN1 76DB0000 76DC1FFF 00012000
* VERSION 77BD0000 77BD7FFF 00008000
* SSmsLPCn 42CD0000 42CD6FFF 00007000
* ntdsapi 76770000 76782FFF 00013000
* DNSAPI 76EF0000 76F16FFF 00027000
* WLDAP32 76F30000 76F5BFFF 0002c000
* sqlimage 4A400000 4A40CFFF 0000d000
* DBGHELP 020F0000 02102FFF 00013000
*
* Edi: 19991FFC: 16290F65 00000000 00000000 00000000 00000000 00000000
* Esi: 01F6D244: 19990F65 0000FFFF 00000000 00000000 01F6D2D8 00000000
* Eax: 19990F65: FFFFFFFF FFFFFFFF 75405AFF 8C969852 03DB62E5 FFFFFFFF
* Ebx: 19990000: 00000301 00FF0000 00000000 00000000 00000000 00060000
* Ecx: 0000FFFF:
* Edx: 00000026:
* Eip: 00402484: 0114B70F 83145689 EAC107C2 0A4C8D03 184E8902 752000F6
* Ebp: 01F6D264: 01F6D298 00576A9E 00000001 01F6D310 01F6D308 01F6D2D8
* SegCs: 0000001B:
* EFlags: 00010202: 0053005C 00730079 00650074 0033006D 005C0032 00620057
* Esp: 01F6D234: 01F6D244 0040289C 01F6D2D8 00408FEA 19990F65 0000FFFF
* SegSs: 00000023:
*******************************************************************************
-
Short Stack Dump
00402484 Module(sqlservr+00002484)
00576A9E Module(sqlservr+00176A9E) (SQLExit(unsigned long)+00021C8C)
0057620B Module(sqlservr+0017620B) (SQLExit(unsigned long)+000213F9)
005021AC Module(sqlservr+001021AC)
0041ED96 Module(sqlservr+0001ED96)
00442DD0 Module(sqlservr+00042DD0)
004BFD41 Module(sqlservr+000BFD41)
00427985 Module(sqlservr+00027985)
004271BA Module(sqlservr+000271BA)
0042EA36 Module(sqlservr+0002EA36)
0042E82D Module(sqlservr+0002E82D)
004160DB Module(sqlservr+000160DB)
00415765 Module(sqlservr+00015765)
00415410 Module(sqlservr+00015410)
005A683F Module(sqlservr+001A683F) (SQLExit(unsigned long)+00051A2D)
004160DB Module(sqlservr+000160DB)
00415765 Module(sqlservr+00015765)
00415410 Module(sqlservr+00015410)
00459A54 Module(sqlservr+00059A54)
004175D8 Module(sqlservr+000175D8)
410735D0 Module(UMS+000035D0) (UmsSystemUserContext::UmsSystemUserContext(class UmsScheduler *,struct UMS_SYSPARAMS *)+00000434)
4107382C Module(UMS+0000382C) (UmsScheduler::FiberEnabled(void)+000001D2)
77C0A243 Module(MSVCRT+0002A243) (_endthread+000000AF)
7C80B50B Module(kernel32+0000B50B) (GetModuleFileNameA+000001B4)
-
2007-07-06 09:58:46.26 spid56 Error: 0, Severity: 19, State: 0
2007-07-06 09:58:46.26 spid56 language_exec: Process 56 generated an access violation. SQL Server is terminating this process..
2007-07-06 09:58:50.28 spid57 Error: 7105, Severity: 22, State: 6
2007-07-06 09:58:50.28 spid57 Page (1:3568), slot 0 for text, ntext, or image node does not exist..

Hi,

which version of SQL Server are you running ?

Did you try to run DBCC CHECKDB already ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

This is probably a bug in SQL Server. Please contact Microsoft product support or provide feedback at http://connect.microsoft.com/sql. When providing feedback upload one of your errorlogs with the error, and any corresponding dump files (*.mdmp*) files that might be present in your log directory.

Thanks,

Fabricio.

|||

Hmmmm. This was reported nearly a month ago. No responses other than 'contact support'.

And yet we're seeing the same thing....and wasting days talking to someone in Bangalore.

Is this the new Microsoft? Hello?

|||

Have you contacted Microsoft support regading this issue? They are usually pretty quick with resolutions and you would not be wasting your time. If you have done so, can you please provide me with your case # and I'll make sure this issue gets resolved (please send it to fvoznika at microsoft.com).

Thanks,

Fabricio.

|||I've just started getting this EXCEPTION_ACCESS_VIOLATION (0xc0000005) on machines using Windows 2000 sp4 connecting to SQLServer. This is crashing JVMs (multiple Sun versions and BEA also) in the Java VM thread (outside our code). This has just started recently - perhaps with the last set of patches? Has anyone else seen this or know what I could do to get more information? Could this be related to updates to named pipes?

Thanks!

-Brian Temple

|||

Brian,

The problem you're describing is a crash in the client application connection to SQL Server, and not in SQL Server itself. You can try to post your question in SQL Server Data Access forum (sibling of this one) if you believe SQL Server JDBC is at fault or follow up with Sun as to why JVM is crashing.

Thanks,

Fabricio.

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

my sql server give me a error log,who can help me?

Hi,

which version of SQL Server are you running ?

Did you try to run DBCC CHECKDB already ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thanks,

Fabricio.

|||

Hmmmm. This was reported nearly a month ago. No responses other than 'contact support'.

And yet we're seeing the same thing....and wasting days talking to someone in Bangalore.

Is this the new Microsoft? Hello?

|||

Thanks,

Fabricio.

Thanks!

-Brian Temple

|||

Brian,

Thanks,

Fabricio.

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

my sql server give me a error log,who can help me?

Hi,

which version of SQL Server are you running ?

Did you try to run DBCC CHECKDB already ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thanks,

Fabricio.

|||

Hmmmm. This was reported nearly a month ago. No responses other than 'contact support'.

And yet we're seeing the same thing....and wasting days talking to someone in Bangalore.

Is this the new Microsoft? Hello?

|||

Thanks,

Fabricio.

Thanks!

-Brian Temple

|||

Brian,

Thanks,

Fabricio.

Friday, February 24, 2012

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

my sql server give me a error log,who can help me?

Hi,

which version of SQL Server are you running ?

Did you try to run DBCC CHECKDB already ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thanks,

Fabricio.

|||

Hmmmm. This was reported nearly a month ago. No responses other than 'contact support'.

And yet we're seeing the same thing....and wasting days talking to someone in Bangalore.

Is this the new Microsoft? Hello?

|||

Thanks,

Fabricio.

Thanks!

-Brian Temple

|||

Brian,

Thanks,

Fabricio.

Excel versus PDF Rendering

We have a report that's rendered to a printable form over 1000 times
in a span of 2 hours. We're in the process of replacing the server
because this workload has been hammering the machine and running the
RS services out of memory. I've added a metering component (the page
that redirects users to the report checks to see how many reports are
running and holds them at that page if it's over a set number). My
question is... for a fairly plain report (about 8 pages, mostly just
gridlines and shaded areas, with column and row header text. No
embedded images), which rendering performs better - PDF or Excel?
I've done some un-scientific research, and found that the CPU and
clock-time for each is pretty consistent, but that PDF might require
less memory per rendering report? Any feedback on this would be very
helpful.With SP1 of Reporting, the Algoritm for PDF Render are improved.
Con el Service Pack 1, el algoritmo de renderizacion de PDF fue mejorado.
John Bocachica
Colombia
"TShay" wrote:
> We have a report that's rendered to a printable form over 1000 times
> in a span of 2 hours. We're in the process of replacing the server
> because this workload has been hammering the machine and running the
> RS services out of memory. I've added a metering component (the page
> that redirects users to the report checks to see how many reports are
> running and holds them at that page if it's over a set number). My
> question is... for a fairly plain report (about 8 pages, mostly just
> gridlines and shaded areas, with column and row header text. No
> embedded images), which rendering performs better - PDF or Excel?
> I've done some un-scientific research, and found that the CPU and
> clock-time for each is pretty consistent, but that PDF might require
> less memory per rendering report? Any feedback on this would be very
> helpful.
>

Sunday, February 19, 2012

Excel reports to RS

We have several extensive reports in Excel that I
would like to port over to Reporting Services (am in process of testing
SQL/RS 2005), if at all possible. From what I understand, the only way to do
this is via a third party piece of software, such as OfficeWriterSE for
ASP by softartisans.com...
A couple questions:
1. Is there an open source alternative to the commercial third party
software (the cost of OfficeWriterSE is way beyond our budget)?
2. Does Microsoft plan on ever offering the capability of importing Excel
reports into RS? (I do like the ability of importing Access report
objects, so why not expand to Excel and Word too)?
3. Should I just forget the whole thing?
TIA!
Greg--My guess is that you should give it up. My guess is the 3rd party tool
allows you to create reports in Excel that are RS reports, not that it
importants existing Excel sheets into RS. Excel has an ability to be
unstructured that RS does not have which make it in my mind highly unlikely
you will ever see a tool from MS to do what you want. Access is very
structured (it is a database product after all) which is why they could
import Access reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gms" <gms@.discussions.microsoft.com> wrote in message
news:5C29B68B-A8CB-458B-BC1F-C061ABC70F49@.microsoft.com...
> We have several extensive reports in Excel that I
> would like to port over to Reporting Services (am in process of testing
> SQL/RS 2005), if at all possible. From what I understand, the only way to
> do
> this is via a third party piece of software, such as OfficeWriterSE for
> ASP by softartisans.com...
> A couple questions:
> 1. Is there an open source alternative to the commercial third party
> software (the cost of OfficeWriterSE is way beyond our budget)?
> 2. Does Microsoft plan on ever offering the capability of importing Excel
> reports into RS? (I do like the ability of importing Access report
> objects, so why not expand to Excel and Word too)?
> 3. Should I just forget the whole thing?
> TIA!
> Greg--|||I guess I knew the answer all along! At lest this confirms it.
Thanks!
Greg--
"Bruce L-C [MVP]" wrote:
> My guess is that you should give it up. My guess is the 3rd party tool
> allows you to create reports in Excel that are RS reports, not that it
> importants existing Excel sheets into RS. Excel has an ability to be
> unstructured that RS does not have which make it in my mind highly unlikely
> you will ever see a tool from MS to do what you want. Access is very
> structured (it is a database product after all) which is why they could
> import Access reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gms" <gms@.discussions.microsoft.com> wrote in message
> news:5C29B68B-A8CB-458B-BC1F-C061ABC70F49@.microsoft.com...
> > We have several extensive reports in Excel that I
> > would like to port over to Reporting Services (am in process of testing
> > SQL/RS 2005), if at all possible. From what I understand, the only way to
> > do
> > this is via a third party piece of software, such as OfficeWriterSE for
> > ASP by softartisans.com...
> >
> > A couple questions:
> >
> > 1. Is there an open source alternative to the commercial third party
> > software (the cost of OfficeWriterSE is way beyond our budget)?
> >
> > 2. Does Microsoft plan on ever offering the capability of importing Excel
> > reports into RS? (I do like the ability of importing Access report
> > objects, so why not expand to Excel and Word too)?
> >
> > 3. Should I just forget the whole thing?
> >
> > TIA!
> >
> > Greg--
>
>|||You can click on the 'Upload File' button in ReportServer and proceed
to upload to your heart's content all the Excel files you want to.
They'll open as Excel files within the Report Server's browser with full
Excel functionality. No need to shell out money for a 3rd party solution.
GeoSynch
"gms" <gms@.discussions.microsoft.com> wrote in message
news:5C29B68B-A8CB-458B-BC1F-C061ABC70F49@.microsoft.com...
> We have several extensive reports in Excel that I
> would like to port over to Reporting Services (am in process of testing
> SQL/RS 2005), if at all possible. From what I understand, the only way to do
> this is via a third party piece of software, such as OfficeWriterSE for
> ASP by softartisans.com...
> A couple questions:
> 1. Is there an open source alternative to the commercial third party
> software (the cost of OfficeWriterSE is way beyond our budget)?
> 2. Does Microsoft plan on ever offering the capability of importing Excel
> reports into RS? (I do like the ability of importing Access report
> objects, so why not expand to Excel and Word too)?
> 3. Should I just forget the whole thing?
> TIA!
> Greg--

Monday, March 26, 2012

Exec Process Task problem

EXEC keyword

EXEC keyword

EXEC keyword

EXEC keyword

Wednesday, March 21, 2012

excluding a package from the build process

Friday, March 9, 2012

EXCEPTION_FLT_UNDERFLOW

EXCEPTION_ACCESS_VIOLATION While Excecuting Select Query.

Wednesday, March 7, 2012

EXCEPTION_ACCESS_VIOLATION

Exception handling in Triggers.

Sunday, February 26, 2012

Exception handling in Triggers.

Exception Access Violation

Exception Access Violation

Exception Access Violation

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

Friday, February 24, 2012

Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00402484

Excel versus PDF Rendering

Sunday, February 19, 2012

Excel reports to RS

Excel Import

Blog Archive

About Me