Re: add person question

Sat, 02 Aug 2008 07:29:21 -0700 




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
























					Reply via email to