Ask the Community
Groups
Server was Unable to Process Request: Could not find stored procedure 'dbo.usp_GetSoapApiServiceTicket' - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Problem: </strong>Tickets in ConnectWise do not get created and MSPAssist shows the below error:</p> <p><em>New ticket in ConnectWise: Server was unable to process request. ---> Could not find stored procedure 'dbo.usp_GetSoapApiServiceTicket'</em> </p> <p><img src="/attachments/token/GWSPfaZL3KTmWqSHXmiZb7CBN/?name=New+ticket+in+ConnectWise++Server+was+unable+to+process+request.+---+Could+not+find+stored+procedure+%27dbo.usp_GetSoapApiServiceTicket%27.png" width="728" height="340" alt="image" class="embedImage-img importedEmbed-img"></img></p> <p><strong>Cause: </strong>The stored procedure named '<em>dbo.usp_GetSoapApiServiceTicket</em>' is missing from the database. </p> <p><strong>Resolution: </strong>Run a reinstall database schema which should create the stored procedure it needs. You can run a reinstall DB schema via <strong>Start </strong>menu locally on the KServer.</p> </article> </main>