Tridion 2011 SP1 UGC

The error "Saving comment failed" usually indicates that the end point of the UGC Content Delivery Web service is not correctly configured or not accesible from the CM server.

Make sure that after changing the ..\Tridion\web\WebUI\Models\UGC\Configuration\DataSources.xml file, you restart IIS so this updated configuration is read. Clearing your browser cache and reloading the CME also can't hurt.

The ugc_dao_bundle.xml file is a real file, but it is located inside the ugc_storage.jar, so as long as that is in your lib folder, you should be fine.

The issue was that I was publishing a specific publication that had it's own entry in cd_storage_conf. This specific entry was being picked up as my pages were being published correctly, however, the UGC item typeMappings in the specific publication weren't being picked up so UGC entries were going to the default storage which is the broker DB ,hence, the Invalid object name error.

The UGC item typeMappings only appear to be picked up if I move them out of the specific publication node in the config and into the main ItemTypes node. Not sure why this would be the case though.