Sage 300 2018 - Errors Post O/E Order Entry

Posted By itinfinity over 5 years ago

Hi All,

Does anyone encounter similar issues before when do posting in O/E Shipment Entry?

That's screenshot given by one of our client whom is using Sage 300 2018.

That client claimed that he/she was trying to post 148 lines of data, but ended up with errors. He/she has split the shipment into two different entries, and the error is no longer there.

What's the caused of the error msg?

We did try to simulate the error msg above, but failed to. We got the following error msg after load the same data and restart maintenance.

We tried to do ship all from O/E Order Entry screen, and tick "Create invoice", and Post. We're given the following error msg.

We did check that not shipment next number and invoice next number caused the problem.

Hope someone can enlighten us regarding above mentioned errors.

Thanks.

0 Django over 5 years ago

You've got some database issues at this point. You can run the rvSpy utility to help diagnose where the problems are and see what is stopping the transaction from posting. As for your data, if you're not comfortable editing the data then you'll want to contact a data repair specialist like Musick International
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Team Equation over 5 years ago

Are these users copying and pasting text (from a PDF or web page or something like that) and pasting it into the detail optional fields? Sometimes some hidden, invalid characters get pasted as well. Best to key in those values, or make sure only text is being copied.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 itinfinity over 5 years ago in reply to Django

Hi Django,

I did try to run rvspy, but couldn't find any clues.

Due to rvspy file is too large, I've quoted some of the "Error" found when run rvspy below.

⌈

      [33e8.7ff.291c] OE0704: OESHIHO [11:27:17.40].Put(view=0x0CD2CF64, field=3, 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' -> '                                                            ')
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.40].BlkPut(view=0x0CD385EC, count=3, verify=0)
         [33e8.7ff.291c] * field=5, size=2, buffer='\01\00'
         [33e8.7ff.291c] * field=6, size=2, buffer='\3c\00'
         [33e8.7ff.291c] * field=7, size=2, buffer='\00\00'
         [33e8.7ff.291c] 0 <==[11:27:17.42;t=0;ovh=0] {}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.42].Put(view=0x0CD385EC, 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' -> '                                                            ')
         [33e8.7ff.291c] 0 <==[11:27:17.42;t=0;ovh=0] {}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.42].Get(view=0x0CD385EC, field=21, size=4)
         [33e8.7ff.291c] 0 <==[11:27:17.42;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.43].Get(view=0x0CD385EC, field=22, size=60)
         [33e8.7ff.291c] 0 <==[11:27:17.43;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' -> '                                                            '}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.43].BlkPut(view=0x0CD385EC, count=3, verify=0)
         [33e8.7ff.291c] * field=5, size=2, buffer='\01\00'
         [33e8.7ff.291c] * field=6, size=2, buffer='\3c\00'
         [33e8.7ff.291c] * field=7, size=2, buffer='\00\00'
         [33e8.7ff.291c] 0 <==[11:27:17.43;t=0;ovh=0] {}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.43].Get(view=0x0CD385EC, field=21, size=4)
         [33e8.7ff.291c] 0 <==[11:27:17.45;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.45].Put(view=0x0CD385EC, field=22, 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' -> '                                                            ')
         [33e8.7ff.291c] 0 <==[11:27:17.45;t=0;ovh=0] {}
         [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.45].Get(view=0x0CD385EC, field=2, size=60)
         [33e8.7ff.291c] 0 <==[11:27: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' -> '                                                            '}
      [33e8.7ff.291c] 0 <==[11:27:17.45;t=47;ovh=47] {}
   [33e8.7ff.291c] 0 <==[11:27:17.45;t=78;ovh=78] {}
   [33e8.7ff.291c] OE0704: OESHIHO [11:27:17.47].Read(view=0x0CD2CF64)
      [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.47].BlkPut(view=0x0CD385EC, count=3, verify=0)
      [33e8.7ff.291c] * field=5, size=2, buffer='\01\00'
      [33e8.7ff.291c] * field=6, size=2, buffer='\3c\00'
      [33e8.7ff.291c] * field=7, size=2, buffer='\00\00'
      [33e8.7ff.291c] 0 <==[11:27:17.47;t=0;ovh=0] {}
      [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.47].Put(view=0x0CD385EC, 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' -> '                                                            ')
      [33e8.7ff.291c] 0 <==[11:27:17.48;t=0;ovh=0] {}
      [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.48].Get(view=0x0CD385EC, field=21, size=4)
      [33e8.7ff.291c] 0 <==[11:27:17.48;t=0;ovh=0] {buffer='\16\00\00\00' -> '????'}
      [33e8.7ff.291c] CS0012: CSOPTFD [11:27:17.48].Get(view=0x0CD385EC, field=22, size=60)
      [33e8.7ff.291c] 0 <==[11:27: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' -> '                                                            '}
   [33e8.7ff.291c] 0 <==[11:27:17.48;t=16;ovh=16] {}
[33e8.7ff.291c] 6666 <==[11:27:17.48;t=51219;ovh=50047] {**ERROR**}
[33e8.7ff.291c] OE0691: OESHID   [11:27:17.50].Get(view=0x0C5234FC, field=1, size=10)
[33e8.7ff.291c] 0 <==[11:27:17.50;t=0;ovh=0] {buffer='\00\00\00\00\00\00\09\04\89\7c' -> 904897}

⌋

⌈
            [3844.7ff.3a5c] OE0110: OEAUDDP [11:42:53.81].BlkPut(view=0x0CF4038C, count=7, verify=0)
            [3844.7ff.3a5c] * field=5, size=12, buffer='\30\30\42\4f\41\54\20\20\20\20\20\20' -> '00BOAT      '
            [3844.7ff.3a5c] * field=6, size=60, 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' -> '                                                            '
            [3844.7ff.3a5c] * field=7, size=2, buffer='\01\00'
            [3844.7ff.3a5c] * field=8, size=2, buffer='\3c\00'
            [3844.7ff.3a5c] * field=9, size=2, buffer='\00\00'
            [3844.7ff.3a5c] * field=10, size=2, buffer='\00\00'
            [3844.7ff.3a5c] * field=11, size=2, buffer='\00\00'
            [3844.7ff.3a5c] 0 <==[11:42:53.82;t=0;ovh=0] {}
            [3844.7ff.3a5c] OE0110: OEAUDDP [11:42:53.84].Insert(view=0x0CF4038C)
            [3844.7ff.3a5c] 1 <==[11:42:53.85;t=16;ovh=0] {**ERROR**}
         [3844.7ff.3a5c] 9902 <==[11:42:53.85;t=43078;ovh=39905] {**ERROR**}
      [3844.7ff.3a5c] 9902 <==[11:42:54.04;t=54453;ovh=49407] {**ERROR**}
      [3844.7ff.3a5c] OE0260: OEDEND   [11:42:54.06].Cancel(view=0x0CB90E74)
      [3844.7ff.3a5c] 0 <==[11:42:54.06;t=0;ovh=0] {}
      [3844.7ff.3a5c] OE0260: OEDEND   [11:42:54.07].Close(view=0x0CB90E74)
         [3844.7ff.3a5c] OE0605: OEPOSTS [11:42:54.07].Close(view=0x0CE3C7DC)
            [3844.7ff.3a5c] IC0100: ICACCT   [11:42:54.09].Close(view=0x0CE42454)
            [3844.7ff.3a5c] 0 <==[11:42:54.09;t=0;ovh=0] {}
            [3844.7ff.3a5c] IC0100: ICACCT   [11:42:54.10].Unload
            [3844.7ff.3a5c] IC0210: ICCATG   [11:42:54.10].Close(view=0x0C3FFB64)
            [3844.7ff.3a5c] 0 <==[11:42:54.10;t=0;ovh=0] {}
            [3844.7ff.3a5c] IC0210: ICCATG   [11:42:54.10].Unload
            [3844.7ff.3a5c] IC0270: ICCSTP   [11:42:54.10].Close(view=0x0D8F730C)
               [3844.7ff.3a5c] IC0260: ICCOST   [11:42:54.12].Close(view=0x0D8F7DEC)
               [3844.7ff.3a5c] 0 <==[11:42:54.12;t=0;ovh=0] {}
               [3844.7ff.3a5c] IC0260: ICCOST   [11:42:54.12].Unload
            [3844.7ff.3a5c] 0 <==[11:42:54.12;t=0;ovh=0] {}
⌋

⌈

         [3844.7ff.3a5c] GP0950: GPGLPO   [11:42:54.67].Close(view=0x0CE2D40C)
            [3844.7ff.3a5c] GL0008: GLBCTL   [11:42:54.67].Put(view=0x0D96DAE4, field=32, size=2, verify=0, buffer='\00\00')
            [3844.7ff.3a5c] 0 <==[11:42:54.67;t=0;ovh=0] {}
            [3844.7ff.3a5c] GL0008: GLBCTL   [11:42:54.68].Process(view=0x0D96DAE4)
            [3844.7ff.3a5c] 0 <==[11:42:54.68;t=0;ovh=0] {}
            [3844.7ff.3a5c] GL0005: GLOPT    [11:42:54.68].Close(view=0x0D96B9AC)
            [3844.7ff.3a5c] 0 <==[11:42:54.68;t=0;ovh=0] {}
            [3844.7ff.3a5c] GL0005: GLOPT    [11:42:54.68].Unload
            [3844.7ff.3a5c] GL0006: GLJEH    [11:42:54.68].Close(view=0x0D97890C)
               [3844.7ff.3a5c] GL0002: GLSRCE   [11:42:54.70].Close(view=0x0D97BBBC)
               [3844.7ff.3a5c] 0 <==[11:42:54.70;t=0;ovh=0] {}
               [3844.7ff.3a5c] GL0002: GLSRCE   [11:42:54.70].Unload
            [3844.7ff.3a5c] 0 <==[11:42:54.70;t=0;ovh=0] {}
            [3844.7ff.3a5c] GL0006: GLJEH    [11:42:54.70].Unload
            [3844.7ff.3a5c] GL0008: GLBCTL   [11:42:54.70].Close(view=0x0D96DAE4)
               [3844.7ff.3a5c] GL0001: GLAMF    [11:42:54.70].Close(view=0x0D97151C)
                  [3844.7ff.3a5c] GL0500: GLOFD    [11:42:54.70].Close(view=0x0D975FD4)
                     [3844.0.3a5c] TRACE: *** Optional field cache dump ***
                     [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.71].Close(view=0x0D7CF0AC)
                     [3844.7ff.3a5c] 0 <==[11:42:54.71;t=0;ovh=0] {}
                     [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.71].Unload
                  [3844.7ff.3a5c] 0 <==[11:42:54.71;t=0;ovh=0] {}
                  [3844.7ff.3a5c] GL0500: GLOFD    [11:42:54.71].Unload
               [3844.7ff.3a5c] 0 <==[11:42:54.71;t=15;ovh=15] {}
               [3844.7ff.3a5c] GL0001: GLAMF    [11:42:54.71].Unload
            [3844.7ff.3a5c] 0 <==[11:42:54.73;t=31;ovh=15] {}
            [3844.7ff.3a5c] GL0008: GLBCTL   [11:42:54.73].Unload
            [3844.7ff.3a5c] GL0010: GLJED    [11:42:54.73].Close(view=0x0D97C32C)
               [3844.7ff.3a5c] GL0007: GLJEC    [11:42:54.73].Close(view=0x0D980BBC)
               [3844.7ff.3a5c] 0 <==[11:42:54.73;t=0;ovh=0] {}
               [3844.7ff.3a5c] GL0007: GLJEC    [11:42:54.73].Unload
               [3844.7ff.3a5c] GL0002: GLSRCE   [11:42:54.73].Close(view=0x0CF8378C)
               [3844.7ff.3a5c] 0 <==[11:42:54.74;t=0;ovh=0] {}
               [3844.7ff.3a5c] GL0002: GLSRCE   [11:42:54.74].Unload
               [3844.7ff.3a5c] GL0001: GLAMF    [11:42:54.74].Close(view=0x0CF87C34)
                  [3844.7ff.3a5c] GL0500: GLOFD    [11:42:54.74].Close(view=0x0CF8BD24)
                     [3844.0.3a5c] TRACE: *** Optional field cache dump ***
                     [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.74].Close(view=0x0CF8CFCC)
                     [3844.7ff.3a5c] 0 <==[11:42:54.74;t=0;ovh=0] {}
                     [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.74].Unload
                  [3844.7ff.3a5c] 0 <==[11:42:54.76;t=15;ovh=0] {}
                  [3844.7ff.3a5c] GL0500: GLOFD    [11:42:54.76].Unload
               [3844.7ff.3a5c] 0 <==[11:42:54.76;t=15;ovh=0] {}
               [3844.7ff.3a5c] GL0001: GLAMF    [11:42:54.76].Unload
            [3844.7ff.3a5c] 0 <==[11:42:54.76;t=31;ovh=16] {}
            [3844.7ff.3a5c] GL0010: GLJED    [11:42:54.76].Unload
            [3844.7ff.3a5c] GL0402: GLJEDO   [11:42:54.76].Close(view=0x0D9837FC)
               [3844.0.3a5c] TRACE: *** Optional field cache dump ***
               [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.78].Close(view=0x0D7CB114)
               [3844.7ff.3a5c] 0 <==[11:42:54.78;t=0;ovh=0] {}
               [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.78].Unload
            [3844.7ff.3a5c] 0 <==[11:42:54.78;t=0;ovh=0] {}
            [3844.7ff.3a5c] GL0402: GLJEDO   [11:42:54.78].Unload
         [3844.7ff.3a5c] 0 <==[11:42:54.78;t=110;ovh=79] {}
         [3844.7ff.3a5c] GP0950: GPGLPO   [11:42:54.78].Unload
         [3844.7ff.3a5c] AR0402: ARIBHO   [11:42:54.79].Close(view=0x0D8B2F4C)
            [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.79].Close(view=0x0D867E4C)
            [3844.7ff.3a5c] 0 <==[11:42:54.79;t=0;ovh=0] {}
            [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.79].Unload
         [3844.7ff.3a5c] 0 <==[11:42:54.79;t=0;ovh=0] {}
         [3844.7ff.3a5c] AR0402: ARIBHO   [11:42:54.79].Unload
         [3844.7ff.3a5c] AR0401: ARIBDO   [11:42:54.79].Close(view=0x0D825C94)
            [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.79].Close(view=0x0D868414)
            [3844.7ff.3a5c] 0 <==[11:42:54.81;t=0;ovh=0] {}
            [3844.7ff.3a5c] CS0012: CSOPTFD [11:42:54.81].Unload
         [3844.7ff.3a5c] 0 <==[11:42:54.81;t=16;ovh=16] {}
         [3844.7ff.3a5c] AR0401: ARIBDO   [11:42:54.81].Unload
      [3844.7ff.3a5c] 0 <==[11:42:54.81;t=734;ovh=516] {}
      [3844.7ff.3a5c] OE0260: OEDEND   [11:42:54.81].Unload   [3844.7ff.3a5c] 9903 <==[11:42:54.82;t=55407;ovh=50018] {**ERROR**}
   [3844.7ff.3a5c] OE0691: OESHID   [11:42:54.82].Put(view=0x0B85CFD4, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.82;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0705: OESHIDB [11:42:54.84].Put(view=0x0C0E9ECC, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.84;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0703: OESHIDD [11:42:54.84].Put(view=0x0C0EA37C, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.84;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0190: OECOINS [11:42:54.84].Put(view=0x0B91EDB4, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.84;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0745: OETERMS [11:42:54.84].Put(view=0x0B92F934, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.85;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0709: OESHIDS [11:42:54.85].Put(view=0x0C117674, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.85;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0706: OESHIDDS [11:42:54.85].Put(view=0x0C0A06D4, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.85;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0694: OESHIR   [11:42:54.85].Put(view=0x0B92FD04, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.85;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0708: OESHIDL [11:42:54.85].Put(view=0x0C11905C, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.87;t=0;ovh=0] {}
   [3844.7ff.3a5c] OE0707: OESHIDDL [11:42:54.87].Put(view=0x0C14B6A4, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')
   [3844.7ff.3a5c] 0 <==[11:42:54.87;t=0;ovh=0] {}
[3844.7ff.3a5c] 1 <==[11:42:54.87;t=650500;ovh=628792] {**ERROR**}
[3844.7ff.3a5c] OE0710: OESHPP   [11:42:54.87].Init(view=0x0C3C7FAC)
   [3844.7ff.3a5c] AR0012: ARPTP    [11:42:54.87].Init(view=0x0C3CA03C)
   [3844.7ff.3a5c] 0 <==[11:42:54.88;t=0;ovh=0] {}
   [3844.7ff.3a5c] AR0012: ARPTP    [11:42:54.88].Put(view=0x0C3CA03C, field=1, size=12, verify=0, buffer='\43\48\45\43\4b\20\20\20\20\20\20\20' -> 'CHECK       ')
   [3844.7ff.3a5c] 0 <==[11:42:54.88;t=0;ovh=0] {}
   [3844.7ff.3a5c] AR0012: ARPTP    [11:42:54.88].Read(view=0x0C3CA03C)
   [3844.7ff.3a5c] 0 <==[11:42:54.88;t=0;ovh=0] {}
   [3844.7ff.3a5c] AR0012: ARPTP    [11:42:54.88].Get(view=0x0C3CA03C, field=6, size=2)
   [3844.7ff.3a5c] 0 <==[11:42:54.90;t=0;ovh=0] {buffer='\02\00'}

⌋
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 itinfinity over 5 years ago in reply to Team Equation

We not quite sure whether users copying and pasting text or not.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Sage 300 2018 - Errors Post O/E Order Entry

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING