You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Stefan Badenhorst (JIRA)" <ji...@apache.org> on 2015/09/29 16:15:04 UTC
[jira] [Commented] (OFBIZ-6658) Creating a new tenant fails
[ 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)