This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Oct 5, 2012 6:47 AM by Denny Wong RSS

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

964298 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points