topic Default auditing causes web script to fail in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159212#M113252 <HTML><HEAD></HEAD><BODY><STRONG>Update:</STRONG><SPAN> I'm using Alfresco 2.9B.</SPAN><BR /><BR /><SPAN>I recently enabled the default auditing capabilities in Alfresco (according to this guide: </SPAN><A href="http://wiki.alfresco.com/wiki/Audit#Configuration_Guide" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Audit#Configuration_Guide</A><SPAN>) and it is causing a simple web script I created to fail in a strange way. I've verified that disabling the auditing causes the problem to go away, so something it is doing is causing the web script to behave this way.</SPAN><BR /><BR /><SPAN>The web script was for a simple proof of concept. It takes content that was posted to it and updates a specific file in an AVM store. Here's the code for it (it isn't pretty but it's just throw away code that I was using to test some things).</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />script:<BR />{<BR />&nbsp;&nbsp;&nbsp;var content = args["content"];<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // extract avm store id and path<BR />&nbsp;&nbsp;&nbsp; var fullpath = url.extension.split("/");<BR />&nbsp;&nbsp;&nbsp; if (fullpath.length == 0)<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.code = 400;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.message = "Store id has not been provided.";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.redirect = true;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break script;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; var storeid = fullpath[0];<BR />&nbsp;&nbsp;&nbsp; var state&nbsp;&nbsp; = args["state"];<BR />&nbsp;&nbsp;&nbsp; if(state == null || state == "active")<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //storeid += "live";<BR />&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; else if(state == "wip")<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //storeid += "–" + person.properties.userName;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; else if(state == "staging")<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Do nothing<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp; var path = "/www/avm_webapps/ROOT/content.html";<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // locate avm node from path<BR />&nbsp;&nbsp;&nbsp; var store = avm.lookupStore(storeid);<BR />&nbsp;&nbsp;&nbsp; if (store == undefined)<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.code = 404;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.message = "Store " + storeid + " not found.";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.redirect = true;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break script;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;var document = avm.lookupNode(storeid + ":" + path);<BR /><BR />&nbsp;&nbsp;&nbsp;if (document != null) <BR />&nbsp;&nbsp;&nbsp;{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; document.setContent(content);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; document.save();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // setup model for response template<BR />&nbsp;&nbsp;&nbsp;&nbsp; model.result = 'success'<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.code = 200;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; else<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp; model.result = 'failure'<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.code = 400;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.message = "Error: File for update does not exist";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status.redirect = true;<BR />&nbsp;&nbsp;&nbsp; }<BR />}<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><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 /><SPAN>Pretty straight forward: it verifies that the store and document exist and if so, saves the posted content to it, returning a simple one word "success" or "failure" in the response.</SPAN><BR /><BR /><SPAN>When I enable the default auditing (specifically, this auditConfig.xml file: </SPAN><A href="https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/config/alfresco/auditConfig.xml" rel="nofollow noopener noreferrer">https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/config/alfresco/auditConfig.xml</A><SPAN>) this is the response text that is returned:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />successsuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccesssuccess&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "<A href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd" rel="nofollow noopener noreferrer">http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd</A>"&gt;<BR />&lt;html xmlns="<A href="http://www.w3.org/1999/xhtml" rel="nofollow noopener noreferrer">http://www.w3.org/1999/xhtml</A>"&gt;<BR />&nbsp; &lt;head&gt; <BR />&nbsp;&nbsp;&nbsp; &lt;title&gt;Web Script Status 500 - Internal Error&lt;/title&gt; <BR />&nbsp;&nbsp;&nbsp; &lt;link rel="stylesheet" href="/alfresco/css/main.css" TYPE="text/css"&gt;<BR />&nbsp; &lt;/head&gt;<BR />&nbsp; &lt;body&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;table&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;&lt;img src="/alfresco/images/logo/AlfrescoLogo32.png" alt="Alfresco" /&gt;&lt;/td&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;&lt;nobr&gt;&lt;span class="mainTitle"&gt;Web Script Status 500 - Internal Error&lt;/span&gt;&lt;/nobr&gt;&lt;/td&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/table&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;br&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;table&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;The Web Script &lt;a href="/alfresco/service/company/wcm/avmsave/customerlive/content.html"&gt;/alfresco/service/company/wcm/avmsave/customerlive/content.html&lt;/a&gt; has responded with a status of 500 - Internal Error.<BR />&nbsp;&nbsp;&nbsp; &lt;/table&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;br&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;table&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;b&gt;500 Description:&lt;/b&gt;&lt;td&gt; An error inside the HTTP server which prevented it from fulfilling the request.<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;b&gt;Message:&lt;/b&gt;&lt;td&gt;Could not execute JDBC batch update<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;b&gt;Exception:&lt;/b&gt;&lt;td&gt;java.sql.BatchUpdateException - ORA-01401: inserted value too large for column<BR /><BR />&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2174)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.attributes.hibernate.MapEntryDAOHibernate.get(MapEntryDAOHibernate.java:79)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.attributes.MapAttributeImpl.entrySet(MapAttributeImpl.java:152)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.service.cmr.repository.datatype.DefaultTypeConverter$23.convert(DefaultTypeConverter.java:311)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.service.cmr.repository.datatype.DefaultTypeConverter$23.convert(DefaultTypeConverter.java:308)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.service.cmr.repository.datatype.TypeConverter.convert(TypeConverter.java:120)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.domain.PropertyValue$ValueType$11.convert(PropertyValue.java:199)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.domain.PropertyValue.getValue(PropertyValue.java:836)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.AbstractNodeServiceImpl.makeSerializableValue(AbstractNodeServiceImpl.java:691)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.avm.AVMNodeService.getProperties(AVMNodeService.java:975)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;sun.reflect.GeneratedMethodAccessor324.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;$Proxy73.getProperties(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;sun.reflect.GeneratedMethodAccessor324.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:175)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:175)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:204)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:204)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;$Proxy72.getProperties(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.integrity.IncompleteNodeTagger.processNode(IncompleteNodeTagger.java:354)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.node.integrity.IncompleteNodeTagger.beforeCommit(IncompleteNodeTagger.java:343)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:638)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:620)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:592)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:821)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:637)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:624)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:307)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:420)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:250)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:166)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:286)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:230)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:227)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:130)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.web.scripts.servlet.WebScriptServlet.service(WebScriptServlet.java:108)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;com.covisint.content.alfresco.ext.security.authentication.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:110)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;java.lang.Thread.run(Thread.java:595)<BR />&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;td&gt;&nbsp;<BR />&nbsp;&nbsp; &lt;tr&gt;&lt;td&gt;&lt;b&gt;Exception:&lt;/b&gt;&lt;td&gt;org.hibernate.exception.ConstraintViolationException - <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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><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 /><SPAN>Interesting things to note: It writes "success" twenty times before giving the "ORA-01401: inserted value too large for column" error. This behavior can be seen when using the javascript debugger; it actually calls the web script over and over again. Additionally, the file is never actually updated. It's as if when it tries to do the document.save() it runs into an issue attempting to audit the change and somehow the request is reposted many times. I'm not sure what field it is unhappy about, but I suspect it's something in the AUDIT_FACT table (perhaps trying to audit the actual content of the node).</SPAN><BR /><BR /><SPAN>I'm looking to hopefully figure out what is causing this and what can be changed about either my web script or my audit configuration to prevent this issue, while still being able to audit these kinds of changes posted by web scripts.</SPAN><BR /><BR /><SPAN>Thanks in advance for any help on this interesting issue.</SPAN><BR /><BR /><SPAN>Naim</SPAN></BODY></HTML> Tue, 06 May 2008 16:26:22 GMT lnfalandino 2008-05-06T16:26:22Z Default auditing causes web script to fail https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159212#M113252 Update: I'm using Alfresco 2.9B.I recently enabled the default auditing capabilities in Alfresco (according to this guide: http://wiki.alfresco.com/wiki/Audit#Configuration_Guide) and it is causing a simple web script I created to fail in a strange way. I've verified that disabling the auditing caus Tue, 06 May 2008 16:26:22 GMT https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159212#M113252 lnfalandino 2008-05-06T16:26:22Z Re: Default auditing causes web script to fail https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159213#M113253 <HTML><HEAD></HEAD><BODY><SPAN>Oh, I just realized that I forgot to mention that I'm using version 2.9B.</SPAN></BODY></HTML> Tue, 06 May 2008 18:18:51 GMT https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159213#M113253 lnfalandino 2008-05-06T18:18:51Z Re: Default auditing causes web script to fail https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159214#M113254 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>This is a bug. It has been fixed up. The audit information is truncated if it is too large to store.</SPAN><BR /><SPAN>You are most likely to see this using oracle.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 23 Jul 2008 11:55:21 GMT https://connect.hyland.com/t5/alfresco-archive/default-auditing-causes-web-script-to-fail/m-p/159214#M113254 andy 2008-07-23T11:55:21Z