You are correct on all counts … including the missing one critical step part (unfortunately the fault lies with us on this one). So, basically you create an empty database in SQL Server, follow the guidelines in the comments of the sample properties file so that your file looks something like this:
(Note that your DB password will become encrypted on server startup.)
Now, don’t move the files, but (and this is the one critical missing piece) along with removing the “.sample” portion of the filename, you will also need to add an “s” after “datasource” so that the filenames are:
perc-datasources.properties perc-datasources.xml
This was an oversight in this release, and will be corrected in our next release. But yes, once this is all setup, simply stopping then starting CM1 (and in so doing, your DTS server) will cause your DTS server to connect to the database specified and create all of the needed tables, etc.
Let me know if you run into any issues setting this up.</db_password></db_username></database_name></host_name>
Oliver, great tips, thanks for sharing! Yes, the feeds log file is essential in troubleshooting this configuration – I was surprised to re-read my message and realize I hadn’t pointed that out.
Before I do this, I have a question.
During install I created a SQL db tied to the installation. Is this a separate animal altogether and do I continue to do what this post says? If it is separate, what’s the difference and usage?
And, yes, that was two questions. See how I am.
Yes you will need a separate database for the DTS Tomcat server. Because I know that you have everything (IIS, DTS, CM1, SQL Server) running on the same box, I imagine you will just want to create a new database on the same instance of SQL Server that houses your CM1 database, and point your DTS server to that.
Tables are not being created and the feeds log shows multiple errors including this one : ‘WARNING: Could not load properties from URL [file:C:/Percussion/Deployment/Server/conf/perc/perc-datasources.properties]: C:\Percussion\Deployment\Server\conf\perc\perc-datasources.properties (The system cannot find the file specified)’.
The file is in the structure.
For reference: SQL Server is on a different box
In my response to Oliver, I mentioned a known issue where, in addition to removing the “.sample” portion of the file name, you also need to add an “s” before the file extension. Let me know if you’ve already done this. (Definite tripping point, I know.)
In that case I will reach out to you through our existing support ticket so we can take a closer look into what’s going wrong here. Please check your inbox shortly.
To tie off the loop here, we found that the cause of the original issue was that Lloyd’s server was using the default Windows Server configuration where it hides file extension names, so the when the properties file appeared to him as"perc-datasources.properties", in reality “perc-datasources.properties.properties” was sitting on the filesystem. This, of course, led to this error:
WARNING: Could not load properties from URL [file:C:/Percussion/Deployment/Server/conf/perc/perc-datasources.properties]: C:\Percussion\Deployment\Server\conf\perc\perc-datasources.properties (The system cannot find the file specified)'.
Correcting the file name resolved the first problem, but next we encountered this error:
At this point I asked Lloyd to run a command to see if his SQL Server instance was running on the default port 1433. Lloyd discovered that it was not, and so he updated his database connection URL in his perc-datasources.properties with the correct port, and at that point everything started up fully.
I tried this on my setup and it’s not working. I’m getting a lot of “Completed with Failures” in percussion after making the change, restarting DTS and then doing a full site publish.
Please take a look in your feeds.log file located at {dts_root}\Deployment\Server\logs to see if the DTS Tomcat is successfully connecting to your specified database. Sounds like it may not be. Also, please View Details on these failed publishes and let me know what the exact error is, in case this may be something else. Thanks!
Try deleting the file and then stop then start your DTS instance. This will recreate the log file. I’m guessing the publish operation might have caused the log file to explode on you.
As to your metadata errors, can you share the full error? There are a number of causes for this type of error, so I want to know which variety we’re dealing with.
Okay. Wow. I found out what the issue was. I left the checkbox checked for user must change their password on the account I created in MSSQL for the db. Oops. Thanks for pointing me to the log file.
