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: dev@ofbiz.apache.org
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: dev@ofbiz.apache.org
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