Reputation
240
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 7
Newest
 Editor
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
May
11
revised SSIS Packages get stuck in SQL Agent jobs
added 322 characters in body
May
11
comment SSIS Packages get stuck in SQL Agent jobs
If you're interested I narrowed this down to our SSIS framework which is called 'BIPA'. I deleted the BIPA logging add in and we no longer have this problem. Based on the .net wait's happening in SSIS I believe it just couldn't instantiate the provider somehow. Why it only does this at night I don't know.
May
8
comment Script to see running jobs in SQL Server with Job Start Time
For me this returned the correct recordset - currently running jobs
May
8
comment Script to see running jobs in SQL Server with Job Start Time
For me this query returned disabled jobs that aren't actually running
May
4
comment Can't start MSSQLSERVER service
didn't work? What was the error? Does this help: eukhost.com/forums/f15/…
Apr
24
comment SSIS Packages get stuck in SQL Agent jobs
Thankyou Aishwary but the packages run fine 95% of the time, and when they stop, they all stop (including for example backup plan packages which I didn't develop). I don't have any transactions in any package. If this was the case I would see some indication of database activity but there is none.
Apr
24
comment Advantage of exposing data model to customers using our product
Are you liable in any way of a customer imports rubbish and/or error causing rows? Does the import table have sufficient constraints, foreign keys, unique constraints, check constraints to stop people importing rubbish? For example if you have a report which joins on a field, and the field is incorrectly duplicated, it will duplicated all joined tables as well, causing incorrect data.
Apr
24
answered Receiving the following error in step failure of an agent job:
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
OK it happened again. I fire up Process Explorer and took a look at the DTExec process (which is doing nothing). It had 10 threads all in various wait states. There were 6 mscorwks.CreateApplicationContext threads in state Wait_UserRequest. This is not my area of expertise and I don't think it's telling me anything new.
Apr
23
revised SSIS Packages get stuck in SQL Agent jobs
added 68 characters in body
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
Yes, I have my suspicions about AD, but.... I didn't mention this... we also have a PROD instance which seems to be behave. I don't think its had this problem. There are a a LOT of factors going into this one, and I don't expect I'll be able to find a solution here, just suggestions. @bilinkc, have you ever had issues with this 'certificate revocation' issue? sqlservercentral.com/Forums/Topic522133-148-1.aspx. It seems this can cause a delayed start but not a total hang (for days)
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
The other thing is we have a DEV and TEST SQL instance on the same box and they seem to hang at the same time.
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
The default database is fine. The service account is sysadm so there's no reason it can't get into the DB. I don't understand the error - a sysadm will never be unable to log into any database
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
In SQL Profiler trace there is no activity. In the SQL Error logs there are a lot of errors saying the service account cannot log into its default database. This doesn't make any sense though - if the service account suddenly couldn't log in to a database the package would return an error, not just stop.
Apr
23
comment SSIS Packages get stuck in SQL Agent jobs
The thing is they run fine under the same service account the whole time. They just intermittently stop. I would expect some kind of error if there was a security issue, but instead they just don't start
Apr
23
asked SSIS Packages get stuck in SQL Agent jobs
Apr
11
accepted Is the Advanced Security Pack required for windows authenticaion?
Apr
11
comment Is the Advanced Security Pack required for windows authenticaion?
Thanks. My next challenge is to convince the DBA's of this.
Apr
10
comment Is the Advanced Security Pack required for windows authenticaion?
We have a development instance and windows authentication ('the EXTERNAL login with no password) suddenly stopped working. I asked why and I was told advanced security was removed. Nowhere can I find confirmation that advanced security is required to make this work. It just stopped working when they removed it
Apr
10
awarded  Editor