Could anyone help me with these…i ran the migrate TN,coreaudit,processaudit scripts and we imported TN data from 6.1 to 6.5 and when we try to start the server these are the errors that i am seeing in server logs…
[ISU.0000.9999D] TRANET: Loading system configuration
2007-07-03 17:07:23 EDT [ISU.0000.9999D] Warning: SQLException retrieving Delivery Jobs from database: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “USERNAME”: invalid identifier
[Warning: SQLException retrieving Delivery Jobs from database: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “USERNAME”: invalid identifier
]
2007-07-03 17:07:23 EDT [ISU.0000.9999D] java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “USERNAME”: invalid identifier
at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.wm.dd.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.wm.app.tn.db.DeliveryOperations.getActiveJobs(DeliveryOperations.java:429)
at com.wm.app.tn.db.DeliveryStore.init(DeliveryStore.java:117)
at com.wm.app.tn.delivery.JobMgr.(JobMgr.java:91)
at com.wm.app.tn.delivery.JobMgr.init(JobMgr.java:150)
at wm.tn.route.init(route.java:60)
at wm.tn.adminimpl.startup(adminimpl.java:742)
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:324)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:322)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:612)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:226)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:198)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:411)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:521)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:369)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)
[PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist