"Object reference not set to an instance of an object" when importing from staging tables

Troubleshooting

Problem

Customer is trying to import data from staging tables. As part of this, the customer performs the following tasks: 1. Create an import specification ("import spec") 2. Populate the relevant table (xstagefact) with data 3. Run a SQL script (usp_triggerimportbatchjobs) to create the import batch job Afterwards, user opens the batch queue. The batch job has 'Finished with Error'. To diagnose the problem, user opens the SQL table 'xbatchqueue'. There is an error inside the column 'errtext'.

Symptom

Batch queue:

Finished with error

Error recorded inside 'xbatchqueue' table:

Object reference not set to an instance of an object.(Error occured within method=DoScheduledImport in the module with progid=FrDImportBT.clsExtImport)

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Cognos Controller

Software version:
10.2.0

Operating system(s):
Windows

Document number:
274579

Modified date:
08 May 2025

UID

swg21972912

IBM Support

Tips