Demand Plan Server failed with errors - Table does not exist: 'IPR_FUTURE_ORDERS_TAB'
Recently we have installed demand planner service on against IFS Application 10 and service did not start as expected because of below error.
Job started: Load Data from DB Table does not exist: 'IPR_FUTURE_ORDERS_TAB'
error mentioned table was not in the Database as well.
Below component caused the issue and after it has drop from the Database Demand Planner service was worked as expected.
Page 1 / 1
In your Demand Planner, how you have enabled the below setting?
Hi @Rasika Lakmal
Its only forecast. for the IPR option you need to have relevant component purchased.
Best Regards, currently Application run as Windows Service Auto start. but it can be run as Application as well.
Rusiru
@Rusiiiru Then you shouldn’t get such error and I’m not sure why.
We recently ran into the same issue, where we deployed the INVPLA module as a separate addon, but then Demand Server broke with this error message.
The table *did* exist, but the database account used by Demand Planner to connect to the DB did not have any permissions to read the table.
We granted the Demand Planner server DB account SELECT permission to the table IPR_FUTURE_ORDERS_TAB and it appears to have resolved the issue. No need to remove anything from the database; it looks like a simple case of the relevant account simply being unable to see the table due to bad out-of-the-box permissions.