Talk About Network

Google





Software > Biz Talk NonXML > Re: Arithmetic ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 951 of 978
Post > Topic >>

Re: Arithmetic Overflow in 2006 EDI

by "Eric Stott" <ericstott@[EMAIL PROTECTED] > Aug 2, 2007 at 01:13 PM

You simply run 'xsd2edi {source of the customized 856} -r' and it will 
remove it...

Eric
http://blog.biztalk-info.com

"John" <John@[EMAIL PROTECTED]
> wrote in message 
news:EB6F3FFA-6810-4B06-8D1C-5E4E12D1E107@[EMAIL PROTECTED]
> The compeif did not work on its own.  We removed the schemas we use
(4010
> 810,850,855,856) and reinstalled them, then ran compeif again, then
> restarted.  So far that seems to be doing the trick.  However, we do
have 
> a
> custom 856 that is part of one of our solutions that we are unsure how
to
> remove/redeploy.  Could not find the xsd file in the BizTalk folder.
>
> "Eric Stott" wrote:
>
>> I would call into sup****t.
>> If that is not an option, I would stop the EDI service, I would go and
>> delete the live.eif from the do***entshome directory, create a new
blank,
>> dummy one (create a blank text file and rename it live.eif) and then
run
>> compeif.exe.
>> If that does not work, I would remove the EDI xsds from the repository
>> (xsd2edi.exe /?) and the reim****t the schemas and then run compeif.exe
>> again.
>> I am assuming that your engine imput file is corrupt, or you have
>> uninstalled the SQL client tools from the machine. I would assume that
#2
>> did not happen.
>>
>> Eric
>> http://blog.biztalk-info.com
>>
>> "John" <John@[EMAIL PROTECTED]
> wrote in message
>> news:9FD8AB31-AD49-4EB7-9144-7EF26682DD2C@[EMAIL PROTECTED]
>> > Recently we deployed a new EDI solution on BTS 2006 (not r2).  Worked

>> > fine
>> > on
>> > two different testing boxes.  We had a few kinks and had to kill the
>> > esp_srv
>> > service a couple of times during deployment (sometimes it wont stop).
>> > Now
>> > whenever it processes an EDI do***ent, the event log fills up with 
>> > these
>> > errors:
>> >
>> > Event Type: Error
>> > Event Source: EDI Subsystem
>> > Event Category: BizTalk Server 2006
>> > Event ID: 24
>> > Date: 7/26/2007
>> > Time: 9:42:06 PM
>> > User: N/A
>> >
>> > Description:
>> > Error encountered: ERROR (44) :
>> > A database error occurred. Contact the system
>> > administrator.SQLExecDirect()->SQL_ERROR[Microsoft][SQL Native 
>> > Client][SQL
>> > Server]Arithmetic overflow error for data type smallint, value =
86468.
>> > [22003]SELECT thread=4 dbtype=9 dbcon=7 table=audout what=15 lotab=14
>> >
>> > For more information, see Help and Sup****t Center at
>> > http://go.microsoft.com/fwlink/events.asp.
>> >
>> >
>> > The value keeps incrementing.
>> >
>>
>>
>>
 




 4 Posts in Topic:
Arithmetic Overflow in 2006 EDI
=?Utf-8?B?Sm9obg==?= <  2007-07-27 05:32:03 
Re: Arithmetic Overflow in 2006 EDI
"Eric Stott" &l  2007-07-28 22:32:35 
Re: Arithmetic Overflow in 2006 EDI
=?Utf-8?B?Sm9obg==?= <  2007-08-02 12:28:03 
Re: Arithmetic Overflow in 2006 EDI
"Eric Stott" &l  2007-08-02 13:13:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 2:30:57 PST 2009.