Beas Mrp Calculate errpr

Answered

TomLee

• April 08, 2022 02:52

When I Calculate beas_MRP Show error message like below picture

I'v already Do database test but still show the error message 
Please tell me how to fixed it .

the enviorment is Demo enviorment 

Vote

1

• 

  Martin Heigl

  • April 08, 2022 04:19

  Hi,

  picture too small. I can't read it.
• 

  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~

   

   

   
• 

  Martin Heigl

  • April 08, 2022 16:14
  • Edited

  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

   

   

Please sign in to leave a comment.