orbeon form - getting error communicating with the sql database when save the form

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

orbeon form - getting error communicating with the sql database when save the form

jyadav
I have follow most of the topics and based on that I make all the settings. But at last when I try to save the form I am getting this error.



Following is the Properties-local.xml Content


<!--
    This file is an empty template for your own properties-local.xml file. Please follow the instructions here:

    https://doc.orbeon.com/configuration/properties/
-->
<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"
            xmlns:oxf="http://www.orbeon.com/oxf/processors">

<property as="xs:string"  name="oxf.fr.persistence.provider.*.*.*" value="sqlserver"/>
<property as="xs:NMTOKENS" name="oxf.xforms.logging.debug">
        document
        model
        submission
        control
        event
        action
        analysis
        server
        html
        process
    </property>

    <property as="xs:NMTOKENS" name="oxf.xforms.logging.error">
        submission-error-body
    </property>

</properties>

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Reply | Threaded
Open this post in threaded view
|

Re: orbeon form - getting error communicating with the sql database when save the form

Alessandro  Vernet
Administrator
You are saying that you are getting an error, but the error seems to be
missing from your message. Could you attach a screenshot of that error to a
response? Also, do you see any useful information about this in the
`orbeon.log`? If you aren't used to the `orbeon.log`, you might also find
the page linked below useful. You'll let us know what you find!

https://doc.orbeon.com/configuration/troubleshooting/orbeon-log

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: orbeon form - getting error communicating with the sql database when save the form

jyadav
In reply to this post by jyadav
Here is the Error Screen Shot.

1. https://snag.gy/8yc2ZL.jpg
2. https://snag.gy/5HWf94.jpg

Orbeon Log is attached


On Thursday, January 3, 2019 at 3:43:32 AM UTC+5:30, [hidden email] wrote:
I have follow most of the topics and based on that I make all the settings. But at last when I try to save the form I am getting this error.



Following is the Properties-local.xml Content


<!--
    This file is an empty template for your own properties-local.xml file. Please follow the instructions here:

    <a href="https://doc.orbeon.com/configuration/properties/" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fdoc.orbeon.com%2Fconfiguration%2Fproperties%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFkDfF0BBDIbYrme2tw_acZ2YyTYw&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fdoc.orbeon.com%2Fconfiguration%2Fproperties%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFkDfF0BBDIbYrme2tw_acZ2YyTYw&#39;;return true;">https://doc.orbeon.com/configuration/properties/
-->
<properties xmlns:xs="<a href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNETUl7MhKy2nWpH8V8BwGakc8etag&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNETUl7MhKy2nWpH8V8BwGakc8etag&#39;;return true;">http://www.w3.org/2001/XMLSchema"
            xmlns:oxf="<a href="http://www.orbeon.com/oxf/processors" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fwww.orbeon.com%2Foxf%2Fprocessors\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHUiiFySGwdM1bIDS_mg6f5SnUe1Q&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fwww.orbeon.com%2Foxf%2Fprocessors\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHUiiFySGwdM1bIDS_mg6f5SnUe1Q&#39;;return true;">http://www.orbeon.com/oxf/processors">

<property as="xs:string"  name="oxf.fr.persistence.provider.*.*.*" value="sqlserver"/>
<property as="xs:NMTOKENS" name="oxf.xforms.logging.debug">
        document
        model
        submission
        control
        event
        action
        analysis
        server
        html
        process
    </property>

    <property as="xs:NMTOKENS" name="oxf.xforms.logging.error">
        submission-error-body
    </property>

</properties>

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

orbeon.log (1M) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: orbeon form - getting error communicating with the sql database when save the form

Alessandro  Vernet
Administrator
Thank you for the screenshots. From the error message on the second
screenshot, it seems that Tomcat is unable to connect to port 1443 of the
host you specified as your SQL Server. So I'd recommend you check that
config: maybe the host name is incorrect, needs to be fully specified, or
the port needs to be open, or something else. You'll let me know if you
figure this one out.

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: orbeon form - getting error communicating with the sql database when save the form

Alessandro  Vernet
Administrator
Is everything good now with your connection to SQL Server? If not, did you
get a chance to check the config as mentioned in my previous message?

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet