Sumit, The database is already installed. I have that install again?
--- Em sáb, 2/8/08, Sumit Pandit <[EMAIL PROTECTED]> escreveu: De: Sumit Pandit <[EMAIL PROTECTED]> Assunto: Re: add person question Para: [email protected] Data: Sábado, 2 de Agosto de 2008, 11:28 >> Jose, Did you drop the database. If yes please run ant clean-all first then ant run-install. Most of the time i got this error when i drop my database and directly run ant run-install. -- Thanks and Regards Sumit Pandit. HotWaxMedia, Inc http://www.hotwaxmedia.com On Aug 2, 2008, at 7:49 PM, jose junior malheiros barros wrote: > Thanks Sumit, > > > > 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, Sumit Pandit <[EMAIL PROTECTED]> > escreveu: > De: Sumit Pandit <[EMAIL PROTECTED]> > Assunto: Re: add person question > Para: [email protected] > Cc: [EMAIL PROTECTED] > Data: Sábado, 2 de Agosto de 2008, 10:25 > > Hello Jose, > > Here as i understand form your error message is that : > Your createPerson service returns the error that the input parameters > contains the invalid content : partyId, right ? > > So if you are calling service createPerson then it returns the > partyId. It does not needed partyId as input parameter (It generate > the partyId and return it). > If you already have partyId then call updatePerson service. This will > update your existing record. > > If you want more help let me know if you have partyId ? > > Let me know if you want more informations. > > > -- > Thanks and Regards > Sumit Pandit. > HotWaxMedia, Inc > http://www.hotwaxmedia.com > > On Aug 2, 2008, at 6:43 PM, Scott Gray wrote: > >> Jose, >> >> The createPerson service is running fine: >> 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 >> >> It appears the service that called createPerson (importEmaisFromSite) >> is returning an invalid parameter "partyId": >> 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] >> >> Regards >> Scott >> >> 2008/8/3 jose junior malheiros barros <[EMAIL PROTECTED]>: >>> Thanks BJ Freeman, >>> >>> I am trying to use the services 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, BJ Freeman <[EMAIL PROTECTED]> escreveu: >>> De: BJ Freeman <[EMAIL PROTECTED]> >>> Assunto: Re: add person question >>> Para: [email protected] >>> Data: Sábado, 2 de Agosto de 2008, 2:13 >>> >>> if you look further down is says >>> Message: Unknown parameter found: [importEmaisFromSite.partyId] >>>>> >>> I don't think we have that in the svn >>> >>> Pranay Pandey sent the following on 8/1/2008 9:51 PM: >>>> 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. >>>> >>> >>> >>> >>> >>> 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
