FYI: BUG: "IF UPDATE" Functionality Broken In SQL Server 6.5 SP5, 5a

May 18, 1999

see article: Article ID: Q216700 .
Within a trigger on SQL Server 6.5 Service Pack 5 or 5a, the IF UPDATE clause will evaluate to true for all columns when an INSERT is performed, even if there is no value specified and no default value exists for the column

http://support.microsoft.com/support/kb/articles/q216/7/00.asp

View 2 Replies


ADVERTISEMENT

Crystal 9 - Broken Report SQL Server

Dec 8, 2005

I'm using Crystal 9 with SQL Server database. I have a report that was working fine for the first 8 months. As soon as I add another month, the report fails. I've tried different setting in my indexes with different variations of periods. The minute I have over 8 periods included, the report fails. No errors, just no data. I don't even have a clue where to look for possible answers on the Internet.

Can any one help or direct me to some resources??

Thanks,

Debbie

View 4 Replies View Related

Broken Or Hung SQL Server 7 Database Scenarios

Mar 4, 1999

I'm attempting to develop a course whose objective is to present the users with several scenarios of broken or hung databases caused by different things that they then have to fix.

Do you have any ideas or examples of how to break a database and the reasons behind it, also how to repair it afterwards !!

Richard

View 1 Replies View Related

Linked Server W/ Text Field Gets Connection Broken Error

Sep 5, 2006

We have a stored proc on Server B called:

my_sp_server_b it takes 1 parameter a text field as a parameter, with default set to NULL

this proc calls:

my_sp_server_a through a linked server (which happens to be the same server, different DB), it has two parameters: my_id int, my_text text w/ my_text having a default set to NULL

This second stored procedure just selects back an ID that is passed to it (to keep things simple).

If we pass any string value to my_sp_server_b we get the appropriate hardcoded ID passed to my_sp_server_a. If we pass NULL to my_sp_server_b we get the following error:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

If we remove the linked server, and just reference my_sp_server_a via the scoped DB, we do not get an error. If we change the data type in both procs to varchar(50) we do not get an error. If we change the data type to nText we still get an error. If we put IF logic into stored procedure: my_sp_server_b to check for NULL in the input parameter and if it true then to pass NULL explicitly to my_sp_server_a we do not get an error.

It seems to be a combination of using a linked server and trying to pass a text (or nText variable) with a NULL value to stored procedure. Sometimes the error changes based on which scenario I described above - but we consistantly receive an error unless we do some of the workarounds described above.

Any ideas?

View 2 Replies View Related

SQL Server Admin 2014 :: Certain Rows Not Replicated Yet Replication Was Not Broken

Oct 24, 2013

We had an issue recently where a (transactional) replicated table was replicating data as expected.

Then about 30 or so rows in the source table were not in the destination table, but other rows created after those 30 rows were replicated.

We have pretty much confirmed that users did not delete those rows.

Unfortunately we had to resolve the issue quickly and so blew away & recreated the subscription so a lot of evidence is probably gone from the crime scene.

We cant figure out what could cause 30 rows not to be replicated, yet leave replication operational.

View 1 Replies View Related

SQL Server 2012 :: Combine Functionality Of IN And LIKE In WHERE Clause

May 8, 2015

I would like to be able to combine the functionality of IN and LIKE in a WHERE clause. Although the simple AdventureWorks2012 example below illustrates the concept with 3 search criteria, the real-world example I need to apply the concept to has a couple dozen. This returns 50 rows, but requires multiple OR ... LIKE functions:

SELECT DISTINCT c.Name
FROM Sales.Store c
WHERE c.Name LIKE '% sports %'
OR c.Name LIKE '% exercise %'
OR c.Name LIKE '%toy%'

What I would like to do is something like this, which doesn't work:

SELECT DISTINCT c.Name
FROM Sales.Store c
WHERE c.Name IN(LIKE '% sports %', LIKE '% exercise %', LIKE '%toy%')

I could load up a cursor and loop through it, but the syntax is more cumbersome than the multiple LIKE statements, not to mention most SQL programmers are horrified at the mention of the abominable word 'cursor' for performance reasons.

View 7 Replies View Related

Inserting Image Data Fails With Connection Broken (SQL Server 2000 And SQL Native Client)

May 28, 2008

Dear all,

we have tables with many image columns. We fill these image columns via ODBC and SQLPutData as described in MSDN etc (using SQL_LEN_DATA_AT_EXEC(...), calling SQLParamData and sending the data in chunks of 4096 bytes when receiving SQL_NEED_DATA).

The SQLPutData call fails under the following conditions with sqlstate 08S01

- The database resides on SQL Server 2000
- The driver is SQL Native Client
- The table consists e.g. of one Identity column (key column) and nine image columns
- The data to be inserted are nine blocks of data with the following byte size:


1: 6781262
2: 119454

3: 269
4: 7611

5: 120054

6: 269

7: 8172

8: 120054

9: 269
The content of the data does not matter, (it happens also if only zero bytes are written), nor does the data origin (file or memory).

All data blocks including no 7 are inserted. If the first chunk of data block 8 should be written with SQLPutData the function fails and the connection is broken. There are errors such as "broken pipe" or "I/O error" depending on the used network protocol.

If data no 7 consists of 8173 bytes instead of 8172 all works again.
(Changing the 4096 chunk size length does not help)

Has anybody encountered this or a similar phenomenon?

Thank you

Eartha

View 7 Replies View Related

Questions On Use Of SQL Server 2005 Functionality In Gridview Paging

Jun 25, 2007

I have a webpage that displays 4000 or more records in a GridView control powered by a SqlDataSource.  It's very slow.  I'm reading the following article on custom paging: http://aspnet.4guysfromrolla.com/articles/031506-1.aspx.  This article uses an ObjectDataSource, and some functionality new to Sql Server 2005 to implement custom paging.There is a stored procedure called GetEmployeesSubestByDepartmentIDSorted that looks like this:ALTER PROCEDURE dbo.GetEmployeesSubsetByDepartmentIDSorted(    @DepartmentID        int,    @sortExpression        nvarchar(50),    @startRowIndex        int,    @maximumRows        int)AS    IF @DepartmentID IS NULL        -- If @DepartmentID is null, then we want to get all employees        EXEC dbo.GetEmployeesSubsetSorted @sortExpression, @startRowIndex, @maximumRows    ELSE      BEGIN        -- Otherwise we want to get just those employees in the specified department        IF LEN(@sortExpression) = 0            SET @sortExpression = 'EmployeeID'        -- Since @startRowIndex is zero-based in the data Web control, but one-based w/ROW_NUMBER(), increment        SET @startRowIndex = @startRowIndex + 1        -- Issue query        DECLARE @sql nvarchar(4000)        SET @sql = 'SELECT EmployeeID, LastName, FirstName, DepartmentID, Salary,                     HireDate, DepartmentName        FROM            (SELECT EmployeeID, LastName, FirstName, e.DepartmentID, Salary,                     HireDate, d.Name as DepartmentName,                     ROW_NUMBER() OVER(ORDER BY ' + @sortExpression + ') as RowNum             FROM Employees e                INNER JOIN Departments d ON                    e.DepartmentID = d.DepartmentID             WHERE e.DepartmentID = ' + CONVERT(nvarchar(10), @DepartmentID) + '            ) as EmpInfo        WHERE RowNum BETWEEN ' + CONVERT(nvarchar(10), @startRowIndex) +                         ' AND (' + CONVERT(nvarchar(10), @startRowIndex) + ' + '                         + CONVERT(nvarchar(10), @maximumRows) + ') - 1'                -- Execute the SQL query        EXEC sp_executesql @sql      ENDThe part that's bold is the part I don't understand.  Can someone shed some light on this for me?  What is this doing and why?Diane 

View 4 Replies View Related

SQL Server 2008 :: Transaction Replication Functionality Within Mixed SPs

Jul 1, 2015

Currently, we are on SQL2008R2 EE SP1 CU13 across the board.

We are planning on upgrading the primary SQL server to SP3.

Question: Will transactional replication continue to work properly even if the Publisher is upgraded to SP3 but the subscribers remain at SP1 CU13 ?

View 2 Replies View Related

SQL Server 2008 :: Table(s) Design For Messaging Functionality?

Jul 21, 2015

I'm in the process of building messaging functionality in to my application where by users can contact one another, look at it as a dating site, you click on someones profile, view their profile and then send that user a message.

I started to build the table which looked like this:

Id (PK) (Increments by 1)

ToUserId (FK) -- User who they're getting in contact with

FromUserId (FK) -- User who sent the message

Content (nvarchar(3000)) -- Message being send

Status (int) -- read / new / deleted / sent

EmailDate (datetime)

EmailDeleted (datetime)

But the problem with this setup is both user's maybe sending / replying to each other so I would have multiple entries / statuses in one table which may become a nightmare to manage / control.

View 9 Replies View Related

Connection Broken

Jul 17, 2001

Hi
I have a problem, when i do a select records from the production server which is situated in melbourne,around 20,000 records need to be fetched but sunddenly after 13,000 records the connection is broken
why is this heppening
what is the cause for this
how to overcome this
pls let me know asap with the evidence
thanks
venkat

View 1 Replies View Related

Connection Broken!!

Jul 23, 2001

Hi ,
I am running a process from from my client having TCP/IP sockets connected to WIN NT sql server 7.0. I get a error msg [MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKETS]ConnectionCheckForData (null())).
Connection Broken .

The same thing happened in other NT SQL server as well,but it is ran o.k if i run from the server itself. Checked Microsoft documents they advised me to use Named Pipes and to check the client and server network utility. Check every detail but still facing same errors. Can anyone provide an solution for this.

Thanks,
Venkat.

View 1 Replies View Related

Broken Login

May 21, 2005

As we have just got SQL at work I had decided to play with SQL on my home computer to find out what made it tick.

I am using the 120 day demo enterprise version. While playing in the user accounts area (under security) I denied access to the database on the guest account (like you disable the guest account on domain logins) and (if you have not guessed already) I can't get access to the server anymore. I did try reinstalling but I guess that there are still some settings in the registry that don't get deleted. Any suggestions how I can get back in.

My PC at home is a XP home edition, no domain etc. SQL was installed onto the PC and I was accessing (playing with it on this PC). The setup I was playing with has no data (except what comes with the SQL) so I am not worried about losing anything.

Thanks in advance

Tim

View 1 Replies View Related

Connection Broken

Dec 6, 2007



Hi All,

When I run this statement it gives me an error.:

CREATE
INDEX [NC_DateAcctTotal] ON [dbo].[BilledPackages] ([pu_date], [acct_no], [delete_flag], [billing_weight_charge])
WITH
FILLFACTOR = 90
ON [PRIMARY]

::::: ERROR ::::


Server: Msg 823, Level 24, State 2, Line 1
I/O error (torn page) detected during read at offset 0x000006d5f2c000 in file 'E:MSSQLDataManagement_Data2_Data.NDF'.
Connection Broken

Thanks!
Aric

View 1 Replies View Related

My Query Is Broken And I Don't Know How To Fix It...

Jun 27, 2006

I am trying to set up a filtered paging ObjectDataSource for a gridvoew control.

My code works, my query doesn't...

This is OK: Get all rows of data:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes "
Returns all records as expected

This is OK: Getting rows of data with no Filter:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE Row >= 0 AND Row <= 10"
Returns expected data

This is OK: Making sure my WHERE filter works:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes WHERE country_name LIKE '%u%' "
Returns 85 records

This is BROKEN!!!: I want to return 10 rows of filtered data:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE ( Row >= 0 AND Row <= 10 ) AND ( country_name LIKE '%u%' ) "
It Returns 0 records!!!

What am I doing wrong in the last query?
Or even better how do I fix it?

Thanks,
Roger

View 6 Replies View Related

This Forum Is BROKEN!!!!

Mar 8, 2007

Anyone having problems with this forum today?

 

I have had countless email alerts thru today alerting me to people replying to threads I have commented on. And I can see the person's comments.

 

1) WhenI click on the link it takes me to a page saying the post doesn't exist

2) When I try and browse to the thread manually I can't see the reply.

3) On one occasion I replied to one of these threads asking if someone had posted something and then deleted it. After I submitted the post I could see all the other posts in the thread which were supposedly missing before. The next time I browse to the thread (in a new browser window) I can't see any of the posts.

 

BROKEN!!!! I for one won't be coming back here until they fix it. Its pathetic.

I have posted something on the bug report forum by the way.

-Jamie

P.S. Its not just on this forum either.

View 8 Replies View Related

Broken Links

May 19, 2008

I downloaded and registered Visual Studio Express Edition. I got this nice email back with links to demos, tutorials, and starter kits. Unfortunately, the links to most of the starter kits are broken. Can I still get these things?

View 1 Replies View Related

Backup Log Connection Broken

Aug 26, 2002

Hi:

While performing a restore, one of the transaction logs was apparently corrupt. So the database gets partially restored with an error saying :

Backup or restore operation successfully processed 1 pages in 0.505 seconds Processed 6 pages for database 'royal', file 'royal_Log' on file 1.
Server: Msg 9004, Level 21, State 2, Line 1
The log for database ' ' is corrupt.
ODBC: Msg 0, Level 16, State 1
Communication link failure

Can anyone give me some tips how to restore? any help appreciated.
bye
Eva

View 1 Replies View Related

Database Login Broken

Jul 3, 2007

Hi there, wasn't quite sure where to put this but I still regard myself as a bit of an SQL Server noob so thought it'd be ok here....hopefully?! lol

Right....I have a database called CDR and a Login set up for this on the server called CDMLogin. The CDR database is a non-live backup of another database stored elsewhere. In order to update this for testing purposes I needed to make a backup of the live database and then do a 'restore database' over the top of the old CDR one. This has worked fine before.....however, on this occasion, the link between the CDR database and the CDMLogin appears to have been broken. I have since read about how this can be an issue when restoring databases but I have still not found a fix. Any ideas?

Thanks v much

View 1 Replies View Related

How Can I Find 'broken' Records ?

Dec 5, 2006

Version: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)

Problem:

Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 515532920. The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 515532920. The text, ntext, or image node at page (1:377447), slot 1, text ID 897100939264 is not referenced.
<... and 4 same errors>

DBCC results for 'CC_Document'.
The repair level on the DBCC statement caused this repair to be bypassed.
<same messages>

The repair level on the DBCC statement caused this repair to be bypassed.
There are 192 rows in 6 pages for object 'CC_Document'.
CHECKTABLE found 0 allocation errors and 8 consistency errors in table 'CC_Document' (object ID 515532920).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (crmproded.dbo.CC_Document repair_fast).

I won't run checktable with 'repair_allow_data_loss' before all records aren't find out

I try run DBCC PAGE on this pages. It print info

PAGE: (1:377289)
----------------

BUFFER:
-------

BUF @0x01249540
---------------
bpage = 0x2928A000 bhash = 0x00000000 bpageno = (1:377289)
bdbid = 8 breferences = 0 bstat = 0x9
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x2928A000
----------------
m_pageId = (1:377289) m_headerVersion = 1 m_type = 3
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000
m_objId = 515532920 m_indexId = 255 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 2
m_freeCnt = 3742 m_freeData = 4446 m_reservedCnt = 0
m_lsn = (19116:290571:12) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 856438469

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:372048) = 0x42 ALLOCATED 80_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED


Blob fragment at: Page (1:377289) Slot 0 Length: 4266 Type: 3 (DATA)

Blob Id:897099563008


2928A06E: 7fe8108f 64a115ed 245a1a1a b68e502c .......d..Z$,P..
<blob fragment ... >

2928B0FE: 00006278 00006e87 00007ad1 xb...n...z..


Blob fragment at: Page (1:377289) Slot 1 Length: 84 Type: 4 (LARGE_ROOT_2)

Blob Id: 897099563008 Level: 0 MaxLinks: 5 CurLinks: 5

Child fragment at Page (1:377237) Slot 0 Offset: 8080

Child fragment at Page (1:377238) Slot 0 Offset: 16160

Child fragment at Page (1:377239) Slot 0 Offset: 24240

Child fragment at Page (1:377288) Slot 0 Offset: 32320

Child fragment at Page (1:377289) Slot 0 Offset: 36572



There are 5 links at Slot 1 , that's generate error. But why? What does it mean - "The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced" ???

I saw other pages (not 'broken') - there is: Blob Fragment don't contains links - links are in other pages.

What are these 'broken' records in my example - they are chunks of lost information, that i can't recover?

Or not? May be exists a way, that i find all 'broken' records? Because, my table contains 192 records. But there is BLOB field - and i can't check consistency of every file, that uploaded in my table. In addition I will fully appreciate this problem.

At last, if i find record, i run checktable with repair_allow_data_loss, then upload file again.

p.s. These errors contained in backup too.

View 7 Replies View Related

SSIS Package Broken

Feb 15, 2007

I have a SSIS which have a user string variable named connectionstring. In the package definition it has empty value. But in my package.dtsconfig file I set the value of this variable.

But I am not getting the value inside a script component. I tried debugging with a msgbox echoing the variable value ... but I see only empty value i.e. at runtime the value is not being read from config file

What can be wrong here?

next if I put the value ("Data Source=<Server>;Initial Catalog=<Database>;Integrated Security=True;") in the variable definition itself I get the following error

[Execute SQL Task] Error: Failed to acquire connection "<ADO Connection>". Connection may not be configured correctly or you may not have the right permissions on this connection.



The SSIS was running fine previously ... it broke after I updated by machine with the latest windows updates today.

I am working on a 64 bit Windows 2003 SP1 Server box with Visual Studio 2005 SP1, SQL Server 2005 SP1

View 3 Replies View Related

.NET 2.0 SP1 / Connection String To SQL Broken

Apr 12, 2008

Hi,

Our vertical market applicaiton uses connection strings to connect to SQL 2005.
.NET 2.0 SP1 was auto updated on one of our machines

Connection strings are now failing (doesn't return -1 but doesn't connect).

Can anyone help?

I'm really nervoust that on Monday 1200 angry customers are going to call.

View 7 Replies View Related

Broken Link To Chart

Jun 28, 2007

Hi,



I have made a chart that displays data for my company. However, when I have the report.rdl on the "live" serverand use the "live" data source, I can't get the report manager to display the chart, only the famuos x of a broken image link. If I place the report.rdl on the test server and use the "live" data source the chart is displayed.

What is the difference between having the report on the test server versus the "live" server?



Report manager -> report on test server -> live data source = working

Report manager -> report on "live" server -> live data source = no image



I dont think the problem is sequrity related, but I dont know for sure...



Thanks in advance!

Niklas

View 4 Replies View Related

Error 41 Broken Pipe - Any Ideas

Feb 5, 2003

Hi guys,

Running a clustered webserver, windows 2000, IIS v5, and a sql server, v2000. Using OLE Db as connection, running stored procedures, no sql created on the fly. The website handles about 5000 transaction a day.

Every now and again, we get a problem whereby an error 41 - Broken Pipe is reported. I can't find any info on this error on Technet, MSDN, etc. Google returns info, but only really affecting solaris, unix, linux, etc.

Anyone ever come across this error before? or know what might cause it? and possible resolutions?

View 2 Replies View Related

Calculating Avg Of Days Broken Down By Period

Nov 28, 2013

Aim – Calculate the number of days between CreatedDate and [Date_Docs_In_Complete__c],count how many Ids, Fall within a specific month by year, and then work out the avg number of days it took for each month

My query so far

select
ID,
left(CreatedDate,10) as CreatedDate,
left([Date_Docs_In_Complete__c],10) as [Date_Docs_In_Complete__c],
DATEDIFF(day,CreatedDate,[Date_Docs_In_Complete__c]) as Days
from #build

Produces following results

IDCreatedDateDate_Docs_In_Complete__cDays
0063000000ausKGAAY2010-03-262013-07-161208
0063000000mC359AAC2011-06-302013-07-03734
0063000000oyaSPAAY2011-11-292013-07-18597

Desired outcome results would be

Year Month Date_Docs_In_Complete__c Total Days Avg_Days
2013 07 3 2539846.3

View 2 Replies View Related

Broken Links In Subscription Emails

Nov 2, 2007

Hi everyone,

Is there somewhere that I can change the links that are included in subscription emails? The link that goes out is incorrect because the port number of the server is not included in the link, so I'd like to edit this. Does anyone know where this can be done? Thank you!

-Keith

View 1 Replies View Related

SSIS Connection Manager Broken

Oct 6, 2006

Hi to all,

I'm having serious problem with SSIS on my development machine.

each time I try to add a new Connection manager i got this error :

TITLE: Microsoft Visual Studio
------------------------------
The new connection manager could not be created.
------------------------------
ADDITIONAL INFORMATION:

The connection manager 'OLEDB' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design)

This happen for any type of Connection Manager, ADO.NET, FILE,SMTP. I've already tried to uninstall SSIS , but nothing change.

I've any chance to get this problem solved?

Thanks in advance


View 2 Replies View Related

SQL Express Download Links Broken

Feb 13, 2007

Hi,

I was trying to download SQL Server Management Studio Express from http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx. The links on this page seem to be broken.

I tried to download the Mgmt Studio Express by clicking on a link that points to http://go.microsoft.com/fwlink/?LinkId=65110.

Anyone else facing this issue? Is there another place I can get SQL Server Management Studio Express from?

View 10 Replies View Related

Broken Subscriptions Due To Empty Table

Jul 31, 2007

Hi,

I was wondering what the best way was to deal with subscriptions breaking due to an empty table. I have subscriptions that people have scheduled to go out daily, but on certain days the table may be empty, in this case the subscription doesn't read the parameters for the report and then the subscription breaks.

My original solution involved creating a #temp table with the same columns as the original table and inserting one row into it which I'd union with the original table, this row in the temp table had all its values set to 0. The solution worked when I ran it in SQL Server Management Studio but it seems SRS doesn't like the INSERT INTO statement, which is the error I get, but I've read on these forums that it doesn't like #temp tables either. I proceeded to use a stored procedure with all the code in it, but I might have trouble filtering on multi value parameters, because at times these parameter lists get real big, plus I have to do this for multiple reports and don't want to get into creating stored procedures for each report.

Following is what the code I used look something like that executes and does the job in Management Studio but not SRS. I'm mainly just looking for the easiest and cleanest way to do this, since it'll have to be done across multiple reports, so disregard the code if there's an easier way to do it. Thanks in advance.

create table #dummytable
(
name varchar(35),
country varchar(35),
idnumber (int)
)
GO

insert into #dummytable (name),values('0');

select name, country, idnumber
from originaltable
where name in (@name)

union
select name = 0, country = 0, idnumber = 0
from #dummytable

drop #dummytable


View 4 Replies View Related

Execution Instance Guid Broken?

Oct 10, 2006

The execution instance guid appears to be broken in SSIS (post SP1 hotfix is the version for this test). The package itself reports a different value at runtime than management studio does via RunningPackages.

One package execution reports two guids depending on where look. The issue is not with the PackageID or VersionGUID, but the actual runtime guid, available in the package as the system variable "System::ExecutionInstanceGUID".

ExecutionGuid via System::ExecutionInstanceGUID as reported by package script task:
C825418B-E796-4EBF-BEB8-14CBEC257D81

ExecutionGuid reported by /CONSOLELOG command line parameter to dtexec
C825418B-E796-4EBF-BEB8-14CBEC257D81

ExecutionGuid reported by SSIS Log Provider for text files:
C825418B-E796-4EBF-BEB8-14CBEC257D81

ExecutionGuid Reported by Management Studio Running Packages Node:
4810b482-6a83-4564-8b3b-c5017a590506

ExecutionGuid reported in MsDtsSrvr.exe:
4810b482-6a83-4564-8b3b-c5017a590506

ExecutionGuid reported by GetRunningPackages():
4810b482-6a83-4564-8b3b-c5017a590506

All the gory details are below:

Text Log:

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,(null)
OnPostValidate,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,(null)
PackageStart,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,Beginning of package execution.
Diagnostic,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 3.
OnPreExecute,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,(null)
OnInformation,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,LineageID: LineageId
OnInformation,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,Attempting to sleep ...


Console Log:
Log:
Source Name: Sleep
Source GUID: {A367974F-1C2F-4D8B-9F8B-79B1B9AD854E}
Execution GUID: {C825418B-E796-4EBF-BEB8-14CBEC257D81}
Message: ExecutionInstanceGUID => {C825418B-E796-4EBF-BEB8-14CBEC257D81}
Start Time: 2006-10-09 21:33:40
End Time: 2006-10-09 21:33:40

Output System::ExecutionInstanceGUID via Dts.Log()
C825418B-E796-4EBF-BEB8-14CBEC257D81


Management studio Integration Services Running Packages Node:
Package Name ExecGuidTest
Executed By FPSjaegd
Execution Instance ID 4810b482-6a83-4564-8b3b-c5017a590506
Execution Started 10/9/2006 9:30:54 PM
Execution Duration 213542
Package ID 435383c9-f9ca-463d-8a94-f654975b5d2d


Value logged by msdtssrvr.exe:
Registering package ExecGuidTest (435383c9-f9ca-463d-8a94-f654975b5d2d) for FPSjaegd, assigned ID 4810
b482-6a83-4564-8b3b-c5017a590506
Package ExecGuidTest (435383c9-f9ca-463d-8a94-f654975b5d2d) registered by FPSjaegd, assigned ID 4810b4
82-6a83-4564-8b3b-c5017a590506

Value available via GetRunningPackages()

GAC Version Location
--- ------- --------
True v2.0.50727 C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ManagedDTS9.0.242.0__89845dcd8080cc91Micros...

InstanceID : 4810b482-6a83-4564-8b3b-c5017a590506
UserName : FPSjaegd
PackageDescription :
PackageName : ExecGuidTest
PackageID : 435383c9-f9ca-463d-8a94-f654975b5d2d
ExecutionStartTime : 10/9/2006 9:30:54 PM
ExecutionDuration : 136388

Powershell script is as follows:
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ManagedDTS")
$a = New-Object Microsoft.SqlServer.Dts.Runtime.Application
$a.GetRunningPackages("localhost")

View 6 Replies View Related

DB-Library Process Dead - Connection Broken

Aug 19, 1999

Hi!
I am running a SELECT query in SQL Server 6.5 and continue to get the following message (error?):

This command did not return data, and it did not return any rows

DB-Library Process Dead - Connection Broken

I'm running it directly from Enterprise Manager on the same box as the database itself. The problem seems to be specific to the query itself as minor changes work fine. There are lots of joins involved - the query joins 3 tables and a view, that view joins 3 tables and a sub-query, and that sub-query joins 2 more tables. Simple queries on the view seem to indicate that the view works fine.

I'm a web/DB developer, but not much of a DBA. Has anyone run into this problem and know what may be causing it? Please let me know if you need to see the code of the query and/or the view. (Will replies be emailed to me automatically? If not, please email to tmenier@ontrack.com.)

Thank you!

View 3 Replies View Related

Db-library Process Dead - Connection Broken

Mar 30, 1999

Using Server 6.5 ISQL. This occurrs after running a 5 to 10 processes ???

View 2 Replies View Related

Help: DB-Library Process Dead - Connection Broken

Jul 15, 1998

I have a stored procedure whose sole purpose is to assign a value to 26 variables using select statements (i.e. select @enroll = (select count(distinct upid)fromPATLOG). Some of the souces are tables and some are views.

After the 26 variables are assigned they are written to a table using a INSERT into Values (@enroll, @tbrconsents,...)

My problem is that when I run the SP I get the message

"This command did not return data, and it did not return any rows"
"DB-Library Process Dead - Connection Broken"

and nothing is written to the table. I`m fairly new to SQL programming so I haven`t a clue where to start. The SP has run successfully four times intermittantly but I can`t get it to run consistantly.

Any help or insights would be appreciated.

Regards,

Larry

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved