SSIS - OLE DB - IBM DB2 - SQLDUMP - More Dumps Than Works....
Feb 8, 2007
I have a package which access a DB2 database and pulls data from a single table. I can't put a specific event on it, but the package has been causing a dump to occur on a rather regular basis. The really odd part is sometime when I add a data viewer on the output link of the OLE DB Source it works....then it starts to dump again a couple of executions later. There are not date/time values involved in the result set, just character strings. Default code page is set to 1252 and use default page is set to False....any ideas appreciated - this is really starting to drive me nuts!
Thanks
View 18 Replies
ADVERTISEMENT
Apr 26, 1999
Can anyone tell me where I can find information about why sql server might be executing a stack and/or symptom dump?
That is, what are some of the conditions that might cause this. Every time I try to DBCC DBREINDEX on a certain table, stack
and symptom dumps occur and SQL Server remains incommunicado (can't connect, even locally) until I restart it. I'm going to try to fix the table by using
rename table, create new table (and dependent objects) , transfer data, and toast the original table. No problem, I've done that
before with smashing success. But, if this solves my problem, I'll still be no wiser about what it was that caused the problem in
the first place. Any suggestions, questions, comments, or even jeers would be appreciated.
Thanks,
Chris
View 1 Replies
View Related
Jun 27, 2007
Could anyone help about the following case? many many thanks in advance
1. This problem will be happended for different but similar storeprocedures in transient manner. However, when we try to repeat the problem by running the procedure again, it work fines
2. However, the problem has happended again unexpectedly
3. The problem occurs in different server have similar environment (Window 2003 server and SQL Server 2000 SP4).
Following is the dump:
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/21/07 15:52:04 spid 57
*
* Exception Address = 007EA027 (SQLExit + 00282530 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 76A6F2F3
* H p m s _ R p t 12 00 48 00 70 00 6d 00 73 00 5f 00 52 00 70 00 74 00
* M t n _ 0 0 0 1 1 4d 00 74 00 6e 00 5f 00 30 00 30 00 30 00 31 00 31 00
* 2 @ P a r a m _ 32 00 00 00 0a 40 00 50 00 61 00 72 00 61 00 6d 00 5f
* I d x H H 00 49 00 64 00 78 00 00 e7 48 00 04 04 d0 00 00 48 00
* d 7 7 7 9 8 1 1 - 64 00 37 00 37 00 37 00 39 00 38 00 31 00 31 00 2d 00
* 9 9 d e - 4 6 6 1 39 00 39 00 64 00 65 00 2d 00 34 00 36 00 36 00 31 00
* - 9 b 8 4 - 6 9 1 2d 00 39 00 62 00 38 00 34 00 2d 00 36 00 39 00 31 00
* d a f 8 8 3 f d 2 64 00 61 00 66 00 38 00 38 00 33 00 66 00 64 00 32 00
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7C8D0000 7D0D3FFF 00804000
* msvcrt 77BA0000 77BF9FFF 0005a000
* GDI32 77C00000 77C47FFF 00048000
* USER32 77380000 77411FFF 00092000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 76290000 762ACFFF 0001d000
* LPK 62D80000 62D88FFF 00009000
* USP10 75490000 754F0FFF 00061000
* comctl32 77420000 77522FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 71C40000 71C97FFF 00058000
* AUTHZ 76C40000 76C53FFF 00014000
* COMRES 77010000 770D5FFF 000c6000
* ole32 77670000 777A3FFF 00134000
* XOLEHLP 01600000 01605FFF 00006000
* MSDTCPRX 61150000 611C7FFF 00078000
* msvcp60 780C0000 78120FFF 00061000
* MTXCLU 74F40000 74F58FFF 00019000
* VERSION 77B90000 77B97FFF 00008000
* WSOCK32 71BB0000 71BB8FFF 00009000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* OLEAUT32 77D00000 77D8BFFF 0008c000
* CLUSAPI 74DE0000 74DF1FFF 00012000
* RESUTILS 74EF0000 74F02FFF 00013000
* USERENV 76920000 769E3FFF 000c4000
* secur32 76F50000 76F62FFF 00013000
* mswsock 71B20000 71B60FFF 00041000
* DNSAPI 76ED0000 76EFEFFF 0002f000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F87FFF 00008000
* NTMARTA 77E00000 77E21FFF 00022000
* SAMLIB 5CCF0000 5CCFEFFF 0000f000
* SSNETLIB 00E80000 00E95FFF 00016000
* security 71F60000 71F63FFF 00004000
* crypt32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* schannel 76750000 76776FFF 00027000
* rsaenh 68000000 6802EFFF 0002f000
* PSAPI 76B70000 76B7AFFF 0000b000
* dssenh 68100000 68123FFF 00024000
* hnetcfg 5F270000 5F2C8FFF 00059000
* wshtcpip 71AE0000 71AE7FFF 00008000
* SSmsLPCn 00EF0000 00EF7FFF 00008000
* SSnmPN70 410D0000 410D6FFF 00007000
* ntdsapi 766F0000 76704FFF 00015000
* SQLFTQRY 03410000 03435FFF 00026000
* xpsp2res 10000000 102C4FFF 002c5000
* CLBCatQ 777B0000 77832FFF 00083000
* sqloledb 03450000 034D0FFF 00081000
* MSDART 74A50000 74A69FFF 0001a000
* MSDATL3 61200000 61214FFF 00015000
* oledb32 03900000 03978FFF 00079000
* OLEDB32R 037E0000 037F0FFF 00011000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* xpsqlbot 03A00000 03A05FFF 00006000
* xplog70 03020000 0302EFFF 0000f000
* xplog70 03A10000 03A14FFF 00005000
* xpstar 410F0000 4113CFFF 0004d000
* SQLRESLD 42AC0000 42ACBFFF 0000c000
* SQLSVC 04900000 0491AFFF 0001b000
* ODBC32 04920000 0495CFFF 0003d000
* COMCTL32 77530000 775C6FFF 00097000
* comdlg32 762B0000 762F9FFF 0004a000
* odbcbcp 60950000 60955FFF 00006000
* W95SCM 41140000 4114CFFF 0000d000
* SQLUNIRL 5BB30000 5BB5CFFF 0002d000
* WINSPOOL 73070000 73096FFF 00027000
* SHFOLDER 766D0000 766D8FFF 00009000
* odbcint 04B20000 04B36FFF 00017000
* NDDEAPI 75810000 75816FFF 00007000
* SQLSVC 04C50000 04C55FFF 00006000
* xpstar 04C60000 04C68FFF 00009000
* dbghelp 04DB0000 04EAFFFF 00100000
*
* Edi: 00000000:
* Esi: 4A517478: 4A516020 4A517FF0 92CDD908 9D63AD4C CB0EB00C 00000029
* Eax: 76A6F2F3:
* Ebx: 4A517358: 00240024 00000010 00000000 00000000 47000002 00000000
* Ecx: 00000004:
* Edx: 00000004:
* Eip: 007EA027: CE8B108B 508B1189 04518904 8908508B 508B0851 0C51890C
* Ebp: 032F84E8: 032F8540 0075AD60 44E195C0 44DF6038 4A517308 032F8560
* SegCs: 0000001B:
* EFlags: 00010206: 00740073 00720065 0063005C 0075006C 00740073 00720065
* Esp: 032F84C4: 44E195C0 4A517308 44DF6038 4A517478 4A517358 00000001
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 007EA027 Module(sqlservr+003EA027) (SQLExit+00282530)
* 0075AD60 Module(sqlservr+0035AD60) (SQLExit+001F3269)
* 008C222B Module(sqlservr+004C222B) (GetIMallocForMsxml+000CD6AB)
* 00461C5A Module(sqlservr+00061C5A)
* 004B817B Module(sqlservr+000B817B)
* 005DAE2A Module(sqlservr+001DAE2A) (SQLExit+00073333)
* 005DB09D Module(sqlservr+001DB09D) (SQLExit+000735A6)
* 005DA3AB Module(sqlservr+001DA3AB) (SQLExit+000728B4)
* 00461C5A Module(sqlservr+00061C5A)
* 004C680A Module(sqlservr+000C680A)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC024 Module(sqlservr+000FC024)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 00514181 Module(sqlservr+00114181)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 0048ED21 Module(sqlservr+0008ED21)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC024 Module(sqlservr+000FC024)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004C680A Module(sqlservr+000C680A)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004C680A Module(sqlservr+000C680A)
* 00461C5A Module(sqlservr+00061C5A)
* 0048ED21 Module(sqlservr+0008ED21)
* 00461C5A Module(sqlservr+00061C5A)
* 004885F1 Module(sqlservr+000885F1)
* 00461C5A Module(sqlservr+00061C5A)
* 00541A71 Module(sqlservr+00141A71)
* 00461C5A Module(sqlservr+00061C5A)
* 0048FCF1 Module(sqlservr+0008FCF1)
* 00461C5A Module(sqlservr+00061C5A)
* 00461D54 Module(sqlservr+00061D54)
* 00466407 Module(sqlservr+00066407)
* 004667DD Module(sqlservr+000667DD)
* 00466893 Module(sqlservr+00066893)
* 00464D29 Module(sqlservr+00064D29)
* 00464E1F Module(sqlservr+00064E1F)
* 00464FE7 Module(sqlservr+00064FE7)
* 004709F2 Module(sqlservr+000709F2)
* 00470A8F Module(sqlservr+00070A8F)
* 004786CF Module(sqlservr+000786CF)
* 0044DBE7 Module(sqlservr+0004DBE7)
* 0044D85C Module(sqlservr+0004D85C)
* 0043711A Module(sqlservr+0003711A)
* 005CF4AF Module(sqlservr+001CF4AF) (SQLExit+000679B8)
* 005CF7D1 Module(sqlservr+001CF7D1) (SQLExit+00067CDA)
* 00415E57 Module(sqlservr+00015E57)
* 0043CDDE Module(sqlservr+0003CDDE)
* 0043D005 Module(sqlservr+0003D005)
* 0042598D Module(sqlservr+0002598D)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E6608B Module(kernel32+0002608B) (GetModuleFileNameA+000000EB)
* -------------------------------------------------------------------------------
View 2 Replies
View Related
May 15, 2007
I would like to loop through a SQL Server table that contains the paths to all the reports(SSRS) we need to run and then execute the reports via SSIS. What task should I be doing to do this? Will the For Loop work for something like this? Anyone Please Explain how to do it . Or either Explain me how to run a Report(SSRS) from SSIS
View 3 Replies
View Related
Dec 26, 2006
Hi,
I am running SQL Server 2005 and have built a simple SSIS package to import data from an oracle database to my SQL Server 2005 database. When I run it in SSIS, it works and it imports just fine. When I schedule it, it gives me problems. Help!
It might be a problem with Oracle Provider client I installed. Is there a client version I can download and install? the one I downloaded from oracle doesn't work. I bet i did something wrong though.
Here is my version:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: IDE Standard
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.2047.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.2047.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.2047.00
Thanks,
Ryan
View 5 Replies
View Related
Feb 1, 2007
I have a problem running an SSIS package in a SQL Server job. The package runs fine if I run it from the MSDB location, but if I try to run the job it fails. The job is set to Run as: SQL Agent Service Account. The SQL Service Agent service runs as a domain user SQLExec. I have logged in as this user and run the SSIS package and it runs fine, but if I create a job with only this step it fails. There isn't much information about where there is a problem. Any ideas or ways to troubleshoot this problem would be very much appreciated.
Thanks, john
View 3 Replies
View Related
Oct 2, 2007
If this is a duplicate post I apologise in advance as my search yielded many results about mail alerts but none like this.
The scenario is my SSIS package is scheduled to read data from a remote FoxPro source. If for any reason it fails I have set up an email task to alert internal users and an external helpdesk.
My problem is that if I am running it via Management Studio i.e. SQL Server Agent/Jobs/Start Job and I 'force a failure' by unplugging the network cable it successfully sends an email alert to all recipients (internal and external). If I let the job execute according to the schedule (still with the network cable unplugged) the job fails (as expected) but no email alerts are sent.
I log onto the server with a valid domain user account who has administrative rights to the server as well as dbo rights on the SQL instance. I deploy my package as the domain user and have checked that the domain user is also the 'owner' of the scheduled job.
I suspect it has something to do with ownership or which user is 'truly executing the scheduled job'. Any ideas would be welcome.
Thanks in advance, Craig
View 1 Replies
View Related
Oct 2, 2006
Hi:
I am new to SSIS. I would like to know if I want to transfer data from one Oracle schema to another Oracle schema and also to do scheduling of the packages, can I still use SSIS? If yes, what are the components that need to be installed on the database server and the development environment? I hope I don't need the full SQL Server database installation in order to use SSIS.
Thanks!
MuiSukYuen
View 1 Replies
View Related
May 9, 2007
Hi There,
I am trying to set a variable with this default value using expression. This works in tsql but doesn't in ssis. Can anybody tell me what is wrong with this?
dateadd("dd", -1, datediff("dd", 0, getdate()))
Thanks.
View 8 Replies
View Related
Jan 3, 2008
I have made a package that reads a text file into a table.
The data in the file is roughly as follows.
1, "a", "b,c,ddddd", 4, "ee", 0 with the column sizes int, 1, 50, int, 2, int
On all the desktop Bids environments and a SQL 2005 instance on windows server 2000 the package runs fine.
on the 2 Windows server 2003/SQL 2005 machines a truncation error occurs on col 5.
What is happening is on these machines the text qualifier is being ignored and column 5 is reading as ddddd instead of ee!
I figured this out by changing all fields to text and seeing what came out of the other end.
It is very, very strange and I've hit a brick wall.
If Anyone has any ideas throw them in the mixer please?
Cheers,
Steve
View 5 Replies
View Related
Nov 15, 2007
I have an SSAS 2005 database "A" and SSIS package "P" which process full "A" olap database.
SSAS SERVER connection string is based on a variable read from XML configuration file.
It works well in BIDS, but when i deployed, the package failed at the step connecting SSAS, the message is "a connection cannot be made, please ensure the server is running"
In the connnecting string, i am using server name like servera.xx.com, if I change it to IP address, it works.
if I change it to Localhost(happens to be on the same server), it works.
But I need the server name solution as IP may be changed.
I installed SP2.
Any suggestion?
Thanks and regards
View 2 Replies
View Related
Feb 13, 2008
HiIam new to this groupSO can any one provide me with dumps of 1z0-007regdsAJax
View 4 Replies
View Related
Oct 10, 2007
We have a Process Task component setup in a couple SSIS jobs to call a command batch file to support transfering a file via Secure FTP to other servers and the process works fine if we start the SQL Agent job manually, however when the job is started via the scheduler, it fails with an exit code of 4. Even though there is a proxy setup on the agent job, is there a different user account being invoked by the scheduler??? We're on 2005 SP1 Hotfix 1 (2153). Thanks
Some more info...have found that if we leave a login session open on the server (login is the proxy account) the process works. It appears the issue is associated with a need to render/create a command window for the command line/batch process to run in and without an active windows session it fails....would seem to be that a product setup to run on a server in a batch mode would be able to work without this...is this the case? if so, how? Thanks.
View 11 Replies
View Related
Nov 2, 2006
We're experiencing a problem where intermittently our SSIS packages will hang. There are no log errors or events in the event viewer. It will happen whether the package is executed from the SQL Job Agent or run from BIDs. When running from BIDs it appears to hang inside one of the data flows (several parallel pipes with sorts, merge joins etc...). It appears to hang in multiple pipes within the data flow component. The problem is reproducable, we just kill it and re-run, and it appears to hang in the same places.
Now here's the odd thing: as we simply open and close some of the components in the pipe line after the place it hangs, a subsequent run will go further in the pipeline before hanging. If we open and close all the components after the point it initially hung, the data flow will run fine, from there on out. When I say "open and close" I mean no changes are made, we simply double-click the component, like a merge join, then click 'close.'
To me this does not seem like a memory problem but likely something is wrong with the metadata, where opening a component and closing it somehow alters the metadata to "right it".
This seems to occur intermittently after we make modifications to the package. It's like if you make any mod, even unrelated to the data flow, you then have to go through and open and close every component in your package to ensure it will work. Again, no errors or warnings are fired.
Has anyone seen this type of problem?
View 10 Replies
View Related
Aug 13, 1998
Hi !
I have one crashed database !
I have no dumps at all !
I have cold backup of the data files !!
Is it possible to just restore the datafiles and everything`s nice again ??
View 2 Replies
View Related
Oct 6, 1999
Hi,
I need to set up a dump of my main database's transaction log to dump every hour but not overwrite until the 8th hour (keeping 7 log dumps). Can anyone tell me how to set up the scheduled tasks for the transaction log dump? Is there anything special I need to do for the main database dump?
Thank you, Laurie
View 2 Replies
View Related
Jan 25, 1999
Hi:
Actually we have problems doing database dumps, so we're copying directly the .DAT files
to a backup machine, I mean the .DAT files are the data devices that uses SQL no dumps files.
We can do or eecute the dump process.
What problems can we expect doing this?
Which can be the problems 'cause we cannot dump our DB's?
Thanks
View 1 Replies
View Related
Jun 1, 1999
I have noticed a question on the Admin exam which involves declaring and usting a time variable for scheduling a backup or dump of a database. Is this possible and has anyone else seen this on the exam or used it in reality?
View 2 Replies
View Related
Jul 9, 2007
Hello gurus,
Our SQL Servers is giving us a headache, after a certain period in time, either SQL Service automatically shuts down by itself or hangs. I've opened the logs and found hex dumps. Can you help me out with these?
2007-07-08 04:04:35.20 spid53 SqlDumpExceptionHandler: Process 1760 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* ************************************************** *****************************
*
* BEGIN STACK DUMP:
* 07/08/07 04:04:35 spid 53
*
* Exception Address = 0042D46D
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 6AF1EDF0
* Input Buffer 4088 bytes -
* USE Document DBCC DBREINDEX (dtproperties) DBCC DBREINDEX (REfID_DocID
* ) DBCC DBREINDEX (RF_UNISYS_ErrorCodes) DBCC DBREINDEX (SYS_Document_F
* lat_Meta_Data) DBCC DBREINDEX (SYS_Document_Meta_Data) DBCC DBREINDEX
* (SYS_Document_Meta_Detail) DBCC DBREINDEX (SYS_Documents) DBCC DBREIND
* EX (SYS_ETFuelType) DBCC DBREINDEX (SYS_ETStatus) DBCC DBREINDEX (SYS_
* HF_Document_Meta_Data) DBCC DBREINDEX (SYS_HF_MI_Emission_Results) DBC
* C DBREINDEX (SYS_ITP_Failed) DBCC DBREINDEX (SYS_MI_Emission_Results)
* DBCC DBREINDEX (SYS_RF_Document_Meta_Data) DBCC DBREINDEX (SYS_RF_Docum
* ent_Status) DBCC DBREINDEX (SYS_TR_Document) DBCC DBREINDEX (SYS_TR_SM
* S_Document) USE Industry DBCC DBREINDEX (dtproperties) DBCC DBREIND
* EX (IND_MF_Industry) DBCC DBREINDEX (RF_ErrorCodes) DBCC DBREINDEX (RF
* _OperationCodes) DBCC DBREINDEX (RF_Unisys_ErrCodes) DBCC DBREINDEX (S
* YS_Admin_Has_Agents) DBCC DBREINDEX (SYS_Admin_Sharing) DBCC DBREINDEX
* (SYS_Companies) DBCC DBREINDEX (SYS_Company_Has_Admins) DBCC DBREINDE
* X (SYS_Company_Meta_Data) DBCC DBREINDEX (SYS_HF_Admin_Has_Agents) DBC
* C DBREINDEX (SYS_HF_Companies) DBCC DBREINDEX (SYS_HF_Company_Has_Admin
* s) DBCC DBREINDEX (SYS_HF_Company_Meta_Data) DBCC DBREINDEX (SYS_HF_Us
* er_Meta_Data) DBCC DBREINDEX (SYS_HF_Users) DBCC DBREINDEX (SYS_MF_App
* Variables) DBCC DBREINDEX (SYS_MI_Token) DBCC DBREINDEX (SYS_Page_Acce
* ss) DBCC DBREINDEX (SYS_Pages) DBCC DBREINDEX (SYS_Password_History)
* DBCC DBREINDEX (SYS_RF_Announcement) DBCC DBREINDEX (SYS_RF_BodyType)
* DBCC DBREINDEX (SYS_RF_Color) DBCC DBREINDEX (SYS_RF_Company_Meta_Data)
* DBCC DBREINDEX (SYS_RF_Company_Status) DBCC DBREINDEX (SYS_RF_DieselT
* ype) DBCC DBREINDEX (SYS_RF_EmissionFees) DBCC DBREINDEX (SYS_RF_Emiss
* ionRules) DBCC DBREINDEX (SYS_RF_Fuel_Type) DBCC DBREINDEX (SYS_RF_Hel
* pDetails) DBCC DBREINDEX (Sys_RF_Make) DBCC DBREINDEX (SYS_RF_Month)
* DBCC DBREINDEX (SYS_RF_MVClassification) DBCC DBREINDEX (SYS_RF_MVType)
* DBCC DBREINDEX (SYS_RF_MVType2) DBCC DBREINDEX (SYS_RF_Page_Groups)
* DBCC DBREINDEX (SYS_RF_Purpo
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* Invalid Address 77F80000 77FFBFFF 0007c000
... <snipped>
* xpstar 09240000 09248FFF 00009000
* rsabase 092D0000 092F2FFF 00023000
* dbghelp 0AA80000 0AB7FFFF 00100000
*
* Edi: 0AA53937: 00000000 00000000 00000000 84004A00 98018901 C501B101
* Esi: 6AF1EDF0:
* Eax: 00000878:
* Ebx: FFFFE000:
* Ecx: 3FFFF800:
* Edx: FFFFE000:
* Eip: 0042D46D: CA8BA5F3 F303E183 DC7D8BA4 83D045FF 4D8B2CC7 E9D233E0
* Ebp: 0A1BFCC0: 0A1BFCE4 0042D5CD 71E428CC 71E40570 71E40988 0AA519A0
* SegCs: 0000001B:
* EFlags: 00010206: 00530053 0052004F 003D0053 00000034 0053004F 0057003D
* Esp: 0A1BFC28: 0AA519A0 71E4052C 00000000 00000010 71E408A0 00000010
* SegSs: 00000023:
* ************************************************** *****************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0042D46D Module(sqlservr+0002D46D)
* 0042D5CD Module(sqlservr+0002D5CD)
* 0042D6C7 Module(sqlservr+0002D6C7)
* 00508750 Module(sqlservr+00108750)
* 0051EB18 Module(sqlservr+0011EB18)
* 0051E9E4 Module(sqlservr+0011E9E4)
* 0085EACA Module(sqlservr+0045EACA) (GetIMallocForMsxml+0006A08A)
* 004229A7 Module(sqlservr+000229A7)
* 0087B87B Module(sqlservr+0047B87B) (GetIMallocForMsxml+00086E3B)
* 0087E3C9 Module(sqlservr+0047E3C9) (GetIMallocForMsxml+00089989)
* 0059A449 Module(sqlservr+0019A449)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 7C57B3BC Module(KERNEL32+0000B3BC) (lstrcmpiW+000000B7)
* -------------------------------------------------------------------------------
*Dump thread - spid = 53, PSS = 0x55a35280, EC = 0x55a355b0
*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0020.txt
*** Problems occur intermittently, sometimes after our full backup which occurs every 0000h, sometimes 30 minutes after our transaction log dumps.
Please advice me on my next step. Thanks
View 7 Replies
View Related
Mar 18, 2004
Hi all,
I've read that the SQL dump can only be done directly into the local server. Is there a way to put directly the dump into another server via the network (not copying it but writing it during the process of backup).
Any help much apreciate.
Thanks
View 1 Replies
View Related
Mar 14, 2008
According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED.
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
Now this is the situation that I have where I need to understand how SSIS works?
Enviornment: Active Active cluster enviornment for SQL server with SSIS server installed as stand alone as default on both node.
Name: Node 1 Node 2
--------- -------------- ---------------------
Server name: Nd1 Nd2
SQL server name: cs-nd1in01 cs-nd2in02
SSIS server name: Nd1 Nd2
BTW, this is cosolidated enviornment so there are more than one application expected and resides on each instance of SQL server.
The question is around SSIS, what would be the best practice to develop SSIS package that can work with above envoinrment.
Secnario: What if my Nd1 fails. SQL server cs-nd1IN01 will be failover to Nd2 and it will be available. But How about SSIS packages? How that understands
to use Nd2 SSIS as Nd1 SSIS is not available. Is anyone has similar experience to setup SSIS in cluster envionrment but as non-cluster service?
Please help. Thanks in adavance.
View 1 Replies
View Related
Oct 22, 2002
We are experiencng high cpu utilization across all 4 cpu's at the top of the hour when our transaction log dump job runs. Has anyone observed this bahavior before? Is there anything we can do to mitigate this? Thank You.
View 4 Replies
View Related
May 5, 1999
I am testing a procedure to automate the transaction log dump. I am following the steps located in Chapter 22 of the Microsoft SQL Server Administrator's Companion ("Automatic Transaction Log Dumps Using Performance Monitor"). The alert in Performance Monitor appears to be starting when the log is 75% full, but the alert is not firing off the file that contains the dump transaction sql command. For the 'Run Program on Alert' box this is what I have: isql -Ssvrname -Usa -P -id:appsmssqlinndump.sql
The dump.sql file contains: 'dump transaction pubs with no_log'
I have also tried the following 4 steps: 1) Created a SQL Alert Messsage, 2) Created an NT Performance Monitor Threshold Alert to run sqlalrtr to issue a certain error when the pubs log is 75% full, 3) Created a TSQL Task, and 4) Created a SQL Server Alert to run the Task created in step 3. This appears to do the same thing. The Alert is fired off, but the Task is never executed. Note: I am able to execute the task from within the Schedule Tasks Window.
I am using Standard Security with SQL Server 6.5 (sp5a) running on NT4.
Thanks for you help in advance.
View 2 Replies
View Related
May 6, 2007
Hi Forum,
I am new to microsoft SQL server as I am from Oracle background. I am preparing to the MCP certification for Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. The exam shows as SQL server 2000 is there any exam for SQL server 2005.
Is it the write exam to give to start as fesher into microsoft platform. Iam into development not towards administration.
If any body has any Exam preparation questions please forward them to krishna.kanigelpula@gmail.com.
Regards,
Krishna.
View 1 Replies
View Related
Oct 5, 2004
I am attempting to remember the string to dump/restore a database to a different physical server.
I have the database on Server 1 and want to back it up to server 2. Can anyone refresh my memory?
Thanks
View 3 Replies
View Related
Sep 30, 1998
How can I check to make sure that my dumps are not corrupted? I have been using a utility from Microsoft called DSCAN5, but have found that this has some limitations.
View 1 Replies
View Related
Jul 1, 1999
Hi,
does anybody know how to automate the loading of incremental transaction dumps. The manual way is to use the "load tran DB with FILE = x" statement.
Since this has to be done in the right sequence and i need to automate this task to keep a second server up to date i like to know if there is a stored procedure
or any other tool which could do the task.
Thanks for your help
Best Regards
Yorn Ziesche
View 1 Replies
View Related
Jul 28, 2000
our users believe that we lost some valid data, but no one knows who did it,
I thought I can find it from the transaction dumps I take every hour
so ,Can I read Transaction Dumps (*.TRN) file in SQL server 7.0 or Can I get this information through other means.
Thanks for your help
DP
View 3 Replies
View Related
May 31, 2000
I'm going back and forth on an issue and was looking for some outside observations. I have over a dozen SQL NT servers, both 6.5 and 7.0. On some servers I'm dumping the databases and backing up the dumps with Veritas BackupExec, on 4 (two SQL 6.5, two v7) I'm backing up with the Veritas SQL Backup Agent.
Obviously, if you don't have room to dump a database, you must use the backup agent. That is the case on one of my servers and becoming so on a second. But my personal preference is to do the dump/backup.
(as a side note, one server is not backing up correctly with the backup agent but ultimately that box will require it due to DB growth, so it is something that I have to resolve)
I like the dump system for a few reasons. I find it easier to load from a dump, particularly a single table. Likewise, I find it easier to copy a database by loading from a dump rather than going from a backup, but that's mainly because of BackupExec being a little bit strange on redirecting restores.
Here's my clincher. I find restores via the backup agent to be ridiculously slow. Let's say I have a 5gig DB that has 1.5gig in it. The dump size will probably be somewhere below 2gig. The restore via backup agent carefully writes the entire 5gig even though 3.5g of that is empty. This takes a lot of time. Add to that the "post-restore DBCC". I had such a restore take something on the order of 13 HOURS which, needless to say, conflicted with my nightly DBCC's and backups.
OK. End of rant. Any suggestions or thoughts on the subject?
View 1 Replies
View Related
Jul 7, 2015
I have two calls to stored procedures that in an SSIS package fails silently. They are simply not executed in production but works fine in test, nothing happens and the sql server agent reports that everything has gone just fine.
In test they have 1 server with db A and B. No issue here.
In prod they have 2 servers with db A and B. On server 1 sql server agent executes a job that includes an SSIS package that on server 2 runs a couple of sp's. That user is db owner on server 2 db B and yet nothing happens. The sp's are not executed.
If I in prod run the job manually then it works, but not when run with the sql server agent account that as said is even db owner.
View 2 Replies
View Related
Jul 26, 2004
I've got a popular problem so i get a message that server acces denied! ..
But that what is different in my error.... When i use same setting same database and connection string (on MSDE server) there is no problem...
On SQL server i have got windwos authentication but i added all accounts as ASPNET and SA.... and when i try to connect by
RETTO - name of my server
server=RETTO;uid=sa;pwd=password;database=db1;
or by
Integrated Security=SSPIserver=RETTO;uid=RETTOASPNET;database=db1;
I CAN BROWSE RECORDS THERE ARE NO PROBLEMS WITH CONNECTION!!! but when i try to update or iinsert or delete something in database there becomame this error that access denied or server does not exist!!!
PLEASE HELP I'm FIGHTING WITH THAT FOR OVER 5 DAYS!!!
I MADE FOR MY ACCOUNTS (SA, ASPNET) ALL THINGS ALLOWED AS EXECUTING stored procedures.. OR ACCESING datatables with insert delete and update query WHERE IS THE PROBLEM!!!??
View 3 Replies
View Related
Jun 20, 2007
I'm having a strange problem with this but I know (and admit) that the problem is on my PC and nowhere else. My firewall was causing a problem because I was unable to PING the database server, switching this off gets a successful PING immediately. The most useful utility to date is running netstat -an in the command window. This illustrates all the connections that are live and ports that are being listed to. I can establish a connection both by running
telnet sql5.hostinguk.net 1433 and
sqlcmd -S sql5.hostinguk.net -U username -P password
See below:
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP 81.105.102.47:1134 217.194.210.169:1433 ESTABLISHED
TCP 81.105.102.47:1135 217.194.210.169:1433 ESTABLISHED
TCP 127.0.0.1:1031 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51114 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51201 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51202 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51203 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51204 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51206 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1025 *:*
UDP 0.0.0.0:1030 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 81.105.102.47:123 *:*
UDP 81.105.102.47:1900 *:*
UDP 81.105.102.47:5353 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1086 *:*
UDP 127.0.0.1:1900 *:*
Both these utilities show as establishing a connection in netstat so I am able to connect the database server every time, this worked throughout yesterday and has continued this morning.
The problem is when I attempt to use SQL Server Management Studio. When I attempt to connect to tcp:sql5.hostinguk.net, 1433 nothing shows in netstat at all. There is an option to encrypt the connection in the connection properties tab in management studio, when I enable this I do get an entry in netstat -an, see below:
TCP 81.105.102.47:1138 217.194.210.169:1433 TIME_WAIT
TCP 81.105.102.47:1139 217.194.210.169:1433 TIME_WAIT
TCP 81.105.102.47:1140 217.194.210.169:1433 TIME_WAIT
Amost as if it's trying the different ports but you get this time_wait thing. The error message is more meaningful and hopefull because I get:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)
I would expect this as the DNS has not been advised to encrypt the conection.
This is much better than the : Login failed for user 'COX10289'. (.Net SqlClient Data Provider) that I get, irrespective of whether I enter a password or not.
This is on a XP machine trying to connect to the remote webhosting company via the internet.
I can ping the server
I have enabled shared memory and tcp/ip in protocols, named pipes and via are disabled
I do not have any aliases set up
No I do not force encryption
I wonder if you have any further suggestions to this problem?
View 7 Replies
View Related
Sep 26, 2006
I use the code below for updating data from a AS400 Liked server. I dont understend how the WHERE NOT EXISTS( sections work however usualy they do, in this case it does not andt I can't seem to find out why.
Does anyone see the error?
Thanks
--=========================================
--Create a local temporary table that hold
--all the data from the source table
--=========================================
SELECT * INTO #TEMP FROM dbo.LINK_LTTSTOC
--=========================================
--Remove table entries that are no longer
--needed or that have to be updated
--=========================================
DELETE FROM LTTSTOCK
WHERE NOT EXISTS( SELECT * FROM #TEMP
WHERE LTTSTOCK.WarehouseNo = LTWHLO
AND LTTSTOCK.Location = LTWHSL
AND LTTSTOCK.ItemNo = LTITNO
AND LTTSTOCK.NumberAvail = LTAVAL
)
--=========================================
--Insert data that is missing or that
--needed to be updated and was previously
--deleted
--=========================================
INSERT INTO dbo.LTTSTOCK(WarehouseNo,Location,ItemNo,NumberAvail,rowguid)
SELECT DISTINCT LTWHLO,LTWHSL,LTITNO,LTAVAL, NEWID()
FROM #TEMP
WHERE NOT EXISTS( SELECT * FROM LTTSTOCK
WHERE WarehouseNo = LTWHLO
AND Location = LTWHSL
AND ItemNo = LTITNO
AND NumberAvail = LTAVAL
)
--========================================
--Remove local temporary table.
--========================================
DROP TABLE #TEMP
View 2 Replies
View Related
