Sage 100

v3.74 SQL We ran a conversion utility on Monday and everything seemed to work fine. Today, users are suddenly receiving an error 15 in SWCNV1 line 2545 (this was the conversion program run from file, run and we ran it for a backup company so not to mess with the live company) and can't get into anything. Does anyone know what an error 15 is and what can be done to fix this? @AlnoorCassim can you help?

@DougHiggs, an ERROR 15 means that the operating system has returned an error of some sort to ProvideX. If you can get to a command prompt when the error occurs, you can get a great deal more information by typing ?MSG(-1) at the prompt. This will return the actual error message returned by the operating system. In my experience, one of the most common errors when dealing with SQL Server coming from losing the connection or trying to do something illegal vis-a-vis SQL Server. These will all return an ERROR 15. It is the MSG(-1) that will tell you what the problem really is. I am not familiar with SWCNV1 in any meaningful way, but it appears that at the line where the error is occurring, it has just opened an Options file for one of the modules and is attempting to get the first key to that file.

The entire company SQL database is missing. I believe that may pose a small problem.

(possibly.....)

Phil is 100% right - if you hit info and type ? FID(e1) you should see the name of the file/table it is trying to read. This could be SQL rights......

Thanks guys! IT is restoring the DB from a backup.

Well @DougHiggs, I suppose you're right. A missing SQL database could cause some minor problems. :-) I'm glad you got it figured out.

Thanks Phil.