Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 [SQLSTATE 42000] (Error 19055)
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nasali
Starting Member

4 Posts

Posted - 11/26/2008 :  01:16:57  Show Profile  Reply with Quote
I get below message from my SQL scheduled job when i run
Job Name :Manage Login Creation Trace
============================================================
job body:
((EXEC usp_trace_login_creation 'OFF',@tracename='Login Creation on SQL-Server1 '

EXEC usp_trace_login_creation 'ON',@file_name ='F:\Microsoft SQL Server\MSSQL\Audit\',
@TraceName = 'Login Creation on SQL-Server1 ',
@Options = 2,
@TraceType = 8,
@MaxFileSize = 500,
@StopTime = NULL,
@Events = DEFAULT,
@Cols = DEFAULT,
@IncludeTextFilter = NULL,
@IncludeObjIdFilter = 7274611,
@ExcludeObjIdFilter = NULL))
----------------------------------------------------------------------------------------
Fail Message:
Executed as user: SIDF\Administrator. Deleted trace queue 2. [SQLSTATE 01000] (Message 0) The trace output file name is: F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081120233001280.trc. [SQLSTATE 01000] (Message 0) No active traces named Login Creation on SQL-Server1 . [SQLSTATE 01000] (Message 0) Filters with the same event column ID must be grouped together. [SQLSTATE 42000] (Error 19055) Trace started. [SQLSTATE 01000] (Error 0) The trace file name is : F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081121233000543.trc [SQLSTATE 01000] (Error 0). The step failed.

========================================
Actually the login trace file created successfully but still getting job failed in job history, so what is the reason for that

I am not bothered about [SQLSTATE 01000] (Message 0) because I get it in another Job “Mange Trace” still job status success.




Edited by - nasali on 11/26/2008 01:23:56

SwePeso
Patron Saint of Lost Yaks

Sweden
30421 Posts

Posted - 11/26/2008 :  02:24:38  Show Profile  Visit SwePeso's Homepage  Reply with Quote
How do you output the message "Trace started"?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

nasali
Starting Member

4 Posts

Posted - 11/29/2008 :  00:38:02  Show Profile  Reply with Quote
Sorry for being late.

From This script:

......
-- Create the trace queue
EXEC @res=sp_trace_create @TraceId=@QueueHandle OUT, @options=@Options, @tracefile=@file_name,
@maxfilesize=@MaxFileSize, @stoptime=@StopTime
IF @res<>0 BEGIN
IF @res=1 PRINT 'Trace not started. Reason: Unknown error.'
ELSE IF @res=10 PRINT 'Trace not started. Reason: Invalid options. Returned when

options specified are incompatible.'
ELSE IF @res=12 PRINT 'Trace not started. Reason: Error creating file. Returned
if the file already exists, drive is out of space, or path does not exist.'
ELSE IF @res=13 PRINT 'Trace not started. Reason: Out of memory. Returned when
there is not enough memory to perform the specified action.'
ELSE IF @res=14 PRINT 'Trace not started. Reason: Invalid stop time. Returned
when the stop time specified has already happened.'
ELSE IF @res=15 PRINT 'Trace not started. Reason: Invalid parameters. Returned
when the user supplied incompatible parameters.'
RETURN @res
END
PRINT 'Trace started.'
PRINT 'The trace file name is : '+@file_name+'.'+'trc'
....etc

Edited by - nasali on 11/29/2008 00:40:35
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30421 Posts

Posted - 11/29/2008 :  03:50:26  Show Profile  Visit SwePeso's Homepage  Reply with Quote
This is an easier way to get number of days in a month:
DATEDIFF(DAY, GETDATE(), DATEADD(MONTH, 1, GETDATE()))



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

nasali
Starting Member

4 Posts

Posted - 11/29/2008 :  06:29:54  Show Profile  Reply with Quote
Is this related to my post?
sorry ,friend ,i don't know what do you mean?
Go to Top of Page

nasali
Starting Member

4 Posts

Posted - 12/21/2008 :  06:11:58  Show Profile  Reply with Quote
I ran procedure code the i got those messages:

Deleted trace queue 4.
The trace output file name is: F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081220233000503.trc.
No active traces named Login Creation on SQL-Server1 .
Trace started.
The trace file name is : F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081221105557597.trc
Msg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1
Filters with the same event column ID must be grouped together.
Msg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1
Filters with the same event column ID must be grouped together.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000