Server Package Debugging: "failed to Start!"

Discussions related to SoftPro Select Server development.

Moderator: Phil Barton

Post Reply
MattW
Posts: 46
Joined: Tue May 26, 2015 5:17 pm

Server Package Debugging: "failed to Start!"

Post by MattW » Tue Jun 16, 2015 9:45 am

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.

John Morris
Posts: 411
Joined: Thu Sep 11, 2008 11:35 am
Location: Raleigh, NC, USA
Contact:

Re: Server Package Debugging: "failed to Start!"

Post by John Morris » Tue Jun 16, 2015 10:19 am

What version of Select are you using?

Does your user account have access to the sql db? What role is it assigned?
John Morris
Sr. Software Architect
SoftPro

MattW
Posts: 46
Joined: Tue May 26, 2015 5:17 pm

Re: Server Package Debugging: "failed to Start!"

Post by MattW » Tue Jun 16, 2015 12:39 pm

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?

John Morris
Posts: 411
Joined: Thu Sep 11, 2008 11:35 am
Location: Raleigh, NC, USA
Contact:

Re: Server Package Debugging: "failed to Start!"

Post by John Morris » Tue Jun 16, 2015 2:44 pm

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.
John Morris
Sr. Software Architect
SoftPro

MattW
Posts: 46
Joined: Tue May 26, 2015 5:17 pm

Re: Server Package Debugging: "failed to Start!"

Post by MattW » Tue Jun 16, 2015 4:44 pm

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

John Morris
Posts: 411
Joined: Thu Sep 11, 2008 11:35 am
Location: Raleigh, NC, USA
Contact:

Re: Server Package Debugging: "failed to Start!"

Post by John Morris » Tue Jun 16, 2015 5:41 pm

John Morris
Sr. Software Architect
SoftPro

MattW
Posts: 46
Joined: Tue May 26, 2015 5:17 pm

Re: Server Package Debugging: "failed to Start!"

Post by MattW » Wed Jun 17, 2015 10:35 am

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.

Post Reply