Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Message sequencing error Expand / Collapse
Author
Message
Posted Thursday, January 14, 2010 5:57 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:32 AM
Points: 94, Visits: 378
We extract data daily from an Cache database using the OpenQuery method of data extract from Cache. We have received a "Message sequencing error" exception from this process. The SQL code used in the OpenQuery for the Cache extract runs correctly on the Cache server with no errors.

Is there any place I can find what this message actually means?

The complete message is:
OLE DB provider "MSDASQL" for linked server "PGH_CACHE" returned message "[Cache ODBC][State : 08S01][Native Code 452]
[C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe]
Message sequencing error".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT
a.IEN,
a.Number,
a.PatientID,
a.AdmissionDate,
%internal(a.AdmissionDate) as AdmissionDateint,
a.Drg,
a.DischargeDate,
%internal(a.DischargeDate) as DischargeDateint
FROM PTHLDR.Ptf_45 a
Where a.IEN in(288695,288740,288741)" against OLE DB provider "MSDASQL" for linked server "PGH_CACHE".
--
The field that causes the exception is Drg. If I comment out this field the extract works.

Any help or direction is appreciated.

Thanks.
Post #847479
Posted Thursday, January 14, 2010 6:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:54 AM
Points: 6,813, Visits: 14,028
Have you contacted the vendor?



“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #847494
Posted Thursday, January 14, 2010 7:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:32 AM
Points: 94, Visits: 378
Yes. I have contacted them and an individual has been assigned but no response at this time. My previous contacts with issues have been that when the vendor sees an indication of a SQL message vs. Cache message, coupled with the fact that the query runs correctly on the Cache server, the response is "not my problem".

I have not actually received this response yet, but will not be surprised.

Thanks.
Post #847548
Posted Thursday, December 26, 2013 8:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 15, 2014 1:16 PM
Points: 26, Visits: 80
Did you ever get a response from InterSystems on this? I get the same error occasionally and would like to resolve it if I can.
Post #1525977
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse