[
https://issues.apache.org/jira/browse/OFBIZ-6658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14935223#comment-14935223
]
Jacques Le Roux edited comment on OFBIZ-6658 at 9/29/15 3:49 PM:
-----------------------------------------------------------------
Log entries that seem to be pointing to the cause:
{code}
2015-09-29 13:47:04,567 |OFBiz-config-3 |DatabaseUtil
|I| Created 2 foreign keys for entity [TemporalExpressionAssoc]
2015-09-29 13:47:04,567 |OFBiz-config-3 |DatabaseUtil
|E| Error adding foreign key: ModelEntity was null for related entity name
Tenant
2015-09-29 13:47:04,567 |OFBiz-config-3 |DatabaseUtil
|I| Created 1 foreign keys for entity [TermType]
2015-09-29 13:47:16,145 |main |EntitySaxReader
|I| Beginning import from URL:
file:/D:/apache-ofbi/framework/entityext/data/EntityScheduledServices.xml
2015-09-29 13:47:16,145 |main |EntitySaxReader
|I| Transaction Timeout set to 2 hours (7200 seconds)
2015-09-29 13:47:16,161 |main |GenericDelegator
|E| Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)).
Rolling back transaction.
2015-09-29 13:47:16,161 |main |TransactionUtil
|W| [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
java.lang.Exception: Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)).
Rolling back transaction.
at
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:378)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:319)
[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:882)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1382)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:483)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:238)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:235)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:353)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:379) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:135) [ofbiz.jar:?]
2015-09-29 13:47:16,161 |main |GenericDelegator
|E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))
(Error while inserting: [GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))).
Rolling back transaction.
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))
(Error while inserting: [GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1382)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:483)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:238)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:235)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:353)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:379) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:135) [ofbiz.jar:?]
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:189)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:859)
~[ofbiz-entity-test.jar:?]
... 11 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:INSERT INTO public.JOB_SANDBOX (JOB_ID, JOB_NAME,
RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME,
LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME,
CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table
"job_sandbox" violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:184)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:859)
~[ofbiz-entity-test.jar:?]
... 11 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table
"job_sandbox" violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
~[commons-dbcp-1.4.jar:1.4]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:184)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:859)
~[ofbiz-entity-test.jar:?]
... 11 more
2015-09-29 13:47:16,161 |main |TransactionUtil
|I| [TransactionUtil.setRollbackOnly] transaction rollback only not set,
rollback only is already set.
{code}
was (Author: maudrid):
Log entries that seem to be pointing to the cause:
2015-09-29 13:47:04,567 |OFBiz-config-3 |DatabaseUtil
|I| Created 2 foreign keys for entity [TemporalExpressionAssoc]
2015-09-29 13:47:04,567 |OFBiz-config-3 |DatabaseUtil
|E| Error adding foreign key: ModelEntity was null for related entity name
Tenant
2015-09-29 13:47:04,567 |OFBiz-config-3 |DatabaseUtil
|I| Created 1 foreign keys for entity [TermType]
2015-09-29 13:47:16,145 |main |EntitySaxReader
|I| Beginning import from URL:
file:/D:/apache-ofbi/framework/entityext/data/EntityScheduledServices.xml
2015-09-29 13:47:16,145 |main |EntitySaxReader
|I| Transaction Timeout set to 2 hours (7200 seconds)
2015-09-29 13:47:16,161 |main |GenericDelegator
|E| Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)).
Rolling back transaction.
2015-09-29 13:47:16,161 |main |TransactionUtil
|W| [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
java.lang.Exception: Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)).
Rolling back transaction.
at
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:378)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:319)
[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:882)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1382)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:483)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:238)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:235)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:353)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:379) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:135) [ofbiz.jar:?]
2015-09-29 13:47:16,161 |main |GenericDelegator
|E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))
(Error while inserting: [GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))).
Rolling back transaction.
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))
(Error while inserting: [GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1382)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:483)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:238)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:235)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:353)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:379) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:135) [ofbiz.jar:?]
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][createdTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][jobId,8200(java.lang.String)][jobName,Clear
EntitySyncRemove Info(java.lang.String)][lastUpdatedStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][lastUpdatedTxStamp,2015-09-29
13:47:16.145(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,cleanSyncRemoveInfo(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT,
AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "job_sandbox"
violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".))
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:189)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:859)
~[ofbiz-entity-test.jar:?]
... 11 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:INSERT INTO public.JOB_SANDBOX (JOB_ID, JOB_NAME,
RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME,
LOADER_NAME, MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME,
CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table
"job_sandbox" violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".)
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:184)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:859)
~[ofbiz-entity-test.jar:?]
... 11 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table
"job_sandbox" violates foreign key constraint "job_sndbx_usrlgn"
Detail: Key (run_as_user)=(system) is not present in table "user_login".
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
~[postgresql-9.4-1200.jdbc4.jar:9.4]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
~[commons-dbcp-1.4.jar:1.4]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:184)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:859)
~[ofbiz-entity-test.jar:?]
... 11 more
2015-09-29 13:47:16,161 |main |TransactionUtil
|I| [TransactionUtil.setRollbackOnly] transaction rollback only not set,
rollback only is already set.
> Creating a new tenant fails
> ---------------------------
>
> Key: OFBIZ-6658
> URL: https://issues.apache.org/jira/browse/OFBIZ-6658
> Project: OFBiz
> Issue Type: Bug
> Components: ALL APPLICATIONS
> Affects Versions: 13.07.02
> Environment: Windows
> Reporter: Stefan Badenhorst
> Attachments: log files.7z
>
>
> When setting up an additional tenant. I'm having trouble logging in as the
> administrator.
> I have downloaded OfBiz 13.07.02 and changed the configuration to connect to
> Postgres 9.4. Now I have it working with the demo data loaded. I want to add
> a new tenant with no demo data loaded. I heave read many articles and tried
> the suggestions, the furthest I have gotten is to run this at the command
> line: ant create-tenant At first I got errors using this and I realized
> that it could not create the databases that I was specifying. I manually
> created the databases with my chosen tenant id '10001'. So now I have 2
> additional databases ofbiz_10001 and ofbizolap_10001. At the point where it
> asks me what data to install I have tried both 'Seed' and 'seed-initial'. I
> must confess that I'm not sure what this means. I ran the create-tenant
> again and this time it created 833 tables in the main database and 6 tables
> in the olap database. At the end it tells me the following: [echo] Delegator
> = default#10001 [echo] Tenant admin = '10001-admin' [echo] Password for
> tenant admin is 'ofbiz' must change on first login I have also update the
> global config to show the tenant input on the login screen. When I try to
> login with the above user, it tells me that the user does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
