Day End Processing error 2

[mimi2013]

When I run day end processing after loading the day end processing number It gives an error;

Description: Day End Processing could not process all transactions.
Description: Day End Processing was not completed due to errors.
When I run RVSPY I'm not getting the error.
Any help will be appreciated.

 

[Jay Converse]

Run Rvspy with Dbspy, send output to a file and analyze it.

 

[mimi2013]

I have tried to analyze the Rvspy and Dbspy and Can't seem to get what is blocking the Day End. However when I run the integrity I constantly get the error
"E: Internal error. viewFetch failed (704 POINTCKD.C)."
I have done a repair of the installation yet this error remains.
What does this mean?

 

[ettienne]

You have a data problem - not a program problem.
Run a database verify from database setup and let us know what it reports.
Pervasive or MS SQL?

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[mimi2013]

MS SQL.

 

[Jay Converse]

What did database verify tell you?

 

[mimi2013]

Found zero errors.
I have also done a db dump and load and it went in successfully. No errors found.

 

[Jay Converse]

Then you need to review the RVSPY log. Make sure you send output to a file, look for ** ERRROR **, and not the last one in the file, but the second or third to last, there will probably be a few in a row.

 

[mimi2013]

I have attached the RVSPY output file.
Any help will be so highly appreciated.
Can't seem to figure out what's wrong but the errors are appearing at PORCPH.

 

[Jay Converse]

The error is a missing PO receipt. You'll see a block of errors beginning at line 23248, with a table read.

[13a4.7ff.17c4] PO0700: PORCPH [17:29:40.65].Read(view=0x0884064C)
[13a4.7ff.17c4] 1 <==[17:29:40.65;t=16;ovh=0] {**NOT-FOUND**}
[13a4.7ff.17c4] 1 <==[17:29:40.66;t=2153;ovh=1669] {**ERROR**}
[13a4.7ff.17c4] 1 <==[17:29:40.66;t=47034;ovh=34371] {**ERROR**}


Moving back up, here is the missing PORCPH.RCPHSEQ (3503035):

[13a4.7ff.17c4] PO0700: PORCPH [17:29:39.30].Put(view=0x0884064C, field=1, size=10, verify=0, buffer='\00\00\00\00\00\00\35\03\03\5c' -> 3503035)

My suggestion is to remove that pending record from PORCPI, and never do any more transactions against it. But you'll have to do your own forensics as to why that record is missing.

 

[mimi2013]

@tuba2007 Thank you so much, you have really helped me out after a long struggle.