Solved

Error during deployment semantic layer azure analysis services

  • 10 January 2023
  • 1 reply
  • 102 views

Badge

Hi,

During deployment of the semantic model in TimeXtender 6024.1 an error occured.

Finished executing instance 'SSL Test' Execution Package 'Execution Queue Default'
Execution failed
Start Time : 1/10/2023 12:05:34 PM End Time : 1/10/2023 12:05:36 PM on server: vm-tx-prod-01
-Execute Execution Package Execution Queue Default 'Failed'
    Object reference not set to an instance of an object.
    
    Details:
    
    Object reference not set to an instance of an object.
    Module: TimeXtender.Semantic.Logic
    System.NullReferenceException
       at TimeXtender.Semantic.TOMEndpointDeployExecute.GetColumn(SharedSemanticLayerField field, Table parentTable, SharedSemanticLayerEndpointTOM endpointTOM, Dictionary`2 columnCache)
       at TimeXtender.Semantic.TOMEndpointDeployExecute.CreateModel(SharedSemanticLayerEndpointTOM endpointModel, Boolean isDeployment, Boolean forCheckSum)
       at TimeXtender.Semantic.TOMEndpointDeployExecute.Execute(SharedSemanticLayerEndpointTOM endpointModel)
       at TimeXtender.Semantic.StepEndpointExecute.DoAbstractStep(IStepSetup stepSetup)
    
Execute SSL Test:Info:Initialized
  -Execute SSL Test
Execute TabularEndpoint endpoint Azure Analysis Services - Test:Error:Failed
    -Execute TabularEndpoint endpoint Azure Analysis Services - Test 'Failed'
        Object reference not set to an instance of an object.
        
        Details:
        
        Object reference not set to an instance of an object.
        Module: TimeXtender.Semantic.Logic
        System.NullReferenceException
           at TimeXtender.Semantic.TOMEndpointDeployExecute.GetColumn(SharedSemanticLayerField field, Table parentTable, SharedSemanticLayerEndpointTOM endpointTOM, Dictionary`2 columnCache)
           at TimeXtender.Semantic.TOMEndpointDeployExecute.CreateModel(SharedSemanticLayerEndpointTOM endpointModel, Boolean isDeployment, Boolean forCheckSum)
           at TimeXtender.Semantic.TOMEndpointDeployExecute.Execute(SharedSemanticLayerEndpointTOM endpointModel)
           at TimeXtender.Semantic.StepEndpointExecute.DoAbstractStep(IStepSetup stepSetup)
        

No child steps

We solved this by removing and adding the tables again.
What’s the best way to determine the cause of the error when it occurs next time?

Kind regards Michel

 

icon

Best answer by Christian Hauggaard 10 January 2023, 18:13

View original

1 reply

Userlevel 6
Badge +5

Hi

 

I am glad to hear that the issue has been resolved. The error message appears to indicate a failure on execution, rather than deployment. 

 

Do you know if there were any other settings that were changed when you removed and re-added the tables? If it occurs again, or if you encounter a similar issue, I recommend trying to isolate the issue, by narrowing down the error to a particular table, field or setting (e.g. security roles) within the semantic model.

Reply