Skip to main content
  • EN

Team:

I have been developing some processes in fme server 2018 and have an issue that I am not sure how to troubleshoot. The work bench is pretty simple, read access, sort some things, a couple of joins and then push the data into a clean database that has the same schema as the source data via a feature writer instead of an access writer in the workbench—this forces me to use a 2 step approach as I have some SQL executors port processing.

The feature writer works in desktop but not on server. Initially, I thought it was a permissions issue, but then I broke the process—to a 2-step approach—each process worked fine independent of each other.

The log below contains the information related to the issue that I had with the first approach—handling everything in 1 process. I was basically pushing records to a couple of clean preexisting tables. I don’t have a project number for support, I will be happy to talk to any of you later tonight to see if we can solve this to make sure its not a permissions issue. Let me know if anybody would like to test it so I can give you the workbench and some sample files.

BADNEWS: File C:\\Program Files\\FMEServer\\Server\\fme\\metafile\\msaccess_jdbc_.fmi could not be opened (tabrdr_classic.cpp:2756 - tabrdr::ClassicTableReader::TableReaderSource::open)

BADNEWS: No MULTI_WRITER dataset name was specified (couldn't find a value for `FeatureWriter_DATASET' or `MULTI_WRITER_DATASET') (writrimp.cpp:767)

MS Access (JDBC) Writer: Table 'MH_Connections_Media' probably does not exist. You may wish to qualify your table name and try again

BADNEWS: COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 user lacks privilege or object not found: MH_CONNECTIONS_MEDIA (javasess.cpp:708)

COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 user lacks privilege or object not found: MH_CONNECTIONS_MEDIA

(stfchan.cpp:254) - (javawch.cpp:613) - (javasess.cpp:708)

COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 user lacks privilege or object not found: MH_CONNECTIONS_MEDIA

BADNEWS: COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 user lacks privilege or object not found: MH_CONNECTIONS_MEDIA (multiwch.cpp:1029)

FeatureWriter(WriterFactory): COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 user lacks privilege or object not found: MH_CONNECTIONS_MEDIA

Thanks

If you can achieve this in two steps, then it sounds like something is happening too quickly when you have a single workspace. Features in FME generally flow one by one (not one transformer at a time, but one feature at a time) and so sometimes you can start writing data before you've finished reading/joining it.

So, without seeing your workspace, I'd suggest putting a FeatureHolder transformer in there before the FeatureWriter (or at whatever point it is where you can successfully split it into two sections). That will hold up the data until the earlier part has finished. Then the later part can run without interference from the former part.

I'm not sure why this should only occur on Server, which is one reason I'm dubious, but let's see.

I hope this helps. I think it should; but if you can post a screenshot of your workspace then that would be quite helpful.

I am experiencing thisame issue as well (
2024-09-06 07:06:19|   1.5|  0.0|ERROR |BADNEWS: No MULTI_WRITER dataset name was specified (couldn't find a value for `PRIMARY_DEST_DATASET' or `MULTI_WRITER_DATASET')
2024-09-06 07:06:19|   1.5|  0.0|ERROR |(D:\code\fme\source\engine\core\engine\writrimp.cpp:672) class StatusInfo __cdecl STFWriterImp::getDataset(class stk::ex::UString<0> &) const

)

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
Members
Terms & ConditionsCookie settings
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.