I’ve currently got an enterprise cluster that I have been developing some queries and code against. My queries have worked great against this cluster, but we’ve decided we want a separate cluster for the data that I am storing. We set up a community cluster, and I pointed my code to this new cluster. I can create and remove objects, but any time I execute a SELECT query I get a “4040 No such prepared statement”. If I execute a PREPARED statement, the error obviously goes away the next time I execute the query, but I have never had to do this on my other cluster and have written dozens of queries against that cluster. The same queries that are receiving the 4040 error on the community cluster don’t have this issue on the enterprise cluster.
Any ideas? I’ve compared the service level query settings and they are all the same between the two servers. I followed the tips listed on the 4040 issue when upgrading to 6.5 page, and I’ve restarted both my service and the cluster a couple of times now. I also need to try the “auto-prepare” service-level query setting, but as I understand that is disabled for queries with parameters, and I use several queries with named parameters. My enterprise cluster also has that set to false and is working fine.