Synchronizing table: Item -> Run-time error '-2147217833 (80040e57

Posted by Aldo on December 9, 2005, 4:41 pm

Please log in for more thread options

Hi, This question is about the RMS Synchronize Offline Database feature, few
months ago it use to work fine, but now it is doing this:

after close the POS, and when: Synchronize Offline Database > Synchronizing
table: Item
(it syncs nice the Alias and the Customer table, but is breaks when Item
table and returns this message:)

Microsoft Store Operations POS
Run-time error '-2147217833 (80040e57)':
String or binary data would be truncated.

I tried this:
1- Since the POS client its a firewalled windows xp SP2 machine, I make 2
exeptions: I opened port 1433 with subnet scope, also enabled the C:Program
FilesMicrosoft SQL ServerMSSQLbinnsqlservr.exe with subnet scope.
and it makes no difference
2- I tried to create the database locally for testing but it cant be the
same machine as the offline database.
Things are the same.
3-I verified the data integrity of Item table and it seems to be ok, no
duplicated items, no null lookup fields, etc.
Things are the same.
4- I analize the source and target columns lenght and i fixed a difference
of size in SubDescription3 field, but it makes no difference, the error code
is the same and the halt of proccess persist like a nightmare

Thanks for readint this post

Posted by Glenn Adams [MVP - Retail Mgmt on December 9, 2005, 4:56 pm

Please log in for more thread options

Well, number 4 on your list would have been my bet - a column definition
change on the main database.

You can create a new local database for the offline, and it will be
populated with everything it needs at the next Z-report, assuming it doesn't
fail again. The local offline database doesn't need to keep any historical
data, so creating a new one and starting over is fine.

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> Hi, This question is about the RMS Synchronize Offline Database feature,

> few

> months ago it use to work fine, but now it is doing this:

> after close the POS, and when: Synchronize Offline Database >

> Synchronizing

> table: Item

> (it syncs nice the Alias and the Customer table, but is breaks when Item

> table and returns this message:)

> Microsoft Store Operations POS

> Run-time error '-2147217833 (80040e57)':

> String or binary data would be truncated.

> I tried this:

> 1- Since the POS client its a firewalled windows xp SP2 machine, I make 2

> exeptions: I opened port 1433 with subnet scope, also enabled the

> C:Program

> FilesMicrosoft SQL ServerMSSQLbinnsqlservr.exe with subnet scope.

> and it makes no difference

> 2- I tried to create the database locally for testing but it cant be the

> same machine as the offline database.

> Things are the same.

> 3-I verified the data integrity of Item table and it seems to be ok, no

> duplicated items, no null lookup fields, etc.

> Things are the same.

> 4- I analize the source and target columns lenght and i fixed a difference

> of size in SubDescription3 field, but it makes no difference, the error

> code

> is the same and the halt of proccess persist like a nightmare

> Thanks for readint this post

Posted by Aldo on December 9, 2005, 5:15 pm

Please log in for more thread options

I forgot to list it:
I delete the offline database and created new one... the results still are
the same...
what could be?
Thanks

"Glenn Adams [MVP - Retail Mgmt]" wrote:

> Well, number 4 on your list would have been my bet - a column definition

> change on the main database.

> You can create a new local database for the offline, and it will be

> populated with everything it needs at the next Z-report, assuming it doesn't

> fail again. The local offline database doesn't need to keep any historical

> data, so creating a new one and starting over is fine.

> --

> Glenn Adams

> Tiber Creek Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information

> > Hi, This question is about the RMS Synchronize Offline Database feature,

> > few

> > months ago it use to work fine, but now it is doing this:

> >

> > after close the POS, and when: Synchronize Offline Database >

> > Synchronizing

> > table: Item

> > (it syncs nice the Alias and the Customer table, but is breaks when Item

> > table and returns this message:)

> >

> > Microsoft Store Operations POS

> > Run-time error '-2147217833 (80040e57)':

> > String or binary data would be truncated.

> >

> > I tried this:

> > 1- Since the POS client its a firewalled windows xp SP2 machine, I make 2

> > exeptions: I opened port 1433 with subnet scope, also enabled the

> > C:Program

> > FilesMicrosoft SQL ServerMSSQLbinnsqlservr.exe with subnet scope.

> > and it makes no difference

> > 2- I tried to create the database locally for testing but it cant be the

> > same machine as the offline database.

> > Things are the same.

> > 3-I verified the data integrity of Item table and it seems to be ok, no

> > duplicated items, no null lookup fields, etc.

> > Things are the same.

> > 4- I analize the source and target columns lenght and i fixed a difference

> > of size in SubDescription3 field, but it makes no difference, the error

> > code

> > is the same and the halt of proccess persist like a nightmare

> >

> > Thanks for readint this post

Posted by Aldo on December 9, 2005, 9:34 pm

Please log in for more thread options

thats it, i altered the pictureName field to 100 lenght, because my picture
is a yahoo store url (too long), so i have to alter the offline field too.

Thanks!