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'.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web49

  • via Oracle Community by 1028358, 1 year ago
    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'.
  • via Oracle Community by V07, 1 year ago
    !csDbUnableToCreateResultSet,QdocInfo(SELECT/*+ USE_NL (Revisions Documents DocMeta) LEADING(Revisions)INDEX (Revisions PK_Revisions)*/ Revisions.*\, Documents.*\, DocMeta.* FROM Revisions\, Documents\, DocMeta WHERE Revisions.dID=359 AND
  • via Oracle Community by 809734, 1 year ago
    !csDbUnableToCreateResultSet,QwfActiveDocs(SELECT/ + USE_NL (WorkflowDocuments Revisions) LEADING(WorkflowDocuments)INDEX (WorkflowDocuments dWfDocState)*/ DISTINCT Revisions.dRevClassID* FROM WorkflowDocuments\, Revisions WHERE
  • Stack trace

    • 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'. at intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:320) at intradoc.server.archive.ArchiverMonitor.doArchiving(ArchiverMonitor.java:581) at intradoc.server.archive.ArchiverMonitor$4.run(ArchiverMonitor.java:668) at java.lang.Thread.run(Thread.java:662) Caused by: 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(JdbcWorkspace.java:2595) at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:830) at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:769) at intradoc.server.archive.ArchiveExportHelper.performQuery(ArchiveExportHelper.java:171) at intradoc.server.archive.ArchiveHandler.doExportQuery(ArchiveHandler.java:859) at intradoc.server.archive.ArchiveHandler.buildBatch(ArchiveHandler.java:518) at intradoc.server.archive.ArchiveHandler.doExport(ArchiveHandler.java:476) at intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:258)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 1 year ago