Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







SSIS - OLE DB - IBM DB2 - SQLDUMP - More Dumps Than Works....


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
STACK DUMPS AND SYMPTOM DUMPS
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 Replies !   View Related
SQLDump EXCEPTION_ACCESS_VIOLATION


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, itwork 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 Replies !   View Related
SQL Server Sqldump With EXCEPTION_ACCESS_VIOLATION
I am continually getting a sqldump EXCEPTION_ACCESS_VIOLATION and am required to reboot the server to fix the problem. The problem will occur at lease twice a week.

View Replies !   View Related
SSRS Works From SSIS
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 Replies !   View Related
SSIS Package Works, But Not In SQL Server Agent Job
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 Replies !   View Related
SSIS: Oracle Import Works, But Not When Scheduled
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 Studio9.00.2047.00
Microsoft Analysis Services Client Tools2005.090.2047.00
Microsoft Data Access Components (MDAC)2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer6.0.3790.1830
Microsoft .NET Framework2.0.50727.42
Operating System5.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 Replies !   View Related
How SSIS Works With Data Sources Other Than SQL Server?
Hi:

I am new to SSIS. I would like to know if I want to transfer data from one Oracle schema to another Oracle schemaand 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 Replies !   View Related
SSIS E-mail Alert Only Works When Run Manually
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 Replies !   View Related
DateAdd Expression Works In Tsql But Doesn't Work In Ssis
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 Replies !   View Related
SSIS Flat File Text Qualifier Only Works On Some Machines!
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 environmentsand 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 Replies !   View Related
SSIS Processing Cube Task, Only IP Address Works, Put Server Name Will Get Error
I have anSSAS 2005database "A" and SSIS package "P" which processfull "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 Replies !   View Related
SSIS - Process Task Exit Code 4 - Via SQL Agent Scheduled Job Only - Works If Manually Started....
We have a Process Task componentsetup ina 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 Replies !   View Related
SSIS Package Hangs In Data Flow, Magically Works After Opening And Closing Components
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 (severalparallel pipes withsorts, merge joins etc...). It appears tohang 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 Replies !   View Related
How SSIS Works With Cluster SQL And Non Cluster SSIS Service?


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 1Node 2
--------------------------------------------
Server name:Nd1Nd2
SQL server name:cs-nd1in01cs-nd2in02
SSIS server name:Nd1Nd2

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 Replies !   View Related
Need Of SQL Dumps
HiIam new to this groupSO can any one provide me with dumps of 1z0-007regdsAJax

View Replies !   View Related
Please Help Me Debug Hex Dumps
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 Replies !   View Related
SQL 2K Dumps Via Network
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 Replies !   View Related
Restoring Without Dumps
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 Replies !   View Related
Problems Doing Dumps
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 Replies !   View Related
Question Regarding Dumps
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 Replies !   View Related
Transaction Log Dumps
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 Replies !   View Related
Automating Transaction Log Dumps
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 Replies !   View Related
High CPU During Tran Log Dumps
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 Replies !   View Related
Exam 70-229 Preapration Dumps
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 Replies !   View Related
Elapsed Time Differences For Dumps
I have 6.50sp4 installed.
I have noticed significant differences in dump elapsed times for the same database.
It appears to be associated with whether a local drive dump file is used (eg D:MSSQLBACKUPBACKUP1.DAT) versus a UNC name for a local drive dump file (eg COMPUTERAD$MSSQLBACKUPBACKUP1.DAT) where ComputerA is the database
server.

Has anyone found a way to get the local UNC dumps to run faster or a fast as the local drive dump files. I was hopping to convert to using only
UNC dump file names.

Thanks.

View Replies !   View Related
Check To Make Sure Dumps Are Not Corrupt
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 Replies !   View Related
Automate Load Of Transaction Dumps
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 Replies !   View Related
Long-running Transactions And Log Dumps?
Hello:

I am reviewing our backup strategy.

The application, running on mssql 6.5, sp4, involves long-running transaction intermittently during a given month but particularly so at month-end as this is a financial application written in Powerbuilder.

I have been thinking of including the dumping of the transaction log several times a day but I am concerned about the effect of a long-running transaction when the log has to be dumped. The result will probably hang the transaction or the dump; neither being the desired result. It's difficult to determine when the transaction willocur most times.

1) Has any one experienced something like this with long_running transactions and log dumps?

2) Any other thoughts on this?

Thanks.

David Spaisman

View Replies !   View Related
Cross Server Database Dumps
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 Replies !   View Related
SQL SERVER ACCESS DENIED!! BUT Everything Works On MSDE And Works SHOWING RECORDS ON SQL SERVER!! PLEASE HELP
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 Replies !   View Related
Telnet Connection Works, Sql Cmd Connection Works, SQL Server Managment Studio 2005 Does Not
I'm having a strangeproblem 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 furthersuggestions to this problem?



View Replies !   View Related
How To Put An Expiry Date/day On The Dumps But Not Necessarily On The Device
I was just wondering if anyone can help. How to put an expiry date/day on the dumps but not necessarily on the device itself. Is this possible? Any help will be appreciated Thanks.


Jose

View Replies !   View Related
Backing Up: Dumps Vs SQL Backup Agents Using BackupExec
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 Replies !   View Related
Can I Read Transaction Dumps (*.TRN) File In SQL Server 7.0
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 Replies !   View Related
I Don't Understand How This Works, However It Works (sometimes)
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 Replies !   View Related
DTS. Works Sometimes, Not Others
I'm running a DTS package that works correctly when I do "Execute Package" directly, by right clicking the package.

But, if I schedule the job, it fails.

It's trying to write data to another server, but I can't see why it doesn't work as a scheduled job. I tried changing all the parameters I can think of. I'm no Windows expert, so if you have any ideas, please feel free to explain as if you're talking to a "newbie" (since I am one)

Win 2000, SQL 2000

View Replies !   View Related
This Works, But...
I am going to tangle with our ERP system for the rest of my natural life, and in so doing, will need to create new SQL queries on an almost-daily basis. Based on the handful of queries that I have created against it so far, I recognize that I need to get better at authoring them.

Towards that end, I was wondering if anyone with a little firmer grasp on the subject could take a look at this query (which works & does exactly what I need it to do) and make suggestions as to what I might have done better/differently.

I've changed the names of everything to make it more comprehensible (I hope).

The query returns one row for each unique record in DetailTable, with data from the SummaryTable and a PartDescription from ThirdTable.

SELECT SummaryTable.RecordID,
SummaryTable.Status,
SummaryTable.CustomerName,
SummaryTable.CustomerNumber,
SummaryTable.OrderNumber,
SummaryTable.AssignedTo,
SummaryTable.ResolvedBy,
SummaryTable.ResolveDate,
SummaryTable.PartNumber,
SummaryTable.PartRevision,
SummaryTable.OrderQuantity,
SummaryTable.IssueCategory,
SummaryTable.IncidentDate,
SummaryTable.InquiryDate,
SummaryTable.IssueClass,
SummaryTable.Severity,
SummaryTable.IssueNumber,
SummaryTable.AuthorizedBy,
SummaryTable.Facility,
DetailTable.AssignedTo,
DetailTable.ActionDate,
DetailTable.ActionBy,
DetailTable.JobNumber,
DetailTable.ActionTaken,
DetailTable.NextAction,
DetailTable.IncidentNotes,
ThirdTable.PartDescription

FROMtheDatabase.dbo.DetailTable
LEFT JOIN
theDatabase.dbo.SummaryTable ON DetailTable.RecordID=SummaryTable.RecordID
LEFT JOIN
theDatabase.dbo.ThirdTable on SummaryTable.PartNumber = ThirdTable.PartNumber
AND SummaryTable.PartRevision = ThirdTable.PartRevision

WHERE (SummaryTable.IssueCategory='1' OR SummaryTable.IssueCategory='2' OR SummaryTable.IssueCategory='3'
OR SummaryTable.IssueCategory='D' OR SummaryTable.IssueCategory='E' OR SummaryTable.IssueCategory='L'
OR SummaryTable.IssueCategory='O' OR SummaryTable.IssueCategory='R' OR SummaryTable.IssueCategory='S'
OR SummaryTable.IssueCategory='V' OR SummaryTable.IssueCategory='X' OR SummaryTable.IssueCategory='Z')
AND SummaryTable.Facility='Default' AND SummaryTable.Status='OPEN'

ORDER BY SummaryTable.RecordID

View Replies !   View Related
Sometimes It Works, Sometimes Not...
I have a VB app that loads 9 text files for 8 different products, one product at a time. The user must select the product to import. For each product the application:

1. Copies the 9 text files from the source directory to a "process" directory.
2. Calls a stored procedure that sequentially calls a different SSIS package for each text file.
3. Performs some additional processing.

Here's the problem. For the 7th product in the sequence, at least 2 of the text files are not being loaded, and no error exceptions are being thrown. For the 8th product in the sequence at least one text file is not being loaded. If I comment out the call to the stored proc in VB and run the stored proc manually at that point in the program, all files are processed.

On the text file side, the files are being copied correctly and the read-only flag on the file is not being set. In addition, I can open the files in a text editor without any problem.

I'm totally stumped here, so any helpful advice would be appreciated.

TIA,

Mike

View Replies !   View Related
SMO Backup Works On One Not The Other
Can anyone enlighten me on sqlexpress smo?
I have compiled an exe using vbc running the folloing code
Imports SystemImports Microsoft.SqlServer.Management.SmoImports Microsoft.SqlServer.Management.CommonImports System.IO
Module SMOtest
    Sub Main()      Try        Kill(System.Environment.GetFolderPath Environment.SpecialFolder.ProgramFiles) & " estSMO_BACKUP")      Catch      End Try      Try        System.Threading.Thread.Sleep(500)        Dim bkpfileName As String = System.Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles) & " estSMO_BACKUP"        Dim backDeviceItem As New BackupDeviceItem(bkpfileName, DeviceType.File)        Dim db As String = "test"  ' Define and set db        Dim bck As New Backup()  ' Instantiate a Backup object        bck.Action = BackupActionType.Database  ' Set Action
   bck.BackupSetName = db & "_BackupSet"  ' Set Backup
        bck.Database = db  ' Set Database name property        bck.Devices.Add(backDeviceItem)
        Dim srv As New Server()  ' Instantiate a Server object        bck.SqlBackup(srv)  ' Invoke Backup object's SqlBackup method      Catch      End Try    End SubEnd Module
This works fine on a win2k dev system though when moving to another win2k system the code will error on non system databases. If db= model,master,tempdb etc it executes fine. When I try to backup a created db (any) I get an error stating the name is not found in sysdatabases.
SELECT name FROM master..sysdatabases
where name not in ('master','tempdb')
shows all the created databases including "test" in this case
keep in mind many recompiles using different db's work fine on one system and not the other. Even restored "test" from a backup from the system with no problems only to have a 3041 error consistently on the other. System databases work fine for all attempts on the offending system.
Any ideas? (the offending system is a SAT raid which has been evil from the get go) corruption seems to be the only conclusion I can reach
 
 
 
 

View Replies !   View Related
Login Works With VWD But Not On IIS
Hello,
I created a simple login page using the login contol in Visual Web Developer.  I used the site administrator from this control to add a user.  When I preview in browser with VWD the login works fine.  But when I put the page on IIS and goto it, I login and it always says login attempt unsuccessful, like I put in the wrong password or something.
Why does this work with the VWD previewer but not on IIS?
Thanks,
John

View Replies !   View Related
Dts Works From SqlServer But Not From ASP.net
I have an asp.net page that executes a DTS. When I execute that DTS from enterprise manager it takes about 5000 rows from the as400 and insert into sql serverIt works right. but when I execute it from my asp.net page I have this error.Error al procesar DTS TransferirDatos(ExistMP) en el paso DTSStep_DTSActiveScriptTask_1System.Exception: Error al procesar DTS TransferirDatos(ExistMP) en el paso DTSStep_DTSActiveScriptTask_1 at LibreraLentos.exec.ejecuta_SP_EXISTENCIASMP() in C:Documents and SettingsluisvalenMis documentosVisual Studio ProjectsInventariosLentosLibreraLentosexec.vb:line 43 at InventariosLentos.generacionprocesomateriaprima.btnenviar_Click(Object sender, EventArgs e) in C:AplicacionesWebInventariosLentosgeneracionprocesomateriaprima.aspx.vb:line 60LibreraLentos I have this on my ASP page   Private Sub btnenviar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnenviar.Click        Try            objexecsp.ejecuta_SP_EXISTENCIASMP()            lblmensajes.Text = "Proceso generado satisfactoriamente"        Catch ex As Exception            lblmensajes.Text = ex.Message + ex.GetBaseException.ToString + ex.Source.ToString        End Try    End Subthis on my Data Classs   Public Function ejecuta_SP_EXISTENCIASMP()        ' call UpdatePrice using a parameter array of SqlParameter objects        Try            Dim ejecutardts As New cDTS            ejecutardts.EjecutarDTS("TransferirDatos(ExistMP)")        Catch ex As Exception            Throw ex        End Try    End FunctionThis is what executes the DTSImports System.Runtime.InteropServicesImports System.Configuration.ConfigurationSettingsImports DTSPublic Class cDTS    Public Sub EjecutarDTS(ByVal NombreDTS As String)        Dim pkg As New DTS.Package        Dim oStep As DTS.Step        Try            pkg = New DTS.Package            'pkg.LoadFromSQLServer(AppSettings("MED20NT"), AppSettings("user"), AppSettings("pwd"), DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "", "", "pruebaCdr1")            pkg.LoadFromSQLServer("MED20NT", "sa", "prueva", DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "", "", NombreDTS, "")            pkg.AutoCommitTransaction = True            pkg.Execute()            For Each oStep In pkg.Steps                If oStep.ExecutionResult = DTSStepExecResult.DTSStepExecResult_Failure Then                    Throw New Exception("Error al procesar DTS " & pkg.Name & " en el paso " & oStep.Name)                End If            Next        Catch ex As System.Runtime.InteropServices.COMException            Throw ex        Catch ex As Exception            Throw ex        Finally            pkg.UnInitialize()            pkg = Nothing        End Try    End SubEnd Class

View Replies !   View Related
Normalisation Vs If It Works Just Do It!
Hi All,

As an accomplished web devver of many years using ASP and ASP.NET in conjunction with Access and SQL Server, I am a bit pedantic on the rules of good data structures.

Specifically the two main rules of data redundancy and normalisation.

The latter dictates at the lowest level that a data table should NOT contain a field that can be gleaned from one or a combination of others.

I have a problem with this now, I am building a betting system which will take the odds given, plus the stake placed and calculate the winnings or losses accordingly.

There is an added complication in that not all profit is calculated the same way, as a horse can also be 'placed' which does the same calculation as for profit, but then quarters it, so one single select statement won't do.

I could calculate this at data entry stage on a per entry basis and simply store in a Profit/Loss field and keep the value for each bet, however I know this is not the correct thing to do!

My other alternative [and the correct method] is to do this calculation at data request time, but that would involve the use of a cursor or loop in the SP.

I am aware of the huge resources a cursor can consume and I am not sure which is worse, using a cursor or ignoring the normalisation procedures.

So the question is this, what would you do here?

Since I may not be the same SQL Server expert as I am a programmer, is there an alternative way of reading all the bets and doing these calcs on SQL server and bang them back to ASP as a self contained recordset with all the profit/losses calculated for each bet?

Each bet as a unique EntryID and there is a field called Result which stores 'Win, Place or Loss' accordingly.

Thanks in advance of any help/opinions.

:)

View Replies !   View Related
Please Tell Me How SCOPE Works?
The following is the Scope in my MDX Script IIn the Calculation Tab of BIDS
SCOPE
(
[Order Date].[Date].Members,
[Measures].[Internet Sales-Sales Amount]
);
This = ([Ship Date].[Date].CurrentMember, [Measures].[Internet Sales-Sales Amount]);

END SCOPE

I intend to replace the [Internet Sales-Sales Amount] values for [Order Date].[Date] with [Internet Sales-Sales Amount] values for [Ship Date].[Date]

I am not getting the desired results.
Moreover can I use results of other members (other than the once in the SCOPE subcube) to be replaced (by using the This assignment) in the Subcube.

Any help appreciated.
Thanks

View Replies !   View Related
Dts Works But Run Same Dts Via Sql Job Failed
hi all,
i posted this somewhere else but i think here is the right group.

i have a dts that shld write to a text file located at a mapped drive. i read somewhere that sql job does not recognise mapped drive, so i use UNC path in form \128.1.1.1dtsfile, which dtsfile folder is the shared folder name. i opened the folder permission to everyone.

thats abt the remote server. the sql server i am running is on windows NT, logon using Administrator to local. my sql is SQL 2000. i register the server using sa username. the server agent is start up using System account.

now the problem is when i run the dts interactively/manually, it runs succesfully. but when i run it thru SQL job it says "Access denied". Or full error is like this,

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

i really hope and appreciate if someone out there can help me out. thanks!

ps: pls let me know if more clues needed from my environment settings.

View Replies !   View Related
DTS Works But Job Fails
Hi

I have a DTS to copy data from Oracle to SQL Server. When I logon to SQL Server box with a userID xxx, I can run the DTS from EM and it works perfectly fine but when I schedule the DTS as job, it fails.

SQL Server agent is running with same account "xxx"
DTS connects to SQL Server with sa authentication
Job owner is same account "xxx"

Job error log

Executed as user: DOMAINNAMExxx. ... Drop table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart: Drop table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnStart: Drop table [IFS_PROD].[dbo].[SUPPLIER_INFO] Step DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: Drop table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnFinish: Drop table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart: Create Table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart: Create Table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnFinish: Drop table [IFS_PROD].[dbo].[SUPPLIER_INFO] Step DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO] Step DTSRun OnStart: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnFinish: Create Table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnFinish: Create Table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart... Process Exit Code 6. The step failed.


I copied the DTS to another one and scheduled it

This time I got the error log
Executed as user: DOMAINNAMExxx. ...... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnFinish: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnStart: Copy Data from SUPPLIER_INFO_ADDRESS to [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnError: Copy Data from SUPPLIER_INFO_ADDRESS to [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step, Error = -2147467259 (80004005) Error string: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Error source: Microsoft OLE DB Provider for Oracle Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (. The step failed.

Please help!
Thanks in advance

View Replies !   View Related
From Access To SQL And Now Nothing Works!
Help, I had my entire DB created and when i thought i was done, i upsized to SQL and now almost none of my queries work?

The below works when i remove Distinct, but then i have doubles?


Code:

SELECT DISTINCT
Equip_ProductName.ProductName, Equip_ProductName.ProductInfoID, Equip_ProductName.ProductDesc, Equip_ProductName.ProductSearchTerm,
Equip_ProductName.ProductMore, Equip_ProductName.Visible, Equip_Products.ProductID, Equip_Products.CategoryID
FROM Equip_Products INNER JOIN
Equip_ProductName ON Equip_Products.ProductInfoID = Equip_ProductName.ProductInfoID
WHERE (Equip_ProductName.Visible = 1) AND (Equip_Products.CategoryID = 1)
ORDER BY Equip_ProductName.ProductName

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved