This question is locked. New answers and comments are not allowed.
Dear all : any help me please ,
I have a problem with junker table which it represented in Open Access as a collection
I work with open-access 2011 , file version : 2011, 3, 1129, 2
I get error when return the collection list from object entity
============
the error is :
Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.
Stack Trace:
[SQLException: Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.]
Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() +499
OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() +118
OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() +152
[DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL:
SELECT b.[UserId] AS COL1, c.[GroupId] AS COL2, c.[SectionId] AS COL3 FROM [AdminSchema].[LookUpUser] a JOIN [UserMapGroup] AS b ON (a.[UserId] = b.[UserId]) JOIN [AdminSchema].[LookupGroup] AS c ON (b.[GroupId] = c.[GroupId]) WHERE a.[UserId] = ? ORDER BY b.[UserId] Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()]
Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) +28
OpenAccessRuntime.ExceptionWrapper.Throw() +34
OpenAccessRuntime.DataObjects.PCStateMan.handleException(Exception x) +90
OpenAccessRuntime.DataObjects.PCStateMan.getObjectFieldImp(PersistenceCapable pc, FieldMetaData fmd, Object currentValue) +189
OpenAccessRuntime.DataObjects.PCStateMan.GetObjectField(PersistenceCapable pc, Int32 field, Object currentValue) +69
OpenAccessRuntime.DataObjects.SynchronizedStateManagerProxy.GetObjectField(PersistenceCapable pc, Int32 field, Object currentValue) +196
Arcom.OA.NewsWizV4AdminEntity.LookUpUser.OpenAccessEnhancedGetuserMapGroup(LookUpUser ) +123
Arcom.OA.NewsWizV4AdminEntity.LookUpUser.get_UserMapGroups() in C:\Mohany-SpaWS\Arcom.Projects.NewsWiz\Arcom.OA.NewsWizV4AdminEntity\LookUpUser.cs:201
Arcom.NewsWiz.Admin.ServiceAdmin.userAdmin.UserOnFoucs.FillRadListBoxUserGroups() in C:\Mohany-SpaWS\Arcom.Projects.NewsWiz\Arcom.NewsWiz.Admin\ServiceAdmin\userAdmin\UserOnFoucs.aspx.cs:46
Arcom.NewsWiz.Admin.ServiceAdmin.userAdmin.UserOnFoucs.Page_Load(Object sender, EventArgs e) in C:\Mohany-SpaWS\Arcom.Projects.NewsWiz\Arcom.NewsWiz.Admin\ServiceAdmin\userAdmin\UserOnFoucs.aspx.cs:30
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +37
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +95
System.Web.UI.Control.OnLoad(EventArgs e) +145
System.Web.UI.Control.LoadRecursive() +134
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3412
I have a problem with junker table which it represented in Open Access as a collection
I work with open-access 2011 , file version : 2011, 3, 1129, 2
I get error when return the collection list from object entity
============
the error is :
Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.
note: ["UserMapGroup" - is the Collection Object between table User and group]
Stack Trace:
[SQLException: Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.]
Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() +499
OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() +118
OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() +152
[DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL:
SELECT b.[UserId] AS COL1, c.[GroupId] AS COL2, c.[SectionId] AS COL3 FROM [AdminSchema].[LookUpUser] a JOIN [UserMapGroup] AS b ON (a.[UserId] = b.[UserId]) JOIN [AdminSchema].[LookupGroup] AS c ON (b.[GroupId] = c.[GroupId]) WHERE a.[UserId] = ? ORDER BY b.[UserId] Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'UserMapGroup'.
Statement(s) could not be prepared.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()]
Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) +28
OpenAccessRuntime.ExceptionWrapper.Throw() +34
OpenAccessRuntime.DataObjects.PCStateMan.handleException(Exception x) +90
OpenAccessRuntime.DataObjects.PCStateMan.getObjectFieldImp(PersistenceCapable pc, FieldMetaData fmd, Object currentValue) +189
OpenAccessRuntime.DataObjects.PCStateMan.GetObjectField(PersistenceCapable pc, Int32 field, Object currentValue) +69
OpenAccessRuntime.DataObjects.SynchronizedStateManagerProxy.GetObjectField(PersistenceCapable pc, Int32 field, Object currentValue) +196
Arcom.OA.NewsWizV4AdminEntity.LookUpUser.OpenAccessEnhancedGetuserMapGroup(LookUpUser ) +123
Arcom.OA.NewsWizV4AdminEntity.LookUpUser.get_UserMapGroups() in C:\Mohany-SpaWS\Arcom.Projects.NewsWiz\Arcom.OA.NewsWizV4AdminEntity\LookUpUser.cs:201
Arcom.NewsWiz.Admin.ServiceAdmin.userAdmin.UserOnFoucs.FillRadListBoxUserGroups() in C:\Mohany-SpaWS\Arcom.Projects.NewsWiz\Arcom.NewsWiz.Admin\ServiceAdmin\userAdmin\UserOnFoucs.aspx.cs:46
Arcom.NewsWiz.Admin.ServiceAdmin.userAdmin.UserOnFoucs.Page_Load(Object sender, EventArgs e) in C:\Mohany-SpaWS\Arcom.Projects.NewsWiz\Arcom.NewsWiz.Admin\ServiceAdmin\userAdmin\UserOnFoucs.aspx.cs:30
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +37
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +95
System.Web.UI.Control.OnLoad(EventArgs e) +145
System.Web.UI.Control.LoadRecursive() +134
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3412