I start this page in order to reference all error message/code you can get with TDM Portal, and what could be the main reason and solution in order to overpass it. Please fill free to complete.
And don't forget : "An expert is a man who has made all the mistakes which can be made, in a narrow field."
With this kind of table, we can all become experts ;-)
Call to ConnectionManagerService failed: :HttpClientErrorException: 403 Forbidden
The TCP/IP connection to the host ***,port 1433 has failed. Error: "connect timed out.Verify the connection properties. Make sure that an instance of SQL Serveris running on the hostand accepting TCP/IP connections at the port. Make sure that TCP connections to the portare not blocked by a firewall.
For sure, you should first check your SQL server connection and Windows/network firewall.
But If you use SQLSERVEREXPRESS, this could be linked also to the fact that is uses dynamic ports by default. 2 ways to solve, easy one is you specify instance and no ports in TDM configuration. more complex one is to configure static port in you SQLEXPRESS configuration manager instead of dynamic ones. cf. http://web.synametrics.com/sqlexpressremote.htm
Deferred publish of table *** failedbecause no stored data was found for it
This happens when you try to publish from the portal, one of your publish result table is empty and you have operations in this table that links it to other tables that aren't empty.
This is in the pipe for correction by product management, for the moment, the only solution to is to use the old publish either by using Datamaker directly, or changing configuration of TDM portal to use old publish.
ERROR: Publish failed for job ***,Call to ConnectionManagerService failed: :HttpClientErrorException: 404 Not Found
Thanks Dimitris Finas for this post, i am getting new errors in TDM portal. While submitting the request for Test Matching i am getting error 500. No other information available.
Also i am getting error while pulling the requests saying "Failed to get the list of request. Refer lots for more information". From logs i am not able to figure out what is the issue.
Can you provide your inputs on this.
HTTP 500 error is generic, and so it's very difficult to know exactly where it's coming from.
In order to do so, I would first check that all my TDM services are running well (CA Remote Publish, CA TDoD), then check that my test match is already running well from Datamaker (remove all source of errors, except portal).
Then, push logs to DEBUG level (update TDM portal configuration file logback-tdm.properties). This is also documented here Enable DEBUG mode. After that, stop TDM portal, delete all logs and restart, and do your test match again.
You should now have more information to understand when and why it fails.
Thank you for this troubleshooting post. It might also be helpful to point out in the Resolution for the issue "ConnectionManagerService failed" that this error can also occur or a similar error (ConnectionManagerService failed: : HttpClientErrorException: 404 Not Found) even if the user is authorized in the Portal to access the connection profile. This also happens when the connection profile has been originally created in Datamaker instead of the Portal. There is a note in the product documentation that states to use the connection in Publish action in the portal, the connection profile must have been created in the TDM Portal and not within Datamaker.
Completely agree, I added it