intradoc.data.DataException: !csExportErrorForArchiveInCollection,sample,idc!csDbUnableToCreateResultSet,SELECT DISTINCT Revisions.dRevClassID FROM Revisions\, DocMeta\, Documents\, RevClasses WHERE Revisions.dID=DocMeta.dID AND Revisions.dID = Documents.dID AND Revisions.dRevClassId = RevClasses.dRevClassId AND Revisions.dReleaseState <> 'E' AND Revisions.dStatus <> 'DELETED' AND (Revisions.dDocName = 'ECM000007') AND (Revisions.dPublishState is null OR Revisions.dPublishState = '')!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'dRevClassId'.

Oracle Community | 1028358 | 2 years ago
  1. 0

    Unable to delete docs using Archiver

    Oracle Community | 2 years ago | 1028358
    intradoc.data.DataException: !csExportErrorForArchiveInCollection,sample,idc!csDbUnableToCreateResultSet,SELECT DISTINCT Revisions.dRevClassID FROM Revisions\, DocMeta\, Documents\, RevClasses WHERE Revisions.dID=DocMeta.dID AND Revisions.dID = Documents.dID AND Revisions.dRevClassId = RevClasses.dRevClassId AND Revisions.dReleaseState <> 'E' AND Revisions.dStatus <> 'DELETED' AND (Revisions.dDocName = 'ECM000007') AND (Revisions.dPublishState is null OR Revisions.dPublishState = '')!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'dRevClassId'.
  2. 0

    Web center content 11.1.1.8 frameworkfolders migration problem

    Oracle Community | 2 years ago | webyildirim
    intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT dCollectionID\, dCollectionName\, dParentCollectionID\, dCollectionMark FROM Collections WHERE dParentCollectionID='-1'!$ORA-00942: table or view does not exist
  3. 0

    404 page not found error on login page.

    Oracle Community | 10 months ago | 2767202
    intradoc.data.DataException: !csJdbcGenericError
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-01013 while searching in UCM

    Oracle Community | 8 years ago | 688622
    intradoc.common.ServiceException: !csSearchUnableToRetrieveSearchResult!csDbUnableToCreateResultSet,SELECT Revisions.dID\, dDocName\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dCreateDate\, dPublishType\, dRendition1\, dRendition2\, dFileSize AS VaultFileSize\, DocMeta.* FROM Revisions\, DocMeta\, Documents WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And dIsPrimary = 1 AND dReleaseState IN ('Y'\, 'U'\, 'I') ORDER BY dInDate Desc!$ORA-01013: user requested cancel of current operation
  6. 0

    Migration Import Issue

    Oracle Community | 3 years ago | user277913 - oracle
    intradoc.common.ServiceException: !csServiceDataException,INSERT_NEW,validateStandard!$

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. intradoc.data.DataException

      !csDbUnableToCreateResultSet,SELECT DISTINCT Revisions.dRevClassID FROM Revisions\, DocMeta\, Documents\, RevClasses WHERE Revisions.dID=DocMeta.dID AND Revisions.dID = Documents.dID AND Revisions.dRevClassId = RevClasses.dRevClassId AND Revisions.dReleaseState <> 'E' AND Revisions.dStatus <> 'DELETED' AND (Revisions.dDocName = 'ECM000007') AND (Revisions.dPublishState is null OR Revisions.dPublishState = '')!$[FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'dRevClassId'.

      at intradoc.jdbc.JdbcWorkspace.handleSQLException()
    2. intradoc.jdbc
      JdbcWorkspace.createResultSetSQL
      1. intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2595)
      2. intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:830)
      3. intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:769)
      3 frames
    3. intradoc.server.archive
      ArchiveHandler.doArchiving
      1. intradoc.server.archive.ArchiveExportHelper.performQuery(ArchiveExportHelper.java:171)
      2. intradoc.server.archive.ArchiveHandler.doExportQuery(ArchiveHandler.java:859)
      3. intradoc.server.archive.ArchiveHandler.buildBatch(ArchiveHandler.java:518)
      4. intradoc.server.archive.ArchiveHandler.doExport(ArchiveHandler.java:476)
      5. intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:258)
      5 frames