Skip to main content
  • EN

first sorry if the question is not in the right place

 

I have a problem with Excel Writer inconsistently showing the Error:

Excel Writer: Failed to save changes to the spreadsheet 'file name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'bad allocation'
A fatal error has occurred. Check the logfile above for details
... Last line repeated 2 times ...

sometime it doesn't show at all and other times for the some unchanged WB it appears and I only restart my machine and it would work fine but other times it wouldn't unless I manually run the WB till the Excel Writer and run the Writer alone and it will be fine 

I thought that the problem was only appearing when I use the same writer to write multiple Sheets and tried to have them be separate (multiple Writer one for each sheet but all writing to same file) but it appeared again in a write with a single sheet.

by the way it usually start writing some data first so the writer will create the fill and write but stop suddenly.

note: I have seen the same question and the answer was something about writing to a file not directory I don't think that's the problem here.

Can it be that multiple writers try to write to the same file at once?

Do you use Classic writers or FeatureWriters?

If you use FeatureWriters, you can use the summary feature, a Holder and a Tester to prevent the 2nd writer start writing while the first writer is not finished yet.

Can it be that multiple writers try to write to the same file at once?

Do you use Classic writers or FeatureWriters?

If you use FeatureWriters, you can use the summary feature, a Holder and a Tester to prevent the 2nd writer start writing while the first writer is not finished yet.

2020-10-07_10h10_59

"Can it be that multiple writers try to write to the same file at once?"

as I said it also happened with single writer writing to a single Excel sheet

"Do you use Classic writers or FeatureWriters?"

sorry I don't know the difference I am new to FME

Can it be that multiple writers try to write to the same file at once?

Do you use Classic writers or FeatureWriters?

If you use FeatureWriters, you can use the summary feature, a Holder and a Tester to prevent the 2nd writer start writing while the first writer is not finished yet.

I just tried with FeatureWriter and a single Excel Sheet ,but still the same error

"Can it be that multiple writers try to write to the same file at once?"

as I said it also happened with single writer writing to a single Excel sheet

"Do you use Classic writers or FeatureWriters?"

sorry I don't know the difference I am new to FME

Are you sure the file isn't opened somewhere else?

Are you sure the file isn't opened somewhere else?

it can't be opened cause the WB it self create the file

Do you work using Feature Caching? Does it work when switched off? Default on with Feature Caching is causing a lot of issues.

Do you work using Feature Caching? Does it work when switched off? Default on with Feature Caching is causing a lot of issues.

Yeah I work with it on ,but the error also appear when I run the WB using FME Quick Translator which I think doesn't have  Feature Caching.

Yeah I work with it on ,but the error also appear when I run the WB using FME Quick Translator which I think doesn't have  Feature Caching.

You can switch it off in workbench under Run --> Enable Feature Caching.

Can you share your workspace?

Do you have a single writer or multiple writers?

Do you write to an existing or to a new file?

Is the file locally stored or on a network?

Do you or the network use a sync mechanism? This can cause the file to be locked while syncing.

Yeah I work with it on ,but the error also appear when I run the WB using FME Quick Translator which I think doesn't have  Feature Caching.

yeah I Know how to turn it off but as I said I am running it on FME Quick Translator which I think doesn't have Feature Caching

I can't it have sensitive info and the input is from our database

yes there is multiple writers

no the file is created by the workbench

@david_r​ 

can you help me please

@david_r​ 

can you help me please

Sorry, I have no idea. You may want to consider contacting your FME Partner / Reseller for support.

If Anybody have the same problem.

I didn't solve it but a work around is is that i wrote every sheet as a CSV and made another WB to assemble them in one xlsx file the down side to this method is that the main WB now take almost triple the time it previously needed

Reply


Community Stats

30,418
Posts
115,551
Replies
38,228
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.