Sage Enterprise Intelligence Error

Posted By Karabo2020 over 1 year ago

Good day.

Please assist with the below error. When I run some dashboards like the Tb, Income statement and so on the below error Occurs.

If anyone has came across this error before, Please assist.

"Object reference not set to an instance of an object".

Trial Balance×

Trial Balance

Pre-Fetching

Object reference not set to an instance of an object.

Object reference not set to an instance of an object. Nectari.Common.BusinessEntities +++>> at Nectari.BusinessEntities.SqlGenerator.GetSqlCoalesce(String value) at Nectari.BusinessEntities.SqlGenerator.GetDescription(IProcessField field) at Nectari.BusinessEntities.SqlGenerator.GetTitleCodeDescription(IProcessField field) at Nectari.BusinessEntities.SqlGenerator.SetGroup() at Nectari.BusinessEntities.SqlGenerator.GetSelectionForCurrentGroup() at Nectari.BusinessEntities.SqlGenerator.GetSelect() at Nectari.BusinessEntities.SqlGenerator.GetSQLStatement() at Nectari.BusinessEntities.SqlGenerator.get_ToSqlStatement() at Nectari.Services.NectariService.GenerateProcessViewStatement(String loginToken, String envID, BIProcess process, ViewEntity processView, SqlGenerationType sqlGenType, String& statement, String& statementSelectList, SqlGenerator& sqlGen, INectariTraceEvent& eventEntity, String& bestSlice)

Top Replies

Qeqesha over 1 year ago +1

Hello Karabo,

Is the GL Trial Balance view working(Data Models and vies->Finance->GL Transaction Details (x3v7 and up)->)?

Check on your Administration-> Env. & Data Sources set up. and re-run…

Parents

0 Qeqesha over 1 year ago

Hello Karabo,

Is the GL Trial Balance view working(Data Models and vies->Finance->GL Transaction Details (x3v7 and up)->)?

Check on your Administration-> Env. & Data Sources set up. and re-run the global scripts
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Karabo2020 over 1 year ago in reply to Qeqesha

Hi Qeqesha,

I connected the OLAp data source but in the global scripts there are no finance related scripts.

Please assist on how to generate these finance scripts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Qeqesha over 1 year ago in reply to Karabo2020

(1) The yellow highlighted icon on the screen shot I sent before runs these scripts when clicked on.

(2) Make sure you have an OLAP license.

(3) Build and Load the OLAP cube by following onlinehelp.sageenterpriseintelligence.com/.../SageX3-olap-cubes.htm
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Qeqesha over 1 year ago in reply to Karabo2020

(1) The yellow highlighted icon on the screen shot I sent before runs these scripts when clicked on.

(2) Make sure you have an OLAP license.

(3) Build and Load the OLAP cube by following onlinehelp.sageenterpriseintelligence.com/.../SageX3-olap-cubes.htm
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage X3 Africa and Middle East

Sage Enterprise Intelligence Error

Pre-Fetching

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING