3 Replies Latest reply on Jul 11, 2019 8:43 AM by Robert Whelan

    no data displaying in Analyst tool,but table structure is displaying

    Meher Kulkarni New Member

      I have created a human task with bad exception  and executed the workflow successfully,But i am not able to see the data in Analyst tool.I am getting the below error when i click on exception task which is under my tasks in Analyst tool.

       

      [Informatica][Sql server JDBC Driver][SQL Server] invalid column name workflow_id.

       

      workflow_id column existed in IDD_AUDIT table in respective database.But still i am getting the error as invalid column name.

       

      Below is the log file for the reference.

       

      2019-07-10 14:43:55,098 INFO  [SQLWarnings] [informatica][SQLServer JDBC Driver][SQLServer]Changed database context to 'IDQ_Exception_Auditbase'.

      java.sql.SQLWarning: [informatica][SQLServer JDBC Driver][SQLServer]Changed database context to 'IDQ_Exception_Auditbase'.

      at com.informatica.jdbc.sqlserverbase.ddfl.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddfl.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.BaseConnection.getWarnings(Unknown Source)

      at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:907)

      at com.mchange.v2.c3p0.SQLWarnings.logAndClearWarnings(SQLWarnings.java:42)

      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:187)

      at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

      at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

      at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

      at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

      2019-07-10 14:43:55,098 INFO  [SQLWarnings] [informatica][SQLServer JDBC Driver][SQLServer]Changed language setting to us_english.

      java.sql.SQLWarning: [informatica][SQLServer JDBC Driver][SQLServer]Changed language setting to us_english.

      at com.informatica.jdbc.sqlserverbase.ddfl.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddfl.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.BaseConnection.getWarnings(Unknown Source)

      at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:907)

      at com.mchange.v2.c3p0.SQLWarnings.logAndClearWarnings(SQLWarnings.java:42)

      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:187)

      at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

      at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

      at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

      at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

      2019-07-10 14:43:55,114 ERROR [DQAConnectionDAOImpl] Updating audit tables had a problem

      java.sql.SQLSyntaxErrorException: [informatica][SQLServer JDBC Driver][SQLServer]Column names in each table must be unique. Column name 'CHANGED' in table 'IDD_AUDIT_DETAILS' is specified more than once.

      at com.informatica.jdbc.sqlserverbase.ddcw.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcw.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.v(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.dda4.m(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.e(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.x(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.t(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.execute(Unknown Source)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at com.informatica.dqa.services.connectionmgmt.impl.dao.ManageAuditTrailDAOImpl.runSQL(ManageAuditTrailDAOImpl.java:150)

      at com.informatica.dqa.services.connectionmgmt.impl.dao.ManageAuditTrailDAOImpl.updateAuditTablesConnectionAndSchema(ManageAuditTrailDAOImpl.java:334)

      at com.informatica.dqa.services.connectionmgmt.impl.dao.ManageAuditTrailDAOImpl.updateAuditTables(ManageAuditTrailDAOImpl.java:358)

      at com.informatica.dqa.services.connectionmgmt.impl.dao.DQAConnectionDAOImpl.getRecordConnectionDetails(DQAConnectionDAOImpl.java:136)

      at com.informatica.tools.web.datadirector.TaskDataServlet.getColumns(TaskDataServlet.java:1003)

      at com.informatica.tools.web.datadirector.TaskDataServlet.doPost(TaskDataServlet.java:180)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyServlet.service(HttpServiceRuntimeImpl.java:1221)

      at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:50)

      at com.informatica.tools.web.analyst.csp.SetResponseHeaderFilter.doFilter(SetResponseHeaderFilter.java:55)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.response.SetResponseHeaderFilter.doFilterInternal(SetResponseHeaderFilter.java:29)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.compression.CompressionFilter.doFilter(CompressionFilter.java:174)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:173)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.context.SetContextFilter.doFilterInternal(SetContextFilter.java:24)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:70)

      at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:132)

      at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.service(ProxyServlet.java:100)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1139)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Thread.java:748)

      2019-07-10 14:43:55,255 ERROR [LogFileDelegator] [informatica][SQLServer JDBC Driver][SQLServer]Invalid column name 'WORKFLOW_ID'.

      java.sql.SQLSyntaxErrorException: [informatica][SQLServer JDBC Driver][SQLServer]Invalid column name 'WORKFLOW_ID'.

      at com.informatica.jdbc.sqlserverbase.ddcw.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcw.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.v(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddq.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.x(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddn.f(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddn.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.dda4.h(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.x(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.w(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddd2.executeQuery(Unknown Source)

      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

      at com.informatica.dqa.services.badrecordmgmt.impl.dao.DQABadRecordsDAOImpl.getBadRecordsCount(DQABadRecordsDAOImpl.java:151)

      at com.informatica.tools.web.datadirector.TaskDataServlet.getProgress(TaskDataServlet.java:338)

      at com.informatica.tools.web.datadirector.TaskDataServlet.doPost(TaskDataServlet.java:217)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyServlet.service(HttpServiceRuntimeImpl.java:1221)

      at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:50)

      at com.informatica.tools.web.analyst.csp.SetResponseHeaderFilter.doFilter(SetResponseHeaderFilter.java:55)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.response.SetResponseHeaderFilter.doFilterInternal(SetResponseHeaderFilter.java:29)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.compression.CompressionFilter.doFilter(CompressionFilter.java:174)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:173)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.context.SetContextFilter.doFilterInternal(SetContextFilter.java:24)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:70)

      at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:132)

      at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.service(ProxyServlet.java:100)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1139)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Thread.java:748)

      2019-07-10 14:43:55,895 ERROR [LogFileDelegator] [informatica][SQLServer JDBC Driver][SQLServer]Invalid column name 'WORKFLOW_ID'.

      java.sql.SQLSyntaxErrorException: [informatica][SQLServer JDBC Driver][SQLServer]Invalid column name 'WORKFLOW_ID'.

      at com.informatica.jdbc.sqlserverbase.ddcw.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcw.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.v(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddq.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.x(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddn.f(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddn.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.dda4.h(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.x(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.w(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddd2.executeQuery(Unknown Source)

      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

      at com.informatica.dqa.services.badrecordmgmt.impl.dao.DQABadRecordsDAOImpl.getBadRecordsCount(DQABadRecordsDAOImpl.java:151)

      at com.informatica.tools.web.datadirector.TaskDataServlet.getCount(TaskDataServlet.java:831)

      at com.informatica.tools.web.datadirector.TaskDataServlet.doPost(TaskDataServlet.java:186)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyServlet.service(HttpServiceRuntimeImpl.java:1221)

      at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:50)

      at com.informatica.tools.web.analyst.csp.SetResponseHeaderFilter.doFilter(SetResponseHeaderFilter.java:55)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.response.SetResponseHeaderFilter.doFilterInternal(SetResponseHeaderFilter.java:29)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.compression.CompressionFilter.doFilter(CompressionFilter.java:174)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:173)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.context.SetContextFilter.doFilterInternal(SetContextFilter.java:24)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:70)

      at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:132)

      at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.service(ProxyServlet.java:100)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1139)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Thread.java:748)

      2019-07-10 14:43:55,926 ERROR [LogFileDelegator] [informatica][SQLServer JDBC Driver][SQLServer]Invalid column name 'WORKFLOW_ID'.

      java.sql.SQLSyntaxErrorException: [informatica][SQLServer JDBC Driver][SQLServer]Invalid column name 'WORKFLOW_ID'.

      at com.informatica.jdbc.sqlserverbase.ddcw.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcw.a(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.b(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddcv.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.v(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddq.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddr.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.x(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddm.c(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddn.f(Unknown Source)

      at com.informatica.jdbc.sqlserver.tds.ddn.a(Unknown Source)

      at com.informatica.jdbc.sqlserver.dda4.h(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.x(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.dde7.w(Unknown Source)

      at com.informatica.jdbc.sqlserverbase.ddd2.executeQuery(Unknown Source)

      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

      at com.informatica.dqa.services.badrecordmgmt.impl.dao.DQABadRecordsDAOImpl.getBadRecords(DQABadRecordsDAOImpl.java:321)

      at com.informatica.tools.web.datadirector.TaskDataServlet.getRows(TaskDataServlet.java:891)

      at com.informatica.tools.web.datadirector.TaskDataServlet.doPost(TaskDataServlet.java:183)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyServlet.service(HttpServiceRuntimeImpl.java:1221)

      at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:50)

      at com.informatica.tools.web.analyst.csp.SetResponseHeaderFilter.doFilter(SetResponseHeaderFilter.java:55)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.response.SetResponseHeaderFilter.doFilterInternal(SetResponseHeaderFilter.java:29)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.compression.CompressionFilter.doFilter(CompressionFilter.java:174)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:173)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at com.informatica.tools.w3.core.context.SetContextFilter.doFilterInternal(SetContextFilter.java:24)

      at com.informatica.tools.w3.core.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:62)

      at org.eclipse.equinox.http.registry.internal.FilterManager$FilterWrapper.doFilter(FilterManager.java:173)

      at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyFilterFactory$LegacyFilter.doFilter(HttpServiceRuntimeImpl.java:1180)

      at org.eclipse.equinox.http.servlet.internal.registration.FilterRegistration.doFilter(FilterRegistration.java:121)

      at org.eclipse.equinox.http.servlet.internal.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:45)

      at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:70)

      at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:132)

      at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.service(ProxyServlet.java:100)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1139)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Thread.java:748)