SpeedyGonza
Technical User
To start off...I am using Extender 7.5.28, Smartlist Builder 7.5.15 and Great Plains 7.5 SP 6 and SQL Server 7.
In our GP we have several companies...let's call the main one "Company A" and the problematic one "Company B". We also have 2 test servers which are contains a replicate of the database from the live server.
I am having a problem when trying to access
Inquiry > Purchasing > Purchase Order Docs on "Company B" on the live server.
I've entered the Vendor ID, check off all 3 check boxes to view all POs and Receipts entry.
When I've highlighted one of the row and click on the Receipt Number I'm getting:
Unhandled script exception:
Object has no reference.
EXCEPTION_CLASS_SCRIPT_BAD_PARAM
SCRIPT_CMD_DEREF_TABLE
I am not sure what is happening as this is a Great Plains Dexterity error…it has nothing to do with our customized forms / reports / VBA errors.
After testing with different logons, trying the same steps on different machines, I've determined that this script error should have nothing to do with Windows Permission nor GP Permission or specific GP installation files….It should have something to do with the database…. something has changed I don't know what it is.
One possibility is that when I install Extender on the "Company B" it has broke something on the live server.
When we setup "Company A" extender was installed quite earlier on ...we haven't setup extender on "Company B" until just few days ago...there are already lots of POs and Receiving Entry's in the database prior to extender being installed.
But that doesn't quite explain it because I've installed Extender for the "Company B" on 2 test servers and I was still able to do receiving trx inquiry successfully on the test servers. Also, I'm able to do receiving trx inquiry for "Company A" on both the live server and the test servers.
Your comments and advices are highly appreciated.
In our GP we have several companies...let's call the main one "Company A" and the problematic one "Company B". We also have 2 test servers which are contains a replicate of the database from the live server.
I am having a problem when trying to access
Inquiry > Purchasing > Purchase Order Docs on "Company B" on the live server.
I've entered the Vendor ID, check off all 3 check boxes to view all POs and Receipts entry.
When I've highlighted one of the row and click on the Receipt Number I'm getting:
Unhandled script exception:
Object has no reference.
EXCEPTION_CLASS_SCRIPT_BAD_PARAM
SCRIPT_CMD_DEREF_TABLE
I am not sure what is happening as this is a Great Plains Dexterity error…it has nothing to do with our customized forms / reports / VBA errors.
After testing with different logons, trying the same steps on different machines, I've determined that this script error should have nothing to do with Windows Permission nor GP Permission or specific GP installation files….It should have something to do with the database…. something has changed I don't know what it is.
One possibility is that when I install Extender on the "Company B" it has broke something on the live server.
When we setup "Company A" extender was installed quite earlier on ...we haven't setup extender on "Company B" until just few days ago...there are already lots of POs and Receiving Entry's in the database prior to extender being installed.
But that doesn't quite explain it because I've installed Extender for the "Company B" on 2 test servers and I was still able to do receiving trx inquiry successfully on the test servers. Also, I'm able to do receiving trx inquiry for "Company A" on both the live server and the test servers.
Your comments and advices are highly appreciated.