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 > > > > > > > > > >
