1 2 Previous Next 21 Replies Latest reply: Oct 5, 2012 8:47 AM by Denny Wong-Oracle RSS

    SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.

    964298
      Hi.

      I'm not able to generate any themes for text using Build Text Node (Data Miner). For the tokens it works properly. When I set Transform Type : Theme in Add/Edit Text Transform (Single language : English, Stoplist : Default, Theme Type : Single or Full, Tried both frequencies), and run the node, output data only contains 'SYS.DM_NESTED_NUMERICALS()'. Source column is a clob, containing raw text. After node was run in output i can see only *"No theme is generated"*. Output for tokens is o.k.. Using ctxsys.ctx_doc.themes package I was able to extract themes from the same text. Am i doing something wrong? Please advice.

      Thanks in advance.

      miro.
        • 1. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
          Denny Wong-Oracle
          Hi Miro

          The Build Text node internally uses the CTX_DOC.POLICY_THEMES to generate themes. How did you use the CTX_DOC.POLICY_THEMES? Did you use the function in the same account as in Data Miner? Can you generate themes using the demo dataset (COMMENTS in MINING_BUILD_TEXT)? Please make sure the knowledge base is installed with Oracle Text (CTX_DOC.POLICY_THEMES requires an installed knowledge base).

          Thanks,
          Denny
          • 2. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
            964298
            Hi Denny.

            Thanks for Your reply.

            The knowledge base in instaled : C:\Oracle\product\11.2.0\dbhome_1\ctx\data\enlx\droldUS.dat and other files.

            Directly in database (DMUSER - the same user as SQL Dev. uses) i created policy with default values :
            begin
            ctx_ddl.create_policy(policy_name => 'NEW_policy', lexer => NULL, stoplist => NULL, wordlist => NULL);
            end;

            I extracted themes from samples (customer.comments) and my own data successfully.

            declare
            la varchar2(200);
            rtab ctx_doc.theme_tab;
            doc clob;
            begin
            --select ft.document into doc from FILTERTAB ft where ft.query_id = 3;
            select dt.comments into doc from mining_data_text_apply_v dt where dt.CUST_ID = 100001;
            ctx_doc.policy_themes('NEW_policy',
            doc,--'To define true madness, What is''t but to be nothing but mad?',
            rtab);
            for i in 1 .. rtab.count loop
            dbms_output.put_line(rtab(i).theme || ':' || rtab(i).weight);
            end loop;
            end;

            Anyway, back in SQL Dev. i got only "SYS.DM_NESTED_NUMERICALS()" in COMMENTS_THM column after transformation. COMMENTS_TOK looks better "SYS.DM_NESTED_NUMERICALS(SYS.DM_NESTED_NUMERICAL(CARD,0.0671736773433261515021971180253200439891)........
            I tried all combinatios for theme to generate.

            Both db(11.2.0.1 64b) and SQL Dev.(3.2.0.9) are installed on the same pc(WIN 7).

            I hope my informations will be helpful. Just let me know if some additional informations are needed.

            Thanks.

            Miro.
            • 3. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
              Denny Wong-Oracle
              Hi Miro

              Try this in your user account and see if it returns any themes. Basically, the Build Text node performs these operations to get the themes.

              exec ctx_ddl.create_preference('MY_LEXER', 'BASIC_LEXER');
              exec ctx_ddl.create_policy(policy_name => 'MY_POLICY', lexer => 'MY_LEXER');

              SELECT COMMENTS,
              ODMR_ENGINE_TEXT.dm_policy_themes('MY_POLICY', "COMMENTS", 0) "themes"
              FROM mining_data_text_apply_v where CUST_ID = 100001

              What is your locale? What db version do you have?

              Thanks,
              Denny
              • 4. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                964298
                Hi Denny.

                Here is the result:

                Connected to Oracle Database
                Connected as DMUSER@ORCLX

                SQL> exec ctx_ddl.create_preference('MY_LEXER', 'BASIC_LEXER');

                PL/SQL procedure successfully completed

                SQL> exec ctx_ddl.create_policy(policy_name => 'MY_POLICY', lexer => 'MY_LEXER');

                PL/SQL procedure successfully completed

                SQL>

                SQL> SELECT COMMENTS,
                2 ODMR_ENGINE_TEXT.dm_policy_themes('MY_POLICY', "COMMENTS", 0) "themes"
                3 FROM mining_data_text_apply_v where CUST_ID = 100001
                4 ;

                COMMENS themes
                Thanks a lot for my new affinity card. I love the discounts and have since start <Object>

                SQL>

                --------------------------
                <Object> contains values:

                starts
                love
                stores
                shopping
                Cardinal
                attraction
                discount
                newness

                ---------------------

                DB is 64bit version of 11g Enterprise Edition Release 11.2.0.1.0, instaled on Windows 7 Enterprise, Service pack 1. SQL Developer is version 3.2.0.9. Java is 1.6.0.350.

                Thanks.

                Miro.
                • 5. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                  Denny Wong-Oracle
                  Hi Miro

                  It seems the theme generation is working.
                  Please export your workflow to a xml file and post it here.

                  Thanks
                  Denny
                  • 6. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                    964298
                    Here is simple sample:

                    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
                    <WorkflowProcess Version="11.2.1.1.1" xmlns="http://xmlns.oracle.com/odmr11">
                    <Nodes>
                    <DataSource Status="Complete" Name="MINING_DATA_TEXT_BUILD_V" Id="10001">
                    <Icon YCOORD="261" XCOORD="218"></Icon>
                    <Messages/>
                    <CacheSettings GenerateCache="false" UseFullData="false">
                    <NumberOfRows>2000</NumberOfRows>
                    <Method>
                    <TopN/>
                    </Method>
                    </CacheSettings>
                    <SQLExpression>"N$10001" as (select /*+ inline */ "MINING_DATA_TEXT_BUILD_V"."CUST_ID",
                    "MINING_DATA_TEXT_BUILD_V"."COMMENTS"
                    from "DMUSER"."MINING_DATA_TEXT_BUILD_V" )</SQLExpression>
                    <Attributes>
                    <Attribute Status="Valid" DataType="NUMBER" Name="CUST_ID"/>
                    <Attribute Status="Valid" DataType="VARCHAR2" Name="COMMENTS"/>
                    </Attributes>
                    <SourceTable Name="MINING_DATA_TEXT_BUILD_V" Schema=""/>
                    </DataSource>
                    <BuildText Status="Complete" Name="PrepareComments" Id="10003">
                    <Icon YCOORD="261" XCOORD="422"></Icon>
                    <Messages/>
                    <CacheSettings GenerateCache="false" UseFullData="false">
                    <NumberOfRows>2000</NumberOfRows>
                    <Method>
                    <TopN/>
                    </Method>
                    </CacheSettings>
                    <SQLExpression>"N$10003" as (SELECT /*+ inline */
                    "CUST_ID",
                    ODMR_ENGINE_TEXT.dm_text_token_features('ODMR$COMMENTS19541633_PL', "COMMENTS", 'ODMR$COMMENTS315611162_FT', 'COMMENTS', 50, 'IDF') "COMMENTS_TOK",
                    ODMR_ENGINE_TEXT.dm_text_theme_features('ODMR$COMMENTS34503614_PL', "COMMENTS", 'ODMR$COMMENTS713204258_FT', 'COMMENTS', 1, 50, 'IDF') "COMMENTS_THM" FROM {INPUT_SOURCE} )</SQLExpression>
                    <CaseAttributes/>
                    <TransformationSourceAttributes>
                    <TransformationSourceAttributeType Status="Valid" DataType="VARCHAR2" Name="COMMENTS">
                    <IsOutput>false</IsOutput>
                    </TransformationSourceAttributeType>
                    <TransformationSourceAttributeType Status="Valid" DataType="NUMBER" Name="CUST_ID">
                    <IsOutput>true</IsOutput>
                    </TransformationSourceAttributeType>
                    </TransformationSourceAttributes>
                    <Stoplists>
                    <Stoplist DBName="ODMR$10_44_57_142000FUPYXUH" Language="ENGLISH" Type="Basic" Name="Default" Id="1">
                    <StopTokens>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>a</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>all</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>almost</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>also</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>although</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>an</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>and</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>any</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>are</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>as</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>at</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>be</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>because</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>been</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>both</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>but</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>by</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>can</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>could</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>d</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>did</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>do</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>does</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>either</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>for</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>from</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>had</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>has</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>have</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>having</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>he</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>her</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>here</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>hers</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>him</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>his</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>how</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>however</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>i</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>if</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>in</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>into</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>is</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>it</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>its</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>just</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>ll</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>me</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>might</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>Mr</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>Mrs</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>Ms</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>my</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>no</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>non</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>nor</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>not</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>of</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>on</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>one</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>only</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>onto</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>or</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>our</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>ours</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>s</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>shall</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>she</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>should</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>since</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>so</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>some</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>still</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>such</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>t</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>than</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>that</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>the</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>their</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>them</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>then</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>there</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>therefore</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>these</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>they</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>this</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>those</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>though</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>through</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>thus</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>to</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>too</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>until</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>ve</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>very</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>was</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>we</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>were</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>what</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>when</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>where</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>whether</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>which</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>while</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>who</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>whose</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>why</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>will</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>with</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>would</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>yet</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>you</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>your</Item>
                    </Token>
                    <Token Language="ENGLISH" Type="Word">
                    <Item>yours</Item>
                    </Token>
                    </StopTokens>
                    </Stoplist>
                    </Stoplists>
                    <TransformedAttributes>
                    <MapTextTransformedSource>
                    <Key Source="COMMENTS" Status="Valid" DataType="DM_NESTED_NUMERICALS" Name="COMMENTS_TOK">
                    <IsOutput>true</IsOutput>
                    <TransformationElement>
                    <Token>
                    <Token Policy="ODMR$COMMENTS19541633_PL" StoplistId="1" Frequency="IDF" MaxNumberAllDocs="3000" MaxNumberPerDoc="50">
                    <Lexer Type="Basic" Name="ODMR$16_38_31_265000SPGQKWM">
                    <Settings/>
                    </Lexer>
                    <Languages>
                    <Language Type="SingleByte" Name="ENGLISH"/>
                    </Languages>
                    <StatisticTable CreationDate="2012-10-01T16:38:40.000000" Name="ODMR$COMMENTS315611162_FT"/>
                    <FeatureTable CreationDate="2012-10-01T16:38:40.000000" Name="ODMR$16_38_32_123000UWKLRMX"/>
                    </Token>
                    </Token>
                    </TransformationElement>
                    <Modified>true</Modified>
                    </Key>
                    </MapTextTransformedSource>
                    <MapTextTransformedSource>
                    <Key Source="COMMENTS" Status="Valid" DataType="DM_NESTED_NUMERICALS" Name="COMMENTS_THM">
                    <IsOutput>true</IsOutput>
                    <TransformationElement>
                    <Theme Type="Full">
                    <Token Policy="ODMR$COMMENTS34503614_PL" StoplistId="1" Frequency="IDF" MaxNumberAllDocs="3000" MaxNumberPerDoc="50">
                    <Lexer Type="Basic" Name="ODMR$16_38_40_921000QQFFVRV">
                    <Settings/>
                    </Lexer>
                    <Languages>
                    <Language Type="SingleByte" Name="ENGLISH"/>
                    </Languages>
                    <StatisticTable CreationDate="2012-10-01T16:38:48.000000" Name="ODMR$COMMENTS713204258_FT"/>
                    <FeatureTable CreationDate="2012-10-01T16:38:48.000000" Name="ODMR$16_38_42_575000SPIECIK"/>
                    </Token>
                    </Theme>
                    </TransformationElement>
                    <Modified>true</Modified>
                    </Key>
                    </MapTextTransformedSource>
                    </TransformedAttributes>
                    <SampleSettings GenerateCache="true" UseFullData="false">
                    <PercentOfTotal>60.0</PercentOfTotal>
                    <Method>
                    <Random Seed="12345"/>
                    </Method>
                    </SampleSettings>
                    </BuildText>
                    </Nodes>
                    <Links>
                    <Link Label="From &quot;MINING_DATA_TEXT_BUILD_V&quot; to &quot;PrepareComments&quot;" Name="Link" To="10003" From="10001" Id="10002">
                    <ConnectorGraphicsInfo>
                    <Coordinates YCoordinate="0.0" XCoordinate="0.0"/>
                    </ConnectorGraphicsInfo>
                    </Link>
                    </Links>
                    </WorkflowProcess>
                    • 7. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                      Denny Wong-Oracle
                      Hi Miro

                      I just run the workflow and I got some themes generated:

                      :cards:     329
                      :stores:retail trade industry:commerce and trade:business and economics:     324
                      :attraction:     321
                      :newness:     278
                      :shopping:retail trade industry:commerce and trade:business and economics:     263
                      : : :
                      : : :

                      I am not sure why you didn't get the theme generated. Can you try to create a new Build Text node in a new workflow and try again?

                      Thanks,
                      Denny
                      • 8. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                        964298
                        Hi Denny.

                        I ran the query from xml against database.

                        (SELECT /*+ inline */
                        "CUST_ID",
                        ODMR_ENGINE_TEXT.dm_text_token_features('ODMR$COMMENTS19541633_PL', "COMMENTS", 'ODMR$COMMENTS315611162_FT', 'COMMENTS', 50, 'IDF') "COMMENTS_TOK",
                        ODMR_ENGINE_TEXT.dm_text_theme_features('ODMR$COMMENTS34503614_PL', "COMMENTS", 'ODMR$COMMENTS713204258_FT', 'COMMENTS', 1, 50, 'IDF') "COMMENTS_THM" FROM mining_data_text_apply_v );

                        The tokens were o.k.. Themes were only empty collections. I tried to change policies and model_table_name. Tokens worked well with other policies. But still no any results for the themes. It looks to me, there is a problem with model_table. Using policy 'ODMR$COMMENTS34503614_PL' i was able to get out the tokens. So i think the policy is o.k. But i'm not sure about the model_table. I don't know were to look for more informations about the model tables.

                        Model table 'ODMR$COMMENTS713204258_FT' (the one for the themes) is empty.
                        Feture tables is not empty ( <FeatureTable CreationDate="2012-10-01T16:38:48.000000" Name="ODMR$16_38_42_575000SPIECIK"/>). There are comments in text_column. But there are empty collections in 'FEATURES' column.

                        Model table 'COMMENTS315611162_FT', for the tokens is filled.

                        I'm still investigating. I'm just posting what i founded meanwhile. Btw. new workflow doesn't felp.

                        Thanks.

                        Miro.

                        Edited by: 961295 on Oct 2, 2012 2:06 PM
                        • 9. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                          Denny Wong-Oracle
                          Hi Miro

                          Is the ODMR$COMMENTS713204258_FT empty? It sounds to me the table is empty.

                          Here is the query used to generate the ODMR$COMMENTS713204258_FT. Can you try running the query to see if it can generate the table (assume the ODMR$COMMENTS34503614_PL still exists)?

                          CREATE TABLE <some table name> AS
                          SELECT 'COMMENTS' "COLUMN_NAME", token, value, rank, count
                          FROM
                          (SELECT token, value, RANK() OVER(ORDER BY value ASC) rank, count
                          FROM
                          (SELECT column_value token, LN(N/count(*)) value, count(*) count
                          FROM
                          (SELECT t2.column_value, t1.N
                          FROM
                          (SELECT
                          COUNT(*) OVER () N,
                          rownum rn,
                          ODMR_ENGINE_TEXT.dm_policy_themes('ODMR$COMMENTS34503614_PL', "COMMENTS", 1) nt
                          FROM mining_data_text_apply_v
                          ) t1, TABLE(t1.nt) t2
                          GROUP BY t2.column_value, t1.rn, t1.N
                          )
                          GROUP BY column_value, N
                          )
                          )
                          WHERE rank <= 3000


                          Thanks,
                          Denny
                          • 10. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                            964298
                            Hi Denny.

                            Thanks for the command. The table ODMR$COMMENTS713204258_FT was empty as i posted earlier.

                            When i populated the table using your commad, the themea appaered in 'EDIT BUILD TEXT NODE' in tab 'THEMES'. The tab 'OUPUT' contains 'No theme is generated'. When i rerun the node, feature table is empty again.

                            I tired your command few times using different combinations and i found out that:
                            When using policy made for Themes, the query returns zero rows. ODMR_ENGINE_TEXT.dm_policy_themes generetes only empty collections for themes. (the embeded select statement)
                            So i tried to use policy prepared for tokens, and my own policy. With this policies the command populated the table or returned rows...

                            So i think that the problem is with the policy properties, for themes. I'm not able find and compare the policies in databese. I can not see anything suspicious in xml file (regarding to policies).

                            I'm about to believe, that if the query returns the rows, while runnig the workflow, it will be o.k.

                            But i don't know how to do that. Any ideas?

                            Anyway, thanks for your willingness and patience.

                            Miro.
                            • 11. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                              Denny Wong-Oracle
                              It does seem something to do with the policy. Please run this query to compare the policies:

                              select * from CTX_USER_INDEX_VALUES where IXV_INDEX_NAME='<policy name>'
                              select * from CTX_USER_INDEX_OBJECTS where IXO_INDEX_NAME='<policy name>'

                              You can find the policy name for the theme in the exported workflow xml file.

                              Thanks,
                              Denny
                              • 12. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                                Denny Wong-Oracle
                                Just to clarify, when you run this query using the ODMR$COMMENTS34503614_PL (theme policy), it returns some themes or empty row?

                                SELECT 'COMMENTS' "COLUMN_NAME", token, value, rank, count
                                FROM
                                (SELECT token, value, RANK() OVER(ORDER BY value ASC) rank, count
                                FROM
                                (SELECT column_value token, LN(N/count(*)) value, count(*) count
                                FROM
                                (SELECT t2.column_value, t1.N
                                FROM
                                (SELECT
                                COUNT(*) OVER () N,
                                rownum rn,
                                ODMR_ENGINE_TEXT.dm_policy_themes('ODMR$COMMENTS34503614_PL', "COMMENTS", 1) nt
                                FROM mining_data_text_apply_v
                                ) t1, TABLE(t1.nt) t2
                                GROUP BY t2.column_value, t1.rn, t1.N
                                )
                                GROUP BY column_value, N
                                )
                                )
                                WHERE rank <= 3000

                                Thanks,
                                Denny
                                • 13. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                                  964298
                                  Hy Denny.

                                  It looks that we are in sync, finaly. :)

                                  The query now returns 144 rows, Themes/Rank/Count....

                                  SELECT 'COMMENTS' "COLUMN_NAME", token, value, rank, count
                                  FROM
                                  (SELECT token, value, RANK() OVER(ORDER BY value ASC) rank, count
                                  FROM
                                  (SELECT column_value token, LN(N/count(*)) value, count(*) count
                                  FROM
                                  (SELECT t2.column_value, t1.N
                                  FROM
                                  (SELECT
                                  COUNT(*) OVER () N,
                                  rownum rn,
                                  ODMR_ENGINE_TEXT.dm_policy_themes('ODMR$COMMENTS34503614_PL', "COMMENTS", 1) nt
                                  FROM mining_data_text_apply_v
                                  ) t1, TABLE(t1.nt) t2
                                  GROUP BY t2.column_value, t1.rn, t1.N
                                  )
                                  GROUP BY column_value, N
                                  )
                                  )
                                  WHERE rank <= 3000



                                  Now to the policies.

                                  I created fresh workflow, by importing the xml.
                                  Using your select i listed the properties for both policies. Believe or not, all the rows were the same except names. I tried the above statement again for both policies. The one for tokens returns rows, the one for themes does not.

                                  Do you think my db needs to be restarted? Or is it me who need it?

                                  miro.

                                  SELECT 'COMMENTS' "COLUMN_NAME", token, value, rank, count
                                  FROM
                                  (SELECT token, value, RANK() OVER(ORDER BY value ASC) rank, count
                                  FROM
                                  (SELECT column_value token, LN(N/count(*)) value, count(*) count
                                  FROM
                                  (SELECT t2.column_value, t1.N
                                  FROM
                                  (SELECT
                                  COUNT(*) OVER () N,
                                  rownum rn,
                                  ODMR_ENGINE_TEXT.dm_policy_themes('ODMR$COMMENTS107120535_PL', "COMMENTS", 1) nt -- THEMES
                                  FROM mining_data_text_build_v
                                  ) t1, TABLE(t1.nt) t2
                                  GROUP BY t2.column_value, t1.rn, t1.N
                                  )
                                  GROUP BY column_value, N
                                  )
                                  )
                                  WHERE rank <= 3000;

                                  zero rows.

                                  SELECT 'COMMENTS' "COLUMN_NAME", token, value, rank, count
                                  FROM
                                  (SELECT token, value, RANK() OVER(ORDER BY value ASC) rank, count
                                  FROM
                                  (SELECT column_value token, LN(N/count(*)) value, count(*) count
                                  FROM
                                  (SELECT t2.column_value, t1.N
                                  FROM
                                  (SELECT
                                  COUNT(*) OVER () N,
                                  rownum rn,
                                  ODMR_ENGINE_TEXT.dm_policy_themes('ODMR$COMMENTS533064182_PL', "COMMENTS", 1) nt -- TOKENS
                                  FROM mining_data_text_build_v
                                  ) t1, TABLE(t1.nt) t2
                                  GROUP BY t2.column_value, t1.rn, t1.N
                                  )
                                  GROUP BY column_value, N
                                  )
                                  )
                                  WHERE rank <= 3000;

                                  144 rows.



                                       IXO_INDEX_NAME     IXO_CLASS     IXO_OBJECT
                                  1     ODMR$COMMENTS533064182_PL     DATASTORE     DIRECT_DATASTORE
                                  2     ODMR$COMMENTS533064182_PL     FILTER     NULL_FILTER
                                  3     ODMR$COMMENTS533064182_PL     SECTION_GROUP     NULL_SECTION_GROUP
                                  4     ODMR$COMMENTS533064182_PL     LEXER     BASIC_LEXER
                                  5     ODMR$COMMENTS533064182_PL     WORDLIST     BASIC_WORDLIST
                                  6     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST
                                  7     ODMR$COMMENTS533064182_PL     STORAGE     BASIC_STORAGE

                                       IXO_INDEX_NAME     IXO_CLASS     IXO_OBJECT
                                  1     ODMR$COMMENTS107120535_PL     DATASTORE     DIRECT_DATASTORE
                                  2     ODMR$COMMENTS107120535_PL     FILTER     NULL_FILTER
                                  3     ODMR$COMMENTS107120535_PL     SECTION_GROUP     NULL_SECTION_GROUP
                                  4     ODMR$COMMENTS107120535_PL     LEXER     BASIC_LEXER
                                  5     ODMR$COMMENTS107120535_PL     WORDLIST     BASIC_WORDLIST
                                  6     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST
                                  7     ODMR$COMMENTS107120535_PL     STORAGE     BASIC_STORAGE

                                       IXV_INDEX_NAME     IXV_CLASS     IXV_OBJECT     IXV_ATTRIBUTE     IXV_VALUE
                                  1     ODMR$COMMENTS533064182_PL     WORDLIST     BASIC_WORDLIST     FUZZY_MATCH     GENERIC
                                  2     ODMR$COMMENTS533064182_PL     WORDLIST     BASIC_WORDLIST     STEMMER     NULL
                                  3     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     yours
                                  4     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     your
                                  5     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     you
                                  6     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     yet
                                  7     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     would
                                  8     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     with
                                  9     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     will
                                  10     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     why
                                  11     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     whose
                                  12     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     who
                                  13     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     while
                                  14     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     which
                                  15     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     whether
                                  16     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     where
                                  17     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     when
                                  18     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     what
                                  19     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     were
                                  20     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     we
                                  21     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     was
                                  22     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     very
                                  23     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     ve
                                  24     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     until
                                  25     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     too
                                  26     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     to
                                  27     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     thus
                                  28     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     through
                                  29     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     though
                                  30     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     those
                                  31     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     this
                                  32     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     they
                                  33     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     these
                                  34     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     therefore
                                  35     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     there
                                  36     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     then
                                  37     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     them
                                  38     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     their
                                  39     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     the
                                  40     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     that
                                  41     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     than
                                  42     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     t
                                  43     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     such
                                  44     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     still
                                  45     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     some
                                  46     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     so
                                  47     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     since
                                  48     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     should
                                  49     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     she
                                  50     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     shall
                                  51     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     s
                                  52     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     ours
                                  53     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     our
                                  54     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     or
                                  55     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     onto
                                  56     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     only
                                  57     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     one
                                  58     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     on
                                  59     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     of
                                  60     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     not
                                  61     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     nor
                                  62     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     non
                                  63     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     no
                                  64     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     my
                                  65     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     might
                                  66     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     me
                                  67     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     ll
                                  68     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     just
                                  69     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     its
                                  70     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     it
                                  71     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     is
                                  72     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     into
                                  73     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     in
                                  74     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     if
                                  75     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     i
                                  76     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     however
                                  77     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     how
                                  78     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     his
                                  79     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     him
                                  80     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     hers
                                  81     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     here
                                  82     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     her
                                  83     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     he
                                  84     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     having
                                  85     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     have
                                  86     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     has
                                  87     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     had
                                  88     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     from
                                  89     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     for
                                  90     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     either
                                  91     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     does
                                  92     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     do
                                  93     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     did
                                  94     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     d
                                  95     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     could
                                  96     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     can
                                  97     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     by
                                  98     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     but
                                  99     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     both
                                  100     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     been
                                  101     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     because
                                  102     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     be
                                  103     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     at
                                  104     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     as
                                  105     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     are
                                  106     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     any
                                  107     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     and
                                  108     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     an
                                  109     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     although
                                  110     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     also
                                  111     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     almost
                                  112     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     all
                                  113     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     a
                                  114     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     Ms
                                  115     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     Mrs
                                  116     ODMR$COMMENTS533064182_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     Mr
                                  117     ODMR$COMMENTS533064182_PL     STORAGE     BASIC_STORAGE     I_INDEX_CLAUSE     compress 2
                                  118     ODMR$COMMENTS533064182_PL     STORAGE     BASIC_STORAGE     R_TABLE_CLAUSE     lob (data) store as (cache)


                                       IXV_INDEX_NAME     IXV_CLASS     IXV_OBJECT     IXV_ATTRIBUTE     IXV_VALUE
                                  1     ODMR$COMMENTS107120535_PL     WORDLIST     BASIC_WORDLIST     FUZZY_MATCH     GENERIC
                                  2     ODMR$COMMENTS107120535_PL     WORDLIST     BASIC_WORDLIST     STEMMER     NULL
                                  3     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     yours
                                  4     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     your
                                  5     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     you
                                  6     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     yet
                                  7     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     would
                                  8     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     with
                                  9     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     will
                                  10     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     why
                                  11     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     whose
                                  12     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     who
                                  13     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     while
                                  14     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     which
                                  15     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     whether
                                  16     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     where
                                  17     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     when
                                  18     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     what
                                  19     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     were
                                  20     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     we
                                  21     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     was
                                  22     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     very
                                  23     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     ve
                                  24     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     until
                                  25     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     too
                                  26     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     to
                                  27     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     thus
                                  28     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     through
                                  29     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     though
                                  30     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     those
                                  31     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     this
                                  32     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     they
                                  33     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     these
                                  34     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     therefore
                                  35     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     there
                                  36     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     then
                                  37     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     them
                                  38     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     their
                                  39     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     the
                                  40     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     that
                                  41     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     than
                                  42     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     t
                                  43     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     such
                                  44     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     still
                                  45     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     some
                                  46     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     so
                                  47     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     since
                                  48     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     should
                                  49     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     she
                                  50     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     shall
                                  51     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     s
                                  52     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     ours
                                  53     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     our
                                  54     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     or
                                  55     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     onto
                                  56     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     only
                                  57     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     one
                                  58     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     on
                                  59     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     of
                                  60     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     not
                                  61     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     nor
                                  62     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     non
                                  63     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     no
                                  64     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     my
                                  65     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     might
                                  66     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     me
                                  67     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     ll
                                  68     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     just
                                  69     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     its
                                  70     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     it
                                  71     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     is
                                  72     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     into
                                  73     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     in
                                  74     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     if
                                  75     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     i
                                  76     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     however
                                  77     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     how
                                  78     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     his
                                  79     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     him
                                  80     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     hers
                                  81     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     here
                                  82     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     her
                                  83     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     he
                                  84     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     having
                                  85     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     have
                                  86     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     has
                                  87     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     had
                                  88     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     from
                                  89     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     for
                                  90     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     either
                                  91     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     does
                                  92     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     do
                                  93     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     did
                                  94     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     d
                                  95     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     could
                                  96     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     can
                                  97     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     by
                                  98     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     but
                                  99     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     both
                                  100     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     been
                                  101     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     because
                                  102     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     be
                                  103     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     at
                                  104     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     as
                                  105     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     are
                                  106     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     any
                                  107     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     and
                                  108     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     an
                                  109     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     although
                                  110     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     also
                                  111     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     almost
                                  112     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     all
                                  113     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     a
                                  114     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     Ms
                                  115     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     Mrs
                                  116     ODMR$COMMENTS107120535_PL     STOPLIST     BASIC_STOPLIST     STOP_WORD     Mr
                                  117     ODMR$COMMENTS107120535_PL     STORAGE     BASIC_STORAGE     I_INDEX_CLAUSE     compress 2
                                  118     ODMR$COMMENTS107120535_PL     STORAGE     BASIC_STORAGE     R_TABLE_CLAUSE     lob (data) store as (cache)

                                  Edited by: 961295 on Oct 3, 2012 3:54 PM
                                  • 14. Re: SQL Dev. 3.2.0.9/ Build Text Node - No theme is generated.
                                    Denny Wong-Oracle
                                    Hi Miro

                                    I am confused. The ODMR$COMMENTS34503614_PL is the policy used by the theme generation and the query does return themes (so theme generation is working). But when you run the workflow, it didn't generate any theme? What are the locale of your systems (Data Miner client and database)? The policy that didn't work, how was that policy created?

                                    Thanks
                                    Denny
                                    1 2 Previous Next