Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 20
Registered: ‎08-23-2010

SLX Mobile Error - Invalid column name 'PRIMARYADDRESS', 'ADDRESSTYPE'.

[ Edited ]

New installation of SLX Mobile, on 7.5.4 with Web Update 1,2 & 3.

 

Every account, contact, opp I click on throws the generic mobile error "A server error occurred while requesting data.". Evaluating with Firebug, I can see the actual error - any ideas why its looking for these 2 fields that don't exist?

 

"NHibernate.Exceptions.GenericADOException: could not load an entity: [Sage.SalesLogix.Entities.Address#aQF8AA000VS7][SQL: SELECT address0_.ADDRESSID as ADDRESSID39_0_, address0_.ADDRESS1 as ADDRESS2_39_0_, address0_.ADDRESS2 as ADDRESS3_39_0_, address0_.ADDRESS3 as ADDRESS4_39_0_, address0_.ADDRESS4 as ADDRESS5_39_0_, address0_.CITY as CITY39_0_, address0_.COUNTRY as COUNTRY39_0_, address0_.COUNTY as COUNTY39_0_, address0_.CREATEDATE as CREATEDATE39_0_, address0_.CREATEUSER as CREATEUSER39_0_, address0_.DESCRIPTION as DESCRIP11_39_0_, address0_.ENTITYID as ENTITYID39_0_, address0_.ISMAILING as ISMAILING39_0_, address0_.ISPRIMARY as ISPRIMARY39_0_, address0_.MODIFYDATE as MODIFYDATE39_0_, address0_.MODIFYUSER as MODIFYUSER39_0_, address0_.POSTALCODE as POSTALCODE39_0_, address0_.ROUTING as ROUTING39_0_, address0_.SALUTATION as SALUTATION39_0_, address0_.STATE as STATE39_0_, address0_.TIMEZONE as TIMEZONE39_0_, address0_.TYPE as TYPE39_0_, address0_.CitySTZip as CitySTZip39_0_, address0_.GLOBALSYNCID as GLOBALS24_39_0_, address0_.ERPNAME as ERPNAME39_0_, address0_.TICK as TICK39_0_, address0_.APPID as APPID39_0_, address0_.ADDRESSTYPE as ADDRESS28_39_0_, address0_.PRIMARYADDRESS as PRIMARY29_39_0_ FROM ADDRESS address0_ WHERE address0_.ADDRESSID=?] ---> System.Data.OleDb.OleDbException: Invalid column name 'PRIMARYADDRESS'. : Invalid column name 'ADDRESSTYPE'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Loader.Entity.BatchingEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Load(Object id, Object optionalObject, LockMode lockMode, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.DoLoad(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.ImmediateLoad(String entityName, Object id) at NHibernate.Proxy.AbstractLazyInitializer.Initialize() at NHibernate.Proxy.AbstractLazyInitializer.GetImplementation() at Sage.Platform.NHibernateRepository.Utility.Unwrap(Object instance) at Sage.Platform.NHibernateRepository.Utility.Unwrap[T](T instance) at Sage.Platform.ChangeManagement.ChangeSet.IncludeEntity(IPersistentEntity entity) at Sage.SalesLogix.Orm.EntityBase.ActivateRelatedEntity(Object entity) at Sage.SalesLogix.Entities.Account.get_Address() in c:\Users\administrator\AppData\Roaming\Sage\Platform\Output\implementation\Account.cs:line 2139 at Sage.Integration.Entity.Adapter.AccountRequestHandler.CalculateETagHash(IAccount entity, InclusionNode include, InclusionNode hashInclude, Int64& hash) in c:\Users\administrator\AppData\Roaming\Sage\Platform\Output\sdata\Account.cs:line 1678 at Sage.Platform.SData.RequestHandlerBase`3.UpdateFeedEntryFromEntity(TFeedEntry entry, TEntity entity, InclusionNode include, Boolean includeSchema, Boolean isSingleEntry) at Sage.Platform.SData.RequestHandlerBase`3.CreateFeedEntryFromEntity(TEntity entity, InclusionNode include, Boolean includeSchema, Boolean isSingleEntry)"

Highlighted
New Member
Posts: 20
Registered: ‎08-23-2010

Re: SLX Mobile Error - Invalid column name 'PRIMARYADDRESS', 'ADDRESSTYPE'.

Well I have no idea where those fields came from, but I excluded them from my Address SData feed, compiled & redeployed and it's working now.