Day End problem

[vbdbcoder]

Hi guys,

I am running into a day end not completing problem. I have never seen this error.

The error messages are:

1. Purchase Order Audit Headers Invalid characters put to field "Tax Excluded 2 Sum."
2. Purchase Order Audit Headers Invalid characters put to field "Tax Authority 1."
3. Purchase Order Audit Headers Invalid characters put to field "Tax Authority 2."
4. Purchase Order Audit Headers Invalid characters put to field "Tax Rate 1."
5. Purchase Order Audit Headers Invalid characters put to field "Tax Rate 2."
6. Purchase Order Audit Headers Invalid characters put to field "Tax Rate 3."

Thanks in advance.

 

[Jay Converse]

Run RVSPY, find the records, and fix them with a database editor.

 

[vbdbcoder]

Hi Tuba, Thanks for getting back. I cut and pasted the part with "ERROR" here. I am having problem locating the transaction records. Would you have any idea? Thanks

[22a4.7ff.2188] 0 <==[09:20:17.39;t=0;ovh=0] {}
[22a4.7ff.2188] 0 <==[09:20:17.39;t=47;ovh=47] {}
[22a4.7ff.2188] PO0612: POPORAH [09:20:17.39].BlkPut(view=0x0C0074A4, count=65, verify=0)
[22a4.7ff.2188] * field=1, size=10, buffer='\00\00\00\00\00\00\00\01\97\5c' -> 1975
[22a4.7ff.2188] * field=2, size=10, buffer='\00\00\00\00\00\00\00\00\00\1c' -> 1
[22a4.7ff.2188] * field=4, size=10, buffer='\00\00\00\00\00\00\07\69\99\4c' -> 769994
[22a4.7ff.2188] * field=3, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=5, size=5, buffer='\02\01\60\32\2c' -> 20160322
[22a4.7ff.2188] * field=6, size=5, buffer='\02\01\60\32\3c' -> 20160323
[22a4.7ff.2188] * field=7, size=5, buffer='\02\01\51\02\8c' -> 20151028
[22a4.7ff.2188] * field=8, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=9, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=10, size=60, buffer='\43\6f\6e\74\72\61\63\74\20\32\30\31\35\20\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0' -> 'Contract 2015 ??????????????????????????????????????????????'
[22a4.7ff.2188] * field=11, size=60, buffer='\42\6c\61\6e\6b\65\74\20\4f\72\64\65\72\20\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0' -> 'Blanket Order ??????????????????????????????????????????????'
[22a4.7ff.2188] * field=12, size=2, buffer='\02\00'
[22a4.7ff.2188] * field=13, size=12, buffer='\57\48\49\54\45\43\52\45\53\54\20\a0' -> 'WHITECREST ?'
[22a4.7ff.2188] * field=14, size=60, buffer='\57\68\69\74\65\63\72\65\73\74\20\4d\75\73\68\72\6f\6f\6d\73\20\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0' -> 'Whitecrest Mushrooms ???????????????????????????????????????'
[22a4.7ff.2188] * field=15, size=12, buffer='\48\53\54\20\a0\a0\a0\a0\a0\a0\a0\a0' -> 'HST ????????'
[22a4.7ff.2188] * field=16, size=12, buffer='\48\53\54\20\a0\a0\a0\a0\a0\a0\a0\a0' -> 'HST ????????'
[22a4.7ff.2188] * field=17, size=12, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '??????????? '
[22a4.7ff.2188] * field=18, size=12, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '??????????? '
[22a4.7ff.2188] * field=19, size=12, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '??????????? '
[22a4.7ff.2188] * field=20, size=12, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '??????????? '
[22a4.7ff.2188] * field=21, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=22, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=23, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=24, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=25, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=26, size=22, buffer='\50\4f\30\30\30\30\30\31\37\39\38\20\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0' -> 'PO000001798 ??????????'
[22a4.7ff.2188] * field=27, size=22, buffer='\52\43\50\30\30\30\30\34\34\35\34\20\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0' -> 'RCP00004454 ??????????'
[22a4.7ff.2188] * field=28, size=2, buffer='\46\00'
[22a4.7ff.2188] * field=29, size=3, buffer='\43\41\44' -> 'CAD'
[22a4.7ff.2188] * field=30, size=8, buffer='\00\00\00\01\00\00\00\0c' -> 10000000
[22a4.7ff.2188] * field=31, size=5, buffer='\02\01\51\02\8c' -> 20151028
[22a4.7ff.2188] * field=32, size=2, buffer='\53\50'
[22a4.7ff.2188] * field=33, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=34, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=35, size=2, buffer='\02\00'
[22a4.7ff.2188] * field=38, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=39, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=40, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=41, size=3, buffer='\36\32\41' -> '62A'
[22a4.7ff.2188] * field=43, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=42, size=4, buffer='\00\00\00\00' -> '????'
[22a4.7ff.2188] * field=44, size=5, buffer='\02\01\51\02\8c' -> 20151028
[22a4.7ff.2188] * field=45, size=8, buffer='\00\00\00\01\00\00\00\0c' -> 10000000
[22a4.7ff.2188] * field=46, size=5, buffer='\02\01\51\02\8c' -> 20151028
[22a4.7ff.2188] * field=47, size=2, buffer='\53\50'
[22a4.7ff.2188] * field=48, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=49, size=2, buffer='\63\00'
[22a4.7ff.2188] * field=50, size=10, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0
[22a4.7ff.2188] * field=51, size=10, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0
[22a4.7ff.2188] * field=52, size=22, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '????????????????????? '
[22a4.7ff.2188] * field=53, size=22, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '????????????????????? '
[22a4.7ff.2188] * field=54, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=55, size=5, buffer='\02\01\60\32\2c' -> 20160322
[22a4.7ff.2188] * field=56, size=4, buffer='\32\30\31\36' -> '2016'
[22a4.7ff.2188] * field=57, size=2, buffer='\09\00'
[22a4.7ff.2188] * field=58, size=60, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '??????????????????????????????????????????????????????????? '
[22a4.7ff.2188] * field=59, size=60, buffer='\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\a0\20' -> '??????????????????????????????????????????????????????????? '
[22a4.7ff.2188] * field=60, size=3, buffer='\43\41\44' -> 'CAD'
[22a4.7ff.2188] * field=61, size=8, buffer='\00\00\00\01\00\00\00\0c' -> 10000000
[22a4.7ff.2188] * field=62, size=5, buffer='\02\01\51\02\8c' -> 20151028
[22a4.7ff.2188] * field=63, size=2, buffer='\53\50'
[22a4.7ff.2188] * field=64, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=65, size=2, buffer='\00\00'
[22a4.7ff.2188] * field=66, size=2, buffer='\02\00'
[22a4.7ff.2188] * field=67, size=6, buffer='\31\20\20\20\20\20' -> '1 '
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.42].Put(view=0x0C00FF6C, field=1, size=10, verify=0, buffer='\00\00\00\00\00\00\00\01\97\5c' -> 1975)
[22a4.7ff.2188] PO0613: POPOALO [09:20:17.44].Cancel(view=0x0BEF7F5C)
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.44].Get(view=0x0C00FF6C, field=1, size=10)
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\01\97\5c' -> 1975}
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.44].Get(view=0x0C00FF6C, field=2, size=10)
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.44].Get(view=0x0C00FF6C, field=3, size=10)
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.44].BlkPut(view=0x0AA68DEC, count=3, verify=0)
[22a4.7ff.2188] * field=5, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=6, size=2, buffer='\3c\00'
[22a4.7ff.2188] * field=7, size=2, buffer='\00\00'
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.44].Put(view=0x0AA68DEC, field=20, size=60, verify=0, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' ')
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.44].Get(view=0x0AA68DEC, field=21, size=4)
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.44].Get(view=0x0AA68DEC, field=22, size=60)
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '}
[22a4.7ff.2188] 0 <==[09:20:17.44;t=0;ovh=0] {}
[22a4.7ff.2188] PO0613: POPOALO [09:20:17.44].Put(view=0x0BEF7F5C, field=3, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {}
[22a4.7ff.2188] PO0613: POPOALO [09:20:17.45].Put(view=0x0BEF7F5C, field=1, size=10, verify=0, buffer='\00\00\00\00\00\00\00\01\97\5c' -> 1975)
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {}
[22a4.7ff.2188] 0 <==[09:20:17.45;t=15;ovh=15] {}
[22a4.7ff.2188] PO0611: POPOAHO [09:20:17.45].Put(view=0x0BEF6984, field=1, size=10, verify=0, buffer='\00\00\00\00\00\00\00\01\97\5c' -> 1975)
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.45].BlkPut(view=0x0AA693B4, count=3, verify=0)
[22a4.7ff.2188] * field=5, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=6, size=2, buffer='\3c\00'
[22a4.7ff.2188] * field=7, size=2, buffer='\00\00'
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.45].Put(view=0x0AA693B4, field=20, size=60, verify=0, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' ')
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.45].Get(view=0x0AA693B4, field=21, size=4)
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.45].Get(view=0x0AA693B4, field=22, size=60)
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '}
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {}
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.45].Put(view=0x0C00FF6C, field=2, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\1c' -> 1)
[22a4.7ff.2188] PO0613: POPOALO [09:20:17.45].Cancel(view=0x0BEF7F5C)
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.45].Get(view=0x0C00FF6C, field=1, size=10)
[22a4.7ff.2188] 0 <==[09:20:17.45;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\01\97\5c' -> 1975}
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.47].Get(view=0x0C00FF6C, field=2, size=10)
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\1c' -> 1}
[22a4.7ff.2188] PO0614: POPORAL [09:20:17.47].Get(view=0x0C00FF6C, field=3, size=10)
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.47].BlkPut(view=0x0AA68DEC, count=3, verify=0)
[22a4.7ff.2188] * field=5, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=6, size=2, buffer='\3c\00'
[22a4.7ff.2188] * field=7, size=2, buffer='\00\00'
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.47].Put(view=0x0AA68DEC, field=20, size=60, verify=0, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' ')
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.47].Get(view=0x0AA68DEC, field=21, size=4)
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.47].Get(view=0x0AA68DEC, field=22, size=60)
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '}
[22a4.7ff.2188] 0 <==[09:20:17.47;t=16;ovh=16] {}
[22a4.7ff.2188] PO0613: POPOALO [09:20:17.47].Put(view=0x0BEF7F5C, field=3, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {}
[22a4.7ff.2188] PO0613: POPOALO [09:20:17.47].Put(view=0x0BEF7F5C, field=2, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\1c' -> 1)
[22a4.7ff.2188] 0 <==[09:20:17.47;t=0;ovh=0] {}
[22a4.7ff.2188] 0 <==[09:20:17.47;t=16;ovh=16] {}
[22a4.7ff.2188] PO0611: POPOAHO [09:20:17.47].Put(view=0x0BEF6984, field=2, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\1c' -> 1)
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.48].BlkPut(view=0x0AA693B4, count=3, verify=0)
[22a4.7ff.2188] * field=5, size=2, buffer='\01\00'
[22a4.7ff.2188] * field=6, size=2, buffer='\3c\00'
[22a4.7ff.2188] * field=7, size=2, buffer='\00\00'
[22a4.7ff.2188] 0 <==[09:20:17.48;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.48].Put(view=0x0AA693B4, field=20, size=60, verify=0, buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' ')
[22a4.7ff.2188] 0 <==[09:20:17.48;t=0;ovh=0] {}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.48].Get(view=0x0AA693B4, field=21, size=4)
[22a4.7ff.2188] 0 <==[09:20:17.48;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
[22a4.7ff.2188] CS0012: CSOPTFD [09:20:17.48].Get(view=0x0AA693B4, field=22, size=60)
[22a4.7ff.2188] 0 <==[09:20:17.48;t=0;ovh=0] {buffer='\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20' -> ' '}
[22a4.7ff.2188] 0 <==[09:20:17.48;t=0;ovh=0] {}
[22a4.7ff.2188] 0 <==[09:20:17.48;t=62;ovh=62] {}
[22a4.7ff.2188] PO0612: POPORAH [09:20:17.48].Insert(view=0x0C0074A4)
[22a4.7ff.2188] 1024 <==[09:20:17.53;t=47;ovh=0] {**ERROR**}
[22a4.7ff.2188] 1024 <==[09:20:17.55;t=2016;ovh=1813] {**ERROR**}
[22a4.7ff.2188] 1024 <==[09:20:17.55;t=27422;ovh=20812] {**ERROR**}
[22a4.7ff.2188] IC0276: ICDEP [09:20:17.55].Cancel(view=0x09A4AA9C)

 

[Jay Converse]

WHITECREST ? is suspicious. In fact all those hex A0s are suspicious, too, should be hex 20.

 

[vbdbcoder]

I have removed from PO posting tables (POPORI, POPORM) the suspicious PO # PO000001798 listed in the above log file. I also verified that Receipt posting tables (PORCPI, PORCPM) do not have the associated Receipt # RCP00004454 records. I am still getting the same errors in day end.

What else to remove?

 

[Jay Converse]

Run RVSPY, and find the other bad records. FWIW, the fact that this happened in the first place tells me something screwy/non-standard is being done to your system.

 

[ettienne]

Contact Musick Int

http://www.musick-int.com

dbr@musick-int.com

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[vbdbcoder]

Thanks Guys. This is a great place!