HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

Issue with CSV Driver, Error Message "Failed to Acquire Table"	Weizhe	2016-02-23 17:41:09
Dear HXTT Support, I am encountering issue when use the sql statement to delete record from the csv file. After delete statement executed twice, the file will generate a lot line breaks. Thus we use another pack table statement to remove the line breaks. However, in this case I am encountering the error below: Failed to Acquire Table. Log trace below. Appreciate if you can provide a response and advise me what to do to avoid this error. I have done all the search online but there is not much information on this error as it's a product related error message. 2016-02-23 14:19:14,613 ERROR Workflow Event Thread 1 deloitte.midas.custom.FilePersistence:? - java.sql.SQLException: Failed to acquire table Manual_Fulfillment_Test_20150506: java.lang.InterruptedException: Timeout Interrupted Exception: beyond 1000 msecs. at com.hxtt.concurrent.ai.new(Unknown Source) at com.hxtt.concurrent.a2.if(Unknown Source) at com.hxtt.concurrent.ak.T(Unknown Source) at com.hxtt.concurrent.aa.a(Unknown Source) at com.hxtt.sql.text.l.a(Unknown Source) at com.hxtt.sql.text.a.a(Unknown Source) at com.hxtt.sql.text.f.do(Unknown Source) at com.hxtt.sql.bz.a(Unknown Source) at com.hxtt.sql.bz.a(Unknown Source) at com.hxtt.sql.bz.a(Unknown Source) at com.hxtt.sql.am.a(Unknown Source) at com.hxtt.sql.am.a(Unknown Source) at com.hxtt.sql.am.a(Unknown Source) at com.hxtt.sql.am.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:182) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at bsh.Reflect.invokeMethod(Unknown Source) at bsh.Reflect.invokeObjectMethod(Unknown Source) at bsh.Name.invokeMethod(Unknown Source) at bsh.BSHMethodInvocation.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHTryStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHWhileStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHTryStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHWhileStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHIfStatement.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.util.BeanShellBSFEngine.eval(Unknown Source) at org.apache.bsf.BSFManager$5.run(BSFManager.java:445) at java.security.AccessController.doPrivileged(Native Method) at org.apache.bsf.BSFManager.eval(BSFManager.java:442) at sailpoint.server.BSFRuleRunner.eval(BSFRuleRunner.java:206) at sailpoint.server.BSFRuleRunner.runRule(BSFRuleRunner.java:166) at sailpoint.server.InternalContext.runRule(InternalContext.java:1160) at sailpoint.server.InternalContext.runRule(InternalContext.java:1132) at sailpoint.connector.CollectorServices.runRule(CollectorServices.java:840) at sailpoint.connector.CollectorServices.runRule(CollectorServices.java:878) at sailpoint.connector.JDBCConnector.handleJDBCOperations(JDBCConnector.java:773) at sailpoint.connector.JDBCConnector.provision(JDBCConnector.java:655) at sailpoint.connector.ConnectorProxy.provision(ConnectorProxy.java:694) at sailpoint.integration.ConnectorExecutor.provision(ConnectorExecutor.java:144) at sailpoint.provisioning.PlanEvaluator.provision(PlanEvaluator.java:1136) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:678) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:599) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:498) at sailpoint.api.Provisioner.execute(Provisioner.java:1639) at sailpoint.workflow.IdentityLibrary.provisionProject(IdentityLibrary.java:3107) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at sailpoint.api.Workflower.doCall(Workflower.java:5682) at sailpoint.api.Workflower.evalSource(Workflower.java:5546) at sailpoint.api.Workflower.advanceStep(Workflower.java:4892) at sailpoint.api.Workflower.advance(Workflower.java:4325) at sailpoint.api.Workflower.advanceSubcase(Workflower.java:5131) at sailpoint.api.Workflower.advanceStep(Workflower.java:4812) at sailpoint.api.Workflower.advance(Workflower.java:4325) at sailpoint.api.Workflower.advanceSubcase(Workflower.java:5131) at sailpoint.api.Workflower.advanceStep(Workflower.java:4812) at sailpoint.api.Workflower.advance(Workflower.java:4325) at sailpoint.api.Workflower.assimilate(Workflower.java:3987) at sailpoint.api.Workflower.handleWorkItem(Workflower.java:7378) at sailpoint.api.Workflower.processEvent(Workflower.java:1755) at sailpoint.task.Housekeeper$WorkflowerThread.process(Housekeeper.java:2103) at sailpoint.task.Housekeeper$WorkflowerThread.run(Housekeeper.java:2030)
Re:Issue with CSV Driver, Error Message	HXTT Support	2016-02-24 03:29:58
> Thus we use another pack table statement to remove the line breaks. However, in this case I am encountering the error below: Failed to Acquire Table. Log trace below. Pack Table sql need table exclusive lock. Your delete statement should be closed. You can commit that pack table sql in the same connection.

Email:

webmaster@hxtt.com