It looks like this:
<extend-entity entity-name="Visit">
<field name="contactMechId" type="id"></field>
<field name="partyId" type="id"></field>
<field name="roleTypeId" type="id"></field>
<relation type="one" fk-name="VISIT_CONT_MECH"
rel-entity-name="ContactMech">
<key-map field-name="contactMechId"/>
</relation>
<relation type="one" fk-name="VISIT_PARTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="VISIT_ROLE_TYPE"
rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="VISIT_PARTY_ROLE"
rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
</extend-entity>
has been loaded twice, you should check your entitymodel.xml files for
the duplicate. You could possibly have two copies of the party
component's entitymodel.xml lying around.
Regards
Scott
2008/8/3 jose junior malheiros barros <[EMAIL PROTECTED]>:
> Thanks Scott,
>
> 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, Scott Gray <[EMAIL PROTECTED]> escreveu:
> De: Scott Gray <[EMAIL PROTECTED]>
> Assunto: Re: add person question
> Para: [email protected], [EMAIL PROTECTED]
> Data: Sábado, 2 de Agosto de 2008, 10:13
>
> 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
