- VMware Technology Network
- :
- Cloud & SDDC
- :
- VMware Aria Automation
- :
- VMware Aria Automation Tools Discussions
- :
- Catalog Request stuck in "Requested" status and no...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Also, follow the below link,but also not able to resolved.
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