Pre-execute Hangs At 50%
Aug 6, 2007
Hello,
I did a search and found no answers. I have a simple project; one data flow task reading from one DB2 tabel and writing to another. My OLEDB source is a sql command that returns 97,000 rows and my OLEDB destination's data access mode is "table or view".
For my OLEDB source SQL command, I run it through the "build query" panel and I get all 97,000 rows back within 90 seconds everytime.
I don't know what is so different since I currently do SQL commands that bring back 2.5 million rows from DB2 with no effort in SSIS. I even took my data flow task and placed into a known good solution - but still hangs at 50% forever. I tried attaching to SSIS server and executing through there, again no luck. Still hung!
Any ideas? Thanks.
View 8 Replies
ADVERTISEMENT
Mar 21, 2007
Hi,
I'm having a problem with one 'Execute SQL Task' calling a stored proc...
The problem is that once the stored proc has finished executing after 10 mins (I know it has thanks to an audit log table entry ), the SSIS task carries on hanging for another 20mins before it gets the task execution result and moves to the following task.
I tried:
- adding/removing a return statement at the end of the stored proc. It doesn't solve the problem
- running the package without debugging and outside visual studio, and I'm still getting the same problem. so it's nothing to do with the debugger...
- tried various settings for the transaction and isolation settings... not getting any better
- changed the stored proc so that it processes less data. Execution time goes down to a couple of minutes and the SSIS tasks only hangs for 2 mins... better but not really helping...
Any clues? I'm new to SSIS so I must have certainly missed something!
Thanks.
View 4 Replies
View Related
Dec 6, 2006
Dear all:
I had got the below error when I execute a DELETE SQL query in SSIS Execute SQL Task :
Error: 0xC002F210 at DelAFKO, Execute SQL Task: Executing the query "DELETE FROM [CQMS_SAP].[dbo].[AFKO]" failed with the following error: "The transaction log for database 'CQMS_SAP' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
But my disk has large as more than 6 GB space, and I query the log_reuse_wait_desc column in sys.databases which return value as "NOTHING".
So this confused me, any one has any experience on this?
Many thanks,
Tomorrow
View 5 Replies
View Related
Apr 19, 2007
I'm looking for a way to refer to a package variable within any
Transact-SQL code included in either an Execute SQL or Execute T-SQL
task. If this can be done, I need to know the technique to use -
whether it's something similar to a parameter placeholder question
mark or something else.
FYI - I've been able to successfully execute Transact-SQL statements
within the Execute SQL task, so I don't think the Execute T-SQL task
is even necessary for this purpose.
View 5 Replies
View Related
Mar 6, 2008
Hi.
I have a master package, which executes child packages that are located on a SQL Server. The Child packages execute other child packages which are also located on the SQL server.
Everything works fine when I execute in process. But when I set the parameter in the mater package ExecutePackageTask to ExecuteOutOfProcess = True, I get the following error
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Row Count" (5349).
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "SCR Custom Split" (6399).
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "SCR Data Source" (5100).
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "DST_SCR Load Data" (6149).
The child packages all run fine when executed directly, and the master package runs fine if Execute Out of Process is False.
Any help would be greatly appreciated.
Thanks
Geoff.
View 7 Replies
View Related
Jun 25, 2007
I have a SSIS package contains an "Execute SQL Task". The SQL will raise error or succeed. However, it sounds the package won't pick up the raised error?
Or is it possible to conditional run other control flow items according the the status of SQL task execution?
View 1 Replies
View Related
Jun 26, 2001
I posted a message about this yesterday but I have more info..
I have a server (SQL 7.0, sp2) that anywhere I connect to it through EM the EM hangs. I can drill down into the server and even get into the Security drop down but if I hit Databases to drill down or Management etc. It hangs.
I did profiler on this and another server. When I click the + by the Database folder I hang and get
"TSQL:Batch Starting: exec sp_MSdbuseraccess N'db', N'%'"
but never get a "TSQL:BatchCompleted" for that statement. (Where other working servers I do get the set of both start and completed)
Drilling into the Security tab runs the query: exec sp_MSDBUserpriv... etc.) and this one works..
Anyone have any info on: exec sp_MSdbuseraccess N'db', N'%'
I can't find anything in BOL, Microsoft KB, Technet etc.. Please Help as there are certain things I can't do without EM... THANKS!!!
View 1 Replies
View Related
Jun 5, 2001
I have been trying all day to install SQL 7.0 on an NT 4.0 SP6a server. It gets to the point where it wants to load MDAC and just goes out to lunch. No errors are generated and the rest of the system does not appear to be affected. However, the only way to end the install is to end task it. Has anyone run into this?
View 1 Replies
View Related
Sep 28, 2001
Some of my jobs hang at FTP step for several hours until some one kills the FTP (it's a perl process) on the box. Is there a way to find how much time a particular step of the job is executing? and know it by somehow if it's hanging at that step?? If we know this,I want to kill the perl process(FTP) on the box in an automated way whenever the job hangs! Any ideas welcome!! Thanks. :-)
Di
View 3 Replies
View Related
Oct 25, 2000
Hi all - I'm having a problem with a dts job that I haven't run across before. The function of the job itself is pretty basic just moving data into a sql table using a few lookups and mappings. The job starts fine and gets to a status of 5000 records processed and just sits there. It's doesn't go into a 'not responding state' nor does it produce any error information in the error file I set up. Anyone have any thoughts on what might be happening? How to identify the specific record it may be hanging on? Help!! - this one is driving me nuts.
View 4 Replies
View Related
Dec 4, 2000
I'm running a pretty simply DTS just to pump some data into a table. Nothing fancy just a couple lookups and a couple columns being copied over. I get to 5000 records processed and the DTS just spins its wheels. It does not go into a 'not responding' state. There are no indexes on the table and the db size is plenty big so it is not reindexing or resizing the db at this point. Any ideas on how I can debug this one would be greatly appreciated.
Thanks
View 2 Replies
View Related
Sep 28, 2000
I am having a problem importing data into SQL 7 from any type of source. I go through the whole import process no problem. When I click the finish button to start the import, nothing at all happens. Enterprise Manager and the DTS just hang and I must use crtl+alt+delete to end the program. Can anyone give me any suggestions as to what might be happening. Big Thanks in advance, I've been working on this for days.
glevi
View 3 Replies
View Related
Apr 19, 2000
Anyone else had this problem ?
I've run dbcc check commands on a 5Gig database which has 2 Gig of unallocated space, with no problems with the tables or database.
However when i try to run dbcc shrinkfile ( on the DATA file ) from Query Analyser the command just runs indefinitely with no response.
Duncan
PS SQL 7 sp 2
View 2 Replies
View Related
Aug 28, 2000
I am having problems of my DTS package hanging when run through the sql server agent through a scheduled job. If I execute the job manually it runs fine? If I run the package manually it runs fine? Of course there is no way to actually tell what is being hung? Any ideas?
Thanks David
View 2 Replies
View Related
Oct 15, 2002
Hi everyone, I had to do a restore of a database from tape. I have the tape set to eject when it's complete, the tape ejects and the dialog box looks like the restore finishes fine. But when I look at the database after the restore it is still in the loading phase. So the restore never really took or looks like it hangs. Do you guys know why or how to fix this problem? Thanks in advance.
Stink!
View 1 Replies
View Related
Feb 12, 1999
My client is using SQL Server 6.5 on NT 4.0. They have recently began to have their SQL server session freeze intermittently.
I have determined that only users that are accessing one particular database are freezing which leads me to a locking problem.
What is the best way to determine the locking problem (i.e. event logs, sp_lock, ....)?
View 2 Replies
View Related
Oct 22, 2004
Hello everyone,
I've done some searching, asking of friends, and searching every log file and event file I can think of. So now I'm coming here.
Recently I moved some of our databases from an NT4 box running SQL 7 to an Advanced 2000 box running SQL 2000. The web server is still on an NT4 box. It seems that about three times a day or so ASP type files will hang on the webserver. This server hosts different sites and all ASP type files will stop even if some of them hit the old SQL7 server.
Right now I moved the web server back to looking at the SQL 7 machine and things are going fine.
Can anyone offer me a direction to start looking? Why is it working fine to the old stuff but not the new stuff? Is there an issue with NT4 with its IIS trying to talk to an Advanced 2000 with its SQL2000?
Thank you in advance for any help.
View 2 Replies
View Related
May 30, 2008
I've written a recursive CTE to update a table's heirarchy data with a lineage that the CTE builds. This works and executes over 80,000 records on my local test environment in about 45 seconds. However when I try to execute it from a "production" environment, it hangs and never completes the update (well at least it's taking longer than 5 minutes and I'm too impatient to wait). The CTE itself still runs fine and returns data if I do a Select *, but not when I run the update. Here's my CTE, any ideas? Is there anything in database settings that would disallow this query update? or field requirements?
WITH MyLineage (ID, Lineage, ParentID)
AS (SELECT ID, CAST('.'+ convert(nvarchar(max), ID) +'.' AS nVarchar(max)) as Lin, ParentID FROM Equipment WHERE OrgID=2 AND ParentID IS NULL
UNION ALL
SELECT E.ID, CAST(L.Lineage+ convert(nvarchar(max),E.ID)+'.' AS nVarchar(max)) AS Lin, E.ParentID FROM Equipment E INNER JOIN MyLineage L ON L.ID=E.ParentID WHERE L.ID=E.ParentID)
UPDATE E SET E.Lineage=L.Lineage FROM Equipment E INNER JOIN MyLineage L ON E.ID=L.ID
If I try to do the update like this:
UPDATE Equipment SET Lineage=(SELECT Lineage FROM MyLineage WHERE MyLineage.ID=Equipment.ID)
it will hang in my local test environment as well. It seems like the other sql 2005 server instance is converting the join update into a nested select update, or something. I don't know what's going on, help?
View 9 Replies
View Related
May 15, 2007
Hi ppl
I have a DTS that is loading 6 text files into respective tables. Before loading this files the tables are emptied using SQL tasks with the following code:
DELETE
FROM Table1
WHERE (OMC=?)
OMC is a PK from table1 and ? is a parameter within the DTS.
Occasionally the system hangs executing these delete statements for one of the tables (not always the same!)
I’m forced to reboot and then DB goes trough a recovery process.
Any idea what might be wrong?
Thanks in advance
View 1 Replies
View Related
Jul 23, 2005
Hi,Currently it is running on SQL 7.00.623 on Winnt 4.0+SP5.Now i want to upgrade this with SP 4.As i follow the installation procedure according to MicrosoftSQL7SP4 readme help, It hangs during the installation of Mdac_typ.exe.Don't know where and whats went wrong with the procedure.I've tried 3-4 times to install it but the same problem raises. Pleasesome body assist me how to complete this installation.Thanks in advanceIvar
View 2 Replies
View Related
Mar 7, 2006
I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start.
To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package.
The job will run under the "executing" status until I stop it manually.
Does anyone have any idea why it might be doing this?
View 15 Replies
View Related
Oct 17, 2006
I've installed SSE2005 (with SP1 and the hotfix rollup) on a Small Business Server 2003 SP1, and 90% of the time, all is well.
SSE is running two user databases; one for an ASP web-based application, and one for a desktop application. Occasionally, pretty much everything for both apps hangs for a number of seconds (variable, but probably about 10-30 seconds at a time). During the hangs, even using Management Studio Express becomes impossible, and Activity Monitor just times out, so I can't see what's happening. SSE's Errorlog and server Event Logs show nothing unusual.
The hangs tend to come in batches, on-and-off for an hour or so, after which the problem clears and it's service as usual.
Does anyone have any ideas what the problem might be, or at least how to start tracking it down?
View 1 Replies
View Related
Nov 28, 2007
Hi,
I have a package that runs just fine from BIDS. There are no message boxes in any scripts, or prompts of any kind.
However, when I attempt to the exact same package from a job, it just hangs forever.
Is there an obvious explanation for this?
Thanks
View 11 Replies
View Related
May 7, 2007
I have a problem where a SQL 2005 server in the morning will deny all connections do to a time out error. Sytem has 4 CPU's in it and sqlservr.exe is utilizing 85% of all CPU's. If I run filemon it does not show activity to any of the SQL databases. I get a login timeout message when I try to connect via the enterprise manager or from a command prompt, even if I bump the timeout delay to 5 minutes. If I restart the SQL Server services all is fine for a few days.
View 4 Replies
View Related
Jun 8, 2007
On random occasions, our SQL Server instance will just hang and the users will not be able to use the application until we restart the SQL Server 2005 Service. Anyone have any ideas what we might do to figure out what is going on? The server hung up at 8:00 AM this morning. There was nothing after our midnight backup in the log until we rebooted the server at 8:05 AM.
Any suggestions would be greatly appreciated. Thanks! - Eric-
View 1 Replies
View Related
Sep 28, 2007
Hi,
Im trying to upgrade the PUBS DB from SQL 2000 to SQL 2005 using UA, the analysis starts well and progress and hangs at 28% for about 1 hours, what could be the reason, can any one help me?
Thanks in advance
Sakthi
View 1 Replies
View Related
Jan 12, 2005
First off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt.... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.
I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.
Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download
Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.
Hey! Hope this helps others.
Paul Townsend
View 1 Replies
View Related
Aug 13, 2001
I have setup SQL mail on SQL 7 sp3 running on NT 4 sp6a using a POP3 account (Lotus Notes 5.03 Domino Server.) I can bring up Outlook (2002) and send/receive works. Also, if I send a test mail from Operators this works as well. The problem is when using xp_sendmail the thing just hangs (xp_sendmail 'dmccallie@olanmills', 'Test') and I am left with a couple of processes in SQL that I can't kill. Is SQL mail really this hard or is it just a POS? I had been using a domain administrator account to start MSSQLServer and MSSQLAgent so I created a new domain account SQLSrvr with the same results.
Thanks in advance and any help would be great...DeWayne
View 2 Replies
View Related
Aug 17, 2001
Hi,
I am trying to drop an index usiong enterprise manager.The process hangs and Enterprise manager is not responding.When I checked the Current activity the process is in sleeping condition.I appreciate if any one can tell me what could be the reason for the process to be hung.
thanks
Mohan
View 2 Replies
View Related
Oct 3, 2001
While installing SQL 7.0 on nt4/sp6 it hangs during the MDAC portion.
The copying of files is succesfull but when it goes to the MDAC portion it hangs.
View 1 Replies
View Related
Feb 1, 2001
I have a scheduled task that runs backups on our prodcution database at midnight - it usually takes five minutes to run - but the last two nights it has been running for hours and never completing. It ran for 3 hours last night - until i was paged by the database that the transaction log backups were failing (with error 3023) to run because the backup (Backup Database db to db1_nightly with init) job was still running.
The night before our European users could not reach the database - the machine was locked up when I got in in the morning - needed a hard boot to get it back up.
I ran the backup job last night at 8:30 pm and it succeeded - but when it ran at 12:00 AM for the last two days - it runs and never completes. When I tried to kill the process in Enterprise Manager at 3:00 AM, it wouldn't stop. I tried stopping the SQLAgent Service and MSSQLSERVER service to stop the process, with no luck. Finally an early morning drive and a hard boot killed the process.
Any thoughts? There were no new jobs scheduled in the last couple of days. There is no error in the logs (the step never completes - so it's not recorded). The backup works fine if run earlier in the day.
I am running SQL 7.0 with SP2.
Thanks you for any ideas - I'm hoping not to have to drive in at 3 AM this morning - so any thoughts would be great.
View 2 Replies
View Related
Mar 21, 2000
I have created a DTS package and am having problems running it under the SQL Agent scheduler. (This is a test package and copies < 15 records from one table to another table in the same DB.)
We are running SQL Svr 7 + SP1. The server is using mixed security. The package was created using a SQL Server userid (Trusted NT ids do not have correct security to retrieve and execute the package.)
I used Enterprise Manager to schedule the package. I have edited the job to call DTSRun with the correct userid and password.
When I run the job from my desktop, it completes within a few seconds. (I have tried running the same DTSRun command from a command prompt as the one used by the scheduled job and the package completes in under a minute.)
When the job is started by SQL Agent it appears to hang and never complete.
Any ideas??
View 2 Replies
View Related
Mar 8, 1999
ISQL.EXE hangs during installation. In task manager, when I end task on ISQL.EXE the installation continues, but msdb comes up suspect. Can someone please help me.
View 2 Replies
View Related
