Hi,
I try to repair DB that is in state Emergency Mode, but execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la p=E1gina (1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecuci=F3n de DBCC completada. Si hay mensajes de error, consulte al
administrador del sistema.
How do i for repair the DB?
Than'kFrom Google translation page:
A latch in the page (1:177) with the type of latch SH. Error in sysindexes
cannot be read and be established.
(Pretty good translation actually)
One of the pages in the leaf level of the sysindexes clustered index is
corrupt. This error cannot be repaired so you'll have to revert to your
disaster recovery strategy. I recommend you call Product Support to help you
out. (http://support.microsoft.com)
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ivan Alexander Laverde" <anonymous@.discussions.microsoft.com> wrote in
message news:104c001c43f4c$d6aaaaf0$a101280a@.phx.gbl...
Hi,
I try to repair DB that is in state Emergency Mode, but
execute it the following instruction:
dbcc checkdb ('viaticos', REPAIR_ALLOW_DATA_LOSS )
with ALL_ERRORMSGS
show the error
Server: Msg 8966, Level 16, State 1, Line 1
No se puede leer y establecer un pestillo en la página
(1:177) con el tipo de
pestillo SH. Error en sysindexes.
Ejecución de DBCC completada. Si hay mensajes de error,
consulte al
administrador del sistema.
How do i for repair the DB?
Than'k
Showing posts with label execute. Show all posts
Showing posts with label execute. Show all posts
Thursday, March 29, 2012
Monday, March 26, 2012
error ora -00937
hi,
what's the problem?
When I execute this query
select decode((magazzino.QUANTIT - (count(noleggio.data_noleggio) + count(prenotazione.data_prenotazione))),0,'false', 1,'true','true') as disponibile
from MAGAZZINO,FILM,PRENOTAZIONE,NOLEGGIO,NEGOZIO
where magazzino.codfilm=film.idfilm and magazzino.CODNEGOZIO=negozio.idnegozio
and prenotazione.codfilm=film.idfilm and prenotazione.CODNEGOZIO=negozio.idnegozio
and noleggio.codfilm=film.idfilm and noleggio.CODNEGOZIO=negozio.idnegozio
and film.titolo='Matrix' and negozio.idnegozio=1
the result is:
Error: ORA-00937: not a single-group group function.
Thank you ElisaHello, the problem is that you use a aggregate command "count" in the select statement and Oracle does not know how to hande the field
magazzino.QUANTIT ...
magazzino.QUANTIT -> every record
count -> aggregate of result set
use the group by function or an inner select to calculate the count of your fields.
Hope that helps ?
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com
Originally posted by trilly
hi,
what's the problem?
When I execute this query
select decode((magazzino.QUANTIT - (count(noleggio.data_noleggio) + count(prenotazione.data_prenotazione))),0,'false', 1,'true','true') as disponibile
from MAGAZZINO,FILM,PRENOTAZIONE,NOLEGGIO,NEGOZIO
where magazzino.codfilm=film.idfilm and magazzino.CODNEGOZIO=negozio.idnegozio
and prenotazione.codfilm=film.idfilm and prenotazione.CODNEGOZIO=negozio.idnegozio
and noleggio.codfilm=film.idfilm and noleggio.CODNEGOZIO=negozio.idnegozio
and film.titolo='Matrix' and negozio.idnegozio=1
the result is:
Error: ORA-00937: not a single-group group function.
Thank you Elisa|||Originally posted by trilly
hi,
what's the problem?
When I execute this query
select decode((magazzino.QUANTIT - (count(noleggio.data_noleggio) + count(prenotazione.data_prenotazione))),0,'false', 1,'true','true') as disponibile
from MAGAZZINO,FILM,PRENOTAZIONE,NOLEGGIO,NEGOZIO
where magazzino.codfilm=film.idfilm and magazzino.CODNEGOZIO=negozio.idnegozio
and prenotazione.codfilm=film.idfilm and prenotazione.CODNEGOZIO=negozio.idnegozio
and noleggio.codfilm=film.idfilm and noleggio.CODNEGOZIO=negozio.idnegozio
and film.titolo='Matrix' and negozio.idnegozio=1
the result is:
Error: ORA-00937: not a single-group group function.
Thank you Elisa
When you use aggregate functions like COUNT together with other columns, you have to add a GROUP BY clause to the query. For example, this doesn't work:
SQL> select deptno, count(*)
2 from emp
3 /
select deptno, count(*)
*
ERROR at line 1:
ORA-00937: not a single-group group function
But this does:
SQL> select deptno, count(*)
2 from emp
3 group by deptno;
DEPTNO COUNT(*)
---- ----
10 3
20 5
30 6
I don't understand what your query is trying to do. Perhaps if you explain the requirement, we can advise on the proper syntax.|||Originally posted by andrewst
When you use aggregate functions like COUNT together with other columns, you have to add a GROUP BY clause to the query. For example, this doesn't work:
SQL> select deptno, count(*)
2 from emp
3 /
select deptno, count(*)
*
ERROR at line 1:
ORA-00937: not a single-group group function
But this does:
SQL> select deptno, count(*)
2 from emp
3 group by deptno;
DEPTNO COUNT(*)
---- ----
10 3
20 5
30 6
I don't understand what your query is trying to do. Perhaps if you explain the requirement, we can advise on the proper syntax.
I want to know how many dvd or vhs for a specific film I have into a particular negozio.
The total number of films that I have into my negozio is contained on the table magazzino ,I have to count the total number of films that are out of my negozio ,counting reservations and rents which are in the table "prenotazione" e "noleggio" for that film in that negozio for that types of support.
do you understand?thank you elisa and my english teacher elena
Table:
CREATE TABLE Magazzino
(CodFilm NUMBER(7) NOT NULL,
CodNegozio NUMBER(8) NOT NULL,
Tipo VARCHAR2(3) NOT NULL,
Quantit NUMBER(4) NOT NULL,
Evetuali_Commenti VARCHAR2(30),
PRIMARY KEY(CodFilm,CodNegozio,Tipo)
FOREIGN KEY(CodNegozio)
REFERENCES Negozio(IdNegozio)
ON DELETE CASCADE,
FOREIGN KEY(CodFilm)
REFERENCES Film(IdFilm)
ON DELETE CASCADE)
CREATE TABLE Prenotazione
(CodFilm NUMBER(7) NOT NULL,
CodNegozio NUMBER(8) NOT NULL,
CodCliente VARCHAR(10) NOT NULL,
Data_Prenotazione NUMBER(8) NOT NULL,
Ora_Prenotazione NUMBER(5) NOT NULL,
Data_Scadenza_Prenotazione NUMBER(8) NOT NULL,
Ora_Scadenza_Prenotazione NUMBER(5) NOT NULL,
Supporto VARCHAR2(3) NOT NULL,
PRIMARY KEY(CodFilm,CodNegozio,CodCliente,Data_Prenotazion e,Ora_Prenotazione,Supporto)
FOREIGN KEY(CodNegozio)
REFERENCES Negozio(IdNegozio)
ON DELETE CASCADE,
FOREIGN KEY(CodFilm)
REFERENCES Film(IdFilm)
ON DELETE CASCADE,
FOREIGN KEY(CodCliente)
REFERENCES Cliente(User_id)
ON DELETE CASCADE)
CREATE TABLE Noleggio
(CodFilm NUMBER(7) NOT NULL,
CodNegozio NUMBER(8) NOT NULL,
CodCliente VARCHAR(10) NOT NULL,
Data_Noleggio NUMBER(8) NOT NULL,
Ora_Noleggio NUMBER(5) NOT NULL,
Supporto VARCHAR2(3) NOT NULL,
PRIMARY KEY (CodFilm,CodNegozio,CodCliente,Data_noleggio,Ora_N oleggio,Supporto)
FOREIGN KEY(CodNegozio)
REFERENCES Negozio(IdNegozio)
ON DELETE CASCADE,
FOREIGN KEY(CodFilm)
REFERENCES Film(IdFilm)
ON DELETE CASCADE,
FOREIGN KEY(CodCliente)
REFERNCES Cliente(User_id)
ON DELETE CASCADE)|||I can't write the query, but it sounds like you want to do this:
1) count number of records in Magazzino for that film = A
2) count number of records in Prenotazione for that film = B
3) count number of records in Noleggio for that film = C
4) Return answer = A - B - C
This can be done using "scalar subqueries", like this:
SELECT (select count(*) from Magazzino where ... )
- (select count(*) from Prenotazione where ... )
- (select count(*) from Noleggio where ... )
FROM DUAL;
If required, each scalar subquery can be joined to the outer query, e.g.
SELECT (select count(*) from Magazzino M where M.codfilm = F.idfilm AND... )
- (select count(*) from Prenotazione P where P.codfilm = F.idfilm AND... )
- (select count(*) from Noleggio N where N.codfilm = F.idfilm AND... )
FROM film F, ...
WHERE F.titolo='Matrix'
AND ...;
Hope that gets you started.|||Originally posted by andrewst
I can't write the query, but it sounds like you want to do this:
1) count number of records in Magazzino for that film = A
2) count number of records in Prenotazione for that film = B
3) count number of records in Noleggio for that film = C
4) Return answer = A - B - C
This can be done using "scalar subqueries", like this:
SELECT (select count(*) from Magazzino where ... )
- (select count(*) from Prenotazione where ... )
- (select count(*) from Noleggio where ... )
FROM DUAL;
If required, each scalar subquery can be joined to the outer query, e.g.
SELECT (select count(*) from Magazzino M where M.codfilm = F.idfilm AND... )
- (select count(*) from Prenotazione P where P.codfilm = F.idfilm AND... )
- (select count(*) from Noleggio N where N.codfilm = F.idfilm AND... )
FROM film F, ...
WHERE F.titolo='Matrix'
AND ...;
Hope that gets you started.
Thank you very much for your avaiable, Elisa
what's the problem?
When I execute this query
select decode((magazzino.QUANTIT - (count(noleggio.data_noleggio) + count(prenotazione.data_prenotazione))),0,'false', 1,'true','true') as disponibile
from MAGAZZINO,FILM,PRENOTAZIONE,NOLEGGIO,NEGOZIO
where magazzino.codfilm=film.idfilm and magazzino.CODNEGOZIO=negozio.idnegozio
and prenotazione.codfilm=film.idfilm and prenotazione.CODNEGOZIO=negozio.idnegozio
and noleggio.codfilm=film.idfilm and noleggio.CODNEGOZIO=negozio.idnegozio
and film.titolo='Matrix' and negozio.idnegozio=1
the result is:
Error: ORA-00937: not a single-group group function.
Thank you ElisaHello, the problem is that you use a aggregate command "count" in the select statement and Oracle does not know how to hande the field
magazzino.QUANTIT ...
magazzino.QUANTIT -> every record
count -> aggregate of result set
use the group by function or an inner select to calculate the count of your fields.
Hope that helps ?
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com
Originally posted by trilly
hi,
what's the problem?
When I execute this query
select decode((magazzino.QUANTIT - (count(noleggio.data_noleggio) + count(prenotazione.data_prenotazione))),0,'false', 1,'true','true') as disponibile
from MAGAZZINO,FILM,PRENOTAZIONE,NOLEGGIO,NEGOZIO
where magazzino.codfilm=film.idfilm and magazzino.CODNEGOZIO=negozio.idnegozio
and prenotazione.codfilm=film.idfilm and prenotazione.CODNEGOZIO=negozio.idnegozio
and noleggio.codfilm=film.idfilm and noleggio.CODNEGOZIO=negozio.idnegozio
and film.titolo='Matrix' and negozio.idnegozio=1
the result is:
Error: ORA-00937: not a single-group group function.
Thank you Elisa|||Originally posted by trilly
hi,
what's the problem?
When I execute this query
select decode((magazzino.QUANTIT - (count(noleggio.data_noleggio) + count(prenotazione.data_prenotazione))),0,'false', 1,'true','true') as disponibile
from MAGAZZINO,FILM,PRENOTAZIONE,NOLEGGIO,NEGOZIO
where magazzino.codfilm=film.idfilm and magazzino.CODNEGOZIO=negozio.idnegozio
and prenotazione.codfilm=film.idfilm and prenotazione.CODNEGOZIO=negozio.idnegozio
and noleggio.codfilm=film.idfilm and noleggio.CODNEGOZIO=negozio.idnegozio
and film.titolo='Matrix' and negozio.idnegozio=1
the result is:
Error: ORA-00937: not a single-group group function.
Thank you Elisa
When you use aggregate functions like COUNT together with other columns, you have to add a GROUP BY clause to the query. For example, this doesn't work:
SQL> select deptno, count(*)
2 from emp
3 /
select deptno, count(*)
*
ERROR at line 1:
ORA-00937: not a single-group group function
But this does:
SQL> select deptno, count(*)
2 from emp
3 group by deptno;
DEPTNO COUNT(*)
---- ----
10 3
20 5
30 6
I don't understand what your query is trying to do. Perhaps if you explain the requirement, we can advise on the proper syntax.|||Originally posted by andrewst
When you use aggregate functions like COUNT together with other columns, you have to add a GROUP BY clause to the query. For example, this doesn't work:
SQL> select deptno, count(*)
2 from emp
3 /
select deptno, count(*)
*
ERROR at line 1:
ORA-00937: not a single-group group function
But this does:
SQL> select deptno, count(*)
2 from emp
3 group by deptno;
DEPTNO COUNT(*)
---- ----
10 3
20 5
30 6
I don't understand what your query is trying to do. Perhaps if you explain the requirement, we can advise on the proper syntax.
I want to know how many dvd or vhs for a specific film I have into a particular negozio.
The total number of films that I have into my negozio is contained on the table magazzino ,I have to count the total number of films that are out of my negozio ,counting reservations and rents which are in the table "prenotazione" e "noleggio" for that film in that negozio for that types of support.
do you understand?thank you elisa and my english teacher elena
Table:
CREATE TABLE Magazzino
(CodFilm NUMBER(7) NOT NULL,
CodNegozio NUMBER(8) NOT NULL,
Tipo VARCHAR2(3) NOT NULL,
Quantit NUMBER(4) NOT NULL,
Evetuali_Commenti VARCHAR2(30),
PRIMARY KEY(CodFilm,CodNegozio,Tipo)
FOREIGN KEY(CodNegozio)
REFERENCES Negozio(IdNegozio)
ON DELETE CASCADE,
FOREIGN KEY(CodFilm)
REFERENCES Film(IdFilm)
ON DELETE CASCADE)
CREATE TABLE Prenotazione
(CodFilm NUMBER(7) NOT NULL,
CodNegozio NUMBER(8) NOT NULL,
CodCliente VARCHAR(10) NOT NULL,
Data_Prenotazione NUMBER(8) NOT NULL,
Ora_Prenotazione NUMBER(5) NOT NULL,
Data_Scadenza_Prenotazione NUMBER(8) NOT NULL,
Ora_Scadenza_Prenotazione NUMBER(5) NOT NULL,
Supporto VARCHAR2(3) NOT NULL,
PRIMARY KEY(CodFilm,CodNegozio,CodCliente,Data_Prenotazion e,Ora_Prenotazione,Supporto)
FOREIGN KEY(CodNegozio)
REFERENCES Negozio(IdNegozio)
ON DELETE CASCADE,
FOREIGN KEY(CodFilm)
REFERENCES Film(IdFilm)
ON DELETE CASCADE,
FOREIGN KEY(CodCliente)
REFERENCES Cliente(User_id)
ON DELETE CASCADE)
CREATE TABLE Noleggio
(CodFilm NUMBER(7) NOT NULL,
CodNegozio NUMBER(8) NOT NULL,
CodCliente VARCHAR(10) NOT NULL,
Data_Noleggio NUMBER(8) NOT NULL,
Ora_Noleggio NUMBER(5) NOT NULL,
Supporto VARCHAR2(3) NOT NULL,
PRIMARY KEY (CodFilm,CodNegozio,CodCliente,Data_noleggio,Ora_N oleggio,Supporto)
FOREIGN KEY(CodNegozio)
REFERENCES Negozio(IdNegozio)
ON DELETE CASCADE,
FOREIGN KEY(CodFilm)
REFERENCES Film(IdFilm)
ON DELETE CASCADE,
FOREIGN KEY(CodCliente)
REFERNCES Cliente(User_id)
ON DELETE CASCADE)|||I can't write the query, but it sounds like you want to do this:
1) count number of records in Magazzino for that film = A
2) count number of records in Prenotazione for that film = B
3) count number of records in Noleggio for that film = C
4) Return answer = A - B - C
This can be done using "scalar subqueries", like this:
SELECT (select count(*) from Magazzino where ... )
- (select count(*) from Prenotazione where ... )
- (select count(*) from Noleggio where ... )
FROM DUAL;
If required, each scalar subquery can be joined to the outer query, e.g.
SELECT (select count(*) from Magazzino M where M.codfilm = F.idfilm AND... )
- (select count(*) from Prenotazione P where P.codfilm = F.idfilm AND... )
- (select count(*) from Noleggio N where N.codfilm = F.idfilm AND... )
FROM film F, ...
WHERE F.titolo='Matrix'
AND ...;
Hope that gets you started.|||Originally posted by andrewst
I can't write the query, but it sounds like you want to do this:
1) count number of records in Magazzino for that film = A
2) count number of records in Prenotazione for that film = B
3) count number of records in Noleggio for that film = C
4) Return answer = A - B - C
This can be done using "scalar subqueries", like this:
SELECT (select count(*) from Magazzino where ... )
- (select count(*) from Prenotazione where ... )
- (select count(*) from Noleggio where ... )
FROM DUAL;
If required, each scalar subquery can be joined to the outer query, e.g.
SELECT (select count(*) from Magazzino M where M.codfilm = F.idfilm AND... )
- (select count(*) from Prenotazione P where P.codfilm = F.idfilm AND... )
- (select count(*) from Noleggio N where N.codfilm = F.idfilm AND... )
FROM film F, ...
WHERE F.titolo='Matrix'
AND ...;
Hope that gets you started.
Thank you very much for your avaiable, Elisa
Wednesday, March 21, 2012
Error on Executing SSIS packages on a remote machine using code
Hello all,
I am trying to execute the ssis packages using code.These packages are hosted on remote server under MSDB in local Network.
Below is the code tried to Execute
--
DTSExecResult execRslt = _dtsxPackage.Execute();
foreach (DtsError dtserr in _dtsxPackage.Errors)
{
Console.WriteLine("Source: " + dtserr.Source + ", Description: " + dtserr.Description);
}
I get hte following Error
--
"Dupaco Load MMAs"-"An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80004005 Description: \"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\".\r\n"
"Data Flow Task" -"The AcquireConnection method call to the connection manager \"Dupaco\" failed with error code 0xC0202009.\r\n"
"Data Flow Task" -"component \"OLE DB Destination\" (119) failed validation and returned error code 0xC020801C.\r\n"
"One or more component failed validation.\r\n"
"There were errors during task validation.\r\n"
When i try to execute the same code on the server where all the package are hosted. It is working fine.
More Info:
In thepackage we are using one "Source Flat file connection" and one "Oledb Destination connection"
Please help me to solve this problem, as my client needs it very badly
Thanks
Subin
Subin wrote:
"Dupaco Load MMAs"-"An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80004005 Description: \"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\".\r\n"
The problem appears to be that whatever address or alias was used to create the OLE DB connection can't be resolved from where the package is executing. Maybe it was set up using (local) or something. Maybe the server doesn't allow TCP/IP connections (the default for SQL Server 2005).
|||
Hi Jay,
Earlier We were using sql server name now we have changes that to IP address,
we have saved the password in the "Oledb Destination connection" by checking in the checkbox to save the password.
now we are getting the following Error
"An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\n"
|||
"An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\n"
I've already answered that one today, so all you get is a link.
See if this helps.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1453667&SiteID=1
|||
"An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\n"
Are you intending to be logging in as the user 'sa'?|||
Hello all,
I am trying to execute the ssis packages using code.These packages are hosted on remote server under MSDB in local Network.
...
To clarify possible confusion: you are not executing the package on a remote machine (as the title of your question suggests).
You are loading package from a remote machine and running it locally (where your application runs).
http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx
Michael.
|||Hello Michael,
You are absolutely correct. Sorry for confusion.
I am not executing the package on a remote machine (as the title of question suggests),loading package from a remote machine and running it locally (where my application runs).
Thanks
Subin
|||Hello All,
Thank you all for help.
I have solved the problem.
The package which i had tried to execute was a password protected package and I was not setting the PackagePassword property of Application class before loading package from remote machine. So that the loaded package does not have sensitive information. That was the problem.
Application app = new Application();
app.PackagePassword = "test";
Package package = app.LoadFromSqlServer(@."PackTest", "Circle-DotNet57", "ssisdeveloper", "circle_123", null);
//package.ProtectionLevel = DTSProtectionLevel.EncryptSensitiveWithPassword;
//package.PackagePassword = "test";
DTSExecResult result = package.Execute();
Thank you
Subin
Error on Executing SSIS packages on a remote machine using code
Hello all,
I am trying to execute the ssis packages using code.These packages are hosted on remote server under MSDB in local Network.
Below is the code tried to Execute
--
DTSExecResult execRslt = _dtsxPackage.Execute();
foreach (DtsError dtserr in _dtsxPackage.Errors)
{
Console.WriteLine("Source: " + dtserr.Source + ", Description: " + dtserr.Description);
}
I get hte following Error
--
"Dupaco Load MMAs"-"An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80004005 Description: \"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\".\r\n"
"Data Flow Task" -"The AcquireConnection method call to the connection manager \"Dupaco\" failed with error code 0xC0202009.\r\n"
"Data Flow Task" -"component \"OLE DB Destination\" (119) failed validation and returned error code 0xC020801C.\r\n"
"One or more component failed validation.\r\n"
"There were errors during task validation.\r\n"
When i try to execute the same code on the server where all the package are hosted. It is working fine.
More Info:
In thepackage we are using one "Source Flat file connection" and one "Oledb Destination connection"
Please help me to solve this problem, as my client needs it very badly
Thanks
Subin
"Dupaco Load MMAs"-"An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80004005 Description: \"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\".\r\n"
The problem appears to be that whatever address or alias was used to create the OLE DB connection can't be resolved from where the package is executing. Maybe it was set up using (local) or something. Maybe the server doesn't allow TCP/IP connections (the default for SQL Server 2005).
|||
Hi Jay,
Earlier We were using sql server name now we have changes that to IP address,
we have saved the password in the "Oledb Destination connection" by checking in the checkbox to save the password.
now we are getting the following Error
"An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\n"
|||
"An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\n"
I've already answered that one today, so all you get is a link.
See if this helps.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1453667&SiteID=1
|||
"An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft OLE DB Provider for SQL Server\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\n"
Are you intending to be logging in as the user 'sa'?|||
Hello all,
I am trying to execute the ssis packages using code.These packages are hosted on remote server under MSDB in local Network.
...
To clarify possible confusion: you are not executing the package on a remote machine (as the title of your question suggests).
You are loading package from a remote machine and running it locally (where your application runs).
http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx
Michael.
|||Hello Michael,
You are absolutely correct. Sorry for confusion.
I am not executing the package on a remote machine (as the title of question suggests),loading package from a remote machine and running it locally (where my application runs).
Thanks
Subin
|||Hello All,
Thank you all for help.
I have solved the problem.
The package which i had tried to execute was a password protected package and I was not setting the PackagePassword property of Application class before loading package from remote machine. So that the loaded package does not have sensitive information. That was the problem.
Application app = new Application();
app.PackagePassword = "test";
Package package = app.LoadFromSqlServer(@."PackTest", "Circle-DotNet57", "ssisdeveloper", "circle_123", null);
//package.ProtectionLevel = DTSProtectionLevel.EncryptSensitiveWithPassword;
//package.PackagePassword = "test";
DTSExecResult result = package.Execute();
Thank you
Subin
Friday, March 9, 2012
error Multi-part identifier
After OK parse, I try to execute this statement in a trigger:
if inserted.col1 = 10 --col1 type int
--do instruction
But I have this message:
The multi-part identifier "inserted.col1" could not be bound.
What is this problem'
How can I resolve it?
Thanks!
Good night!Inserted is a "table" that can have many rows in it (1 for each row inserted
or updated in the statement that fired the trigger). As such, you could do
something like this:
SELECT @.variable = col1 FROM Inserted
IF @.Variable = 10 ...
However, this will only get the col1 value from 1 of the rows in the
inserted table.
Show us the rest of the code in your trigger and we can likely help you
write it using a set based solution that will handle multiple rows in the
inserted table.
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!|||You can't do a direct comparison on a column in a table in an IF statement.
It's pretty tough to tell you what the appropriate syntax should be without
knowing more about what you are trying to do. In any case you should always
code triggers to account for multiple rows being affected. What you are
trying to do infers only one row is ever affected which will ultimately get
you in trouble.
Andrew J. Kelly SQL MVP
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!
if inserted.col1 = 10 --col1 type int
--do instruction
But I have this message:
The multi-part identifier "inserted.col1" could not be bound.
What is this problem'
How can I resolve it?
Thanks!
Good night!Inserted is a "table" that can have many rows in it (1 for each row inserted
or updated in the statement that fired the trigger). As such, you could do
something like this:
SELECT @.variable = col1 FROM Inserted
IF @.Variable = 10 ...
However, this will only get the col1 value from 1 of the rows in the
inserted table.
Show us the rest of the code in your trigger and we can likely help you
write it using a set based solution that will handle multiple rows in the
inserted table.
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!|||You can't do a direct comparison on a column in a table in an IF statement.
It's pretty tough to tell you what the appropriate syntax should be without
knowing more about what you are trying to do. In any case you should always
code triggers to account for multiple rows being affected. What you are
trying to do infers only one row is ever affected which will ultimately get
you in trouble.
Andrew J. Kelly SQL MVP
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:7BBC3219-4A58-4561-8DBA-95CF54E46489@.microsoft.com...
> After OK parse, I try to execute this statement in a trigger:
> if inserted.col1 = 10 --col1 type int
> --do instruction
> But I have this message:
> The multi-part identifier "inserted.col1" could not be bound.
> What is this problem'
> How can I resolve it?
> Thanks!
> Good night!
Wednesday, March 7, 2012
Error messages logging and copying.
Hi:
How can I copy the error messages when I execute a SSIS package?. The Progress tab or the Execution results tab both dont have the means to copy the results. I would like the errors to be output to a text file under a directory on my drive system (some thing like C:\SSIS\ExecResults.txt). Is this possible?. If so how do I configure my package to output the package execution results to a text file?.
Any help/suggestions/comments highly appreciated.
Thanks
AK
Right click the package control flow and select Logging. Create and configure text log provider to output events that you want to the text file.Books Online has detailed instructions on this. By the way, we just release July update to BOL, it is worth download time:
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
Error Message: sp_replcmds
I receive this error for one of my Transactional
Replications..
The Process Could Not Execute sp_replcmds
Any ideas?
There are several causes for this error.
Please enable logging as per the below kb article and post the results back here.
http://support.microsoft.com/default...b;EN-US;312292
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"niv" wrote:
> I receive this error for one of my Transactional
> Replications..
> The Process Could Not Execute sp_replcmds
> Any ideas?
>
|||Niv, to run sp_replcmds you have to turn off the logreader, as the
connection you are using needs to effectively become the logreader itself.
Alternatively try sp_repltrans.
HTH,
Paul Ibison
|||I received this:
The step did not produce any output. The step failed.
>--Original Message--
>There are several causes for this error.
>Please enable logging as per the below kb article and
post the results back here.
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;312292
>--
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>
>"niv" wrote:
>.
>
|||Is the log reader stuck on initializing? If so you have to try the following
1) stop SQL Server agent, and restart it to see if this clears the error
2) stop SQL Server, and restart it to see if this clears the error
3) reboot, and see if this clears the error
IF you don't even get the initialization error, please post the command string for your log reader agent here.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" wrote:
> Niv, to run sp_replcmds you have to turn off the logreader, as the
> connection you are using needs to effectively become the logreader itself.
> Alternatively try sp_repltrans.
> HTH,
> Paul Ibison
>
>
|||Hillary,
I have given up on trying to resolve this issue.
My solution was to delete the transactional replication
that I set up and create a merge replication instead.
Thanks for your help. I appreciate your quick replies and
your expert advice.
niv
BTW: I am sure that I will have a lot more questions for
you in the near future.. so rest up.
>--Original Message--
>Is the log reader stuck on initializing? If so you have
to try the following
>1) stop SQL Server agent, and restart it to see if this
clears the error
>2) stop SQL Server, and restart it to see if this clears
the error
>3) reboot, and see if this clears the error
>IF you don't even get the initialization error, please
post the command string for your log reader agent here.[vbcol=seagreen]
>
>--
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>
>"Paul Ibison" wrote:
logreader, as the[vbcol=seagreen]
the logreader itself.
>.
>
Replications..
The Process Could Not Execute sp_replcmds
Any ideas?
There are several causes for this error.
Please enable logging as per the below kb article and post the results back here.
http://support.microsoft.com/default...b;EN-US;312292
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"niv" wrote:
> I receive this error for one of my Transactional
> Replications..
> The Process Could Not Execute sp_replcmds
> Any ideas?
>
|||Niv, to run sp_replcmds you have to turn off the logreader, as the
connection you are using needs to effectively become the logreader itself.
Alternatively try sp_repltrans.
HTH,
Paul Ibison
|||I received this:
The step did not produce any output. The step failed.
>--Original Message--
>There are several causes for this error.
>Please enable logging as per the below kb article and
post the results back here.
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;312292
>--
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>
>"niv" wrote:
>.
>
|||Is the log reader stuck on initializing? If so you have to try the following
1) stop SQL Server agent, and restart it to see if this clears the error
2) stop SQL Server, and restart it to see if this clears the error
3) reboot, and see if this clears the error
IF you don't even get the initialization error, please post the command string for your log reader agent here.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" wrote:
> Niv, to run sp_replcmds you have to turn off the logreader, as the
> connection you are using needs to effectively become the logreader itself.
> Alternatively try sp_repltrans.
> HTH,
> Paul Ibison
>
>
|||Hillary,
I have given up on trying to resolve this issue.
My solution was to delete the transactional replication
that I set up and create a merge replication instead.
Thanks for your help. I appreciate your quick replies and
your expert advice.
niv
BTW: I am sure that I will have a lot more questions for
you in the near future.. so rest up.
>--Original Message--
>Is the log reader stuck on initializing? If so you have
to try the following
>1) stop SQL Server agent, and restart it to see if this
clears the error
>2) stop SQL Server, and restart it to see if this clears
the error
>3) reboot, and see if this clears the error
>IF you don't even get the initialization error, please
post the command string for your log reader agent here.[vbcol=seagreen]
>
>--
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>
>"Paul Ibison" wrote:
logreader, as the[vbcol=seagreen]
the logreader itself.
>.
>
Wednesday, February 15, 2012
Error message
Hello,
If a execute a query
SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
Expr5,
0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
FROM Zahlungen INNER JOIN
Kunde ON Zahlungen.KundeID = Kunde.ID
WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
Zahlungen.Periode = '200713' OR
Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
0)
I get an error message:
Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 56
Process ID: 296
Die Verbindung wurde unterbrochen.
If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
the error message.
It seams to bee a new problem, because on Tuesday it worked.
Many thanks for your support and best Regards.
StefanPossibly a data corruption. Check out DBCC CHECKDB.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stefan Braun" <stefan@.braun.name> wrote in message news:58osl6F2hrlctU1@.mid.individual.net...
> Hello,
> If a execute a query
> SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
> Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
> Expr5,
> 0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
> FROM Zahlungen INNER JOIN
> Kunde ON Zahlungen.KundeID = Kunde.ID
> WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
> Zahlungen.Periode = '200713' OR
> Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
> 0)
> I get an error message:
> Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
> Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
> SPID: 56
> Process ID: 296
> Die Verbindung wurde unterbrochen.
> If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
> the error message.
> It seams to bee a new problem, because on Tuesday it worked.
> Many thanks for your support and best Regards.
> Stefan
>
>
>
If a execute a query
SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
Expr5,
0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
FROM Zahlungen INNER JOIN
Kunde ON Zahlungen.KundeID = Kunde.ID
WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
Zahlungen.Periode = '200713' OR
Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
0)
I get an error message:
Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 56
Process ID: 296
Die Verbindung wurde unterbrochen.
If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
the error message.
It seams to bee a new problem, because on Tuesday it worked.
Many thanks for your support and best Regards.
StefanPossibly a data corruption. Check out DBCC CHECKDB.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stefan Braun" <stefan@.braun.name> wrote in message news:58osl6F2hrlctU1@.mid.individual.net...
> Hello,
> If a execute a query
> SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
> Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
> Expr5,
> 0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
> FROM Zahlungen INNER JOIN
> Kunde ON Zahlungen.KundeID = Kunde.ID
> WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
> Zahlungen.Periode = '200713' OR
> Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
> 0)
> I get an error message:
> Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
> Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
> SPID: 56
> Process ID: 296
> Die Verbindung wurde unterbrochen.
> If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
> the error message.
> It seams to bee a new problem, because on Tuesday it worked.
> Many thanks for your support and best Regards.
> Stefan
>
>
>
Error message
Hello,
If a execute a query
SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
Expr5,
0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
FROM Zahlungen INNER JOIN
Kunde ON Zahlungen.KundeID = Kunde.ID
WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
Zahlungen.Periode = '200713' OR
Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
0)
I get an error message:
Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 56
Process ID: 296
Die Verbindung wurde unterbrochen.
If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
the error message.
It seams to bee a new problem, because on Tuesday it worked.
Many thanks for your support and best Regards.
Stefan
Possibly a data corruption. Check out DBCC CHECKDB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stefan Braun" <stefan@.braun.name> wrote in message news:58osl6F2hrlctU1@.mid.individual.net...
> Hello,
> If a execute a query
> SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
> Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
> Expr5,
> 0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
> FROM Zahlungen INNER JOIN
> Kunde ON Zahlungen.KundeID = Kunde.ID
> WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
> Zahlungen.Periode = '200713' OR
> Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
> 0)
> I get an error message:
> Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
> Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
> SPID: 56
> Process ID: 296
> Die Verbindung wurde unterbrochen.
> If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
> the error message.
> It seams to bee a new problem, because on Tuesday it worked.
> Many thanks for your support and best Regards.
> Stefan
>
>
>
If a execute a query
SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
Expr5,
0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
FROM Zahlungen INNER JOIN
Kunde ON Zahlungen.KundeID = Kunde.ID
WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
Zahlungen.Periode = '200713' OR
Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
0)
I get an error message:
Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 56
Process ID: 296
Die Verbindung wurde unterbrochen.
If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
the error message.
It seams to bee a new problem, because on Tuesday it worked.
Many thanks for your support and best Regards.
Stefan
Possibly a data corruption. Check out DBCC CHECKDB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stefan Braun" <stefan@.braun.name> wrote in message news:58osl6F2hrlctU1@.mid.individual.net...
> Hello,
> If a execute a query
> SELECT '200703' AS Expr1, Zahlungen.KundeID, Zahlungen.Periode,
> Zahlungen.Datum, Zahlungen.Betrag, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS
> Expr5,
> 0 AS Expr6, 'U' AS Expr7, Kunde.H_Kanton , Kunde.H_Plz
> FROM Zahlungen INNER JOIN
> Kunde ON Zahlungen.KundeID = Kunde.ID
> WHERE (Zahlungen.Betrag > 0) AND (Zahlungen.Periode = '200703' OR
> Zahlungen.Periode = '200713' OR
> Zahlungen.Periode = '200613') AND (Zahlungen.KundeID >
> 0)
> I get an error message:
> Server: Nachr.-Nr. 3624, Schweregrad 20, Status 1, Zeile 1
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
> Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
> SPID: 56
> Process ID: 296
> Die Verbindung wurde unterbrochen.
> If I use "TOP 100000" it works fine. If I use TOP 1000000 (million) I get
> the error message.
> It seams to bee a new problem, because on Tuesday it worked.
> Many thanks for your support and best Regards.
> Stefan
>
>
>
Subscribe to:
Posts (Atom)