Beas Mrp Calculate errpr Answered

• 

  Martin Heigl

  • April 08, 2022 04:19

  Hi,

  picture too small. I can't read it.

  0
• 

  TomLee

  • April 08, 2022 09:15

  Hi Martin it's show 4 error message 

  I copy it below 
  1.(**) Error while Read or Update DataStore: SQLSTATE = 23000 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Version', table 'SHEENOB3.dbo.BEAS_MRP_DETAIL'; column does not allow nulls. INSERT fails.  No changes

  2.(**) Error Save beas_mrp_detail. beas create a copy of this Datastore in C:\Users\sapadm\AppData\Local\Temp\2\beas\beas_mrp_detail.xls. Error-Code

  3.(**) Error while Read or Update DataStore: SQLSTATE = 23000 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ItemVersion', table 'SHEENOB3.dbo.BEAS_MRP'; column does not allow nulls. INSERT fails.  No changes mad

  4.(**) Error Save beas_mrp. beas create a copy of this Datastore in C:\Users\sapadm\AppData\Local\Temp\2\beas\beas_mrp.xls. Error-Code

   

  Thanks~

   

   

   

  0
• 

  Martin Heigl

  • Edited April 08, 2022 16:14

  Hi TomLee

  Start DataCheck
  

  Check result of the data check

  if not solved
  
  Open
  C:\Users\sapadm\AppData\Local\Temp\2\beas\beas_mrp_detail.xls.
  And check, which entries have NULL values in version field.
  
  MRP setting activate or disable "Consider I-Version"

  Disable more and more points in "Pegging and Replenishment" to find out the area

  

  

  Try to find the item related to excel list, try to reduce count of calculated items and Peggings to a minimum and then start the calculation with debug log and create support ticket with all informations.
  
  if we have mutch as possible information, we can help very fast.
  
  regards

  Martin

   

   

  0

Please sign in to leave a comment.