Service Graph Connector - GCP is getting stuck at VM Instance schedule

[Rashmika BS]

Hi, 

We have installed the SG-GCP plugin, when we run the schedule, the GCP runs fine till storage volume , fetches the details but when it tries to run the VM instance schedule job, its getting stuck at loading and getting cancelled without any error message. Please advise

Thank you

[Rohit N]

Hi @Rashmika BS,

We recently encountered the same issue with SG-GCP and identified the root cause.

SG-GCP checks the Sys Object Source table to determine whether a VM already exists by performing a lookup using only the ID field. Since the ID field was not indexed in our environment, these lookups became very slow, causing the SG-GCP VM job to remain in the Loading state for an extended period and eventually get cancelled.

As a workaround, we created a non-unique index on the ID field in the Sys Object Source table. After adding the index, the VM job processing time improved significantly and the issue was resolved.

In my view, this lookup design could be improved by using a combination of Name & ID, similar to how IRE performs the lookups.

Best Regards,

Rohit Naik