SQLite: Problematic conversion

[jbirch]

I was trying to pull out a subset of data for testing with #316 using FME, and managed to create an SDF that breaks either the convertor (using "optimize") or causes an exception in SQLite provider itself if I convert the data source without optimizing.

This file works fine in its native SDF format, and the data converts and works fine as the Easement feature class from the NanaimoCadastre SDF (linked to #316). Something in the FME data transfer process caused it to no longer be acceptable to the SQLite provider; perhaps an attribute data type changed?

 http://www.jasonbirch.com/temp/NanEase.zip

[traianstanev]

Looks like there a few weird things about the SDF produced by FME. First, the integer ID is not marked as autogenerated, even though it looks like it is. Second, the GISLINK property comes out as REAL even though it should probably be an int. Nevertheless, it converted without errors for me, but it looks strange (lots of null properties). I will send you the converted file to compare.

[jbirch]

I wouldn't be at all surprised if I screwed something up in the FME settings. I'll try again, fixing those problems.

Odd that I got errors during optimized conversion when you didn't though. I'll try a clean build on the provider and see if it makes a difference.

Most of the data in my test set probably has a lot of nulls. Those layers were under heavy development when I pulled them out of Oracle a year and a half ago :)

[traianstanev]

Ah, optimized. I was doing regular conversion. I will try optimized now.

[jbirch]

It's failing at this line:

FdoPtr?<FdoIFeatureReader> rdr = select->Execute();

Don't know enough about VS debugging to tell you more than that...

I wonder if this could be because of the mixed environment I'm using? I've "externalled" the SQLite provider into the 3.3.0 tag of FDO.

[traianstanev]

Actually I know what it is. It is because the ID is not marked as autogenerated -- it ends up making a weird filter to ask for a specific feature from the source SDF, and that fails. I know how to fix it.

[traianstanev]

It should be fixed now. Reopen if you still have the same problem.