Thanks Pranay,
The problem was importEmaisFromSite,was included the data in database. But now i receive the error: 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ RequestHandler.java:239:INFO ] [Processing Request]: checkLogin sessionId=A5AF1733DDB81E13D944C81150FC0EB6.jvm1 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ LoginWorker.java:265:INFO ] reqParams Map: [] 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ LoginWorker.java:266:INFO ] queryString: 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ LoginWorker.java:276:INFO ] checkLogin: queryString= 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ LoginWorker.java:277:INFO ] checkLogin: PathInfo=/checkLogin 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ TestEvent.java:39 :INFO ] Test Event Ran Fine. 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ RequestHandler.java:427:INFO ] [RequestHandler.doRequest]: Response is a view. sessionId=A5AF1733DDB81E13D944C81150FC0EB6.jvm1 2008-08-02 11:09:37,266 (http-0.0.0.0-8443-Processor3) [ RequestHandler.java:580:INFO ] servletName=control, view=login sessionId=A5AF1733DDB81E13D944C81150FC0EB6.jvm1 2008-08-02 11:09:37,281 (http-0.0.0.0-8443-Processor3) [ ScreenRenderer.java:224:INFO ] Found servlet context (application) attribute that conflicts with parameter name, leaving request parameter in place for name: _REQUEST_HANDLER_ 2008-08-02 11:09:37,281 (http-0.0.0.0-8443-Processor3) [ UtilXml.java:246:DEBUG] XML Read 0.0s: file:/D:/opentaps-1.0/specialpurpose/mercadolivre/widget/MercadolivreScreens.xml 2008-08-02 11:09:37,281 (http-0.0.0.0-8443-Processor3) [ ScreenFactory.java:121:INFO ] Got 5 screens in 0.0s from: file:/D:/opentaps-1.0/specialpurpose/mercadolivre/widget/MercadolivreScreens.xml 2008-08-02 11:09:37,313 (http-0.0.0.0-8443-Processor3) [ GenericDelegator.java:591:ERROR] ---- exception report ---------------------------------------------------------- Failure in create operation for entity [Visit]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice"))). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Exception while inserting the following entity: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice"))) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice"))) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice")) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice") org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) java.sql.SQLException: Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice" com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) com.mysql.jdbc.Connection.execSQL(Connection.java:2281) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1825) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1667) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) -------------------------------------------------------------------------------- 2008-08-02 11:09:37,328 (http-0.0.0.0-8443-Processor3) [ TransactionUtil.java:258:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:257) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:239) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:594) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) -------------------------------------------------------------------------------- 2008-08-02 11:09:37,328 (http-0.0.0.0-8443-Processor3) [ TransactionUtil.java:268:INFO ] [TransactionUtil.rollback] transaction rolled back 2008-08-02 11:09:37,328 (http-0.0.0.0-8443-Processor3) [ TransactionUtil.java:192:WARN ] [TransactionUtil.commit] Not committing transaction, status is STATUS_NO_TRANSACTION 2008-08-02 11:09:37,328 (http-0.0.0.0-8443-Processor3) [ VisitHandler.java:196:ERROR] ---- exception report ---------------------------------------------------------- Could not create new visit: Exception: org.ofbiz.entity.GenericEntityException Message: Exception while inserting the following entity: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice"))) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice"))) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:Visit][createdStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][createdTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][fromDate,2008-08-02 11:06:58.446(java.sql.Timestamp)][lastUpdatedStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-02 11:09:37.297(java.sql.Timestamp)][serverHostName,juniorpc(java.lang.String)][serverIpAddress,192.168.254.103(java.lang.String)][sessionId,A5AF1733DDB81E13D944C81150FC0EB6.jvm1(java.lang.String)][visitId,10285(java.lang.String)] (SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice")) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO VISIT (VISIT_ID, VISITOR_ID, USER_LOGIN_ID, USER_CREATED, SESSION_ID, SERVER_IP_ADDRESS, SERVER_HOST_NAME, WEBAPP_NAME, INITIAL_LOCALE, INITIAL_REQUEST, INITIAL_REFERRER, INITIAL_USER_AGENT, USER_AGENT_ID, CLIENT_IP_ADDRESS, CLIENT_HOST_NAME, CLIENT_USER, COOKIE, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID, CONTACT_MECH_ID, PARTY_ID, ROLE_TYPE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice") org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) java.sql.SQLException: Syntax error or access violation message from server: "Column 'ROLE_TYPE_ID' specified twice" com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) com.mysql.jdbc.Connection.execSQL(Connection.java:2281) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1825) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1667) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546) org.ofbiz.entity.GenericValue.create(GenericValue.java:115) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:193) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:136) org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:612) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Unknown Source) --- Em sáb, 2/8/08, Pranay Pandey <[EMAIL PROTECTED]> escreveu: De: Pranay Pandey <[EMAIL PROTECTED]> Assunto: Re: add person question Para: [email protected], [EMAIL PROTECTED] Data: Sábado, 2 de Agosto de 2008, 10:23 Jose, As Scott said the createPerson service is running fine(I was also saying this only). You should check the service definition for importEmaisFromSite which is calling createPerson. -- Thanks & Regards -- Pranay Pandey Indore, India On Sat, Aug 2, 2008 at 6:37 PM, jose junior malheiros barros < [EMAIL PROTECTED]> wrote: > Thanks Pranay Pandey, > > I am trying to use the services already ready of partymgr component in > folder applications/party. The service definition is this: > > <service name="createPerson" engine="java" default-entity-name="Person" > location="org.ofbiz.party.party.PartyServices" > invoke="createPerson" auth="false"> > <description>Create a Person</description> > <auto-attributes mode="INOUT" include="pk" optional="true"/> > <auto-attributes mode="IN" include="nonpk" optional="true"/> > <attribute name="statusId" type="String" mode="IN" > optional="true"/> > <attribute name="preferredCurrencyUomId" type="String" mode="IN" > optional="true"/> > <attribute name="description" type="String" mode="IN" > optional="true"/> > <override name="firstName" optional="false"/> > <override name="lastName" optional="false"/> > </service> > > --- Em sáb, 2/8/08, Pranay Pandey <[EMAIL PROTECTED]> > escreveu: > De: Pranay Pandey <[EMAIL PROTECTED]> > Assunto: Re: add person question > Para: [email protected] > Data: Sábado, 2 de Agosto de 2008, 1:51 > > Hello Jose, > > I think you should check the service definition you have given. Because > you are returning serviceResults which is having the party Id and may be > it has not been included in your service definition. > Exception report says this only. > > -- > Thanks & Regards > > Pranay Pandey > > > > jose junior malheiros barros wrote: > > I am trying to add a person only with firsName and lastName. The code > used: > > > > GenericDelegator delegator = dctx.getDelegator(); > > GenericValue userLogin > =delegator.findByPrimaryKey("UserLogin", > > context.put("firstName", "chico"); > > context.put("lastName", "cesar"); > > context.put("userLogin", userLogin); > > Map serviceResults = dispatcher.runSync("createPerson", > context); > > return serviceResults; > > > > but receive the error Unknow parameter PartyId. > > > > > > 2008-08-01 > > 13:37:07,407 (http-0.0.0.0-8080-Processor3) [ > > RequestHandler.java:239:INFO ] [Processing Request]: > > importEmaisFromSite sessionId=824A77417DF7CE083D2E930C3055B63C.jvm1 > > 2008-08-01 > > > > 13:37:07,407 (http-0.0.0.0-8080-Processor3) [ > > Integrator.java:38 :INFO ] Running method > > Integrator.processUreadEmailsFromSite > > 2008-08-01 > > 13:37:07,422 (http-0.0.0.0-8080-Processor3) [ > > SequenceUtil.java:258:INFO ] Got bank of sequenced IDs for [Party]; > > curSeqId=10080, maxSeqId=10090, bankSize=10 > > 2008-08-01 13:37:07,438 > > (http-0.0.0.0-8080-Processor3) [ ServiceEcaRule.java:140:INFO ] > > Running Service ECA Service: ensureNaPartyRole, triggered by rule on > > Service: createPerson > > 2008-08-01 13:37:07,485 > > (http-0.0.0.0-8080-Processor3) [ UtilXml.java:246:DEBUG] XML > > Read 0.031s: > > > > file:/D:/opentaps-1.0/applications/party/script/org/ofbiz/party/party/PartySimpleMethods.xml > > 2008-08-01 13:37:07,500 (http-0.0.0.0-8080-Processor3) [ > ServiceDispatcher.java:470:DEBUG] Sync service > > [pedido/ensureNaPartyRole] finished in [62] milliseconds > > 2008-08-01 > > 13:37:07,500 (http-0.0.0.0-8080-Processor3) [ > > ServiceDispatcher.java:470:DEBUG] Sync service [pedido/createPerson] > > finished in [78] milliseconds > > 2008-08-01 13:37:07,500 > > (http-0.0.0.0-8080-Processor3) [ ModelService.java:481:ERROR] > > [ModelService.validate] : {importEmaisFromSite} : (OUT) Required test > > error: org.ofbiz.service.ServiceValidationException: Unknown parameter > > found: [importEmaisFromSite.partyId] > > 2008-08-01 13:37:07,500 (http-0.0.0.0-8080-Processor3) [ > ServiceDispatcher.java:377:ERROR] > > ---- exception report > ---------------------------------------------------------- > > Outgoing result (in runSync : importEmaisFromSite) does not match > expected > requirements > > Exception: org.ofbiz.service.ServiceValidationException > > Message: Unknown parameter found: [importEmaisFromSite.partyId] > > ---- stack trace > > --------------------------------------------------------------- > > org.ofbiz.service.ServiceValidationException: Unknown parameter found: > > [importEmaisFromSite.partyId] > > org.ofbiz.service.ModelService.validate(ModelService.java:549) > > org.ofbiz.service.ModelService.validate(ModelService.java:479) > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:375) > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) > > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152) > > > > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:310) > > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:448) > > > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:277) > > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:595) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > > org.apache.catalina.core.Applicatio > > nFilterChain.doFilter(ApplicationFilterChain.java:173) > > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > > org.apache.coyote.http11.Http11Processor.process(Http11Processo > > r.java:869) > > > > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > > > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > > > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > > > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > > java.lang.Thread.run(Unknown Source) > > > > -------------------------------------------------------------------------------- > > > > 2008-08-01 > > 13:37:07,500 (http-0.0.0.0-8080-Processor3) [ > > ServiceDispatcher.java:396:DEBUG] [[Sync service failed...- > > total:0.0,since last(Begin):0.0]] - 'pedido / importEmaisFromSite' > > 2008-08-01 13:37:07,500 (http-0.0.0.0-8080-Processor3) [ > ServiceDispatcher.java:399:ERROR] > > ---- exception report > ---------------------------------------------------------- > > Service [importEmaisFromSite] threw an unexpected > > exception/error > > Exception: org.ofbiz.service.ServiceValidationException > > Message: Unknown parameter found: [importEmaisFromSite.partyId] > > ---- stack trace > --------------------------------------------------------------- > > org.ofbiz.service.ServiceValidationException: Unknown parameter found: > > [importEmaisFromSite.partyId] > > org.ofbiz.service.ModelService.validate(ModelService.java:549) > > org.ofbiz.service.ModelService.validate(ModelService.java:479) > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:375) > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) > > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152) > > > > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:310) > > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:448) > > > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:277) > > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:595) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > > org.apache.catalina.core.Applicatio > > nFilterChain.doFilter(ApplicationFilterChain.java:173) > > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > > org.apache.coyote.http11.Http11Processor.process(Http11Processo > > r.java:869) > > > > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > > > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > > > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > > > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > > java.lang.Thread.run(Unknown Source) > > > > -------------------------------------------------------------------------------- > > > > 2008-08-01 13:37:07,516 (http-0.0.0.0-8080-Processor3) [ > TransactionUtil.java:258:ERROR] > > ---- exception report > ---------------------------------------------------------- > > [TransactionUtil.rollback] > > Exception: java.lang.Exception > > Message: Stack Trace > > ---- stack trace > --------------------------------------------------------------- > > java.lang.Exception: Stack > > Trace > > > > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:257) > > > > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:239) > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:402) > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) > > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152) > > > > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:310) > > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:448) > > > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:277) > > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:595) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > > org.apache.catalina.core. > > ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251) > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > > org.apache.coyote.http11.Http11Processor.process(Http > > 11Processor.java:869) > > > > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > > > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > > > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > > > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > > java.lang.Thread.run(Unknown Source) > > > > -------------------------------------------------------------------------------- > > > > 2008-08-01 > > 13:37:07,516 (http-0.0.0.0-8080-Processor3) [ > > TransactionUtil.java:268:INFO ] [TransactionUtil.rollback] transaction > > rolled back > > 2008-08-01 13:37:07,516 (http-0.0.0.0-8080-Processor3) > > [ TransactionUtil.java:192:WARN ] [TransactionUtil.commit] Not > > committing transaction, status is STATUS_NO_TRANSACTION > > 2008-08-01 > > 13:37:07,516 (http-0.0.0.0-8080-Processor3) [ > > RequestHandler.java:311:ERROR] Request importEmaisFromSite caused an > > error with the following message: [Unknown parameter found: > > [importEmaisFromSite.partyId]] > > 2008-08-01 13:37:07,516 (http-0.0.0.0-8080-Processor3) [ > TestEvent.java:39 :INFO ] Test Event Ran Fine. > > 2008-08-01 > > 13:37:07,516 (http-0.0.0.0-8080-Processor3) [ > > RequestHandler.java:427:INFO ] [RequestHandler.doRequest]: Response is > > a view. sessionId=824A77417DF7CE083D2E930C3055B63C.jvm1 > > 2008-08-01 > > 13:37:07,516 (http-0.0.0.0-8080-Processor3) [ > > RequestHandler.java:580:INFO ] servletName=control, view=error > > sessionId=824A77417DF7CE083D2E930C3055B63C.jvm1 > > 2008-08-01 > > 13:37:07,953 (http-0.0.0.0-8080-Processor3) [ > > ControlServlet.java:259:DEBUG] [[[importEmaisFromSite] Done rendering > > page, Servlet Finished- total:0.562,since > > last([importEmaisFromS...):0.562]] > > > > > > > > Someone have idea? > > > > > > Novos endereços, o Yahoo! que você conhece. Crie um email novo com > a sua cara @ymail.com ou @rocketmail.com. > > http://br.new.mail.yahoo.com/addresses > > > > > > > > > Novos endereços, o Yahoo! que você conhece. Crie um email novo com a > sua cara @ymail.com ou @rocketmail.com. > http://br.new.mail.yahoo.com/addresses > Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com. http://br.new.mail.yahoo.com/addresses
