I think it works now. When I used the schema file from the $WEBAPP/etc directory it gave me an error. But when I tried loading the schema.sql from the $WORKLOAD/bin, it worked.
--- On Sat, 11/14/09, Harold Lim <[email protected]> wrote: > From: Harold Lim <[email protected]> > Subject: Re: Problem loading data using ./dbloader > To: [email protected] > Date: Saturday, November 14, 2009, 2:15 PM > Hi Kim, > > I rebuilt the OlioDriver and deployed it to Faban and > recreated bpwebapp and reloaded the new schema.sql but I'm > still getting the same error: > > Any idea how to fix this? > > ./dbloader.sh xxxx 50 > > > Nov 14, 2009 2:09:17 PM > org.apache.olio.workload.loader.LoadController main > INFO: Done clearing database tables. > Nov 14, 2009 2:09:22 PM > org.apache.olio.workload.loader.framework.ThreadConnection > processBatch > WARNING: org.apache.olio.workload.loader.SocialEvent: Retry > loading. > java.sql.BatchUpdateException: Field 'SOCIALEVENTID' > doesn't have a default value > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007) > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443) > at > org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235) > at > org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180) > at > org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276) > > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at > java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > Nov 14, 2009 2:09:22 PM > org.apache.olio.workload.loader.framework.ThreadConnection > processBatch > WARNING: org.apache.olio.workload.loader.SocialEvent: > Failed to update. > java.sql.BatchUpdateException: Field 'SOCIALEVENTID' > doesn't have a default value > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007) > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443) > at > org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235) > at > org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180) > at > org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276) > > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at > java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > Error count exceeded threshold of 50! Exiting. > Nov 14, 2009 2:09:22 PM > org.apache.olio.workload.loader.framework.ThreadConnection > processBatch > WARNING: org.apache.olio.workload.loader.Tag: Retry > loading. > java.sql.BatchUpdateException: Field 'SOCIALEVENTTAGID' > doesn't have a default value > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007) > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443) > at > org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235) > at > org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180) > at > org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276) > > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at > java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > Nov 14, 2009 2:09:22 PM > org.apache.olio.workload.loader.framework.ThreadConnection > processBatch > WARNING: org.apache.olio.workload.loader.Tag: Failed to > update. > java.sql.BatchUpdateException: Field 'SOCIALEVENTTAGID' > doesn't have a default value > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007) > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443) > at > org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235) > at > org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180) > at > org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276) > > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at > java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > Error count exceeded threshold of 50! Exiting. > ERROR: Database loader exited with code 2. > > --- On Thu, 11/12/09, Kim LiChong <[email protected]> > wrote: > > > From: Kim LiChong <[email protected]> > > Subject: Re: Problem loading data using ./dbloader > > To: [email protected] > > Date: Thursday, November 12, 2009, 1:27 AM > > Hi Harold, > > > > Can you refresh your workspace? There has been some > > changes to the > > schema. You will have to drop and recreate your > > database with the new > > schema, and then rerun dbloader. > > > > I just tried this on my updated workspace (I had to > drop > > and recreate as > > well since I was using an older schema) and it went > > through. > > > > kim > > $ ./dbloader.sh localhost 25 > > Nov 11, 2009 10:18:29 PM > > org.apache.olio.workload.loader.LoadController main > > INFO: Done clearing database tables. > > Nov 11, 2009 10:18:33 PM > > org.apache.olio.workload.loader.LoadController main > > INFO: Done data creation. > > Nov 11, 2009 10:19:53 PM > > org.apache.olio.workload.loader.LoadController main > > INFO: Done data loading. > > Nov 11, 2009 10:19:53 PM > > org.apache.olio.workload.loader.LoadController main > > INFO: Done post-load. > > Database Load Successful > > > > > Hi All, > > > > > > > > > When I try to run dbloader, I'm getting the > following > > error: > > > java.sql.BatchUpdateException: Field 'ADDRESSID' > > doesn't have a default value > > > at > > > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007) > > > at > > > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443) > > > at > > > org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235) > > > at > > > org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180) > > > at > > > org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276) > > > at > > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > > > at > > > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > > > at > > > java.util.concurrent.FutureTask.run(FutureTask.java:138) > > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > > > at > > java.lang.Thread.run(Thread.java:619) > > > > > > > > > Any idea how to fix this problem? > > > > > > Thanks, > > > Harold > > > > > > > > > > > > > > > > > > > >
