Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago
Solved

Connector Rule - Object reference not set to an instance of an object

Hi  I always seem to get an "Object reference not set to an instance of an object" in the error log when I execute data loads that use connector rules. The full error message is:   -------------...
Data Integration
  • MarkBird's avatar
    MarkBird
    2 years ago

    Hey Rob

    FYI, I reached out to support and they confirmed that it is a bug in the current version of OneStream that we are using (we're on 7.0.1).

    "Hi Mark,

    I believe this is a bug that has been fixed in version 7.4. It is caused by the Telemetry Service which provides us with logs. This error does not mean anything is breaking, it is just a false flag. Upgrading is the only way to get rid of this error but if possible, would come with extra benefits like access to Smart Integration Connector (SIC), our new connector service. OneStream is moving to Smart Integration Connector (SIC) for all future integrations and will be a requirement for 8.0 so would be good to have the option of slowly migrating.

    Thanks, Max"

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

Are these declared as instance variables? (declared as part of the class declaration).  If so, consider preceding them with underscores for clarity.   

 

 

 

 

  • MarkBird's avatar
    MarkBird
    Contributor III
    2 years ago

    When I use that function, I get the following error:

    Those are declared as constants

    #Region "Constants and Enumerations"

		Dim connectionName As String = "OneStream BI Blend"		
		
		Dim columnNames As String() = {"Account", "AccountType", "Amount", "Credit", "Debit", "Department", "Entity", "Flow", "IC", "Location", "PLCategory", "SourceID", "UD1_ProfitCentre", "UD2_Category", "UD3_Projects", "UD4_DataAudit"}
		
		Dim columnNamesDrillBack As String() = {"Entity", "EntityDesc", "Period", "Account", "AccountDesc", "AccountType", "Debit", "Credit", "Amount", "Debit", "Credit", "Amount", "PLCategory", "Division", "Department", "DepartmentDesc", "Location", "LocationDesc", "PropertyLocation", "PropertyLocationDesc", "ProjectCode", "ProjectCodeDesc"}
		
		Dim accountTypePL As String() = {"COGS", "DeferExpense", "Expense", "Income", "OthExpense", "OthIncome"}
		Dim accountTypeBS As String() = {"AcctPay", "AcctRec", "Bank", "Equity", "FixedAsset", "OthAsset", "OthCurrAsset", "OthCurrLiab", "NonPosting"}
	
		Dim accountTypeSignFlip As String() = {"Income", "OthIncome", "AcctPay", "Equity", "OthCurrLiab"}
		
#End Region

     

    • MarkBird's avatar
      MarkBird
      Contributor III
      2 years ago

      Changing it to the following worked though:

      MonthName(wfMonth, True)

       

      • RobbSalzmann's avatar
        RobbSalzmann
        Valued Contributor II
        2 years ago

        Your original code uses a subscript that subtracts 1 from wfMonth.  Will this yield the correct month now?