# Truncated String field is not showing in kibana visalisation **URL:** \ **Category:** Kibana\ **Created:** [August 19, 2017, 11:33am UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658 "2017-08-19T11:33:09Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\ **Post date:** [August 19, 2017, 11:33am UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658/1 "2017-08-19T11:33:09Z")
i trucated the string format in kibana, but the field is not showing in visualisation.. my example log file: `{"LogLevel":"ERROR","Msg":"{\"itemId\":0,\"module\":\"/curie/attendance\",\"action\":\"/getByDate/{organizationId}/{facilityId}/{date}\",\"errorMessage\":\"systems.ellora.core.exception.UnhandledRuntimeException: org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:561)\\r\\n\\tat io.dropwizard.jetty.BiDiGzipHandler.handle(BiDiGzipHandler.java:68)\\r\\n\\tat org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:56)\\r\\n\\tat org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)\\r\\n\\tat org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)\\r\\n\\tat org.eclipse.jetty.server.Server.handle(Server.java:564)\\r\\n\\tat org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)\\r\\n\\tat org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)\\r\\n\\tat org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)\\r\\n\\tat org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:110)\\r\\n\\tat org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)\\r\\n\\tat org.eclipse.jetty.util.thread.Invocable.invokePreferred(Invocable.java:122)\\r\\n\\tat org.eclipse.jetty.util.thread.strategy.ExecutingExecutionStrategy.invoke(ExecutingExecutionStrategy.java:58)\\r\\n\\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:201)\\r\\n\\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:133)\\r\\n\\tat org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:672)\\r\\n\\tat org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:590)\\r\\n\\tat java.lang.Thread.run(Thread.java:748)\\r\\nCaused by: org.apache.ibatis.exceptions.PersistenceException: \\r\\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column \\u0027e.uid\\u0027 in \\u0027field list\\u0027\\r\\n### The error may exist in AttendanceMapper.xml\\r\\n### The error may involve AttendanceMapper.selectByDate-Inline\\r\\n### The error occurred while setting parameters\\r\\n### SQL: SELECT e.employeeId, e.uid, e.photoUrl, e.name, e.designation, e.joiningDate, e.salary, e.department, ar.entryId, ar.employeeId, ar.date, ar.inTime, ar.outTime, ar.leaveCapture, ar.reason FROM employee e, attendanceEntry ar,facility f, employeeFacility ef WHERE e.employeeId \\u003d ar.employeeId AND ar.date \\u003d ? AND f.facilityId \\u003d org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)\\r\\n\\tat org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)\\r\\n\\tat org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)\\r\\n\\tat org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)\\r\\n\\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)\\r\\n\\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)\\r\\n\\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)\\r\\n\\t... 69 more\\r\\n\",\"parameter\":\"1/1/2015-05-05\"}","Time":"2017-08-18_05:24:38.678"}` i truncated the errorMessage field\_length =5 . In kibana discover its showing correctly but in visualization data is not showing... ---
**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\ **Post date:** [August 21, 2017, 6:45pm UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658/2 "2017-08-21T18:45:57Z")
Would you mind sharing some screenshots of what you're seeing in Discover and in your visualization? Thanks, CJ ---
**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\ **Post date:** [August 22, 2017, 3:58am UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658/3 "2017-08-22T03:58:36Z")
Thanks @cjcenizal ,I figured this out..In my case i used Truncate filter. to set length of my string field.. This is my filter: truncate { fields =\> "errorMessage" length\_bytes =\> 100 } Thanks, Jones Thomas ---
**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\ **Post date:** [August 22, 2017, 3:59am UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658/4 "2017-08-22T03:59:06Z")
Thanks for sharing your solution! ---
**Author:** ![Jonesthomas](https://avatars.discourse-cdn.com/v4/letter/j/f4b2a3/32.png) [@Jonesthomas](https://discuss.elastic.co/u/Jonesthomas)\ **Post date:** [August 22, 2017, 4:01am UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658/5 "2017-08-22T04:01:06Z")
Your welcome @cjcenizal.✌ ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 19, 2017, 4:01am UTC](https://discuss.elastic.co/t/truncated-string-field-is-not-showing-in-kibana-visalisation/97658/6 "2017-09-19T04:01:12Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.