ASCIIOUTPUT file extension has a $ sign at the end

[grusty]

Hi Experts,

Has anyone come across this issue? The output file has a '$' after the '.csv'? I've scoured the internet and these forums and can't seem to find a way to fix this. How do I remove the $ after exporting a cube view to a csv file without doing it manually? I'm using the exported data file to create a journal entry import file.

Code: Select all

ASCIIOUTPUT('\\PRIMARY\general\Finance\TM1 Imports\[b]test_quotes.csv[/b]','item1','3/1/2020','-1.11');

filename in windows directory: 'test_quotes.csv$'

[ascheevel]

Does your file "test_quotes.csv" already exist on the server and is it possibly open in another program. The $ at the end of the extension is a temp file and it will get stuck like that when it's unable to replace the existing file at the completion of TI execution. If you look at the server log after your process runs, you may see a "sf_DeleteFile: Error..." and that it cannot access the file because it's being used by another process.

[grusty]

Does your file "test_quotes.csv" already exist on the server and is it possibly open in another program. The $ at the end of the extension is a temp file and it will get stuck like that when it's unable to replace the existing file at the completion of TI execution. If you look at the server log after your process runs, you may see a "sf_DeleteFile: Error..." and that it cannot access the file because it's being used by another process.

Never even occurred to me to check the log, rookie mistake I'll see if I can find a solution by googling. Thanks for your help!

33716 [26fd] ERROR 2020-04-09 11:06:20.185 TM1.Server sf_Rename: Failed to rename (\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma$) to (\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma). Error: error code:5 reason:"Access is denied." file:""\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma$" : "\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma" "

[tomok]

33716 [26fd] ERROR 2020-04-09 11:06:20.185 TM1.Server sf_Rename: Failed to rename (\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma$) to (\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma). Error: error code:5 reason:"Access is denied." file:""\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma$" : "\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma" "

You wouldn't happen to have this file open in Excel would you? This error happens whenever you have a CSV open in Excel and then try to write to it via a TI. Copy it to another directory and then open in in Excel. Then run your TI process.

[grusty]

33716 [26fd] ERROR 2020-04-09 11:06:20.185 TM1.Server sf_Rename: Failed to rename (\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma$) to (\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma). Error: error code:5 reason:"Access is denied." file:""\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma$" : "\\PRIMARY\general\Finance\TM1 Imports\test_quotes.cma" "

You wouldn't happen to have this file open in Excel would you? This error happens whenever you have a CSV open in Excel and then try to write to it via a TI. Copy it to another directory and then open in in Excel. Then run your TI process.

no, I actually created this process as a separate test with a new file. I then deleted the file and re-ran the process and got the same error. I'm thinking it might be an access issue with the TM1 server not having permission to rename files? I didn't think that was a separate permission from windows WRITE access but then again I'm not all that familiar with windows permissions.

[tomok]

no, I actually created this process as a separate test with a new file. I then deleted the file and re-ran the process and got the same error. I'm thinking it might be an access issue with the TM1 server not having permission to rename files? I didn't think that was a separate permission from windows WRITE access but then again I'm not all that familiar with windows permissions.

The account that TM1 runs under is going to need FULL CONTROL to the folder in question.

[grusty]

The account that TM1 runs under is going to need FULL CONTROL to the folder in question.

Ok I'll follow up with our IT and see if that fixes the issue. Thank you for your help I appreciate it!