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 »

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 »

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 »

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 »

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 »

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 »

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 »

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