Ebase mss repository

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

Post Reply
Steve James
Ebase User
Posts: 331
Joined: Mon Mar 10, 2014 8:34 am

Ebase mss repository

#1

Postby Steve James » Fri Nov 11, 2016 11:02 am

Hi, I've got Ebase running under IIS and I've ported the repository database to MSS.

When I try to run a simple form I get an error -

Please advise.

Code: Select all

ERROR Error writing current version to database.
java.sql.DataTruncation: Data truncation
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:382)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:504)
	at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
	at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:403)
	at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:128)
	at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:285)
	at com.sun.proxy.$Proxy5.executeUpdate(Unknown Source)
	at com.ebasetech.ufs.kernel.workspace.CurrentVersionPersist.insertCurrentVersion(CurrentVersionPersist.java:149)
	at com.ebasetech.ufs.kernel.workspace.CurrentVersionPersist.setCurrentVersion(CurrentVersionPersist.java:46)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.persistCurrentVersion(ServerRuntimeLoader.java:391)
	at com.ebasetech.ufs.runtime.rtLoaders.ServerCachingRuntimeLoader.setCurrentVersion(ServerCachingRuntimeLoader.java:172)
	at com.ebasetech.ufs.runtime.rtLoaders.CachingRuntimeLoader.getRuntime(CachingRuntimeLoader.java:114)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.getRuntime(ServerRuntimeLoader.java:151)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:447)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:439)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:426)
	at com.ebasetech.ufs.runtime.HeadlessUserState.hookupRuntime(HeadlessUserState.java:512)
	at com.ebasetech.ufs.runtime.FormEngineSession.setCurrentUserState(FormEngineSession.java:114)
	at com.ebasetech.ufs.runtime.FormEngineSession.changeCurrentUserState(FormEngineSession.java:102)
	at com.ebasetech.ufs.runtime.UserState.setInFormSession(UserState.java:186)
	at com.ebasetech.ufs.runtime.UserState.setUserForm(UserState.java:145)
	at com.ebasetech.ufs.runtime.UserState.setUserForm(UserState.java:119)
	at formservlets.FormProcessingUtil.initialiseForm(FormProcessingUtil.java:406)
	at formservlets.FormProcessor.initialiseForm(FormProcessor.java:116)
	at formservlets.FormProcessor.prepareForm(FormProcessor.java:102)
	at formservlets.FormProcessor.runForm(FormProcessor.java:45)
	at formservlets.FormClient.process(FormClient.java:118)
	at formservlets.FormClient.doGet(FormClient.java:48)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at formservlets.EbaseFilter.processHtmlRequest(EbaseFilter.java:355)
	at formservlets.EbaseFilter.processRequest(EbaseFilter.java:258)
	at formservlets.EbaseFilter.performFilter(EbaseFilter.java:180)
	at formservlets.EbaseFilter.doFilter(EbaseFilter.java:100)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Fri Nov 11 10:26:51: ERROR Unexpected exception initialising form
com.ebasetech.xi.exceptions.FormRuntimeException: java.sql.DataTruncation: Data truncation
	at com.ebasetech.ufs.kernel.workspace.CurrentVersionPersist.setCurrentVersion(CurrentVersionPersist.java:59)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.persistCurrentVersion(ServerRuntimeLoader.java:391)
	at com.ebasetech.ufs.runtime.rtLoaders.ServerCachingRuntimeLoader.setCurrentVersion(ServerCachingRuntimeLoader.java:172)
	at com.ebasetech.ufs.runtime.rtLoaders.CachingRuntimeLoader.getRuntime(CachingRuntimeLoader.java:114)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.getRuntime(ServerRuntimeLoader.java:151)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:447)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:439)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:426)
	at com.ebasetech.ufs.runtime.HeadlessUserState.hookupRuntime(HeadlessUserState.java:512)
	at com.ebasetech.ufs.runtime.FormEngineSession.setCurrentUserState(FormEngineSession.java:114)
	at com.ebasetech.ufs.runtime.FormEngineSession.changeCurrentUserState(FormEngineSession.java:102)
	at com.ebasetech.ufs.runtime.UserState.setInFormSession(UserState.java:186)
	at com.ebasetech.ufs.runtime.UserState.setUserForm(UserState.java:145)
	at com.ebasetech.ufs.runtime.UserState.setUserForm(UserState.java:119)
	at formservlets.FormProcessingUtil.initialiseForm(FormProcessingUtil.java:406)
	at formservlets.FormProcessor.initialiseForm(FormProcessor.java:116)
	at formservlets.FormProcessor.prepareForm(FormProcessor.java:102)
	at formservlets.FormProcessor.runForm(FormProcessor.java:45)
	at formservlets.FormClient.process(FormClient.java:118)
	at formservlets.FormClient.doGet(FormClient.java:48)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at formservlets.EbaseFilter.processHtmlRequest(EbaseFilter.java:355)
	at formservlets.EbaseFilter.processRequest(EbaseFilter.java:258)
	at formservlets.EbaseFilter.performFilter(EbaseFilter.java:180)
	at formservlets.EbaseFilter.doFilter(EbaseFilter.java:100)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.DataTruncation: Data truncation
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:382)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:504)
	at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
	at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:403)
	at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:128)
	at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:285)
	at com.sun.proxy.$Proxy5.executeUpdate(Unknown Source)
	at com.ebasetech.ufs.kernel.workspace.CurrentVersionPersist.insertCurrentVersion(CurrentVersionPersist.java:149)
	at com.ebasetech.ufs.kernel.workspace.CurrentVersionPersist.setCurrentVersion(CurrentVersionPersist.java:46)
	... 52 more
0 x
Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#2

Postby Jon » Fri Nov 11, 2016 1:52 pm

This is a bug. Can you please check the current_versions table in the Ebase repository, if the runtime_id column is varchar(10) change it to varchar(255).

This will be fixed in the next release.
0 x
Steve James
Ebase User
Posts: 331
Joined: Mon Mar 10, 2014 8:34 am

#3

Postby Steve James » Fri Nov 11, 2016 2:40 pm

Thanks, fixed in both the repisitory and script.
0 x
Post Reply

Return to “Application Development”

Who is online

Users browsing this forum: No registered users and 27 guests