SQLNexus create DB failed

Jun 23, 2011 at 3:30 PM

Hi, I have been trying for 2 days to get SQL Nexus working on my environment.

Whenever I try to import a file, I am getting the error "Create DB failed with exception MODIFY FILE failed. Specified size is less than or equal to the current size. Changed database context to Master".

I have also tried, not recreating the database when I import, by deselecing "Drop Current DB Before Importing" but I get this error: This database already have Nexus data. Please choose or create a different database for fresh data load.

I cant see what I am doing wrong, as on another server, I do exactly the same, and it works fine.

Any ideas would be appreciated

Jul 19, 2011 at 10:38 PM

An ALTER DATABASE command is issued before the import starts. Look at your model database settings and find out what the file size is. That would be the file size of the database when it is initially created. In your case, the file size being specified is smaller than the current size of the existing database and hence the error.