BizTalk: An error occurred while attempting to access the SSO database. Arithmetic overflow error converting IDENTITY to data type int. #msbts

Recently one of the support staff at my company, Daniel Tran, found that one of our clients running a BizTalk 2009 BizTalk server was not processing messages, and errors in the Event log indicated an issue with the SSO database.  To resolve this he had to contact Microsoft, and he was advised to follow the steps in the following blog: Continuous Arithmetic Overflow exception with SSO in BizTalk Server.

Essentially a table in the SSO database had reached the maximum int for the primary key in that table.  And the solution was to start it back at 1 again.   If you are running any older BizTalk environment, it might be an idea to check the SSOX_AuditXPLookup table to ensure that it isn’t coming close to this as well.

Advertisements

Published by Coen (Colin) Dijkgraaf

A BizTalk developer at Datacom Systems Ltd, Auckland, New Zealand. You can follow me on Twitter, StackOverflow and WordPress

Join the Conversation

1 Comment

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog Of the Serverless Spirit

Stray Notions on All Things Microsoft Azure and BizTalk

Microsoft Azure/BizTalk_Read

Let's learn and share !

Boutaleb Hicham

Biztalk Architect

Pieter Vandenheede

Stories, tips & tricks for BizTalk Server, Azure, Data Science & Machine Learning

Glenn Colpaert

Blogging with my head in the (Hybrid) Cloud and my feet on premises! Azure / IoT / Integration

BizMunch

BizTalk blog by Knut Urke

Dragon's BizTalk Blog

A blog about BizTalk, and other integration tools.

The Deployment Bunny

OS Deployment, Virtualization, Microsoft based Infrastructure...

BizTalk Junkies

BizTalk, Azure and more..

Prasoon Gupta

If you know what you don't know, you know what you know.

Usman's blog

SOA - Azure, BizTalk, SharePoint, WCF

toon vanhoutte

Blogging about connecting devices, systems and people! On-premises and in the cloud. Microsoft stack only.

Simple Thoughts

Anything to free my mind... ~Nick Capito

vkbiztalk.wordpress.com/

BIZTALK,ESB,BAM,EAI,SOA

Sprouting Bits

For healthier coding and balanced clouding ;) by Paco de la Cruz

%d bloggers like this: