koushik_vmware
Enthusiast
Enthusiast

Catalog Request stuck in "Requested" status and not able to procceed further

Hello All,

Suddenly our vRA7 set up is having issue with deployment. I requested the catalog item but it is stuck in "Requested" state.

I followed the below KB but not resolved.

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=21457...

Also, follow the below link,but also not able to resolved.

Blueprint status "In Progress" for over hours and Machine status is Requested on Managed machines in...

I found the below error " Cannot insert the value NULL into column 'VirtualMachineName', table 'vra.dbo.VirtualMachine'" in the model manager log.  Does this error relate to the issue ?

Not sure why this error came ? Can you please help me how to resolve this issue so that Request can proceed to next steps ( Building >> Provisioning > etc) ?

Please let me know if you need more details.

[UTC:2016-11-02 07:16:14 Local:2016-11-02 03:16:14] [Trace]: Thread-Id="19" - context=""  token="" Processing ping report, report queue depth is 0

[UTC:2016-11-02 07:16:15 Local:2016-11-02 03:16:15] [Trace]: Thread-Id="14" - context=""  token="" VMO: 00:00:00.0156290 elapsed: requested: 10 machines processing started

[UTC:2016-11-02 07:16:15 Local:2016-11-02 03:16:15] [Info]: Thread-Id="14" - context=""  token="" Machine ID 641739f4-ef66-4c7d-b722-3b0fb5eccfd2, Event name Provision: Waiting for workflow event to complete ...

[UTC:2016-11-02 07:16:16 Local:2016-11-02 03:16:16] [Info]: Thread-Id="14" - context=""  token="" Machine ID 641739f4-ef66-4c7d-b722-3b0fb5eccfd2, Event name Provision: Workflow event completed

[UTC:2016-11-02 07:16:16 Local:2016-11-02 03:16:16] [Debug]: Thread-Id="10" - context=""  token="" System.Workflow.Runtime.Hosting.PersistenceException: Error occurred while executing stored proc usp_UpdateVirtualMachineWithState Cannot insert the value NULL into column 'VirtualMachineName', table 'vra.dbo.VirtualMachine'; column does not allow nulls. UPDATE fails.

The statement has been terminated. ---> System.ApplicationException: Error occurred while executing stored proc usp_UpdateVirtualMachineWithState Cannot insert the value NULL into column 'VirtualMachineName', table 'vra.dbo.VirtualMachine'; column does not allow nulls. UPDATE fails.

The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'VirtualMachineName', table 'vra.dbo.VirtualMachine'; column does not allow nulls. UPDATE fails.

The statement has been terminated.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at DynamicOps.VMPS.DataAccess.ConnectionFactory.ExecuteNonQuery(String storedProcedure, SqlParameter[] collection)

   --- End of inner exception stack trace ---

   at DynamicOps.VMPS.DataAccess.ConnectionFactory.ExecuteNonQuery(String storedProcedure, SqlParameter[] collection)

   at DynamicOps.VMPS.DataAccess.DataAccessLayer.SaveVirtualMachine(VirtualMachineEx virtualMachine, Boolean saveProperties, Boolean saveState)

   at DynamicOps.VMPS.Service.VrmWorkflowPersistenceService.<>c__DisplayClass2.<SaveWorkflowInstanceState>b__0()

   at DynamicOps.Common.Exceptions.RetryTransactionException.RetryIfNecessary(Action action)

   at DynamicOps.VMPS.Service.VrmWorkflowPersistenceService.SaveWorkflowInstanceState(Activity rootActivity, Boolean unlock)

   at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)

   --- End of inner exception stack trace ---

   at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)

   at System.Workflow.Runtime.WorkflowExecutor.ProtectedPersist(Boolean unlock)

INNER EXCEPTION: System.ApplicationException: Error occurred while executing stored proc usp_UpdateVirtualMachineWithState Cannot insert the value NULL into column 'VirtualMachineName', table 'vra.dbo.VirtualMachine'; column does not allow nulls. UPDATE fails.

The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'VirtualMachineName', table 'vra.dbo.VirtualMachine'; column does not allow nulls. UPDATE fails. The statement has been terminated.

Thanks,

KM

0 Kudos
0 Replies