We are trying to move closed jobs in PJ (Project Management) to an archive folder to reduce the size of our database, We have tried multiple times with no success. Things that we have tried.
1- set up a new dummy company to move to
2. tried to move only one job
4. Restart server & desktop
5. Move from directly on the Server.
This is the error message we are getting, there is nothing in the Sage logs with any detail to help. I attached the EV log.
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> - <System> <Provider Name="Sage Diagnostics Exception" /> <EventID Qualifiers="0">0</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2024-02-06T01:40:44.874048700Z" /> <EventRecordID>8134</EventRecordID> <Channel>Sage</Channel> <Computer>SAGE4.flc.local</Computer> <Security /> </System> - <EventData> <Data>An exception is being logged for diagnostic purposes. It is possible for exceptions to be logged during the normal operation of the software. Exceptions are included in increasing order of specificity. ********************************************* Exception Source: Sage.Data.CRE.Provider Exception Message: Unable to retrieve metadata from the database. Exception Stack Trace: at Sage.Data.CRE.tsDbCommand.Execute(Int32& recordsAffected) at Sage.Data.CRE.PervasiveAccessProvider.FillDataSet(IDbCommand command) at Sage.Data.AOF.DataAccessProvider.GetDataSet(IDbCommand command) at Sage.Data.AOF.DataAccessor.GetDataSet(String commandGroup, String commandName, WorkingSet workingSet) at Sage.Data.AOF.DataAccessor.GetDataTable(String commandGroup, String commandName, WorkingSet workingSet) at Sage.Data.CRE.MetaDataTable.GetField(String field)</Data> </EventData> </Event>
