RVSPY Log on DayEnd error

[IanBooth2022]

Hi

I have two errors in my RVSPY log

The first
[1044.7ff.1454] PO0702: PORCPJ [20:33:13.99].Read(view=0x0B63EA1C)
[1044.7ff.1454] 1 <==[20:33:14.00;t=0;ovh=0] {**NOT-FOUND**}
[1044.7ff.1454] 1 <==[20:33:14.06;t=19547;ovh=18045] {**ERROR**}
[1044.7ff.1454] 1 <==[20:33:14.07;t=408907;ovh=388423] {**ERROR**}

And the second where the Dayend actually fell over
[1044.7ff.1454] PO0335: PODEPR [20:33:20.96].Unload
[1044.7ff.1454] 9903 <==[20:33:20.99;t=443829;ovh=419395] {**ERROR**}
[1044.7ff.1454] 9903 <==[20:33:21.00;t=443829;ovh=419395] {**ERROR**}

My question is this: What do the t= and ovh = numbers mean? Do they indicate which record?
My issue is my SEQ numbers are like 31832985 and 69881 rows on the PORCPJ table.

Thanks for any help

 

[ettienne]

Look in the line above the first line ([1044.7ff.1454] PO0702: PORCPJ [20:33:13.99].Read(view=0x0B63EA1C)), you will see it puts values to the key fields before attempting the .read
That will be the record(s) of interest.

Sage 300 Certified Consultant

 

[IanBooth2022]

Thank you Ettienne

This makes sense to me now. I know the 31816109 record.

[1044.7ff.1454] PO0702: PORCPJ [20:33:13.98].Put(view=0x0B63EA1C, field=1, size=10, verify=0, buffer='\00\00\00\00\00\03\18\16\10\9c' -> 31816109)
[1044.7ff.1454] 0 <==[20:33:13.99;t=0;ovh=0] {}

By the way, did you work for Lorge quite some time ago?

 

[ettienne]

Hi, Ian. Yes that's me


Sage 300 Certifiable Consultant

 

[IanBooth2022]

Hi Ettienne
Good to meet up here after all that time.

I have found my error from the last hint you gave me and ran a script to correct that issue.

However, I now find this issue. I am running this as admin.
Could this be something on the PORETH table that is stopping the PO dayend from running?
InstanceSecurity?

Thank you for you help.


[1034.7ff.1b88] 0 <==[21:31:12.05;t=2469;ovh=2406] {}
[1034.7ff.1b88] PO0731: AUPORETH [21:31:12.05].Read(view=0x0B40A9B4)
[1034.7ff.1b88] AU0892: PORETH [21:31:12.06].InstanceSecurity(view=0x0B8E39C4)
[1034.7ff.1b88] 0 <==[21:31:12.06;t=0;ovh=0] {permissions=0x0000001f}
[1034.7ff.1b88] AU0892: PORETH [21:31:12.06].Read(view=0x0B8E39C4)
[1034.7ff.1b88] 1 <==[21:31:12.17;t=94;ovh=0] {**NOT-FOUND**}
[1034.7ff.1b88] 1 <==[21:31:12.17;t=109;ovh=15] {**NOT-FOUND**}
[1034.7ff.1b88] 1 <==[21:31:12.24;t=8625;ovh=8046] {**ERROR**}
[1034.7ff.1b88] 1 <==[21:31:12.24;t=479578;ovh=440439] {**ERROR**}

 

[ettienne]

Hey Ian, yeah it's been a while. You still in Cape Town?

AU = audit logger
InstanceSecurity returns the permissions of the user, I don't think that is the issue.

https://documentation.help/AccpacCOMAPI/InstanceSecurity.htm

Look at the .put above the .read, that will be the PORETH record that it is failing on. It could be something in the header or the detail lines.

Sage 300 Certifiable Consultant