Archive Exception IS_QM_ACCEPTED

40 Views

Hi,

Our Archiving has stopped working after upgrading to 6.0.4.6.

We get an exception about a column IS_QM_ACCEPTED missing both

when running the Archive bat-file and by using the Archive activity from within SAP ME Menu.

Anybody have an idea?

Best Regards,

Johan Nordebrink

The exception from default trace file is:

#2.0 #2013 06 10 16:07:04:065#+0200#Error#com.sap.engine.services.ejb3.runtime#

com.sap.ASJ.ejb.005017#BC-JAS-EJB#ejb#C0000AD30348414B0000000000001354#9934850000000004#sap.com/me~ear#com.sap.engine.services.ejb3.runtime#JONORD#4797873#JTA Transaction : 72513587#C9F153DCD1D611E2935B000000979802#05c7f9b3d1d711e287d4000000979802#05c7f9b3d1d711e287d4000000979802#0#Thread[HTTP Worker [@1757884431],5,Dedicated_Application_Thread]#Plain##

System exception

[EXCEPTION]

javax.ejb.EJBTransactionRolledbackException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public int com.sap.me.datacollection.ParametricBOBean.archive(com.sap.me.frame.Data) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.datacollection.ParametricBOBean@657d31e8 for bean sap.com/me~ear*xml|me.datacollection.ejb-6.0.4.6.jar*xml|ParametricBO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'IS_QM_ACCEPTED'.; nested exception is: javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public int com.sap.me.datacollection.ParametricBOBean.archive(com.sap.me.frame.Data) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.datacollection.ParametricBOBean@657d31e8 for bean sap.com/me~ear*xml|me.datacollection.ejb-6.0.4.6.jar*xml|ParametricBO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'IS_QM_ACCEPTED'.

javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public int com.sap.me.datacollection.ParametricBOBean.archive(com.sap.me.frame.Data) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.datacollection.ParametricBOBean@657d31e8 for bean sap.com/me~ear*xml|me.datacollection.ejb-6.0.4.6.jar*xml|ParametricBO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'IS_QM_ACCEPTED'.

javax.ejb.EJBException: nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'IS_QM_ACCEPTED'.

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'IS_QM_ACCEPTED'.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:350)

at com.sap.me.frame.jdbc.DynamicQuery.executeUpdate(DynamicQuery.java:859)

at com.sap.me.frame.AbstractSqlImplementation.executeUpdate(AbstractSqlImplementation.java:71)

at sun.reflect.GeneratedMethodAccessor973.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.visiprise.frame.proxy.DefaultInterceptor.intercept(DefaultInterceptor.java:31)

at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)

at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:67)

at com.sap.me.frame.CheckReadOnlyModeInterceptor.intercept(CheckReadOnlyModeInterceptor.java:16)

at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)

at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:67)

at com.visiprise.frame.proxy.AdviceInterceptor.intercept(AdviceInterceptor.java:44)

at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:48)

at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:81)

at $Proxy1548.executeUpdate(Unknown Source)

at com.sap.me.frame.AbstractDataSource.executeUpdate(AbstractDataSource.java:301)

at com.sap.me.system.base.ArchivableBOBean.archiveQuick(ArchivableBOBean.java:900)

at com.sap.me.datacollection.ParametricBOBean.archive(ParametricBOBean.java:2020)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)