Error occurred when opening view PO0710 1

[pb4infocentral]

Any assistance with the following will be greatly appreciated:

We get the following error when attempting to open Purchase Order Receipts:
1. Error occurred when opening view PO0710- Source svrDBLink
2. View PO0710 is no a valid View ID - Source DS dsPORCPL
3. Error occurred when activating Sage ERP 300 Data Source - Source DS dsPORCPL

The environment is Windows 8.1 with a clean install of Sage ERP 300 2014 Premium

It appears to be related to this particular database as purchase order receipts works on the SAMINC database.

We have also unloaded and reloaded the error database and get the same error.

Other functionality such as OE and Purchase Entry work ok but invoice entry fails with a PO0424 error similar to the above.

The database is our development database so are happy to apply data related changes to correct the error.

So far, have attempted to clear all of the POR related tables in this error database but error remains.

 

[ettienne]

Reinstall PO - that error indicates missing program files.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[pb4infocentral]

Hi Etienne,

Thanks for response.

Have reinstalled the ERP 300 2014 twice already with no change. Then tried purchase order receipts using SAMINC from the same computer and it works ok - so it feels like a data related issue.

 

[ettienne]

Run a data integrity check on PO.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[pb4infocentral]

Hi Etienne,

Yes - we did that as well - and the data integrity check reported an error:

Receipts:
E: Internal error. OpenOneView failed (1388 POINTCKD.C)

I also attempted to record a macro when opening the PO Receipts to see whether it gave any clues but this did not help either.

 

[ettienne]

Your data is damaged.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[pb4infocentral]

I really would like to salvage the data if possible!

I have run the RVSpy and it shows an error as follows:

[cc0.0.109c] PO0710: PORCPL [14:13:57.97].Load
[cc0.0.109c] PO0710: PORCPL [14:13:57.97].VersionTemplate()
[cc0.0.109c] 0 <==14:13:57.99 {version='60A', date='2009-12-07'}
[cc0.7ff.109c] PO0710: PORCPL [14:13:57.99].InstanceOpen(PIB=2047, link=10, flags=0x00000000, size=0, buffer='')
.....
[d2c.0.5cc] --LINK-10: 14:13:58.24
[cc0.0.109c] FA0500: ???????? [14:13:58.25].Load
[cc0.7ff.109c] FA0500: ???????? [14:13:58.27].Open(PIB=2047, link=10)
[cc0.7ff.109c] 0 <==[14:13:58.27;t=0;ovh=0] {view=0xDEADBEAF}
[cc0.7ff.109c] FA0500: ???????? [14:13:58.27].Fields(view=0xDEADBEAF)
[cc0.7ff.109c] 0 <==[14:13:58.28;t=0;ovh=0] {fields=0}
[cc0.7ff.109c] FA0500: ???????? [14:13:58.28].Browse(view=0xDEADBEAF, filter='', direction=forward)
[cc0.7ff.109c] 0 <==[14:13:58.28;t=0;ovh=0] {}
[cc0.7ff.109c] FA0500: ???????? [14:13:58.30].Fetch(view=0xDEADBEAF)
[cc0.7ff.109c] 1021 <==[14:13:58.30;t=0;ovh=0] {**NO-MORE-DATA**}
[cc0.7ff.109c] FA0500: ???????? [14:13:58.30].Close(view=0xDEADBEAF)
[cc0.7ff.109c] 0 <==[14:13:58.31;t=0;ovh=0] {}
[cc0.7ff.109c] FA0500: ???????? [14:13:58.31].Unload
[d2c.0.5cc] --LINK-10: 14:13:58.31 CLOSE-TABLE ( handle=PORCPL-4 )
[d2c.0.5cc] --LINK-10: 14:13:58.33
[cc0.7ff.109c] 1 <==[14:13:58.35;t=344;ovh=46] {**ERROR**}
[cc0.7ff.109c] PO0710: PORCPL [14:13:58.36].Unload
[cc0.7ff.109c] PO0700: PORCPH [14:13:58.38].Close(view=0x0B6623CC)

I am not familiar with the log contents but it looks like it is failing opening a view FA0500.

The newly built SAMINC for 2015 does not even contain a table FAOPT.

Any suggestions?

 

[ettienne]

What is FA? Look in version 2012 - click Help, System Information.
If FA is active in 2012 then you need to activate it in 2014.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[pb4infocentral]

OK - problem solved - PO Receipts is working.

When I did a clean install of 2014, I did not bother to install Fixed Assets integration as I do not use Fixed Assets, but the 60A database must have had Fixed Assets integration installed. So, I reinstalled 2014 (yet again) and this time included FA - but got the same error (PO0710) until such time as I activated the Fixed Assets Integration.

Thanks all for suggestions etc.

 

[ettienne]

That's common sense - if something was active in a previous version then it needs to be active in the new version.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net