Day End Processing Error in OE

[winstz]

Hi all,

I have an error when Day End Processing.

Here is the screenshot :

http://i39.tinypic.com/2eevrlt.jpg

I am using ACCPAC 5.5A Product Update 2 and my database is SQL Server 2005.

here is the rvspy result :

http://rapidshare.com/files/235143181/rvspy.zip.html

Any solution ? help me please...

Thanks.

 

[ettienne]

You are missing records from OESHCD, you can compare with OESHCH linked on SHIUNIQ and search for missing records, then rebuild the records from OESHID.

 

[winstz]

hi ettienne,
how to rebuild the records from OESHID ?
please give me the step by step.

is my error common ?

thanks.

 

[ettienne]

Rebuild the data using SQL queries.
This is not an uncommon error, but I have not seen it for a while and never with 5.5

 

[ettienne]

This worked for me on older versions, you will have to test with OE 5.5

INSERT INTO OESHCD ( SHIUNIQ, DETAILNUM, AUDTDATE, AUDTTIME, AUDTUSER, AUDTORG, SHINUMBER, QTYSHIPPED, SHIUNIT, UNITCONV, COST, ACTUALCOST )
SELECT OESHID.SHIUNIQ, OESHID.DETAILNUM, OESHID.AUDTDATE, OESHID.AUDTTIME, OESHID.AUDTUSER, OESHID.AUDTORG, OESHCH.SHINUMBER, OESHID.QTYSHIPPED, OESHID.SHIUNIT, OESHID.UNITCONV, OESHID.UNITCOST AS COST, OESHID.UNITCOST AS ACTUALCOST
FROM (OESHID INNER JOIN OESHCH ON OESHID.SHIUNIQ = OESHCH.SHIUNIQ) LEFT JOIN OESHCD ON (OESHID.DETAILNUM = OESHCD.DETAILNUM) AND (OESHID.SHIUNIQ = OESHCD.SHIUNIQ) 
WHERE (((OESHCD.SHIUNIQ) Is Null) AND (OESHID.QTYSHIPPED)<>0))

 

[winstz]

hi ettienne,
formerly u have faced this problem too and u fixed it succesfully with the code above ?

what version of accpac ?

 

[ettienne]

That was on OE 5.3 or 5.4

 

[winstz]

hi ettienne,
i have executed the sql query you give above
but the result is 0 row(s) affected
and when i start the day end processing again, i have the same error.
what must i do now ?

from rvspy data, what make this error happened ?
help me please.

thanks.

 

[ettienne]

You need to figure out which records are missing and rebuild them.

 

[winstz]

hi ettienne,
can u give me the step by step to figure out the missing records ?

my day end processing error when processing shinumber = 'SJO13109050103'

thanks.

 

[winstz]

hi ettienne,

here is the latest screenshot :

http://i41.tinypic.com/2jg0bow.jpg

http://i43.tinypic.com/2qi4q4l.jpg

help me please.
thanks.