Discussion:
stagingcopy fails with a NullPointerException on table attrvalue
(too old to reply)
j***@sbcglobal.net
2007-01-09 21:46:46 UTC
Permalink
We are trying to copy our production data over to our staging server (initial load) and everything works great until we finish copying the attribute table. I'm assuming that the next table to process is the attrvalue and it's blowing up since it's fairly large (approximately 150k rows), although not as large as I've seen at other engagements.

I've upped the log file size (logprimary 100 and logfilsiz 2000), and increased the memory (256 min 1024 max), but it still seems to fail.

The error we get is this:

Exception in thread "main" java.lang.NullPointerException
at com.ibm.commerce.staging.Copy.getRecordInfo(Copy.java:505)
at com.ibm.commerce.staging.Copy.runBatch(Copy.java(Compiled Code))
at com.ibm.commerce.staging.Copy.copyOneTable(Copy.java(Compiled Code))
at com.ibm.commerce.staging.MerchantCopy.copyMerchantTables(MerchantCopy.java:766)
at com.ibm.commerce.staging.StagingCopy.stageCopy(StagingCopy.java:1349)
at com.ibm.commerce.staging.StagingCopy.main(StagingCopy.java:668)

Has anyone seen this or know what could be going wrong?
j***@sbcglobal.net
2007-01-09 22:08:56 UTC
Permalink
Well, turns out it was a database log issue. I kept upping hte logprimary and logfilsiz and it eventually went away.
Loading...