SQL Max Size database?
Posted: Wed Sep 26, 2012 12:12 am
Hello
I have a problem with the SQL database.
Now it's grown to 256MB, and when i want to export a datalogger, the IX software crash.
How can i fix that problem?
Can i change the max size of the database?
I have deleted/renamed the database, and then it made a new file, but i have "lost" my data.
In IX 1.31, dataloggers were made seperate instead off combined in the database. It worked better i think.
I'm running a C2D box pc, with IX2.0 Runtime.
- Emil Gundersen
JCJelektro.dk
From Log file:
2012-09-26 09:49:50,218 [5] ERROR Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF [(null)] - Connect to database failed.
The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 0 ]
2012-09-26 09:49:50,218 [5] ERROR Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF [(null)] - With SqlCeErrors:
2012-09-26 09:49:50,218 [5] ERROR Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF [(null)] - System.Data.SqlServerCe.SqlCeError: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 0 ]
2012-09-26 09:49:50,234 [5] FATAL Neo.ApplicationFramework.Common.Runtime.GlobalsBase [(null)] - Unhandled Exception causing shutdown.
System.InvalidOperationException: ExecuteReader: Connection property has not been initialized.
at System.Data.SqlServerCe.SqlCeCommand.ValidateCommand(String method)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF.t(IDatabaseData A_0, String A_1)
at Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF.m(IDatabaseData A_0)
at Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF.DatabaseExportToCSV(Object parameters)
at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
I have a problem with the SQL database.
Now it's grown to 256MB, and when i want to export a datalogger, the IX software crash.
How can i fix that problem?
Can i change the max size of the database?
I have deleted/renamed the database, and then it made a new file, but i have "lost" my data.
In IX 1.31, dataloggers were made seperate instead off combined in the database. It worked better i think.
I'm running a C2D box pc, with IX2.0 Runtime.
- Emil Gundersen
JCJelektro.dk
From Log file:
2012-09-26 09:49:50,218 [5] ERROR Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF [(null)] - Connect to database failed.
The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 0 ]
2012-09-26 09:49:50,218 [5] ERROR Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF [(null)] - With SqlCeErrors:
2012-09-26 09:49:50,218 [5] ERROR Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF [(null)] - System.Data.SqlServerCe.SqlCeError: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 0 ]
2012-09-26 09:49:50,234 [5] FATAL Neo.ApplicationFramework.Common.Runtime.GlobalsBase [(null)] - Unhandled Exception causing shutdown.
System.InvalidOperationException: ExecuteReader: Connection property has not been initialized.
at System.Data.SqlServerCe.SqlCeCommand.ValidateCommand(String method)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF.t(IDatabaseData A_0, String A_1)
at Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF.m(IDatabaseData A_0)
at Neo.ApplicationFramework.Tools.Database.DatabaseServiceCF.DatabaseExportToCSV(Object parameters)
at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()