Null value in post processing operation
Best Answer
-
Mike U Posts: 316 Gold 1No worries at all. The only reason I mentioned a support ticket for this is that it's quite specific to your database schema. And I agree, from the sound of it SQL Source Control should have been able to handle having the table and schema dropped at the same time and figured out the dependency ordering correctly. But again, for us to fix some of these complex dependency ordering problems we do need access to your schema definitions.
A support ticket has already been raised for this problem, so someone from the support team should be in touch with you directly soon. If you ever do need to raise a support request, you can do that directly at https://productsupport.red-gate.comDevelopment Lead
Redgate Software
Answers
I have sent another error log via your feedback system. Can someone please look into this as the product is not functional at all at the moment.
Many thanks
If you need more help diagnosing the problem, then we'll need a copy of your scripts folder to figure out which objects are inconsistent - so that's probably best handled through a support ticket rather than on a public forum.
Redgate Software
The problem seems to have been because an unwanted table and corresponding schema was dropped at the same time. SourceControl worked fine once the schema was added back in. Then changes could be committed, the schema dropped again and that change could finally be committed.
I consider this a bug in so much as I expected SourceControl to figure out it needed to resolve the table drop first, then the schema. Do you agree or at least feel the error information could be more helpful?
Sorry I thought this was for raising a support ticket. As your products are so reliable I can't ever call raising a support request before. In future I'll find the right process for doing so!
Thanks
Tom