I am trying to create a simple read/write workspace using SqlCreator to access an MS SQL database.
When I run the workspace, the inspector shows an empty table with header <no schema> above a single column of 928 rows (the expected # of resulting rows).
When I click on an individual cell in the table, the feature information pane displays the expected feature properties and attributes. Again, no attributes are displayed in the table itself.
When I point the SqlCreator results to a csv writer, the log shows that all features were written, but the output CSV is empty.
I have verified that Native Client 2012 is installed. Any advice is appreciated!
Posting the last bit of the log file here:
---------
Microsoft SQL Server Non-Spatial Reader: Database read complete. Retrieved 928 feature(s)
SQLCreator_Creator(CreationFactory): Created 1 features
Microsoft SQL Server Non-Spatial Reader: Closing `KITSDB' . Read operation complete
SQLCreator RESULT Splitter(TeeFactory): Cloned 928 input feature(s) into 2784 output feature(s)
SQLCreator_RESULT_0_Xo1c2GgqDQQ= Feature Counter -1 3(TeeFactory): Cloned 928 input feature(s) into 928 output feature(s)
SQLCreator_RESULT_1_Xo1c2GgqDQQ= Feature Counter -1 5(TeeFactory): Cloned 928 input feature(s) into 928 output feature(s)
SQLCreator_RESULT_2_Xo1c2GgqDQQ= Feature Counter -1 8(TeeFactory): Cloned 928 input feature(s) into 928 output feature(s)
SQLCreator_Result_DirCreator(CreationFactory): Created 1 features
SQLCreator_Result_DirCreatorCleanerUpper(TeeFactory): Cloned 1 input feature(s) into 0 output feature(s)
SQLCreator_Result_FeatureDirector(TestFactory): Tested 928 input feature(s) -- 0 feature(s) passed and 928 feature(s) failed
SQLCreator_Result___FeatureDirector1(TestFactory): Tested 928 input feature(s) -- 0 feature(s) passed and 928 feature(s) failed
SQLCreator_Result_VectorSetterUpper(TeeFactory): Cloned 928 input feature(s) into 928 output feature(s)
SQLCreator_Result___PointCloudThinner(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)
SQLCreator_Result_RasterSetterUpper(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)
Stored 928 feature(s) to FME feature store file `C:\\Users\\xxxxx\\AppData\\Local\\Temp\\intersection_status_v1_162252\\inspector.ffs'
Saving spatial index into file 'C:\\Users\\xxxxx\\AppData\\Local\\Temp\\intersection_status_v1_162252\\inspector.fsi'
Finished saving spatial index into file 'C:\\Users\\xxxxx\\AppData\\Local\\Temp\\intersection_status_v1_162252\\inspector.fsi'
Stored 1 feature(s) to FME feature store file `C:\\Users\\xxxxx\\AppData\\Local\\Temp\\intersection_status_v1_162252\\inspector.fsc'
SQLCreator_Result_Recorder(RecorderFactory): Recorded 928 feature(s) to file `C:\\Users\\xxxxx\\AppData\\Local\\Temp\\intersection_status_v1_162252\\inspector.ffs'
SQLCreator_Result_2_Logger(TeeFactory): Cloned 928 input feature(s) into 928 output feature(s)
SQLCreator_Result_2 LOGGED Output Nuker(TeeFactory): Cloned 928 input feature(s) into 0 output feature(s)
Destination Feature Type Routing Correlator(RoutingFactory): Tested 928 input feature(s), wrote 928 output feature(s): 0 matched merge filters, 928 were routed to output, 0 could not be routed.
Final Output Nuker(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)
f_20(CreationFactory): Created 1 features
f_21(TeeFactory): Cloned 1 input feature(s) into 0 output feature(s)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Feature output statistics for `FFS' writer using keyword `W_1':
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Features Written
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
==============================================================================
Total Features Written 0
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
CSV Writer: Closing file `C:\\Users\\xxxxx\\Desktop\\test_csv_writer.csv'
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Feature output statistics for `CSV' writer using keyword `CSV_1':
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Features Written
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
test_csv_writer (test_csv_writer) 928
==============================================================================
Total Features Written 928
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Features Read Summary
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
==============================================================================
Total Features Read 0
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Features Written Summary
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
test_csv_writer 928
==============================================================================
Total Features Written 928
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Microsoft SQL Server Non-Spatial Reader: Closing `KITSDB' . Read operation complete
Translation was SUCCESSFUL with 0 warning(s) (928 feature(s) output)
Stored 20 feature(s) to FME feature store file `H:\\ATD_BSA\\Intersection Status\\FME\\intersection_status_v1_log.ffs'
FME Session Duration: 1.8 seconds. (CPU: 0.3s user, 0.3s system)
END - ProcessID: 7592, peak process memory usage: 63636 kB, current process memory usage: 63320 kB
Translation was SUCCESSFUL