Items failed during Preparing Transport/Transporting phase . No error log seen in Event Viewer or cd_transport logs. Noticed that publishing package is not being generated for the items that are failed. Restarting the CM database solved the issue.How to find why items were failed in that phase ? Will there be any logging in the CM database to verify or can it be found in any other logs? (Using Tridion 2013 SP1 version)
Most likely reason for failure in transport phase is connectivity with deployer having issues.
For your error, since it is resolved by restarting CM, it seems you are transporting package on https to deployer and there were issues with certificate for https, which can be resolved by restart of service.
For checking error details you can look at following 3 location:
- Publishing queue, click on failed state to see error.
- Cd_transport log, which can be configured in transport service configure located in bin folder.
- Tridion event log.
The Publisher service is responsible for creating the transport package. In your case the package was not created hinting at an issue with the Publisher service. The Publisher also places a heavy load on the Database as it tries to render the content with the templates, and somewhere in this 'conversation' between the publisher and database things went wrong. Maybe the event viewer or log on the database server has some clues. You can also check the publisher log if it was configured in the MMC snapin.