SoftPro Developer Forum

I'm trying to set up a test server package to test out. I keep running into an issue every time I try to debug the server package. The program hits the OnInitalize () method successfully, but after exiting that method it always throws the same exception:

SoftPro Select Server failed to start! Error: The default schema does not exist.
Cannot find the queue 'ChangeMonitor-b35640bb-464b-45ee-8747-8708c4922748', because it does not exist or you do not have permission.

I few notes if they help:
The GUID is different every time it runs.
The exception occurs when run the sample "SimpleOrderValidation" from the SDK and when I build a new Server package from the softpro templates.
I have tried completely uninstalling and reinstalling the Softpro Select Services to no avail.
I have not found anything even mentioning this in the documentation or anywhere on these boards.
There is no reference that I can find about a Change Monitor in any of the server xml files either that it launches.

At these point I have no idea where to even look to get past this.

Any assistance would be appreciated.

Thanks.

What version of Select are you using?

Does your user account have access to the sql db? What role is it assigned?

Version: 4.0.30302.25

User account does have access with the following roles:

db_datareader
db_datawriter
db_ddladmin


Also as a side question, Is there a command line argument that can be used to set/override the UserAccount for spssvc?

There is not a command line argument for that. When running the spssvc.exe in debug mode (/debug), it always runs as your user account.

Try giving your account the dbo role access and see if it resolves the issue.

Tried giving the account 'db_owner' and this did not work, same issue.

See if this helps.

http://stackoverflow.com/questions/3733 ... ntime-quer

Finally got it working!

End result seemed to be a combination of setting the user account level to db_owner along with setting the default schema in SoftproDB to 'dbo' for that same account.

Thanks for your help.