I’m hoping somebody has run into this before…
I’m on CommandBox 3.8.0+00766 w/ CFconfig and Lucee 5. We’re using CFConfig to connect to a MS SQL 2014 database on another server (the CommandBox stuff is my laptop, SQL database is on a co-lo). I’ve got the datasource variables (server IP, database name, username, password) stored as environment variables. This is all running on Windows 7. That part all seems to be fine. Here’s the weird part…
About two thirds of the time when I do “box start” the site will start up, but I will get this error from Lucee:
Invalid object name ‘tParts’.
…so it can’t find the tParts table, which wouldn’t be weird except that table -is- there and has records in it. And it gets weirder from there. Sometimes it can find that table fine, and finishes that query. But Lucee will move on to another query in the request and I’ll get something like:
Invalid object name ‘tOrderItems’.
…which is also a valid table in the database.
Sometimes it fails when trying to run a query that usese that tParts table. Othertimes it does that okay but fails on a different query looking for a different database table (everything uses the same datasource via CFConfig, it’s all in the same database). It’s almost like the JDBC driver needs a few minutes to finish “finding” all the tables in the database or something.
The reason I think this might be CommandBox related is, I’ve got the same codebase connecting to the same database on a co-lo “QA” web server, and that works fine. The only difference (I think) between my Dev laptop and the QA box is I’m using CommandBox / CFConfig and the QA server isn’t.