Substep related error when releasing the shop order in SAP ME 15.1

[Former Member]

Hello Experts,

We have recently upgraded the SAP ME system to 15.1.

Post upgrade, when we try to release a shop order, we get an error related to substep. This order is created in ME and not downloaded from SAP. We have checked the routing and there are no susteps assigned to nay operation.

The error log is as below (part of the error log only. The log is quite big and can be provided if required):

System exception

[EXCEPTION]

javax.ejb.EJBTransactionRolledbackException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public com.sap.me.frame.Data com.sap.me.production.ActivityLogBOBean.log(com.sap.me.frame.Data) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.production.ActivityLogBOBean@1252d6f8 for bean sap.com/me~ear*xml|me.production.ejb-151.1.0.jar*xml|ActivityLogBO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBSTEP": invalid identifier

; nested exception is: javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public com.sap.me.frame.Data com.sap.me.production.ActivityLogBOBean.log(com.sap.me.frame.Data) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.production.ActivityLogBOBean@1252d6f8 for bean sap.com/me~ear*xml|me.production.ejb-151.1.0.jar*xml|ActivityLogBO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBSTEP": invalid identifier

javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public com.sap.me.frame.Data com.sap.me.production.ActivityLogBOBean.log(com.sap.me.frame.Data) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.production.ActivityLogBOBean@1252d6f8 for bean sap.com/me~ear*xml|me.production.ejb-151.1.0.jar*xml|ActivityLogBO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBSTEP": invalid identifier

javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "SUBSTEP": invalid identifier

Can some one please suggest what could be the reason for this?

Thanks in advance.

Srinivas

[alexander_teslyuk · Accepted solution]

Hello Srinivas,

Looks like the database has not been migrated. Please, make sure you have executed the Migration task of MECTC 15.1 wizard.

Br, Alex.

[Former Member · Accepted solution]

Hello Alexander,

Thanks a lot for the prompt help. This issue has been resolved now following your suggestion.

Thanks

Srinivas