Topic
3 replies Latest Post - ‏2013-03-29T13:00:14Z by SystemAdmin
OlgaLind
OlgaLind
34 Posts
ACCEPTED ANSWER

Pinned topic Are there any limitations on features number?

‏2013-02-04T11:30:18Z |
Hi,

I'm experiencing a certaing issue when trying to add features to annotations. The ICA studio permits me to add about 18 features of String type, and then gives the error message:

Caused by: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '<?xml version="1.0" encoding="UTF-8"?><root><alltypes><type &' to length 4096.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

Does somebody know a possible workaround to this issue? I need at least 30 features to be added to the annotations. Thank you.
Updated on 2013-03-29T13:00:14Z at 2013-03-29T13:00:14Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    197 Posts
    ACCEPTED ANSWER

    Re: Are there any limitations on features number?

    ‏2013-02-05T15:11:17Z  in response to OlgaLind
    First question I would ask you is: "What will you do with 30 features?" Is there any other way to do this in a simpler and cleaner way?
    I think there is a restriction of the size of the the derby databases columns etc.., this is probably why you are getting the error.
    • OlgaLind
      OlgaLind
      34 Posts
      ACCEPTED ANSWER

      Re: Are there any limitations on features number?

      ‏2013-02-06T05:53:41Z  in response to SystemAdmin
      Thanks. That's a good question, but believe me I need that much :)
      • SystemAdmin
        SystemAdmin
        197 Posts
        ACCEPTED ANSWER

        Re: Are there any limitations on features number?

        ‏2013-03-29T13:00:14Z  in response to OlgaLind
        Hi everybody,
        I am using IBM Cognos Content Analytics v 2.1 in my end of study project. ( I am new using this tool)
        And I have some problems in the exploration text application.

        In fact, my boss want to see something like this demo : http://www.youtube.com/watch?v=v8jHNkQ4fdY on the example of juice and tea type which exist in the firststep folder as xml files.

        I added the facets and the keywords but the tool is not able to do the text mining.
        It is only doing a keyword search.
        So I can't see the Time Series, Facet pairs, facets, trends ...

        Can you help me to activate the text mining ?

        Thanks for your help.