Tools (Alchemy / Chameleon): Creating index

1 to 6 of 6

  1.  
    • CommentAuthorcbetts
    • CommentTimeSep 8th 2009
     
    Hi,

    Im trying to create an index on a column with the following alchemy import script:

    OUTPUT Wells;
    DATASET "Custom Data Import Example" ;
    COPYRIGHT "(c) 2006 Telogis" ;

    SELECT %LOC as LSD
    INTO ImportWells
    FROM "C:\Mentor\GeobaseMaps\Shapefiles\mentor_wells_with_LSD_AB_and_SASK\mentorWells";

    CREATE INDEX index_lsd ON ImportWells USING BKTREE 2 (LOC);


    The script fails with the following error:
    Data build failed: Cannot create index on 'importwells' - table doesn't exist


    Any idea wha'ts wrong?
    • CommentAuthorcbetts
    • CommentTimeSep 8th 2009
     
    Im sorry. The last line should read:
    CREATE INDEX index_lsd ON ImportWells USING BKTREE 2 (LSD);

    I have tried it both ways.
    •  
      CommentAuthorPepitaL
    • CommentTimeSep 8th 2009
     
    hi cbetts,

    The name of table ImportWells needs to be all in lower case, ie
    SELECT %LOC as LSD
    INTO importwells
    FROM "C:\Mentor\GeobaseMaps\Shapefiles\mentor_wells_with_LSD_AB_and_SASK\mentorWells";

    CREATE INDEX index_lsd ON importwells USING BKTREE 2 (LSD);

    let us know how it goes.
    Pepita
    • CommentAuthorcbetts
    • CommentTimeSep 9th 2009
     
    Hi Pepita,

    Thank you. That worked, but I have a new error.
    The script now looks like this:

    OUTPUT Wells;
    DATASET "Custom Data Import Example" ;
    COPYRIGHT "(c) 2006 Telogis" ;

    SELECT %LOC as loc
    INTO importwells
    FROM "C:\Mentor\GeobaseMaps\Shapefiles\mentor_wells_with_LSD_AB_and_SASK\mentorWells";

    CREATE INDEX index_lsd ON importwells USING BKTREE 2 (loc);


    The error I get is:
    Data build failed: Unable to read beyond the end of the stream.

    Thanks,
    •  
      CommentAuthorPepitaL
    • CommentTimeSep 9th 2009
     
    Hi Cbetts,

    Which version of Alchemy are you using? What is the whole message displayed in the Alchemy command windows?
    If possible could you send a sample of your data and your SFI script to gbsupport@telogis.com, so we can try it out? thanks, Pepita
    • CommentAuthorcbetts
    • CommentTimeSep 10th 2009
     
    Hi Pepita,

    I am using v1.6.8.0

    Here is the output:

    starting
    Processing 'C:\Mentor\GeobaseMaps\mentorWells'
    Processed 1000 of 2959 features, Written 1000
    Processed 2000 of 2959 features, Written 2000
    Processed 2959 of 2959 features, Wrote 2959
    Data build failed: Unable to read beyond the end of the stream.

    at System.IO.__Error.EndOfFile()
    at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
    at System.IO.BinaryReader.ReadUInt32()
    at xc964d2319e53c184.x66e83adc35c10c50.Process(x32eac27632acc346 xbce90b56ab4
    11c23)
    at xc964d2319e53c184.x867eb3246b182488.xc447809891322395(String[] xce8d8c7e3c
    2c2426)
    Total Time = 00:00:00.3280998
    Press any key to exit ...

    I will send a data sample and the script to you.


    Thanks,

1 to 6 of 6

  1.