ConcourseSuite Support

Support
Corporate
PUBLIC PROFILE

Back to topics

Discuss Lead Management

Leeds Import Error

You need to be logged in to post messages

This question is unanswered

Leeds Import Error

4/14/2008 4:10 PM EDT (edited)

After importing 100 leeds into 5.0.5 I received this error when going to leeds overview. The import worked properly, [leed review was approved], I can see the data when I go to leeds, import, [specified import name], view results. Any ideas on how i can fix this?

The actual error is:

java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.close(Unknown Source)
at org.aspcfs.modules.contacts.base.ContactList.buildShortList(Unknown Source)
at org.aspcfs.modules.contacts.actions.Sales.executeCommandDashboard(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.lang.NullPointerException
at org.apache.derby.impl.services.locks.ConcurrentLockSet.unlock(Unknown Source)
at org.apache.derby.impl.services.locks.LockSpace.unlockGroup(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.unlockGroup(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.unlockGroup(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking2.unlockContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseContainerHandle.close(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.close(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericController.close(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.closeScan(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.close(Unknown Source)
at org.apache.derby.impl.store.access.BackingStoreHashTableFromScan.close(Unknown Source)
at org.apache.derby.impl.sql.execute.HashScanResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.AnyResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.NoPutResultSetImpl.close(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.finishAndRTS(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.finish(Unknown Source)
... 23 more

1. 4/15/2008 8:42 AM EDT

Well, it seems that after a restart the problem is solved. Leeds, overview is showing the data fine now... strange.

Blair Sherwood wrote:
After importing 100 leeds into 5.0.5 I received this error when going to leeds overview. The import worked properly, [leed review was approved], I can see the data when I go to leeds, import, [specified import name], view results. Any ideas on how i can fix this?

The actual error is:

java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.close(Unknown Source)
at org.aspcfs.modules.contacts.base.ContactList.buildShortList(Unknown Source)
at org.aspcfs.modules.contacts.actions.Sales.executeCommandDashboard(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.lang.NullPointerException
at org.apache.derby.impl.services.locks.ConcurrentLockSet.unlock(Unknown Source)
at org.apache.derby.impl.services.locks.LockSpace.unlockGroup(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.unlockGroup(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.unlockGroup(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking2.unlockContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseContainerHandle.close(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.close(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericController.close(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.closeScan(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.close(Unknown Source)
at org.apache.derby.impl.store.access.BackingStoreHashTableFromScan.close(Unknown Source)
at org.apache.derby.impl.sql.execute.HashScanResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.AnyResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.NoPutResultSetImpl.close(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.close(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.finishAndRTS(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.finish(Unknown Source)
... 23 more


1 result found