by ryan.m.beasley » Fri Mar 15, 2019 8:09 pm
I've just finished deploying a huge update to the servoy application I maintain into dev and I'm running into some issues with calling stored procedures from my sql server database I'm connected to. When running the client locally everything works as it should, however when I'm running it when the solution has been deployed to the dev environment I get this error:
Mar 15, 2019 2:03:04 PM com.servoy.j2db.util.Debug error
SEVERE: TypeError: Cannot find function sp_apply_overlay_to_ssp in object SPDataSourceServer[allnames,length]. (SPCentral/forms/ssp_input_sctm/ApplyOverlays#144) (Form Context: ssp_input_sctm), JSEvent(type = action, source = ScriptButton[sv__14574E25_D32A_449E_8A5B_79F595A86788:Apply Overlay(s) and Baselines], formName = ssp_input_sctm, elementName = <no name>, timestamp = Fri Mar 15 14:03:03 EDT 2019,modifiers = 16,x =0,y = 0,data = null)
at SPCentral/forms/ssp_input_sctm/ApplyOverlays:144 (ApplyOverlays)
org.mozilla.javascript.EcmaError: TypeError: Cannot find function sp_apply_overlay_to_ssp in object SPDataSourceServer[allnames,length]. (SPCentral/forms/ssp_input_sctm/ApplyOverlays#144)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:4224)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:4202)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:4235)
at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:4254)
at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:4326)
at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThisHelper(ScriptRuntime.java:2562)
at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRuntime.java:2544)
at org.mozilla.javascript.gen.SPCentral_forms_ssp_input_sctm_ApplyOverlays_44._c_ApplyOverlays_0(SPCentral/forms/ssp_input_sctm/ApplyOverlays:144)
at org.mozilla.javascript.gen.SPCentral_forms_ssp_input_sctm_ApplyOverlays_44.call(SPCentral/forms/ssp_input_sctm/ApplyOverlays)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:399)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3534)
at org.mozilla.javascript.gen.SPCentral_forms_ssp_input_sctm_ApplyOverlays_44.call(SPCentral/forms/ssp_input_sctm/ApplyOverlays)
at com.servoy.j2db.scripting.ScriptEngine.executeFunction(ScriptEngine.java:665)
at com.servoy.j2db.BasicFormController.executeFunction(BasicFormController.java:1074)
at com.servoy.j2db.BasicFormController.executeFunction(BasicFormController.java:956)
at com.servoy.j2db.BasicFormController.executeFunction(BasicFormController.java:827)
at com.servoy.j2db.FormController$ScriptExecuter.executeFunction(FormController.java:1042)
at com.servoy.j2db.ui.BaseEventExecutor.fireEventCommand(BaseEventExecutor.java:299)
at com.servoy.j2db.ui.BaseEventExecutor.fireEventCommand(BaseEventExecutor.java:265)
at com.servoy.j2db.ui.BaseEventExecutor.fireActionCommand(BaseEventExecutor.java:233)
at com.servoy.j2db.ui.BaseEventExecutor.fireActionCommand(BaseEventExecutor.java:228)
at com.servoy.j2db.smart.dataui.AbstractScriptButton$2.actionPerformed(AbstractScriptButton.java:660)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
I'm using the same database, connection string, etc. in the dev server as I am locally. I have the query procedures property checked for that server. The stored procedure exists in the database. I don't understand why I'm unable to call it in the dev environment. Any help?