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.
Server Package Debugging: "failed to Start!"
Moderator: Phil Barton
-
- Posts: 411
- Joined: Thu Sep 11, 2008 11:35 am
- Location: Raleigh, NC, USA
- Contact:
Re: Server Package Debugging: "failed to Start!"
What version of Select are you using?
Does your user account have access to the sql db? What role is it assigned?
Does your user account have access to the sql db? What role is it assigned?
John Morris
Sr. Software Architect
SoftPro
Sr. Software Architect
SoftPro
Re: Server Package Debugging: "failed to Start!"
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?
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?
-
- Posts: 411
- Joined: Thu Sep 11, 2008 11:35 am
- Location: Raleigh, NC, USA
- Contact:
Re: Server Package Debugging: "failed to Start!"
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.
Try giving your account the dbo role access and see if it resolves the issue.
John Morris
Sr. Software Architect
SoftPro
Sr. Software Architect
SoftPro
Re: Server Package Debugging: "failed to Start!"
Tried giving the account 'db_owner' and this did not work, same issue.
-
- Posts: 411
- Joined: Thu Sep 11, 2008 11:35 am
- Location: Raleigh, NC, USA
- Contact:
Re: Server Package Debugging: "failed to Start!"
John Morris
Sr. Software Architect
SoftPro
Sr. Software Architect
SoftPro
Re: Server Package Debugging: "failed to Start!"
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.
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.