[ https://issues.apache.org/jira/browse/OFBIZ-6658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14935223#comment-14935223 ]
Stefan Badenhorst commented on OFBIZ-6658: ------------------------------------------ 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)