Vantage 6.1 open purchase orders report problem

Yahoo Archive
1

Just a question – does the report run if you select a single vendor? How about choosing a range of vendors?

When we had that happen, it worked if we didn’t run it wide open. Maybe you could find your “bad” vendor record

if you try running small groups, a few at a time. Â

 

Good luck!!

Julie

Mercury Minnesota Inc.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Sunday, May 17, 2015 8:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 6.1 open purchase orders report problem

 

 

So the idxbuild did not work.  so much for tect support. Any other recommendations?

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5941 / Virus Database: 4342/9803 - Release Date: 05/17/15

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5941 / Virus Database: 4342/9803 - Release Date: 05/17/15

2
We have recently moved our installation of Vantage to a new server and are having a strange behavior when anyone attempts to run the Open Purchase Orders canned report.

The user is able to bring up the initial Open Purchase Order Report filter criteria screen and enter the beginning and ending dates.   They then click on the Vendors button opening the Select Vendors window.  Clicking on the magnifying glass allows them to select the vendor they want from the vendor list, but when they click ok and move back to the Select Vendors window, Vantage closes with no errors and nothing noted in any of the system logs on the computer.

Vantage server is on a Hyper-V machine running Windows Server 2003 Standard, client PC's vary between physical and virtualized XP machines to 32 bit Windows 7 physical machines.  The database has been checked and re-indexed, database conversion #5110 (reset /synchronize purchase orders status) has been run, and menu.prl and workingmenu.prl were moved from the old server to the new one.

I have had this issue once in the past - most likely the last time I moved the database from one server to another, but I cannot find any record of how it was fixed.  It's either a different conversion program that needs to be run, or there is a file to move that I missed. 

Does anyone out there have any recommendations?

TIA,

Mike.


3

Dredging up old memories here.  It’s been a year since I dealt with V6.1 on a regular basis.

One gotcha from changing servers that I vividly recall was related to the server name change from old to new.  If you changed Computer name  on the new server then look for and eliminate  registry references to the old server.  Ditto for HOSTS file references.  Aside from connection issue this can severely impact speed.  Also if new server is different from domain controller look for references to the old server (if decommissioned) in the DNS settings there.  These can also confuse things.  Also maybe look at any Progress or Vantage related services and what credentials they run on on the new server.  No guarantees but maybe a few things worth trying.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 11, 2015 7:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 open purchase orders report problem

 

 

We have recently moved our installation of Vantage to a new server and are having a strange behavior when anyone attempts to run the Open Purchase Orders canned report.

The user is able to bring up the initial Open Purchase Order Report filter criteria screen and enter the beginning and ending dates.   They then click on the Vendors button opening the Select Vendors window.  Clicking on the magnifying glass allows them to select the vendor they want from the vendor list, but when they click ok and move back to the Select Vendors window, Vantage closes with no errors and nothing noted in any of the system logs on the computer.

Vantage server is on a Hyper-V machine running Windows Server 2003 Standard, client PC's vary between physical and virtualized XP machines to 32 bit Windows 7 physical machines.  The database has been checked and re-indexed, database conversion #5110 (reset /synchronize purchase orders status) has been run, and menu.prl and workingmenu.prl were moved from the old server to the new one.

I have had this issue once in the past - most likely the last time I moved the database from one server to another, but I cannot find any record of how it was fixed.  It's either a different conversion program that needs to be run, or there is a file to move that I missed. 

Does anyone out there have any recommendations?

TIA,

Mike.

 

4

If you open Vendor maintenance, does the first “record” in the browser list happen to be what appears to be a blank record?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 11, 2015 6:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 6.1 open purchase orders report problem

 

 

Dredging up old memories here.  It’s been a year since I dealt with V6.1 on a regular basis.

One gotcha from changing servers that I vividly recall was related to the server name change from old to new.  If you changed Computer name  on the new server then look for and eliminate  registry references to the old server.  Ditto for HOSTS file references.  Aside from connection issue this can severely impact speed.  Also if new server is different from domain controller look for references to the old server (if decommissioned) in the DNS settings there.  These can also confuse things.  Also maybe look at any Progress or Vantage related services and what credentials they run on on the new server.  No guarantees but maybe a few things worth trying.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 11, 2015 7:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 open purchase orders report problem

 

 

We have recently moved our installation of Vantage to a new server and are having a strange behavior when anyone attempts to run the Open Purchase Orders canned report.

The user is able to bring up the initial Open Purchase Order Report filter criteria screen and enter the beginning and ending dates.   They then click on the Vendors button opening the Select Vendors window.  Clicking on the magnifying glass allows them to select the vendor they want from the vendor list, but when they click ok and move back to the Select Vendors window, Vantage closes with no errors and nothing noted in any of the system logs on the computer.

Vantage server is on a Hyper-V machine running Windows Server 2003 Standard, client PC's vary between physical and virtualized XP machines to 32 bit Windows 7 physical machines.  The database has been checked and re-indexed, database conversion #5110 (reset /synchronize purchase orders status) has been run, and menu.prl and workingmenu.prl were moved from the old server to the new one.

I have had this issue once in the past - most likely the last time I moved the database from one server to another, but I cannot find any record of how it was fixed.  It's either a different conversion program that needs to be run, or there is a file to move that I missed. 

Does anyone out there have any recommendations?

TIA,

Mike.

 

5

Someone mentioned this to you already, but did you check to see if you had a blank Vendor record?

Just open up Vendors and see if the first record is blank. If so, delete it and that will probably solve your problem.

Don’t know why, but that seems to happen periodically in 6.1 and does cause that behavior when trying to run that report.

 

Regards,

Julie

Mercury Minnesota Inc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 11, 2015 7:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 open purchase orders report problem

 

 

We have recently moved our installation of Vantage to a new server and are having a strange behavior when anyone attempts to run the Open Purchase Orders canned report.

The user is able to bring up the initial Open Purchase Order Report filter criteria screen and enter the beginning and ending dates.   They then click on the Vendors button opening the Select Vendors window.  Clicking on the magnifying glass allows them to select the vendor they want from the vendor list, but when they click ok and move back to the Select Vendors window, Vantage closes with no errors and nothing noted in any of the system logs on the computer.

Vantage server is on a Hyper-V machine running Windows Server 2003 Standard, client PC's vary between physical and virtualized XP machines to 32 bit Windows 7 physical machines.  The database has been checked and re-indexed, database conversion #5110 (reset /synchronize purchase orders status) has been run, and menu .prl and workingmenu.prl were moved from the old server to the new one.

I have had this issue once in the past - most likely the last time I moved the database from one server to another, but I cannot find any record of how it was fixed.  It's either a different conversion program that needs to be run, or there is a file to move that I missed. 

Does anyone out there have any recommendations?

TIA,

Mike.

 

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5941 / Virus Database: 4342/9752 - Release Date: 05/11/15

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5941 / Virus Database: 4342/9756 - Release Date: 05/12/15

6
Todd,

I too know the pain of moving a server and finding the 'gotchas'.  This is the second time I have moved the server, so I knew the pitfalls to avoid (or so I thought).  The Vantage server name and IP address remains the same, and references to the old domain server have been removed via regedit, but no love on the Open PO report.

I've gotten a response from Tech Support for a different IDXBUILD command to use than the one I did, so hopefully it will fix the issue.  Now I just need to convince everyone that it's a good idea to log out for a couple hours :)

Thanks for the suggestion!

Mike.
7
Mike,

There was a 'blank' record in the first spot of Vendor Maintenance.  Deleting it did not provide the desired results though.

I received a response from tech support that I will be trying later this week.  I'll post the results for posterities sake.

Mike.
8
Julie,

Thanks for the input, but it didn't work.  I did find an empty record and deleted it, but no love, the software still crashes.

I have something from tech support to try and I'll post the results later this week.

Mike
9
So the idxbuild did not work.  so much for tect support. Any other recommendations?