Skip to content
logo Knowledgebase

SEI All Cubes' worksheets fail with an Invalid object name 'SEICUBE.[X3 folder name].[Cube name]'.

Created on  | Last modified on 

Description

You may also receive following errors:

  • The BI Service log shows: "The multi-part identifier "X3SALESX|fieldname".
  • New SEI install: Error - 'Object reference not set to an instance of an object' when attempting to access any report or dashboard
    Object reference not set to an instance of an object. Nectari.Common.DataService +++>> at Nectari.DataAccess.DataService.GetDBMetaData(DbConnection oleDbConn, Boolean resetCache) at Nectari.DataAccess.DataServiceBase.GetSQLInfo(DbConnection oleDbConn, String statementSelectlist, Dictionary`2 MappingAliasTableDictionary, DataTable requestSchemaTable) at Nectari.DataAccess.SqlDataService.GetSQLInfo(String statementSelectlist, Dictionary`2 MappingAliasTableDictionary, DataTable requestSchemaTable) at Nectari.DataAccess.DALBase`2.SetMetaData(String statementSelectlist, Dictionary`2 MappingAliasTableDictionary, IDataReader reader) at Nectari.DAL.RequestDAL.SQLGetInfoColumnsBySelectList() at Nectari.Services.NectariService.SQLGetInfoColumns(String statementToken, INectariTraceEvent& eventEntity)

Cause

The Data Source definition for the SEICube has its Database name as SEICUBE; however, in SQL it is named SEICube.

The capitalization must be the same.

Resolution

  1. Open SEI
  2. Administration, Manage Env. & D.S.
    1. Select the Cube Data Source
      • Correct the Database Schema Name
    2. Save
    3. On the applicable environment (Production, Pilot, Seed, etc.)
      • Click the refresh button to the right of the environment's name, in the Environments section of the screen.
    4. In Execute Scripts screen fill in at least these parameters
      • X3 Database (SQL Server Only)
      • Schema for Custom Objects
      • X3 Schema (Folder)
    5. Run
  3. Administration, OLAP Manager
    1. Manage Cubes
    2. Action = Build
    3. Environments = [select appropriate one]
    4. Select all Cubes (checkbox, top left of window)
    5. Confirm