Friday, March 23, 2012
Help with Agent Jobs
I am suddenly receiving a number fo failed jobs, upon looking at the
history, there is very little to go on, any help on where i can look to
solve this would be great. The only error i receive is below, I am the
owner.
The job failed. The Job was invoked by User EFMG\InglisG. The last step to
run was step 1 (Update Clients).
Hi,
In the Job History screen click the "Job step details" and look into the
details messages of each step id.
You will get more details there to troubleshoot.
Thanks
Hari
MCDBA
"Gordon" <inglisg@.edfd.com> wrote in message
news:OLfX#s4IEHA.228@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am suddenly receiving a number fo failed jobs, upon looking at the
> history, there is very little to go on, any help on where i can look to
> solve this would be great. The only error i receive is below, I am the
> owner.
> The job failed. The Job was invoked by User EFMG\InglisG. The last step
to
> run was step 1 (Update Clients).
>
|||Gordon
Most likely it is because your ID was not logged into the server and did not have access at the time. If you would make the owner of the jobs SA then most likely your problems will go away. If your SQL instance is running as a network ID and it has admi
n access you could also make it the owner of the job.
Hope this helps
Jeff
MCDBA, MCSE+I
Help with Agent Jobs
I am suddenly receiving a number fo failed jobs, upon looking at the
history, there is very little to go on, any help on where i can look to
solve this would be great. The only error i receive is below, I am the
owner.
The job failed. The Job was invoked by User EFMG\InglisG. The last step to
run was step 1 (Update Clients).Hi,
In the Job History screen click the "Job step details" and look into the
details messages of each step id.
You will get more details there to troubleshoot.
Thanks
Hari
MCDBA
"Gordon" <inglisg@.edfd.com> wrote in message
news:OLfX#s4IEHA.228@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am suddenly receiving a number fo failed jobs, upon looking at the
> history, there is very little to go on, any help on where i can look to
> solve this would be great. The only error i receive is below, I am the
> owner.
> The job failed. The Job was invoked by User EFMG\InglisG. The last step
to
> run was step 1 (Update Clients).
>|||Gordon
Most likely it is because your ID was not logged into the server and did not
have access at the time. If you would make the owner of the jobs SA then m
ost likely your problems will go away. If your SQL instance is running as a
network ID and it has admi
n access you could also make it the owner of the job.
Hope this helps
Jeff
MCDBA, MCSE+Isql
Help with Agent Jobs
I am suddenly receiving a number fo failed jobs, upon looking at the
history, there is very little to go on, any help on where i can look to
solve this would be great. The only error i receive is below, I am the
owner.
The job failed. The Job was invoked by User EFMG\InglisG. The last step to
run was step 1 (Update Clients).Hi,
In the Job History screen click the "Job step details" and look into the
details messages of each step id.
You will get more details there to troubleshoot.
Thanks
Hari
MCDBA
"Gordon" <inglisg@.edfd.com> wrote in message
news:OLfX#s4IEHA.228@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am suddenly receiving a number fo failed jobs, upon looking at the
> history, there is very little to go on, any help on where i can look to
> solve this would be great. The only error i receive is below, I am the
> owner.
> The job failed. The Job was invoked by User EFMG\InglisG. The last step
to
> run was step 1 (Update Clients).
>
Monday, March 12, 2012
Help with "Create View" statement and Eorror Message
I am trying to create a view with approx. 3000 columns... and got the following error message:
"CREATE VIEW failed because column 'HSEPRIN' in view 'MyTestView' exceeds the maximum of 1024 columns.
Is it mean the max number of columns for each table is 1024? I thought in SQL server the table can contain as much information as possible.
Anyone can help to answer my question?
Thank you in advance.As much information vertically, not horizontally.
Frankly, if you are trying to create a view with 3000 columns, the problem is in your design, not SQL Server's limitations!
Why are you doing this? Maybe somebody here can find a better approach for you to take.|||No, a single row in a table can only contain a bit short of 8 kilobytes. A given row in a result set (therefore in a view) can only contain 1024 columns, and there are some limitations on the 1024th column.
That said, how on earth would you make use of a view that wide ?!?! What would you do with it ?
-PatP|||I definitely recommend printing it on legal-size paper set to landscape orientation, using Arial Narrow font.|||You can you go over the row limit in a physical table but you just get some warning about inserts and updates. See it often in poor designs or lack there of.|||Are you by any chance trying to crosstab that 40-year history you were talking about in that other post? That's the only thing I can think of that would give you that many columns. :D|||I do not have to see/create all the columns. However I would like to know the limitation. I just tried running the same query again for 950 columns which was succussful.
Maybe I have to run 3000 columns separately to create 3000/950 views. Can I union them together as a one object/something? In addition,
How am I going to update number of views on daily basis? :confused:|||All kidding aside.
Why don't you provide us with some more information about what exactly you are trying to do? Of course the ddl might be too much 411. But if you give us enough info one of might come up with something or at least some advice.
Some of the folks in this forum are as smart as they think they are. Myself excluded. I am as dumb as I seem. darrrrrrrrrrrrrrrrrrrrrrr!!!!!!!!!!|||This post is related to the one "updating daily information in a history table (was "Help-Brainstorming")"... which provides details.
Sorry about the confusion. And thank you for the help.|||Good Morning All,
Hope you all had a great weekend!
I think I am probably asking a silly question but...
I created a view by using the following statement:
create view TestView1
as
select date as Date,
XXXXX= sum(case when ID='XXXXX' then Field1 else 0 end),
YYYYY= sum(case when ID='YYYYY' then Field1 else 0 end)
from MyTable
Group by Date
The structure of MyTable is:
Date(datetime) ID(char 10) Field1(float)
1/1/65 XXXXX -999.999
1/4/65 XXXXX -999.999
...
2/24/05 XXXXX 500
2/25/05 XXXXX 550
1/1/65 YYYYY -999.999
1/4/65 YYYYY -999.999
...
2/24/05 YYYYY 600
2/25/05 YYYYY 650
when I run "select * from TestView order by date"
The actual results I got:
Date XXXXX YYYYY
1/1/65 0.0 0.0
1/4/65 0.0 0.0
...
2/24/05 500 600
2/25/05 550 650
This is the results I should expect:
Date XXXXX YYYYY
1/1/65 -999.999 -999.999
1/4/65 -999.999 -999.999
...
2/24/05 500 600
2/25/05 550 650
What is wrong with my create view statement? Do I have to specify the datatype?
Thank you for the help in advance.|||What is wrong with it?
The question is, "What good is it?"
What is the practical use of a view with 3000 cross-tabbed columns? You can't print it. You can't display it. You can't use it practically in any other views or procedures.
What are you planning to do with this?|||This is going to be the data source for another application (Matlab).
And this is desired format. It does not matter if I can display them all as long as I can display partially to make sure the information is there and the expected data format.
Should I put information into a table instead of View?
Thank you for the help!|||MatLab can't accept normalized data?
And it can't do its own crosstabs?
That is pretty weak.
I'm sorry, but I just can't suggest any solution along the lines you are thinking, because I think it is going to cause you severe problems in the future.|||Matlab is a statistic package to do math calculation and generate graphs. It may take 5+ hours to run the results therefore I am thinking to use SQL to generate the expected data source format to feed into Matlab.
If you think the only possible solution should be on Matlab side, I guess I have to work on that.
However, do you know why my actual result from my sql statement shows data as "0.0" instead of expected "-999.999" which is stored in the table?
Any suggestion and comments are truely appreciated!
shiparsons|||I don't have that problem..you probably shouldn't be using float though...
USE Northwind
GO
SET NOCOUNT ON
CREATE TABLE myTable99([ID] varchar(15), [Date] datetime, Field1 float)
GO
INSERT INTO myTable99([Date],[ID],Field1)
SELECT '1/1/65', 'XXXXX', -999.999 UNION ALL
SELECT '1/4/65', 'XXXXX', -999.999 UNION ALL
SELECT '2/24/05', 'XXXXX', 500 UNION ALL
SELECT '2/25/05', 'XXXXX', 550 UNION ALL
SELECT '1/1/65', 'YYYYY', -999.999 UNION ALL
SELECT '1/4/65', 'YYYYY', -999.999 UNION ALL
SELECT '2/24/05', 'YYYYY', 600 UNION ALL
SELECT '2/25/05', 'YYYYY', 650
GO
CREATE VIEW myView99
AS
SELECT [Date]
, SUM(CASE WHEN [ID]='XXXXX' THEN Field1 ELSE 0 END) AS X
, SUM(CASE WHEN [ID]='YYYYY' THEN Field1 ELSE 0 END) AS Y
FROM MyTable99
GROUP BY [Date]
GO
SELECT * FROM myView99
GO
SET NOCOUNT OFF
DROP VIEW myView99
DROP TABLE myTable99
GO|||Brett,
Thank you for the help! You are right. It works fine.
The problem was on my end. In my statement I had a space was quoted in for ID field. (ID=' XXXXX ' instead of ID='XXXXX')
:p
Friday, March 9, 2012
Help w/ data errors
HI,
Periodically, I receive these errors in my package:
The "component "Set date to NULL or format" (111)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "SettlementDate - derived" (544)" specifies failure on error. An error occurred on the specified object of the specified component.
It has to do with the fact that I have a derived column that uses an expression to format a date field. The expression is as follows:
ISNULL(TRIM(SettlementDate)) || TRIM(SettlementDate) == "" || LEN(TRIM(SettlementDate)) < 8 || TRIM(SettlementDate) == "89999999" ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING(SettlementDate,5,2) + "/" + SUBSTRING(SettlementDate,7,2) + "/" + SUBSTRING(SettlementDate,1,4))
It looks complicated, but it isn't. Basically, I'm just checking to see if the date value is NULL, a blank, less than 8 chars, or if it equals 899999999. If it is, set the date to null.
Anyways, the problem is, that the date field value changes sometimes. That is, I thought I covered the problem by checking for 89999999, but apparently other values are showing up as well, and when this happens it breaks the package.
How can I account for varying values, without having to know in advance what they are? Apparently, this problem is going to continue.
Thanks much
How about"... || TRIM(SettlementDate) > "21000000" ? NULL(DT_DBTIMESTAMP) : ......."|||
Hmm, don't know. I went into my package and ran the step manually, and viola it worked.
I honestly don't know why it broke at 3:30 am this morning, but ran okay five hours later... I loaded the exact same data file.
This makes no sense to me.
|||Are you sure the package that runs via a schedule is the same as the one you opened up manually to execute the step?|||
yeah, that's probably it. the one that ran at 3:30 ran from a job, using the msdb package store.
the one i ran manually was from BIDS
i probably forgot to update it in msdb
i notice the "create date" column in sysdtspackages90 does not reflect the date the package is loaded into msdb, but the original creation date of the package, so there's no way to keep track of when the package was loaded into msdb
unless this data is somewhere else?
Wednesday, March 7, 2012
Help Tracking down failed SQL login
am getting numerous event id of 17055, which is a login
failure for a particular account on my SQL server. The
problem I am having is that I am trying to find out where
this account is logging in from. The description of the
event reads: 18456 :Login failed for user 'user'. Is
there a logging mode or tool I can use to find out where
this login is being generated from so I can fix this
failed login attempt?
Thanks,
Alex
Alex,
Check the SQL Profiler tool that comes with SQL Server so you already have
it.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Alex Mook" <anonymous@.discussions.microsoft.com> wrote in message
news:aec401c436af$405d75a0$a001280a@.phx.gbl...
> On my SQL 2000 Server and in my application event log I
> am getting numerous event id of 17055, which is a login
> failure for a particular account on my SQL server. The
> problem I am having is that I am trying to find out where
> this account is logging in from. The description of the
> event reads: 18456 :Login failed for user 'user'. Is
> there a logging mode or tool I can use to find out where
> this login is being generated from so I can fix this
> failed login attempt?
> Thanks,
> Alex
Help Tracking down failed SQL login
am getting numerous event id of 17055, which is a login
failure for a particular account on my SQL server. The
problem I am having is that I am trying to find out where
this account is logging in from. The description of the
event reads: 18456 :Login failed for user 'user'. Is
there a logging mode or tool I can use to find out where
this login is being generated from so I can fix this
failed login attempt?
Thanks,
Alex
Alex,
have a look at profiler for this - you can to pick up the "Host Name" this
way using the AuditLogin... events.
Regards,
Paul Ibison
|||Try making a network capture while the problem is occuring. This will give
you the mac address and IP address of the client.
Microsoft Network Monitor is included in Windows 2000 Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Help Tracking down failed SQL login
am getting numerous event id of 17055, which is a login
failure for a particular account on my SQL server. The
problem I am having is that I am trying to find out where
this account is logging in from. The description of the
event reads: 18456 :Login failed for user 'user'. Is
there a logging mode or tool I can use to find out where
this login is being generated from so I can fix this
failed login attempt?
Thanks,
AlexAlex,
have a look at profiler for this - you can to pick up the "Host Name" this
way using the AuditLogin... events.
Regards,
Paul Ibison|||Try making a network capture while the problem is occuring. This will give
you the mac address and IP address of the client.
Microsoft Network Monitor is included in Windows 2000 Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Friday, February 24, 2012
Help setting up Net Send operator
Failed to Net Send to the address "xxxxxxx".
I've tried multiple addresses, including my network sign-in name, computer
name.
Please help, thank you in advance for your time!
Leon ShargorodskyIs the messenger service installed and running on the machine you are trying
to use net send?
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:3AC999C9-A96E-4D79-AAD1-775D7B59FF92@.microsoft.com...
> I get this error every time I try to test Net Send operator:
> Failed to Net Send to the address "xxxxxxx".
> I've tried multiple addresses, including my network sign-in name, computer
> name.
> Please help, thank you in advance for your time!
> Leon Shargorodsky|||I'm able to use Net Send after enabling and starting Messenger service!
Thanks a lot for your help, Simon!
"Simon Worth" wrote:
> Is the messenger service installed and running on the machine you are trying
> to use net send?
> "Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
> message news:3AC999C9-A96E-4D79-AAD1-775D7B59FF92@.microsoft.com...
> > I get this error every time I try to test Net Send operator:
> >
> > Failed to Net Send to the address "xxxxxxx".
> >
> > I've tried multiple addresses, including my network sign-in name, computer
> > name.
> >
> > Please help, thank you in advance for your time!
> >
> > Leon Shargorodsky
>
>