0

An unexpected error has occured: Value cannot be Null

Jet Reports Historic Posts

July 06, 2015 13:12

None

Follow

Hi all,

the solution:

It appears that the error is being caused by blank, empty or null values in the Code field (Dimension Code) of the Dimension Value table (table number 349).
Values are pulled directly from this table in order to query the dimension value.
If that value is blank, empty or null you will receive the Argument Null Exception error.
Our assumption is that the values must be incomplete in the database's Dimension Value table.
I would recommend having the person that handles your NAV database look into resolving this issue by making the necessary modifications to this table.
e.g.
dbo.CRONUS Mexico S_A_$Dimension Value
dbo.CRONUS Canada, Inc_$Dimension Value
dbo.CRONUS USA, Inc_$Dimension Value

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 06, 2015 13:12

  Hello together,
  
  I tried to run a simple Jet Report (customer list with No and Name) and get the following error message (Datasource is NAV2013R2, Jet Version is 15.0.14295.0.)
  
  —————————
  Jet Essentials
  —————————
  An unexpected error has occurred:
  
  Value cannot be null.
  
  Parameter name: code
  
  System.ArgumentNullException
  
  at Jet.Data.Nav.NavGlobalDimension..ctor(Int32 A_0, String A_1, String A_2, String A_3)
  
  at Jet.Data.Nav.NavSqlDataSource.y()
  
  at aj.c(Object A_0, cb A_1)
  
  at a5.c(cb A_0)
  
  at a5.c()
  
  at Jet.Data.Nav.NavSqlDataSource.a(String A_0, String A_1)
  
  at Jet.Data.Nav.NavSqlDataSource.f(NavTableInfo A_0, XElement A_1, Int32 A_2, NavFieldInfo& A_3)
  
  at Jet.Data.Nav.NavSqlDataSource.b(NavTableInfo A_0)
  
  at aj.a(Object A_0, j A_1)
  
  at d6.a(j A_0)
  
  at Jet.Data.Nav.NavTableInfo.get_NavFields()
  
  at Jet.Data.Nav.NavRtcDataSourceBase.m.r()
  
  at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  
  at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  
  at Jet.Data.Nav.NavRtcDataSourceBase.a(NavTableInfo A_0, XElement A_1, NavKey& A_2, NavKey A_3)
  
  at Jet.Data.Nav.NavRtcDataSourceBase.a(NavTableInfo A_0, XElement[] A_1)
  
  at Jet.Data.Nav.NavRtcDataSourceBase.a(NavTableInfo A_0, XElement A_1, NavKey[]& A_2)
  
  at Jet.Data.Nav.NavSqlDataSource.m(NavTableInfo A_0)
  
  at aj.a(Object A_0, fr A_1)
  
  at Jet.Data.Nav.NavTableInfo.OnKeysRequested(fr e)
  
  at Jet.Data.Nav.NavTableInfo.get_Keys()
  
  at Jet.Data.Nav.NavTableInfo.get_PrimaryKey()
  
  at Jet.Data.Nav.NavSqlDataSource.a(f2 A_0, Boolean A_1, hk& A_2, NavTableInfo& A_3, e& A_4, List`1& A_5, Int32& A_6, bn& A_7)
  
  at Jet.Data.Nav.NavSqlDataSource.ax(f0 A_0)
  
  at bz.ExecuteQuery(f2 query)
  
  at Jet.Data.Nav.NavSqlDataSource.ExecuteQuery(f2 query)
  
  at Jet.JetDispatcher.a(du A_0, IJetDataSource A_1)
  
  at Jet.JetDispatcher.a(du A_0, Boolean A_1, Boolean A_2)
  
  at Jet.JetDispatcher.f(du A_0, Boolean A_1)
  
  at Jet.JetDispatcher.e(Object[] A_0)
  
  
  —————————
  OK
  —————————
  
  Thank you in advance.