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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Problem with Archiving TN DB using built in service wm.tn.archive:archive

  • 1.  Problem with Archiving TN DB using built in service wm.tn.archive:archive

    Posted Thu October 03, 2013 12:09 PM

    Hello All,

    I’m trying to archive the TN DB which are 30 days old using built in service wm.tn.archive:archive . i gave input “archiveAfterDays” as 30. But instead archiving iam getting below error.could any one help me regarding this aspect

    ERROR:
    Could not run ‘archive’.

    com.wm.app.tn.db.DatastoreException: Could not archive documents.
    (0) java.sql.SQLSyntaxErrorException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00904: “SERVICENAME”: invalid identifier

    (1) java.sql.SQLSyntaxErrorException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00904: "SERVICENAME": invalid identifier

    ArchiveError.bmp (396 KB)


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


  • 2.  RE: Problem with Archiving TN DB using built in service wm.tn.archive:archive

    Posted Thu October 03, 2013 02:47 PM

    It’s issue with your archive schemas missing some definitions most likely.

    So can you drop the archive tables and rerun the scripts and make sure all the Archive tables installed and also check with your DBA another set of eye to check every thing fine on the DB side.

    Then try to run the archive service (Note this will take longer if you have huge data sitting in the DB and running first time)

    HTH,
    RMG


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


Related Content