Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
12 replies Latest Post - ‏2011-09-15T15:48:34Z by SK_NYCERS
nithisha
nithisha
8 Posts
ACCEPTED ANSWER

Pinned topic Error while performing eforms lookup

‏2010-01-15T07:41:14Z |
Hello all,

I am using eforms designer 5.0.3 with FileNet BPM 4.5.

I am trying to perform an ODBC lookup using db2 database. The lookup works fine when I test it in the eforms designer but I receive an error in the filenet Workplace , saying the connection settings are missing.

I have configured the ODBC connection in the eforms designer. Do I need to perform any other configuration for this to work in the filenet workplace.
Please help.
Thanks in advance.
Updated on 2011-09-15T15:48:34Z at 2011-09-15T15:48:34Z by SK_NYCERS
  • SystemAdmin
    SystemAdmin
    53 Posts
    ACCEPTED ANSWER

    Re: Error while performing eforms lookup

    ‏2010-01-15T07:51:35Z  in response to nithisha
    Hi,

    You need to configure the same ODBC connection on AE server, and furthermore, you need to edit <AE install folder>/../Config/AE/eforms-preferences.xml and to speficy the ODBC connection, like bellow:

    <?xml version="1.0" encoding="UTF-8"?>
    <preferences>
    <sql>
    <connection dsn="<ODBC_NAME>"
    driver="sun.jdbc.odbc.JdbcOdbcDriver"
    user="<user>" password="<password>"
    url="jdbc:odbc:<ODBC_NAME>">
    </connection>
    </sql>
    </preferences>
    • nithisha
      nithisha
      8 Posts
      ACCEPTED ANSWER

      Re: Error while performing eforms lookup

      ‏2010-01-15T08:08:20Z  in response to SystemAdmin
      Hi,
      Thanks for the reply.I want to know where do I configure the same ODBC connection on AE server.
      • SystemAdmin
        SystemAdmin
        53 Posts
        ACCEPTED ANSWER

        Re: Error while performing eforms lookup

        ‏2010-01-15T08:18:09Z  in response to nithisha
        If you are using Windows as operating system on AE server, you can define ODBC connections by Control Panel -> Administrative Tools -> Data Sources (ODBC).
        • nithisha
          nithisha
          8 Posts
          ACCEPTED ANSWER

          Re: Error while performing eforms lookup

          ‏2010-01-15T08:35:46Z  in response to SystemAdmin
          I have performed those tasks but i continue to receive the same error. this is the detailed error.

          Type: ChainedException
          Message: The connection settings are missing.
          Location: 315HSI

          Type: SqlError
          Message: The connection settings are missing.

          Cause: com.filenet.eforms.api.FormException: The connection settings are missing.
          at com.filenet.eforms.core.queries.SqlQueryImpl.handleAction(SqlQueryImpl.java:85)
          at com.filenet.eforms.core.queries.SqlQueryImpl.lookup(SqlQueryImpl.java:73)
          at com.filenet.eforms.core.queries.QueryImpl.execute(QueryImpl.java:102)
          at com.filenet.eforms.core.http.CallbackHandler$QueryListener.getJavaScript(CallbackHandler.java:239)
          at com.filenet.eforms.core.http.CallbackHandler$JavaScriptCallbackListener.handleRequest(CallbackHandler.java:749)
          at com.filenet.eforms.core.http.CallbackHandler.handleRequest(CallbackHandler.java:101)
          at com.filenet.eforms.core.renderers.HtmlFormRendererImpl.handleCallback(HtmlFormRendererImpl.java:320)
          at com.filenet.eforms.core.platforms.FactoryImpl.handleCallback(FactoryImpl.java:110)
          at com.filenet.eforms.api.HtmlFormRenderer.handleCallback(HtmlFormRenderer.java:430)
          at com.filenet.eforms.toolkit.server.servlet.BaseEFormCallbackServlet$GetFormRequest.getForm(BaseEFormCallbackServlet.java:118)
          at com.filenet.eforms.toolkit.server.servlet.BaseEFormCallbackServlet$GetFormRequest.access$100(BaseEFormCallbackServlet.java:75)
          at com.filenet.eforms.toolkit.server.servlet.BaseEFormCallbackServlet.doGet(BaseEFormCallbackServlet.java:56)
          at com.filenet.eforms.toolkit.server.servlet.BaseEFormCallbackServlet.doPost(BaseEFormCallbackServlet.java:62)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
          at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1075)
          at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1016)
          at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
          at com.filenet.ae.toolkit.server.servlet.filter.ThreadLocalCleanupFilter.doFilter(ThreadLocalCleanupFilter.java:50)
          at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
          at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
          at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
          at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:771)
          at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)
          at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:546)
          at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
          at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
          at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
          at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
          at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:115)
          at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
          at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
          at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
          at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
          at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
          at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
          at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
          at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
          at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
          at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
          at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
          • SystemAdmin
            SystemAdmin
            53 Posts
            ACCEPTED ANSWER

            Re: Error while performing eforms lookup

            ‏2010-01-15T08:45:31Z  in response to nithisha
            Did you restarted Workplace application? Or better, you can restart application server.
            • nithisha
              nithisha
              8 Posts
              ACCEPTED ANSWER

              Re: Error while performing eforms lookup

              ‏2010-01-15T09:04:25Z  in response to SystemAdmin
              Ya, I have restarted the both the workplace and the application server. This is what I have configured in my eforms preferences.xml file.

              <?xml version="1.0" encoding="UTF-8"?>
              <preferences>
              <sql>
              <connection dsn="Objst"
              driver="sun.jdbc.odbc.JdbcOdbcDriver"
              user="db2admin" password="filenet1"
              url="jdbc:odbc:Objst">
              </connection>
              </sql>
              </preferences>
              • SystemAdmin
                SystemAdmin
                53 Posts
                ACCEPTED ANSWER

                Re: Error while performing eforms lookup

                ‏2010-01-15T09:13:34Z  in response to nithisha
                Hi,

                Let my understand:
                - ODBC Connection Name: Objst (System Data Source) (like in url="jdbc:odbc:Objst")
                - in eforms template, you invoke an ODBC called Objst (like in dsn="Objst")

                Are the above items correct?

                PS: Use System Data Sources because are available for all users. User Data Sources are available only for user how define it.
                • nithisha
                  nithisha
                  8 Posts
                  ACCEPTED ANSWER

                  Re: Error while performing eforms lookup

                  ‏2010-01-15T09:23:36Z  in response to SystemAdmin
                  Yes, Objst is a system data source and this data source was actually created automatically when I defined the ODBC connection in the eforms designer. This is the same name I had given to the database server when I defined connection for odbc in the eforms designer.
                  • nithisha
                    nithisha
                    8 Posts
                    ACCEPTED ANSWER

                    Re: Error while performing eforms lookup

                    ‏2010-01-15T11:12:56Z  in response to nithisha
                    Well..Can u let me know one thing. When you define the ODBC connection in the eforms designer, the database server name indicates the database in which the tables exist for lookup..right? so we do not specify the name of the ODBC datasource anywhere in the eforms designer configuration..
                    • nithisha
                      nithisha
                      8 Posts
                      ACCEPTED ANSWER

                      Re: Error while performing eforms lookup

                      ‏2010-01-15T12:37:41Z  in response to nithisha
                      Hey can you please let me know how to connect using the JDBC connection if not. I would like to know the connection string, driver and url configuration that I should do in the eforms designer.
                      • SystemAdmin
                        SystemAdmin
                        53 Posts
                        ACCEPTED ANSWER

                        Re: Error while performing eforms lookup

                        ‏2010-01-15T13:12:59Z  in response to nithisha
                        Please follow the eForms Install Documentation, chapters

                        - Planning -> Pre-installation Tasks -> Configure the application server for data access
                        - Planning -> Configuration/Startup Tasks -> Customize Preferences -> SQL Connections
  • SK_NYCERS
    SK_NYCERS
    1 Post
    ACCEPTED ANSWER

    Re: Error while performing eforms lookup

    ‏2011-09-15T15:48:34Z  in response to nithisha
    I have the same issue.

    We have configured the following.
    Microsoft System DSN
    Edited the XML preferences file
    Created a Web Sphere datasource.

    I still get an error stating there is no suitable driver.

    Any thoughts?