Skip to main content

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.

 

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.

Nick


Reply