Datastream failed permanently, GLOBAL_UNKNOWN error

[florianv]

Hi everyone,

We have a datastream instance connecting to an on-prem SQL server. Everything was running well until we had an issue within the source instance, which forced us to recover the stream after it failed. 
The stream was not able to recover correctly, and is now still in a Failed Permanently state. We are not able to recover nor delete the instance. We tried deleting it through the console and API, but we're getting the following error:

```
This error response matches on the unknownErrorFn matcher function at the global level on error code GLOBAL_UNKNOWN.
```
Additionally, when going to the stream page, there is no error specified. This seems to be an unexpected internal error.
 

Any idea how to proceed from there? We want to make sure we can delete this stream before creating a new one.

Thank you 

[ChieKo]

Hi @florianv,

Welcome to the Google Cloud community!

Here are some things you can try to troubleshoot the unknown error you are getting in your Datastream.

• Check Datastream Console:
• Carefully review the Datastream console for any specific error messages associated with the failed stream. Look for details in the stream's overview, logs, or any recent events.
• Examine Cloud Logging:
• Search Cloud Logging for any error messages related to the Datastream instance, the source database, or any related Google Cloud services. Filter logs by the Datastream instance ID or resource type.
• Review or Modify Source Database:
• Investigate or modify the source database for any ongoing issues, such as replication errors, connectivity problems, or database corruption.

You might want to try to check a similar post by @ms4446 regarding Datastream.

If the workarounds above don't work, you can contact Google Cloud Support for a more in-depth analysis. When contacting them, please provide comprehensive details and include screenshots. This will help them better understand and address your issue. 

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.