I recently created 2 additional relationship classes between one of my SDE tables and 2 feature classes. Since doing this I cannot upload the data as a feature service, I get a "Consolidating the Data Failed" error. I've found that removing one of the relationship classes so that there is only one relationship referencing the database table allows it to upload. Is this a known bug where a feature service cannot have multiple relationship classes using the same data source? Is there a known workaround other than creating a redundant database table for the second relationship class?
Can you provide more details to this workflow. Such as What version ArcGIS Server and the SDE is at? How many relationships existed before adding additional relationship classes? Also, are you using a composite or simple relationship class? Lastly what does this issue persist if you change the relationship class to focus on another attribute column?