Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Error reading the dictionary - filename may be invalid

jshah120
6 - Meteoroid

I am working with about 17 .sas7bdat source files. I loaded them in the canvas, created a workflow, multiple joined on a unique ID and generated tableau data extract .tde output file. I am able to successfully perform this for 16 out of 17 sas files. For one of the source sas files, when I load it in canvas I receive an error "Error reading the dictionary - filename may be invalid"

 

There is nothing invalid about the filename (it is in same format as rest of the files) so I am not sure why I am receiving this error. Any thoughts??

 

alteryx error.png

9 REPLIES 9
CristonS
Alteryx Alumni (Retired)

hi @jshah120 - what is the full file name?  Thanks.

jshah120
6 - Meteoroid

C:\Users\jshah\Documents\[...]\f_alerts1.sas7bdat

CristonS
Alteryx Alumni (Retired)

no weird characters in the [...] section?

 

How large are the files?  Does it open correctly in SAS?

jshah120
6 - Meteoroid

No, the location of the folder is same as rest of the other sas files I've used in Alteryx workflow. It's just this one file when I drag into canvas it shows this error.. other files are fine

jshah120
6 - Meteoroid

This alerts.sas file is about 850 MB. It opens correctly in SAS. The other 16 sas files range from 500 KB to 4.4 GB

CristonS
Alteryx Alumni (Retired)

Can you change the location of that one file, for testing purposes? 

jshah120
6 - Meteoroid

That worked! I moved it to Desktop and it loaded it to Alteryx, and it worked just fine. This is so weird!

aljuliano
5 - Atom

I had the same error, but changing the file location didn´t work. 

Any insights as to what may be the problem?

btspl01
5 - Atom

I am also receiving this error even though I am using version 11.7.4 (upgrading was suggested on another thread). I have also tried this solution (reading from desktop) to no avail. Any further ideas on this one?

Labels