datasource delete fails at docker image startup

@ecarey: What is the suggested way to delete unwanted datasources at setup?

I would first complete setup, then delete unwanted datasources afterwards.

I can confirm that

1) there is nothing wrong with the code you mentioned;

2) your code probably worked as expected;

3) you got the error because, when you ran the code, there was no cfartgallery datasource; it either had not been configured or had been deleted earlier.

I copied the same code and ran it as follows:

<cfscript>
    adminObj = createObject("component","CFIDE.adminapi.administrator");
    adminObj.login("my_cfAdmin_password"); 
    
    // Create datasource object
    datasource = createObject("component", "CFIDE.adminapi.datasource");
   
    // delete datasource movedb
    datasource.deleteDatasource("movedb");
   
   //writedump(datasource.getdatasources())
</cfscript>

The result is that it deleted the datasource movedb, as expected. The dump confirmed this.

When I ran the same code again, I got an error identical to yours:

ecarey :"What is the suggested way to delete unwanted datasources at setup?"

Without code certainly!

Open the ColdFusion Administrator.

Go to the datasources page.

Click on the delete button of the datasource concerned.

And you're done in under 10 seconds. 🙂

My broader suggestion is that whenever you have something where you're not sure whether it's going to work or not, you wrap it in an exception handler and move on. So, you'd try your DB remove, and catch the failure (if it fails), and you'd be able to read the failure reason in the CFCATCH structure. If it's because the DB doesn't exist, you're all set and you can treat that as a normal outcome and keep going. If it's for some other reason, then you have to figure out how to respond to that other reason.

Dave Watts, Eidolon LLC