[jira] [Commented] (OFBIZ-3972) user of tenant generate errors on entity Server_Hit
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15882287#comment-15882287 ] Jacques Le Roux commented on OFBIZ-3972: Agreed, just done > user of tenant generate errors on entity Server_Hit > --- > > Key: OFBIZ-3972 > URL: https://issues.apache.org/jira/browse/OFBIZ-3972 > Project: OFBiz > Issue Type: Bug > Components: framework >Affects Versions: Trunk >Reporter: Pierre Smits >Assignee: Jacques Le Roux > Fix For: Trunk > > > When a user is active in a tenant and he/she logs off, server_hits are > generated. However the persistence is rolled back. See excerpt of error.log > below. > 2010-10-01 11:34:12,169 (http-0.0.0.0-8443-5) [ > GenericDelegator.java:889:ERROR] > exception report > -- > Failure in create operation for entity [ServerHit]: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericEntityException > Message: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)) > cause > - > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:INSERT INTO > OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, > NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, > REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table >
[jira] [Commented] (OFBIZ-3972) user of tenant generate errors on entity Server_Hit
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15882044#comment-15882044 ] Deepak Dixit commented on OFBIZ-3972: - Make sense, in both case we need to run alter query in case of backward compatibility. We can start discussion on dev list regarding this. > user of tenant generate errors on entity Server_Hit > --- > > Key: OFBIZ-3972 > URL: https://issues.apache.org/jira/browse/OFBIZ-3972 > Project: OFBiz > Issue Type: Bug > Components: framework >Affects Versions: Trunk >Reporter: Pierre Smits >Assignee: Jacques Le Roux > Fix For: Trunk > > > When a user is active in a tenant and he/she logs off, server_hits are > generated. However the persistence is rolled back. See excerpt of error.log > below. > 2010-10-01 11:34:12,169 (http-0.0.0.0-8443-5) [ > GenericDelegator.java:889:ERROR] > exception report > -- > Failure in create operation for entity [ServerHit]: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericEntityException > Message: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)) > cause > - > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:INSERT INTO > OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, > NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, > REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID,
[jira] [Commented] (OFBIZ-3972) user of tenant generate errors on entity Server_Hit
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15882035#comment-15882035 ] Jacques Le Roux commented on OFBIZ-3972: HI Deepak, Why not TIMESTAMP? https://dev.mysql.com/doc/refman/5.6/en/datetime.html > user of tenant generate errors on entity Server_Hit > --- > > Key: OFBIZ-3972 > URL: https://issues.apache.org/jira/browse/OFBIZ-3972 > Project: OFBiz > Issue Type: Bug > Components: framework >Affects Versions: Trunk >Reporter: Pierre Smits >Assignee: Jacques Le Roux > Fix For: Trunk > > > When a user is active in a tenant and he/she logs off, server_hits are > generated. However the persistence is rolled back. See excerpt of error.log > below. > 2010-10-01 11:34:12,169 (http-0.0.0.0-8443-5) [ > GenericDelegator.java:889:ERROR] > exception report > -- > Failure in create operation for entity [ServerHit]: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericEntityException > Message: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)) > cause > - > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:INSERT INTO > OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, > NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, > REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?,
[jira] [Commented] (OFBIZ-3972) user of tenant generate errors on entity Server_Hit
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15882020#comment-15882020 ] Deepak Dixit commented on OFBIZ-3972: - Hi Jacques, I think we need to update fieldtypemysql.xml to honor Milliseconds. As we have only DATETIME set as sql type and this does not support Milliseconds, we need to use DATETIME(3) or DATETIME(6). > user of tenant generate errors on entity Server_Hit > --- > > Key: OFBIZ-3972 > URL: https://issues.apache.org/jira/browse/OFBIZ-3972 > Project: OFBiz > Issue Type: Bug > Components: framework >Affects Versions: Trunk >Reporter: Pierre Smits >Assignee: Jacques Le Roux > Fix For: Trunk > > > When a user is active in a tenant and he/she logs off, server_hits are > generated. However the persistence is rolled back. See excerpt of error.log > below. > 2010-10-01 11:34:12,169 (http-0.0.0.0-8443-5) [ > GenericDelegator.java:889:ERROR] > exception report > -- > Failure in create operation for entity [ServerHit]: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericEntityException > Message: Error while inserting: > [GenericEntity:ServerHit][contentId,catalog.logout(java.lang.String)][createdStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][createdTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][hitStartDateTime,2010-10-01 > 11:34:11.732(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][lastUpdatedTxStamp,2010-10-01 > 11:34:12.138(java.sql.Timestamp)][partyId,DEMO55-admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/main?externalLoginKey=EL814028348655(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/logout(java.lang.String)][runningTimeMillis,406(java.lang.Long)][serverHostName,zase(java.lang.String)][serverIpAddress,10.0.0.125(java.lang.String)][userLoginId,DEMO55-admin(java.lang.String)][visitId,10024(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT > (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, > RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, > SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, > PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > 'SERVER_HIT' caused a violation of foreign key constraint 'SERVER_HIT_USER' > for key (DEMO55-admin). The statement has been rolled back.)) > cause > - > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:INSERT INTO > OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, > NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, > REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP,
