topic Error while creating file null.lobs.db [90062-101] in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205388#M158518 <HTML><HEAD></HEAD><BODY><SPAN>I'm trying to deploy my workflow in Tomcat using H2 in-mem DB and getting the error below:</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR />DEV 10:27:45.258 [localhost-startStop-1] INFO&nbsp; o.a.e.i.bpmn.deployer.BpmnDeployer - Processing resource com/my/diagram/MyLeaveProcess.bpmn<BR />DEV 10:27:49.554 [localhost-startStop-1] ERROR o.a.e.i.interceptor.CommandContext - Error while closing command context<BR />org.apache.ibatis.exceptions.PersistenceException: <BR />### Error updating database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Error while creating file null.lobs.db [90062-101]<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ResourceEntity.insertResource-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_)&nbsp;&nbsp;&nbsp;&nbsp; values (?, 1, ?, ?, ?, ?)<BR />### Cause: org.h2.jdbc.JdbcSQLException: Error while creating file null.lobs.db [90062-101]<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.1.1.jar:3.1.1]<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Same workflow working fine if I use the UnitTest.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN><BR /></BODY></HTML> Sat, 18 Apr 2015 09:35:49 GMT jss 2015-04-18T09:35:49Z Error while creating file null.lobs.db [90062-101] https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205388#M158518 I'm trying to deploy my workflow in Tomcat using H2 in-mem DB and getting the error below<IMG id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EV 10:27:45.258 [localhost-startStop-1] INFO&nbsp; o.a.e.i.bpmn.deployer.BpmnDeployer - Processing resource com/my/diagram/MyLeaveProcess.bpmnDEV 10:27:49.554 [localhost-startStop-1] ERROR o.a.e.i.interceptor.Comma Sat, 18 Apr 2015 09:35:49 GMT https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205388#M158518 jss 2015-04-18T09:35:49Z Re: Error while creating file null.lobs.db [90062-101] https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205389#M158519 <HTML><HEAD></HEAD><BODY><SPAN>Seems to be H2 specific issue</SPAN><BR /><A href="http://www.h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90062" rel="nofollow noopener noreferrer">http://www.h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90062</A><BR /><BR /><SPAN>"Error while creating file", are you sure you are running H2 in memory? Your URL should look something like</SPAN><BR /><SPAN>jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000</SPAN><BR /></BODY></HTML> Sat, 18 Apr 2015 23:55:25 GMT https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205389#M158519 balsarori 2015-04-18T23:55:25Z Re: Error while creating file null.lobs.db [90062-101] https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205390#M158520 <HTML><HEAD></HEAD><BODY><SPAN>Bassam, Yes I am using H2 in memory mode only and I have double checked my configuration.</SPAN><BR /><SPAN>By the way I'm using version: 5.12.</SPAN></BODY></HTML> Sun, 19 Apr 2015 21:31:40 GMT https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205390#M158520 jss 2015-04-19T21:31:40Z Re: Error while creating file null.lobs.db [90062-101] https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205391#M158521 <HTML><HEAD></HEAD><BODY><A href="http://stackoverflow.com/questions/29715777/error-while-creating-file-null-lobs-db-90062-101" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/29715777/error-while-creating-file-null-lobs-db-90062-101</A></BODY></HTML> Mon, 20 Apr 2015 20:25:18 GMT https://connect.hyland.com/t5/alfresco-archive/error-while-creating-file-null-lobs-db-90062-101/m-p/205391#M158521 jss 2015-04-20T20:25:18Z