DTS fails on Stored Procedure warning

Hi,
I am calling a stored proc from a DTS package in SQL 2000 using Execute SQL
step & when I try to execute it from DTS, I get 'failed on execution', but
when I run the stored proc manually, it runs fine, but gives a couple of
warnings:
Warning: Null value is eliminated by an aggregate or other SET operation.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any ideas why this happens?
Thanks,
Mo
you can setup an option when you call a dbcc command
generally there is a "no_msg" (or an option like this; read the BOL) which
disabled output except in case of errors.
"Mo" <Mo@.discussions.microsoft.com> wrote in message
news:72063C0B-8791-4666-90A0-8C7C645C2ADF@.microsoft.com...
> Hi,
> I am calling a stored proc from a DTS package in SQL 2000 using Execute
> SQL
> step & when I try to execute it from DTS, I get 'failed on execution', but
> when I run the stored proc manually, it runs fine, but gives a couple of
> warnings:
> Warning: Null value is eliminated by an aggregate or other SET operation.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Any ideas why this happens?
> Thanks,
> Mo
>
sql

DTS fails on Stored Procedure warning

Hi,
I am calling a stored proc from a DTS package in SQL 2000 using Execute SQL
step & when I try to execute it from DTS, I get 'failed on execution', but
when I run the stored proc manually, it runs fine, but gives a couple of
warnings:
Warning: Null value is eliminated by an aggregate or other SET operation.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any ideas why this happens?
Thanks,
Moyou can setup an option when you call a dbcc command
generally there is a "no_msg" (or an option like this; read the BOL) which
disabled output except in case of errors.
"Mo" <Mo@.discussions.microsoft.com> wrote in message
news:72063C0B-8791-4666-90A0-8C7C645C2ADF@.microsoft.com...
> Hi,
> I am calling a stored proc from a DTS package in SQL 2000 using Execute
> SQL
> step & when I try to execute it from DTS, I get 'failed on execution', but
> when I run the stored proc manually, it runs fine, but gives a couple of
> warnings:
> Warning: Null value is eliminated by an aggregate or other SET operation.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Any ideas why this happens?
> Thanks,
> Mo
>

DTC Fails

Please Help!...Recently we started seeing DTC failures between two of our
servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
t was working a week ago and our Network gurus say nothing has changed on the
network.
I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
in the same domain and network segment with no firewall between them. I also
added entries to the host and lmhost files on both.
I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
when run from A, but not from B (it hangs in the bind phase after
successfully completing the RPC portion but no error is retuned)The DTCTester
returns the following when run from either:
Executed: dtctester
DSN: dtctest
User Name: sa
Password:
tablename= #dtc5330
Creating Temp Table for Testing: #dtc5330
Warning: No Columns in Result Set From Executing: 'create table #dtc5330
(ival i
nt)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
If the 2003 server has had sp1 installed recently, this may be your
problem.You will need to change the security settings in DCOM.
"Joe Loyd" wrote:

> Please Help!...Recently we started seeing DTC failures between two of our
> servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> t was working a week ago and our Network gurus say nothing has changed on the
> network.
> I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> in the same domain and network segment with no firewall between them. I also
> added entries to the host and lmhost files on both.
> I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> when run from A, but not from B (it hangs in the bind phase after
> successfully completing the RPC portion but no error is retuned)The DTCTester
> returns the following when run from either:
> Executed: dtctester
> DSN: dtctest
> User Name: sa
> Password:
> tablename= #dtc5330
> Creating Temp Table for Testing: #dtc5330
> Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> (ival i
> nt)'
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
> Driver]
> Distributed transaction error'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
> cur
> sor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
>
|||Thank you for the response! What additional settings need to be made?
"BitWise" wrote:
[vbcol=seagreen]
> If the 2003 server has had sp1 installed recently, this may be your
> problem.You will need to change the security settings in DCOM.
> "Joe Loyd" wrote:
|||At the run command type dcomcnfg.exe
Expand Component services >> Computers >> My Computer
Right click My Computer and choose properties
Click on the MSDTC tab
Choose the Security Configuration Button
Under Transaction Manager Communication group, select No Authentication
Required
Click OK
"Joe Loyd" wrote:
[vbcol=seagreen]
> Thank you for the response! What additional settings need to be made?
> "BitWise" wrote:

DTC Fails

Please Help!...Recently we started seeing DTC failures between two of our
servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
t was working a week ago and our Network gurus say nothing has changed on the
network.
I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
in the same domain and network segment with no firewall between them. I also
added entries to the host and lmhost files on both.
I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
when run from A, but not from B (it hangs in the bind phase after
successfully completing the RPC portion but no error is retuned)The DTCTester
returns the following when run from either:
Executed: dtctester
DSN: dtctest
User Name: sa
Password:
tablename= #dtc5330
Creating Temp Table for Testing: #dtc5330
Warning: No Columns in Result Set From Executing: 'create table #dtc5330
(ival i
nt)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.If the 2003 server has had sp1 installed recently, this may be your
problem.You will need to change the security settings in DCOM.
"Joe Loyd" wrote:
> Please Help!...Recently we started seeing DTC failures between two of our
> servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> t was working a week ago and our Network gurus say nothing has changed on the
> network.
> I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> in the same domain and network segment with no firewall between them. I also
> added entries to the host and lmhost files on both.
> I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> when run from A, but not from B (it hangs in the bind phase after
> successfully completing the RPC portion but no error is retuned)The DTCTester
> returns the following when run from either:
> Executed: dtctester
> DSN: dtctest
> User Name: sa
> Password:
> tablename= #dtc5330
> Creating Temp Table for Testing: #dtc5330
> Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> (ival i
> nt)'
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
> Driver]
> Distributed transaction error'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
> cur
> sor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
>|||Thank you for the response! What additional settings need to be made?
"BitWise" wrote:
> If the 2003 server has had sp1 installed recently, this may be your
> problem.You will need to change the security settings in DCOM.
> "Joe Loyd" wrote:
> > Please Help!...Recently we started seeing DTC failures between two of our
> > servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> > t was working a week ago and our Network gurus say nothing has changed on the
> > network.
> >
> > I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> > in the same domain and network segment with no firewall between them. I also
> > added entries to the host and lmhost files on both.
> >
> > I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> > when run from A, but not from B (it hangs in the bind phase after
> > successfully completing the RPC portion but no error is retuned)The DTCTester
> > returns the following when run from either:
> >
> > Executed: dtctester
> > DSN: dtctest
> > User Name: sa
> > Password:
> > tablename= #dtc5330
> > Creating Temp Table for Testing: #dtc5330
> > Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> > (ival i
> > nt)'
> > Initializing DTC
> > Beginning DTC Transaction
> > Enlisting Connection in Transaction
> > Error:
> > SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
> > Driver]
> > Distributed transaction error'
> > Error:
> > SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
> > cur
> > sor state
> > Typical Errors in DTC Output When
> > a. Firewall Has Ports Closed
> > -OR-
> > b. Bad WINS/DNS entries
> > -OR-
> > c. Misconfigured network
> > -OR-
> > d. Misconfigured SQL Server machine that has multiple netcards.
> > Aborting DTC Transaction
> > Releasing DTC Interface Pointers
> > Successfully Released pTransaction Pointer.
> >
> >|||At the run command type dcomcnfg.exe
Expand Component services >> Computers >> My Computer
Right click My Computer and choose properties
Click on the MSDTC tab
Choose the Security Configuration Button
Under Transaction Manager Communication group, select No Authentication
Required
Click OK
"Joe Loyd" wrote:
> Thank you for the response! What additional settings need to be made?
> "BitWise" wrote:
> > If the 2003 server has had sp1 installed recently, this may be your
> > problem.You will need to change the security settings in DCOM.
> >
> > "Joe Loyd" wrote:
> >
> > > Please Help!...Recently we started seeing DTC failures between two of our
> > > servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> > > t was working a week ago and our Network gurus say nothing has changed on the
> > > network.
> > >
> > > I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> > > in the same domain and network segment with no firewall between them. I also
> > > added entries to the host and lmhost files on both.
> > >
> > > I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> > > when run from A, but not from B (it hangs in the bind phase after
> > > successfully completing the RPC portion but no error is retuned)The DTCTester
> > > returns the following when run from either:
> > >
> > > Executed: dtctester
> > > DSN: dtctest
> > > User Name: sa
> > > Password:
> > > tablename= #dtc5330
> > > Creating Temp Table for Testing: #dtc5330
> > > Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> > > (ival i
> > > nt)'
> > > Initializing DTC
> > > Beginning DTC Transaction
> > > Enlisting Connection in Transaction
> > > Error:
> > > SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
> > > Driver]
> > > Distributed transaction error'
> > > Error:
> > > SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
> > > cur
> > > sor state
> > > Typical Errors in DTC Output When
> > > a. Firewall Has Ports Closed
> > > -OR-
> > > b. Bad WINS/DNS entries
> > > -OR-
> > > c. Misconfigured network
> > > -OR-
> > > d. Misconfigured SQL Server machine that has multiple netcards.
> > > Aborting DTC Transaction
> > > Releasing DTC Interface Pointers
> > > Successfully Released pTransaction Pointer.
> > >
> > >

DTC Fails

Please Help!...Recently we started seeing DTC failures between two of our
servers. The calling server(A) is Win2003 and the destination (B) is Win2K.
I
t was working a week ago and our Network gurus say nothing has changed on th
e
network.
I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
in the same domain and network segment with no firewall between them. I also
added entries to the host and lmhost files on both.
I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
when run from A, but not from B (it hangs in the bind phase after
successfully completing the RPC portion but no error is retuned)The DTCTeste
r
returns the following when run from either:
Executed: dtctester
DSN: dtctest
User Name: sa
Password:
tablename= #dtc5330
Creating Temp Table for Testing: #dtc5330
Warning: No Columns in Result Set From Executing: 'create table #dtc5330
(ival i
nt)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Se
rver
Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver
]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.If the 2003 server has had sp1 installed recently, this may be your
problem.You will need to change the security settings in DCOM.
"Joe Loyd" wrote:

> Please Help!...Recently we started seeing DTC failures between two of our
> servers. The calling server(A) is Win2003 and the destination (B) is Win2K
. I
> t was working a week ago and our Network gurus say nothing has changed on
the
> network.
> I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> in the same domain and network segment with no firewall between them. I al
so
> added entries to the host and lmhost files on both.
> I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succee
ds
> when run from A, but not from B (it hangs in the bind phase after
> successfully completing the RPC portion but no error is retuned)The DTCTes
ter
> returns the following when run from either:
> Executed: dtctester
> DSN: dtctest
> User Name: sa
> Password:
> tablename= #dtc5330
> Creating Temp Table for Testing: #dtc5330
> Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> (ival i
> nt)'
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL
Server
> Driver]
> Distributed transaction error'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driv
er]Invalid
> cur
> sor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
>|||Thank you for the response! What additional settings need to be made?
"BitWise" wrote:
[vbcol=seagreen]
> If the 2003 server has had sp1 installed recently, this may be your
> problem.You will need to change the security settings in DCOM.
> "Joe Loyd" wrote:
>|||At the run command type dcomcnfg.exe
Expand Component services >> Computers >> My Computer
Right click My Computer and choose properties
Click on the MSDTC tab
Choose the Security Configuration Button
Under Transaction Manager Communication group, select No Authentication
Required
Click OK
"Joe Loyd" wrote:
[vbcol=seagreen]
> Thank you for the response! What additional settings need to be made?
> "BitWise" wrote:
>