RE: SQL failure

From: Ravi Annepu [MSFT] (annepur_at_online.microsoft.com)
Date: 11/15/04


Date: Mon, 15 Nov 2021 23:16:45 GMT

Can you provide more details on what kind of BizTalk application you have
deployed?

Thank you.
Ravi Annepu.

--------------------
| >>Content-Class: urn:content-classes:message
| >>From: "SP" <sp@discussions.microsoft.com>
| >>Sender: "SP" <sp@discussions.microsoft.com>
| >>References: <43d201c4c68c$c264bf00$a401280a@phx.gbl>
| >>Subject: SQL failure
| >>Date: Thu, 11 Nov 2021 07:49:50 -0800
| >>Lines: 84
| >>Message-ID: <1dc501c4c806$13f4b620$a501280a@phx.gbl>
| >>MIME-Version: 1.0
| >>Content-Type: text/plain;
| >> charset="iso-8859-1"
| >>Content-Transfer-Encoding: 7bit
| >>X-Newsreader: Microsoft CDO for Windows 2000
| >>thread-index: AcTIBhPyzlnrPZJ2QG+/z1QP9UqhPA==
| >>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >>Newsgroups: microsoft.public.biztalk.general
| >>Path: cpmsftngxa10.phx.gbl
| >>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:21555
| >>NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| >>X-Tomcat-NG: microsoft.public.biztalk.general
| >>
| >>Any suggestions from MSFT??
| >>
| >>
| >>>-----Original Message-----
| >>>Any help/suggestions to solve the following errors would
| >>>be appreciated.
| >>>
| >>>Event Type: Error
| >>>Event Source: BizTalk Server 2004
| >>>Event Category: BizTalk Server 2004
| >>>Event ID: 6912
| >>>Date: 11/9/2021
| >>>Time: 1:12:26 PM
| >>>User: N/A
| >>>Computer: NJ90H6ENW2K3A
| >>>Description:
| >>>The following stored procedure call failed: " { call
| >>[dbo].
| >>>[bts_InsertTrackingData]( ?, ?, ?, ?, ?, ?, ?, ?, ?)}".
| >>>SQL Server returned error string: "String data, length
| >>>mismatch".
| >>>
| >>>The above error is followed by
| >>>
| >>>Event Type: Error
| >>>Event Source: XLANG/s
| >>>Event Category: None
| >>>Event ID: 10034
| >>>Date: 11/9/2021
| >>>Time: 1:12:26 PM
| >>>User: N/A
| >>>Computer: NJ90H6ENW2K3A
| >>>Description:
| >>>Uncaught exception terminated service XXXXX(846f436c-388f-
| >>>bacc-d98a-2f95465746b4), instance ade8e6cf-4507-436d-9c97-
| >>>789d3e6d62ce
| >>>
| >>>Exception occurred when persisting state to the database.
| >>>
| >>>Exception type: PersistenceException
| >>>Source: Microsoft.XLANGs.BizTalk.Engine
| >>>Target Site: Void Commit()
| >>>Help Link:
| >>>Additional error information:
| >>>
| >>>A batch item failed persistence Item-ID 5fbec834-e278-
| >>447f-
| >>>97f7-ab5f97cd9d90 OperationType MAIO_CommitBatch Status -
| >>>1061151938 ErrorInfo A database failure occurred due to
| >>an
| >>>unexpected failure. .
| >>>
| >>>Exception type: PersistenceItemException
| >>>Source:
| >>>Target Site:
| >>>Help Link:
| >>>Additional error information:
| >>>
| >>>Exception occurred when persisting state to the database.
| >>>
| >>>Exception type: PersistenceException
| >>>Source: Microsoft.XLANGs.BizTalk.Engine
| >>>Target Site: Void Commit
| >>>(Microsoft.BizTalk.Agent.Interop.IBTMessageBatchEx[],
| >>>Microsoft.XLANGs.Core.Segment,
| >>>Microsoft.BizTalk.Agent.Interop.IBTOperationStatus ByRef)
| >>>Help Link:
| >>>Additional error information:
| >>>
| >>>A batch item failed persistence Item-ID 5fbec834-e278-
| >>447f-
| >>>97f7-ab5f97cd9d90 OperationType MAIO_CommitBatch Status -
| >>>1061151938 ErrorInfo A database failure occurred due to
| >>an
| >>>unexpected failure. .
| >>>
| >>>Exception type: PersistenceItemException
| >>>Source:
| >>>Target Site:
| >>>Help Link:
| >>>Additional error information:
| >>>
| >>>.
| >>>
| >>

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team



Relevant Pages

  • SQL failure
    ... >Exception occurred when persisting state to the database. ... >Help Link: ... >Additional error information: ...
    (microsoft.public.biztalk.general)
  • Exception occurred when persisting state to the database.
    ... This is the Exception I am seeign in my production environment, ... Exception occurred when persisting state to the database. ... Additional error information: ... Status -1061151998 ErrorInfo The published message could not be routed ...
    (microsoft.public.biztalk.general)
  • Re: Variable naming problem
    ... better defined as throwing an exception instead. ... Maybe we should talk about what constitutes a failure first. ... > You seem to be referring to some particular readLine method; ... > * Reads a line into the internal buffer. ...
    (comp.lang.java.programmer)
  • Re: Variable naming problem
    ... >> Maybe we should talk about what constitutes a failure first. ... > stack needs to sort it out. ... the problems you are locally able to deal with, or expect your clients ... to be able to deal with, throw an exception. ...
    (comp.lang.java.programmer)
  • Re: How to get crash dump when a unhandled CException is thrown by a MFC app
    ... hardware problem. ... failure at least once a day, which caused an exception to be thrown, and we recovered. ... So I do not believe that throwing an exception should terminate a program; ... "Go and fix your machine", ...
    (microsoft.public.vc.mfc)