Skip to main content

Qlik Compose for Data Warehouses

Discussion board for collaboration on Qlik Compose for Data Warehouses.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aspence
Partner - Contributor II
Partner - Contributor II

General exception - Logs reference column/object that's not in data source

Hi! 

Testing out compose and have gotten an error that I after a lot of troubleshooting still don't understand. 

In the web gui I get this:

 

image.png

And when searching the logs I can find the corresponding error here:

82 2021-12-09 13:49:12 [Host           ] [WARN ] Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at Attunity.Compose.BwAutomationManager.ETLUtil.ExpressionRolesDictionary(List`1 columnExpList, List`1 entityStagingInfo)
   at Attunity.Compose.BwAutomationManager.ETLsImp.StagingETLsImp.A(Int32 , List`1 , Boolean )
   at Attunity.Compose.BwAutomationManager.ETLsImp.StagingETLsImp.A(Int32 )
   at Attunity.Compose.BwAutomationManager.ETLsImp.StagingETLsImp.A(EntEtlInfo , List`1 , List`1 , List`1 )
   at Attunity.Compose.BwAutomationManager.ETLsImp.StagingETLsImp.HandleStagingAndErrorMarts(List`1 createdScriptsNames)
   at Attunity.Compose.BwAutomationManager.ETL.A(Int32 , List`1 )
   at Attunity.Compose.BwAutomationManager.ETL.GenerateETL(Int32 etlID, String userName, List`1 createdScriptsNames)
   at Attunity.Compose.BwAutomationManager.DataWarehouseRestImp.GenerateDWHETLs(GenerateDWHETLsParams param, GenerateDWHETLsReq req)

 
The thing is, userName  (which I assume is the culprit) is not a field in our data source. Nor is it something I've mapped to.

The error is consistent and repeated in the logs, they all look the same. 

Is userName an internal object that it can't find? Any ideas?

Labels (1)
1 Reply
aj96
Contributor III
Contributor III

Hi @aspence 

On the mapping window Click on the change view and see if any the column is having an empty Lookup or Expression. Like below

aj96_3-1639507657576.png

 

aj96_1-1639507494246.png

If you do then create an expression and click on the cross button to delete it 

aj96_2-1639507575968.png

Or map something to that column. That should fix the issue.