Material Planning Reports running super slow after upgrading to 9.0.2

Visual is currently looking at our database to see why after upgrading to 9.0.2 (from 9.0.0) to see why our Material Planning Reports (yes, all of them) are running slow, about a second per part in the database and we have close to 33,000 parts.

Did anyone else have this kind of issue? Does any one have a SQL statement that will output the data that Material Planning Reports produce? I was trying to develop one but running thought I'd ask first.

Liz Scheller-Williams

Electronics Research, Inc.

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

Legacy Contributor

We've experienced slow running reports and SQL cursor errors. There is a pre-release version of VMPLNWIN.EXE you can request that helps a little. Access to the pre-release is referenced from KB 1953895 in Xtreme. The best workaround we found for the SQL cursor errors was to send the report to a PDF printer.

Elizabeth Scheller-Williams

Yep, got the VMPLNWIN.EXE within 4 hours of the first reported SQL cursor error.

Copyright © 2025 Infor. All rights reserved.