=== 2012-01-12 18:57:51,236 [80-4] INFO RequestContext - URL: '/war/mproject/sc /IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; rv:6.0) Gecko/20100101 Fire fox/6.0': Moz (Gecko) with Accept-Encoding header === 2012-01-12 18:57:51,241 [80-4] DEBUG XML - Parsed XML from (in memory stream ): 2ms === 2012-01-12 18:57:51,245 [80-4] DEBUG RPCManager - Processing 1 requests. === 2012-01-12 18:57:51,253 [80-4] DEBUG RPCManager - Request #1 (DSRequest) pay load: { values:{ fieldName:"ProjectId", operator:"equals", value:"2", EmbarkDate:new Date(1326344400000), DisembarkDate:new Date(1326430800000), CabinAssignments:"Single Cabin", EmployeeId:1, VisaType:"L1/L2" }, operationConfig:{ dataSource:"Manifest", operationType:"add" }, componentId:"isc_DynamicForm_3", appID:"builtinApplication", operation:"add_manifest", oldValues:{ }, criteria:{ } } === 2012-01-12 18:57:51,267 [80-4] DEBUG AppBase - [builtinApplication.add_manif est] No userTypes defined, allowing anyone access to all operations for this app lication === 2012-01-12 18:57:51,271 [80-4] DEBUG AppBase - [builtinApplication.add_manif est] No public zero-argument method named '_add_manifest' found, performing gene ric datasource operation === 2012-01-12 18:57:51,275 [80-4] INFO SQLDataSource - [builtinApplication.add _manifest] Performing add operation with criteria: {fieldName:"ProjectId",operator:"equals",value:"2",EmbarkDate: new Date(1326344400000),DisembarkDate:new Date(1326430800000),CabinAssignments:" Single Cabin",EmployeeId:1,VisaType:"L1/L2"} values: {fieldName:"ProjectId",o perator:"equals",value:"2",EmbarkDate:new Date(1326344400000),DisembarkDate:new Date(1326430800000),CabinAssignments:"Single Cabin",EmployeeId:1,VisaType:"L1/L2 "} === 2012-01-12 18:57:51,424 [80-4] INFO SQLValuesClause - [builtinApplication.a dd_manifest] Ignored data for non-existent or included columns: [fieldName, oper ator, value] === 2012-01-12 18:57:51,427 [80-4] DEBUG SQLValuesClause - [builtinApplication.a dd_manifest] Sequences: {ManifestId=__default} === 2012-01-12 18:57:51,558 [80-4] DEBUG PoolableSQLConnectionFactory - [builtin Application.add_manifest] DriverManager fetching connection for manifest via jdb c url jdbc:mysql://localhost:3306/manifest === 2012-01-12 18:57:51,560 [80-4] DEBUG PoolableSQLConnectionFactory - [builtin Application.add_manifest] Passing credentials getConnection separately from JDBC URL === 2012-01-12 18:57:51,571 [80-4] DEBUG PoolableSQLConnectionFactory - [builtin Application.add_manifest] Returning pooled Connection === 2012-01-12 18:57:51,575 [80-4] DEBUG SQLTransaction - [builtinApplication.ad d_manifest] Started new manifest transaction "25068540" === 2012-01-12 18:57:51,576 [80-4] INFO SQLDriver - [builtinApplication.add_man ifest] Executing SQL update on 'manifest': INSERT INTO manifest (EmployeeId, Pro jectId, EmployeeName, Position, DateOfBirth, VisaType, EmbarkDate, DisembarkDate , CompanyId, CabinAssignments) SELECT A1.EmployeeId as Employee Id, $advancedCriteria.ProjectId as ProjectId, CONCAT(A1.FirstName, ' ', A1.LastN ame) as EmployeeName, A1.Position as Position, A1.DateOfBirth as DateOfBirth, ' L1/L2' as VisaType, '2012-01-12 00:00:00' as EmbarkDate, '2012-01-13 00:00:00' a s DisembarkDate, A1.CompanyId as CompanyId, 'Sing le Cabin' as CabinAssignments from employees as A1 WHERE A1.EmployeeId=1 === 2012-01-12 18:57:51,666 [80-4] WARN RequestContext - dsRequest.execute() fa iled: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '$adva ncedCriteria.ProjectId' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct orAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC onstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2119) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2415) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2333) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2318) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del egatingPreparedStatement.java:102) at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:528) at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:482) at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:602) at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.ja va:403) at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1374) at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:29 3) at com.isomorphic.sql.SQLDataSource.executeAdd(SQLDataSource.java:245) at com.isomorphic.datasource.DataSource.execute(DataSource.java:1289) at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase. java:721) at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:6 58) at com.isomorphic.application.AppBase.execute(AppBase.java:491) at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1948) at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199) at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156 ) at com.dws.managemymanifest.authentication.SecureIDACall.processRequest( SecureIDACall.java:37) at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:188) at com.dws.managemymanifest.server.authentication.GWTCacheControlFilter. doFilter(GWTCacheControlFilter.java:48) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:188) at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.j ava:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:174) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso r.java:843) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr ocess(Http11AprProtocol.java:679) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:13 03) at java.lang.Thread.run(Thread.java:722) === 2012-01-12 18:57:51,713 [80-4] DEBUG RPCManager - Content type for RPC trans action: text/plain; charset=UTF-8 === 2012-01-12 18:57:51,715 [80-4] DEBUG SQLTransaction - Rolling back manifest transaction "25068540" === 2012-01-12 18:57:51,727 [80-4] DEBUG RPCManager - non-DMI response, dropExtr aFields: false === 2012-01-12 18:57:51,728 [80-4] DEBUG SQLTransaction - Ending manifest transa ction "25068540"