Can't enter a part

Trying to enter aprt into Order Entry but ge tthis error:

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
The statement has been terminated.

Any new BPms or data Directives? If not it looks like there’s an issue with your DB… Check your Disc Space on SQL. Make sure your Logs didn’t go coo coo for cocoa puffs

How do I check my logs? Everything else looks good.

No new bpms or data directives.

@josecgomez here is the details.

Message: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
The statement has been terminated.
Program: Epicor.ServiceModel.dll
Method: ShouldRethrowNonRetryableException

Client Stack Trace

at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Erp.Proxy.BO.SalesOrderImpl.MasterUpdate(Boolean lCheckForOrderChangedMsg, Boolean lcheckForResponse, String cTableName, Int32 iCustNum, Int32 iOrderNum, Boolean lweLicensed, Boolean& lContinue, String& cResponseMsg, String& cCreditShipAction, String& cDisplayMsg, String& cCompliantMsg, String& cResponseMsgOrdRel, SalesOrderDataSet ds)
at Erp.Adapters.SalesOrderAdapter.MasterUpdate(Boolean lCheckForOrderChangedMsg, Boolean lcheckForResponse, String cTableName, Int32 iCustNum, Int32 iOrderNum, Boolean lweLicensed, Boolean& lContinue, String& cResponseMsg, String& cCreditShipAction, String& cDisplayMsg, String& cCompliantMsg, String& cResponseMsgOrdRel)
at Erp.UI.App.SalesOrderEntry.Transaction.Update

Any part or one part specifically?

Yes, specific part. I don’t see any invalid characters, but thats all I could think of right now. The PArt number has lower case letters in it, but other than that, nothing that stands out.

Sounds like something is corrupted with the part record… very odd. I’d recycle the app server and if that doesn’t do it then may be time of a support call @aidacra

@josecgomez Case number is 924204, they are at a standstill right now. They thought out of palce character like i did but nothing is out of place. No other part is having this issue. Very strange indeed.

If it is only on one part, have you checked the part description for bad characters? Are there attachments maybe?

Can you transact the part in any other way? Try a qty adjust and see if it allows you to process that.

That doesnt sound like a typical Epicor error message… wondering if it is coming directly from SQL.

William, you might get a message similar to this one if you have a part ABC123 already in the part master and you’re trying to add Abc123 for example; did you check for that?

Best,
.Monty.

did you find any solution for this error? I’m having the same issue currently.

I found this in EpiCare:
This error shows up, because there are invalid characters in the Part description, so go to part entry and remove any character that is invalid for SQL like /* or ‘ or blank spaces to mention a few, once these characters are removed from the description, the error will go away, allowing you to save the changes in the sales order