Re: [jira] [Assigned] (OFBIZ-4936) Installation error occur about JobSandbox

Thu, 14 Jun 2012 07:04:26 -0700

if you load seed data only and not security than these background jobs fail.... 
A work around is to load the security files too.

We need to amend these background jobs to use the 'system' userlogin.
Not only this accounting background job but can also remember there is an other job having the same problem...did not yet have to time to get to this... 

let me see what we can do...

Regards, Hans

On 06/14/2012 04:47 PM, Jacopo Cappellato (JIRA) wrote:

      [ 
https://issues.apache.org/jira/browse/OFBIZ-4936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacopo Cappellato reassigned OFBIZ-4936:
----------------------------------------

     Assignee: Hans Bakker

Hans, I think this is related to the recent refactoring ("security" reader), 
could you please have a look and fix it?
If you are not available, just reassign to me and I will try to have a look and 
fix the code.


Installation error occur about JobSandbox
-----------------------------------------

                 Key: OFBIZ-4936
                 URL: https://issues.apache.org/jira/browse/OFBIZ-4936
             Project: OFBiz
          Issue Type: Bug
          Components: ALL COMPONENTS
    Affects Versions: SVN trunk
         Environment: Mac OS X Lion 1.7.4
Oracle Java SDK 1.7
Apache OFBiz trunk  Rev: 1350081
            Reporter: Thanakrit Wongyued
            Assignee: Hans Bakker
         Attachments: Terminal Saved Output.log


Hi,
My name is Thanakrit from Thailand. I try to install ofbiz from trunk and then 
error occured reading data from file below :
trunk/applications/accounting/data/AccountingScheduledServiceData.xml
trunk/framework/service/data/ScheduledServices.xml
and more...
      [java] 2012-06-14 14:23:26,771 (main) [    EntitySaxReader.java:220:INFO 
] Beginning import from URL: 
file:/Users/Thanakrit/Projects/srk/trunk/framework/service/data/ScheduledServices.xml
      [java] 2012-06-14 14:23:26,771 (main) [    EntitySaxReader.java:270:INFO 
] Transaction Timeout set to 2 hours (7200 seconds)
      [java] 2012-06-14 14:23:26,870 (main) [   
GenericDelegator.java:891:ERROR] Failure in create operation for entity 
[JobSandbox]: org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:JobSandbox][createdStamp,2012-06-14 
14:23:26.829(java.sql.Timestamp)][createdTxStamp,2012-06-14 
14:23:26.771(java.sql.Timestamp)][jobId,PURGE_OLD_JOBS(java.lang.String)][jobName,Purge
 Old Jobs(java.lang.String)][lastUpdatedStamp,2012-06-14 
14:23:26.829(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-14 
14:23:26.771(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,purgeOldJobs(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
 (SQL Exception while executing the following:INSERT INTO OFBIZ.JOB_SANDBOX 
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, 
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, 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, LAST_UPDATED_STAMP, 
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 
'JOB_SANDBOX' caused a violation of foreign key constraint 'JOB_SNDBX_USRLGN' 
for key (system).  The statement has been rolled back.)). Rolling back 
transaction.
      [java] 2012-06-14 14:23:26,871 (main) [    TransactionUtil.java:379:WARN ]
      [java] ---- exception report 
----------------------------------------------------------
      [java] [TransactionUtil.setRollbackOnly] Calling transaction 
setRollbackOnly; this stack trace shows where this is happening:
      [java] Exception: java.lang.Exception
      [java] Message: Failure in create operation for entity [JobSandbox]: 
org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:JobSandbox][createdStamp,2012-06-14 
14:23:26.829(java.sql.Timestamp)][createdTxStamp,2012-06-14 
14:23:26.771(java.sql.Timestamp)][jobId,PURGE_OLD_JOBS(java.lang.String)][jobName,Purge
 Old Jobs(java.lang.String)][lastUpdatedStamp,2012-06-14 
14:23:26.829(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-14 
14:23:26.771(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,purgeOldJobs(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
 (SQL Exception while executing the following:INSERT INTO OFBIZ.JOB_SANDBOX 
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, 
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, 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, LAST_UPDATED_STAMP, 
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 
'JOB_SANDBOX' caused a violation of foreign key constraint 'JOB_SNDBX_USRLGN' 
for key (system).  The statement has been rolled back.)). Rolling back 
transaction.
      [java] ---- stack trace 
---------------------------------------------------------------

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to