Error message help.

[dbant101]

We keep recieving the following error message when doing day end processing.

Description: Internal error. Cannot read OESHCD (6255 OEPOSTI1.C). Write down the message, leave ACCPAC for Windows and Windows and return to the system prompt. Reset your computer and try the task again. See Appendix A in the OE User Guide.

Would anyone know what would be causing this error. We are using ACCPAC ERP 5.4 (all Modules) and is in SQL. Thank you.

 

[Jay Converse]

Run RVSPY to diagnose, you've got some data surgery ahead.

This may help to search:

SELECT DISTINCT OESHCH.SHIUNIQ, OESHCH.SHINUMBER
FROM OESHCH
inner join OESHID on OESHCH.SHIUNIQ = OESHID.SHIUNIQ
WHERE OESHCH.SHIUNIQ NOT IN (SELECT SHIUNIQ FROM OESHCD)


This may help to fix:
INSERT INTO OESHCD select "SHIUNIQ" AS SHIUNIQ,DETAILNUM,AUDTDATE,AUDTTIME,
AUDTUSER,AUDTORG,SHINUMBER,QTYSHIPPED,PRICEUNIT,UNITCONV,
MOSTREC AS COST,MOSTREC AS ACTUALCOST from OEINVD where SHINUMBER ="SHINUMBER"

Your mileage may vary...

 

[ettienne]

Basically you are missing records in one or more tables, it may not necessarily be OESHCD.

 

[dbant101]

Why would it work for a few day ends and then error message appears. Once we recieve the error message we the rerun it and it processes correctly If there are records missing would it not report this error all the time when a day end is processed.

 

[Jay Converse]

Since it's MSSQL, the likely cause is a mismatched ODBCBCP.DLL on one or more workstation, that's been reported on other technical forums.