IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Errors after importing TN data from 6.1 to 6.5

  • 1.  Errors after importing TN data from 6.1 to 6.5

    Posted Thu July 05, 2007 03:24 PM

    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


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


Related Content