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.<init>(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

Hi Sujith

This Error happens when your DBA runs the migrate scripts and in any one of your table “USERNAME” column or row is not present which is in 6.1 TN DB and not in 6.5 TN DB…check with your DBA regarding the missing columns in 6.1 TN DB and 6.5 TN DB…

Thanks
Bhanu

Migration script must have dropped old table or record while altering…

Make sure u have the below master tables properly
Address
BinaryType
BizDocAttributeDef
BizDocTypeAttribute
BizDocTypeDef
BizDocUniqueKeys
Contact
ContactType
DeliveryQueue
DeliveryService
Destination
EDIControlNumber
EDIEnvelope
EDIEnvelopeInfo
EDIGroup
EDIStatus
EDITracking
FieldGroup
IDType
Partner
PartnerBinary
PartnerID
PartnerProfileField
PartnerProfileGroup
ProcessingRule
ProcessingRuleModification
ProfileField
ProfileGroup
Remote
SecurityAgreement
SecurityData
TNModelVersion
TNStatistics
TPA
TPALock