Export Table And Copy tools constantly failing in Model Builder

Question

I'm at my wit's end, please someone help. I have a model that has several instances of exporting and/or copying a table, and they are constantly failing and I have no idea why.

First step is to convert a csv to a feature table - that is the only time that works consistently. After that, I run a few field calculates and then try to export the table again, this time with a filter. Before, I had a "select by attribute", and then exported the selected records, but that also failed. Later on in the script, I join the data, remove the join and try to export or copy the result. Fails.

The error message on all of them is "271 Cannot open the input databases"

But... the table is right there, I just did a bunch of work on it. But sure enough, if I try to open the table after I attempt to run the export table or copy tool, it fails to open. But if I open it before I run the tool, It's fine. Something about attempting to run the tool is corrupting the table.

Any suggestions? Please help!

RodCollingwood1 · Answer

I am having the same issue. In my model, I discovered that the file path disappears from the output table or feature name. It doesn't matter if it is set to "memory" or to GDB

OliviaSwientisky · Answer

I am having the same issue!! very frustrated. Please let me know if you were able to find a solution. I can view the table when i am using the suitability analysis tool within BA Online but when i try to open the table outside of the tool within Online and In Pro Desktop it is giving me Failed to Load Data: Error code: 400
Description: Bad syntax in request. Details: 'where' parameter is invalid; im assuming it is because the way the table is formatted but the analysis is useless without being able to view the values. I am not even able to configure the tool tips because of this. Thank you

Robert LeClair · Answer

I found Error 000271:  Cannot open the input datasets page here - maybe this will assist with troubleshooting as it mentions something about a parameter value issue.