Skip to main content
Solved

Data Output Issue

  • March 25, 2026
  • 3 replies
  • 33 views
deanhowell
Influencer
Forum|alt.badge.img+24

I have a workbench that takes data from Oracle, merges it with a few other tables, runs it through a schema scanner and then tries to output to a file geodatabase.

The file geodatabase has the merged table created but it only contains the schema definition not the data.

 

The output from the schema scanner shows the points in the graphics display.

 

These are the transformers that scan and output

 

Here is the Feature Writer

 

 

The summary is showing the feature count 

 

 

There is some disconnect between the schema scanner and my output and was hoping someone might be able to see what I am doing wrong.

 

The workbench is attached. Any assistance would be greatly appreciated.

 

 

Best answer by deanhowell

Thanks ​@davechoi from ​SAFE as the big issue was grouping.

Turn off the Group Processing and add ‘fme_feature_type_name’ in the schema definition

 

 

 

 

FME - My go to no code development tool

3 replies

hkingsbury
Celebrity
Forum|alt.badge.img+70
  • hkingsburyCelebrity
  • Celebrity
  • March 25, 2026

Are you seeing any errors or warnings in the log?

Your writer setup looks okay (without opening up the fmw) Maybe try setting the featureclass to fme_feature_type and the schema definition name to fme_feature_type_name (as per Dynamic Workflows with the SchemaScanner – FME Support Center)

    deanhowell
    Influencer
    Forum|alt.badge.img+24
    • deanhowellInfluencer
    • Author
    • Influencer
    • March 25, 2026

    Thanks ​@hkingsbury I see the following a couple of times. It writes the blank schema to the GDB but just doesn’t create the data. 

    Cannot define schema for 'CAP_PT' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration
    Writer `WriteMergedLayers_0' of type `FILEGDB' using group definition keyword `WriteMergedLayers_0_DEF'
    FileGDB Writer: A feature with feature type `CAP_PT' could not be written
    Storing feature(s) to FME feature store file `C:\Projects\Workbenches\ArcGISPortalFromOracle_log.ffs'
     

    FME - My go to no code development tool
    deanhowell
    Influencer
    Forum|alt.badge.img+24
    • deanhowellInfluencer
    • Author
    • Influencer
    • Best Answer
    • March 25, 2026

    Thanks ​@davechoi from ​SAFE as the big issue was grouping.

    Turn off the Group Processing and add ‘fme_feature_type_name’ in the schema definition

     

     

     

     

    FME - My go to no code development tool

      Community Stats

      32,405
      Posts
      123,160
      Replies
      40,510
      Members
      Terms & ConditionsCookie settingsAccessibility statement
      A product of
      Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.