Hi all,
Sql server 7
I have created a Web assistant job which select
and displays data from a table (very small amt of data)
on to the webpage. the job is schedule to run
every 1 minute. the job is not running, in job view
history its gives the error msg
"could not open the output file" 16821 Error no.
pls suggest
Awaiting for ur reply
TIA
Adil
I did a small package with only one ODBC connection (Merant 3.70 32-Bit Progess). This package runs well in Visual Studio and fails when runs by SQL Server Agent.
Configuration:
SQL Server Agent on a 32Bit server.
The ODBC connection configuration in available on System DSN on this server.
The user of Server Agent have full access (Admin).
Connect Manager Provider: ".Net ProvidersOdbc Data Provider"
SQL Server version: 9.0.3042
Error Message:
Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:50:33 Error: 2007-06-11 16:50:33.62 Code: 0xC0047062 Source: Data Flow Task DataReader Source [1] Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon... The package execution fa... The step failed.
I created a .bat file with this instruction and It's run well:
dtexec /f "C:Program FilesMicrosoft SQL Server90DTSPackagesIntegration Services Project estcom.dtsx"
pause
Why it's not running with SQL Server Agent???
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.
We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.
There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!
What do I need to tell you to get some idea of where to go next with this?
Hi,
I have suddenly run into a problem. I have a DTS which was running well till few days ago. Now when ever it runs, it crashes the server, any body
have any idea why???
Thanks in Adv.
Nirmal
I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.
it has failed with the following error in view job history
"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this
how can i solve this, i tried restarting the job but its failing again.
Good Morning,
I've been running into a small problem. There are two people that usually create local packages to be executed by the DTS. Either my boss or I. The problem that I have been running into is, there are some local packages that will not execute when I try to run them. These packages are that my boss has created. When she runs them they work fine. But when I run them they just don't run. The only way I can run the local package is if I log in into the server and run it from there.
The error that I keep getting is:
Unspecified Error
[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified.
What would I be able to do so that I can execute this local package from my computer?
Hey guys,
I'm trying to run a job that will convert a load of data but it keeps failing at the first step. If I run the scripts in each step on their own then they run fine. The error message I get is 'The process did not produce any output. Process exit code 1. The step failed'. I think this may be some kind of security problem but I cannot see where. The command I'm using for the first step is as follows:
OSQL -SCRLONSQL01 -DINPRO -Usysadm -Pcarpmaels -i"C:Program FilesCPA Inpro DatabaseScriptsdropinteg.sql" -o"C:conversionoutputdropinteg.txt" -n
Any pointers would be most helpful.
Hi,
I am trying to create a job to run a ssis package.
The job fails. Looking at the history log, there is no proper information on why the job failed. It just says: The job failed. The job was invoked by user ...
please note that the ssis package runs fine on it's own i.e. in the designer by pressing the run button.
Thanks
I have a package which works fine when i ru if from VS but when i schedule it iam getting an error on one of the data reader source. I am not able to figure it why its giving error when its working fine from VStudio
Message
Executed as user: NAdbasvc-alticor. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:28:25 AM Error: 2007-07-10 11:28:26.21 Code: 0xC020838F Source: Staging LKPDataReader Source [1] Description: An error occurred executing the provided SQL command. End Error Error: 2007-07-10 11:28:26.21 Code: 0xC004706B Source: Staging DTS.Pipeline Description: "component "LKPDataReader Source" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2007-07-10 11:28:26.21 Code: 0xC004700C Source: Staging DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-07-10 11:28:26.21 Code: 0xC0024107 Source: Staging Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:28:25 AM Finished: 11:28:26 AM Elapsed: 0.906 seconds. The package execution fai... The step failed.
has anyone come across same issue, help
Hello,
I'm trying to get a handel on ASP.NET and I've put together a new SQL connection to display a view inside of a datagrid.
When I go to run it (before or after compile) I get the error:
------------------------------------------------------------------------------------------------------
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Line 57: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 58: Dim ds As New DataSet
Line 59: SqlDataAdapter1.Fill(ds)
Line 60:
Line 61: DataGrid1.DataSource = ds
Stack Trace:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
jtio8.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootjtio8WebForm1.aspx.vb:59
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Here is the connection string I am using:
Me.SqlConnection1.ConnectionString = "workstation id=MyWorkstation;packet size=4096;integrated security=SSPI;data source=MyServer;" & _
"persist security info=False;initial catalog=Northwind"
-------------------------------------------------------------------------------
Now, I've created a new login to the SQL server using the ASPNET user id (as well as several others for testing), set up the premissions for each UID and I'm still getting this error.
I have also tried to setup the user info in the connection string by doing the following:
Me.SqlConnection1.ConnectionString = "user id=aspnet;password=;workstation id=MyWorkstation;packet size=4096;integrated security=SSPI;data source=MyServer;" & _
"persist security info=False;initial catalog=Northwind"
Any ideas?
Thanks,
Dale
Hi all;
I am getting the following error when I try to connect to my local SQL server from my ASP.NET application
Server Error in '/pelin' Application.
Cannot open database requested in login 'pelin'. Login fails. Login failed for user 'sa'.
for other users also
my connection string is in web.config file:
<appSettings>
<add key="constr" value="server=ARGE057VSDOTNET2003;UID=sa;pwd=sa;database=Test;"></add>
</appSettings>
can you help me please thanks..
Hello,I'm trying to create a new SQL Express database in VWD, and I get the error: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.What is this error all about? I don't understand it.Thanks.
View 1 Replies View RelatedI have this line of db connection code that works in vb.net but not in c#:
con = new ADODB.ConnectionClass(); //for vb.net I used ADODB.Connection() instead and it workscon.Open("Provider=SQLOLEDB;" + ConfigurationSettings.AppSettings["connectionString"]);
Error message:CS1501: No overload for method 'Open' takes '1' arguments
Searched the web but can't find the answer... Does anyone have a clue?
This is a proc that was working on production 7.0 server but is being tested on a 2000, what's changed?
TIA
JeffP....
I trying to FTP Files about 37 files each 3 GB. The FTP is just stuck. It fails half way through. I use IIS 4.0 in Clustered Network and MSSQL 7.0. IIS 4.0 does not support transfer of files more than 4 GB.Is there any other tools that I can use to FTP the dump files. Does anyone have any ideas.
View 1 Replies View RelatedSQL SERVER 7.0
==============
Hi All!
I have a job that has 2 steps.In the first step iam using a group by clause.The column on which I use group by, sometimes has null values.During such case the job is failing at the first step throwing a warning.
Warning: Null value eliminated from aggregate. [SQLSTATE 01003]
1)If i want to override this, is it appropriate to use set ansi_warnings off for my session?
2)If there is some other error will that be detected or will that be overridden too?
Any help appreciated!
TIA
Regards,
kinnu
I have a script that is generated from main frame.
This script updates about 113,000 rows.
I keep getting an error message 225, 16.
From Books on line
225 "Refrenced object (name %*.s) dropped during query optimization"
16 Too many table names in the query. The maximum allowed is %d. knowing that it updates only one table this message does not make sense.
It is on sql server 6.5.
Any help will be very much appreciated.
Thanks in advance
Al
When I schedule a DTS export job,I am getting this error. But if I run it with 'run immediately' option while creating the job,it runs fine! Any clue??
Thanks.
''DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Transfer SQL Server Objects DTSRun OnError: Transfer SQL Server Objects, Error = -2147221504 (80040000) Error string: Error source: Help file: Help context: 0 Error Detail Records: DTSRun OnFinish: Transfer SQL Server Objects DTSRun: Package execution complete. Process Exit Code 1. The step failed.''
when I create a DTS export job,it is running o.k when I select 'run immediately' option.But the same job is not running as a job.Any idea???
Thanks for any help.
Hi ,
While running the load cmd - 'Load database dbname1 from disk='c:empdump1.dat'
through ISQL I am getting the following error
1 transaction rolledback dbid error 7.But when I tried restoring using enterprice manager UI it is working fine.Any body knows why it is happening like this .
Thanks in advance
Jiji
I set up a DTS package to run every night on my SQL 7 Server.
It is supposed to write a text file of modified rows every night.
It was working fine until I changed the password for sa, now it
fails. Also in Enterprise Manager, when I try to look a the package
properties, I get a "login failed for user sa" package error.
What to do?
I have stored procedure that uses the xp_cmdshell procedure to use the dts run to run some dts packages. This package exports data into an Access 97 database. When I run it I get this error:
Error: -2147467259 (80004005); Provider Error: -533791822 (E02EFBB2)
Error string: Could not update; currently locked by user '(unknown)' on machine ''.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003218
If I right click on the local package and select execute it runs with no problem. Any ideas what is going on?
I have a DTS package set up to push data out to several sites. When I execute the package it runs perfectly. When I schedule it as a job it fails.
I checked the proxy account in the SQLAGent properties and there is a check mark there. But the job still fails.
Does anyone have any ideas?
Ok I had a server crash the master was bad or corrupted. I tried to rebuild the master but that failed. I had to reinstall sql and then attach the databases.
I need to know why the master all of a sudden just stopped working. Any ideas where to look or what would cause this?
Thanks.
:eek:
Sorry about that first post I hit the wrong button.
I have a BIG problem. One day about a week ago I came into my office and everything was working fine, except for the fact that the drive of the NT server was a little fragmented. This machine is a dedicated server and since everything was relatively ok I turned the monitor back off and left the machine alone, after starting Diskkeeper to take care of the fragmentation. Later I go to check on the machine and the following message had appeared on the screen, NT system corrupt service can not continue with an OK button. So I sighed an pressed the ok button already to figure out what service needed to be restarted, unfortunately my best laid plans were soon destroyed when again the message popped up till I had shut down every program and had to reboot.... That is when the real fun started, it never rebooted, I had shut it down properly. So now I had a central server, that had never been backed up before that needed windows NT reinstalled. So I started reinstalling NT. I recently came in to this position and the people before me had not made and backup what so ever. So I had no Emergency Disk, and the systems files, i.e. User database, stuff that would normally be on a Emergency Disk were somehow corrupt and I could no recover them. Well after getting NT up, I worked on restoring the functions of the server, file sharing and web hosting. I still have a lot of programs to reinstall as the reinstall of NT left the actual program files alone, but has rendered them unusable. Now that I`m done with the background, I have now made a copy of what was left on the drive, so I could restore the data files. When I go to reinstall SQL 6.5, it will not let me use the upgrade part. So I try to do a complete install, I`m getting desperate here! Well it starts the install no problem asks me for info and I tell it. I have tried this with a new directory and the old one with the files intact. Well as the install goes along it allows the copying of the files, and then goes to a screen where it has the little hour glass thing in the SQL window setting up the server. A few minutes later it changes the title on the screen to read Microsoft SQL Server 6.5 Setup and brings up a window with the error The SQL Server installation could not be successfully completed Setup was not able to connect to the SQL server the only button is Exit to windows NT. I`m out of ideas. HELP me please.
Guys I was wondering if you can help me figure out the problem with the script.
1) I am getting the following error message on one of the job which is backing up all the databases on the server.
...ges for database 'AdminWorkFlow_Reports', file 'AdminWorkFlow_Reports_Data' on file 1.
[SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AdminWorkFlow_Reports',
file 'AdminWorkFlow_Reports_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or
restore operation successfully processed 433177 pages in 64.328 seconds (55.163 MB/sec).
[SQLSTATE 01000] (Message 3014) Processed 113720 pages for database 'BMSRep', file 'BMS_Data'
on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'BMSRep', file '
BMS_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore operation
successfully processed 113721 pages in 17.200 seconds (54.162 MB/sec). [SQLSTATE 01000]
(Message 3014) Processed 208 pages for database 'EmailAddress', file 'EMailAddress_STGE_Data'
on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'EmailAddress',
file 'EMailAddress_STGE_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore
operation succe... The step failed.
Not sure where to start. I looked up the backup script it looks fine.
BackUp Database AdminWorkFlow_Reports to Disk = 'q:\AdminWorkFlow_Reports12-17-2007.bak'
--
--
--
--
BackUp Database EmailAddress to Disk = 'q:\EmailAddress12-17-2007.bak'
2)Also I have another script which for some reason doesn't run on some nights. Its enabled and the job is scheduled daily but its not running for about a week.
SQL server agent is running though.
Any help in this regard would be appreciated.
I'm new to SQL server, so bear with me please.
I'm running NT4 SP3 SQL 6.5 SP5. I have one major database (son_db) which is being backed up (along with others) using this command:
DUMP DATABASE son_db TO DBTape WITH NOUNLOAD , STATS = 10, NOINIT , NOSKIP
The task is completing successfully each night. However, we want to test the restore of this database, so we created a test table (test_table) which resides in the son_db database, added some data, and then let the backup run.
Next day we alter some data and try to restore the single table, but consistantly get the following message after clicking on the restore button:
[SQL Server] invalid source table "test_table" specified in LOAD TABLE. Could not find table in SYSOBJECTS in dump.
After this error, the table (test_table) is now completely empty.
MS website is no help, so I would really appreciate a bit of guidance on this,
Many thanks,
Joe
MCSE (but not including SQL!)
Hi
I have C++ Client application writes data using sp in SQL Server.
After inserting more than 150000 records, i am unable to insert data , simply it hangs and no more connection are not allowing.If I close the application, it is working fine. What could be the reason?
Thank in advance
This is a proc that was working on production 7.0 server but is being tested on a 2000, what's changed?
TIA
JeffP....
Hello, I have a SERIOUS problem where I am restoring my SQL server (6.5) dump to my standby server everyday.......however, it often fails with the following msg:
'Unexpected end-of-dump while loading database, attempting to continue. Please verify database integrity. (Message 3103)'
It does also succeed, but too often fails and my standby server depends on it. The DB that gets restored is placed in single-user mode, so no other process or connection is allowed.
The backup to PROD runs at 12AM, for about 3 hours and succeeds always; the restore runs at 4:00...i've tried later times as well.
Can anyone tell me how to get near 100% success rate? What is the problem and how can I fix it? Thank you for the help.
For years I've had a server registration using sql server auth set up...now it's failing...can't be found not suthed BS...
I can still see mu other boxes in sql mode, and otyhers in mixed, and I can still see my remote boxes in Ireland and Pennysylvania...we're in NJ..
The person next to me does the same thing, had to reboot, but was fine.
I get ice in the winter...
bizzare-o world.
Any ideas?
Never seen anything like it...
I do know that our tech group has been doing some pushes lately...but I checked my settings and they seem fine..but why would I be able to see everything else but this one instance?
Hello,
I have a DTS job that retrieves data from a different server. When I manually run the DTS job, it executes fine, but when I run it from an SQL job it fails regardless of the owner I use to run the SQL job under.
I ran the same DTS package from another computer which has SQL client installed and it ran fine.
Does anyone know what could be the reason for failure when running the DTS job from the SQL job from the server?
Thanks,
Adrian.
I have a DTS local package that transfer data from the host SQL server to another. If I run the package directly (i.e. Right click - Execute Package) everything works as it should.
However, if I try and execute this as a Server Agent job it fails, the job history step details shows the following error:
Executed as user: MYSERVERNAMESYSTEM. ...: Drop table customer Step DTSRun OnError: Drop table customer Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Drop table customer Step DTSRun OnStart: Create Table customer Step DTSRun OnError: Create Table customer Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server... Process Exit Code 2. The step failed.
Whilst this is obviously a connection issue, I dont understand how this can work if executed directly and not if executed as an agent job.
Can anybody shed any light on this?
If it helps this is the sequence of events my DTS package uses
1) Connect to remote DB
2) Drop table customers
3) Create new remote customers table
4) Connect to to local DB (hosting the DTS package)
5) Select * from local customers table
6) Dump data from local select into remote DB