SQL failure

From: SP (sp_at_discussions.microsoft.com)
Date: 11/11/04


Date: Thu, 11 Nov 2021 07:49:50 -0800

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:
>
>.
>



Relevant Pages

  • RE: SQL failure
    ... |>>>Uncaught exception terminated service XXXXX(846f436c-388f- ... |>>>Exception occurred when persisting state to the database. ... |>>>1061151938 ErrorInfo A database failure occurred due to ...
    (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)
  • ErrorReport - Can it be Assigned to?
    ... I'm trying to set up a generic orchestration to catch "bad" messages that I ... Then in the orchestration with the exception block, ... Exception occurred when persisting state to the database. ... Boolean idleRequired, Boolean finalPersist, Boolean bypassCommit, Boolean ...
    (microsoft.public.biztalk.general)
  • RE: Orchestration Failure
    ... Virtual Server, though. ... An unrecoverable exception has occurred. ... Exception occurred when persisting state to the database. ... Status -1061151998 ErrorInfo The published message could not be routed ...
    (microsoft.public.biztalk.general)
  • Orchestration Failure
    ... An unrecoverable exception has occurred. ... Exception occurred when persisting state to the database. ... ctx, Boolean finalPersisting, Boolean terminate) ... The published message could not be routed because no subscribers were found. ...
    (microsoft.public.biztalk.general)