1 2 Назад Вперед 17 Ответы Последний ответ: 11.12.2006 21:05, автор: 666705

    Error retrieving resource

    666705
      Hi i am new to Aqua Logic DSP. I have created one physical DataService using Weblogic workshop. In Test view it is working fine. Next i created another logical DataService using previous physical data service schema, with parameters. If execute in Test view I am getting error like....

      com.bea.ld.QueryException: Cannot generate XQuery for the function {ld:DSProj/MyDS}getAreas:1

           at weblogic.rjvm.BasicOutboundRequest.sendReceive(BasicOutboundRequest.java:108)

           at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290)

           at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:248)

           at com.bea.ld.Server_ydm4ie_EOImpl_816_WLStub.executeFunction(Unknown Source)

           at workshop.liquiddata.xds.views.test.TestPanel.executeFunctionDefn(TestPanel.java:2477)

           at workshop.liquiddata.xds.views.test.TestPanel.access$3100(TestPanel.java:117)

           at workshop.liquiddata.xds.views.test.TestPanel$6.run(TestPanel.java:982)

           at java.lang.Thread.run(Thread.java:534)

      Caused by: com.bea.ld.QueryException: Cannot generate XQuery for the function {ld:DSProj/MyDS}getAreas:1

           at com.bea.ld.EJBRequestHandler.invokeFunction(EJBRequestHandler.java:720)

           at com.bea.ld.EJBRequestHandler.executeFunction(EJBRequestHandler.java:339)

           at com.bea.ld.ServerBean.executeFunction(ServerBean.java:108)

           at com.bea.ld.Server_ydm4ie_EOImpl.executeFunction(Server_ydm4ie_EOImpl.java:524)

           at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)

           at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:491)

           at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:120)

           at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:434)

           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)

           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)

           at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:429)

           at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:35)

           at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)

           at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

      Caused by: com.bea.ld.server.FunctionCallQueryBuilder$QueryBuilderException: {err}<b>XQ0017</b>: "{ld:DSProj/MyDS}getAreas": unknown function (or number of arguments (1) is wrong) - Cause: {err}FODC0002: Error retrieving resource "ld:DSProj/MyDS.ds": {1}

           at com.bea.ld.server.FunctionCallQueryBuilder.buildQuery(FunctionCallQueryBuilder.java:73)

           at com.bea.ld.EJBRequestHandler.invokeFunction(EJBRequestHandler.java:716)

           ... 13 more

      Caused by: weblogic.xml.query.exceptions.XQueryStaticException: {err}<b>XQ0017</b>: "{ld:DSProj/MyDS}getAreas": unknown function (or number of arguments (1) is wrong) - Cause: {err}FODC0002: Error retrieving resource "ld:DSProj/MyDS.ds": {1}

           at com.bea.ld.context.OnDemandOperatorManager.getOperatorOnDemand(OnDemandOperatorManager.java:79)

           at com.bea.ld.context.OnDemandOperatorManager.getOperator(OnDemandOperatorManager.java:46)

           at com.bea.ld.context.RegistrylessOperatorManager.getOperator(RegistrylessOperatorManager.java:77)

           at weblogic.xml.query.operators.OperatorManager.getOperator(OperatorManager.java:641)

           at com.bea.ld.server.FunctionCallQueryBuilder.buildQuery(FunctionCallQueryBuilder.java:71)

           ... 14 more

      Caused by: weblogic.xml.query.exceptions.XQueryDynamicException: {err}<b>FODC0002</b>: Error retrieving resource "ld:DSProj/MyDS.ds": {1}

           at com.bea.ld.context.load.Loader.load(Loader.java:219)

           at com.bea.ld.context.ApplicationContext.loadFunctionCollection(ApplicationContext.java:437)

           at com.bea.ld.context.ApplicationContext.loadFunctionCollectionOnDemand(ApplicationContext.java:414)

           at com.bea.ld.context.OnDemandOperatorManager.getOperatorOnDemand(OnDemandOperatorManager.java:75)

           at com.bea.ld.context.OnDemandOperatorManager.getOperator(OnDemandOperatorManager.java:46)

           at com.bea.ld.context.RegistrylessOperatorManager.getOperator(RegistrylessOperatorManager.java:77)

           at weblogic.xml.query.operators.OperatorManager.getOperator(OperatorManager.java:641)

           at com.bea.ld.server.FunctionCallQueryBuilder.buildQuery(FunctionCallQueryBuilder.java:71)

           at com.bea.ld.EJBRequestHandler.invokeFunction(EJBRequestHandler.java:716)

           at com.bea.ld.EJBRequestHandler.executeFunction(EJBRequestHandler.java:339)

           at com.bea.ld.ServerBean.executeFunction(ServerBean.java:108)

           at com.bea.ld.Server_ydm4ie_EOImpl.executeFunction(Server_ydm4ie_EOImpl.java:524)

           at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)

           at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:491)

           at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:120)

           at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:434)

           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)

           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)

           at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:429)

           at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:35)

      Thanks in Advance.
      Any one please help me.
        • 1. Re: Error retrieving resource
          666705
          I suspect namespace problems - likely from using 'Rename' in the Workshop Project Explorer pane instead of using 'Refactor -> Rename'.

          Open the data service(s) in the Source Editor and see if anything is flagged as an error.

          If that doesn't help, zip up your DSP Project and attach it in this newsgroup.

          - Mike
          • 2. Re: Error retrieving resource
            666705
            Mike thank you for your response.
            No errors in the data servive source editor. Please find the attached project. In the Areas.ds i have two functions, one is read function Areas() and navigation function getAREA_DETAILS(). If i test in workshop Areas function is working but getAREA_DETAILS is not working. the error is as follows ... com.bea.ld.server.FunctionCallQueryBuilder$QueryBuilderException: Cannot find function: {ld:DSProj/Areas}getAREA_DETAILS with 1 parameters

            It is an urgent requirement for me.

            Thanks in Advance for any suggestions.
            • 3. Re: Error retrieving resource
              666705
              I don't have any problems with your project - here's the generated query plan. (I can't run it of course, because I don't have your database).

              - Mike


              <?xml version="1.0" encoding="UTF-8" ?>
              <typeMatch tip="Driving type : element {ld:DSProj/AREA_DETAILS}AREA_DETAILS { {http://www.w3.org/2001/XMLSchema}anyType } Source location : ld:DSProj/Areas.ds, line 38, column 5">
              <FLWOR>
              <return>
              <elementConstructor name="AREA_DETAILS" tip="{ld:DSProj/AREA_DETAILS}AREA_DETAILS">
              <elementConstructor field="(0)" from="$f5454" name="AREAID">
                                  </elementConstructor>
              <elementConstructor field="(1)" from="$f5454" name="DESCRIPTION">
                                  </elementConstructor>
              </elementConstructor>
              </return>
              <join impl="index-cpp" kind="inner">
              <right>
              <for name="$f5454">
              <source kind="relational" name="jndi/ds1" ns="fn-bea" tip="jndi/ds1">
              <![CDATA[SELECT t1."AREAID" AS c1, t1."DESCRIPTION" AS c2
              FROM "GLOBEX"."AREA_DETAILS" t1
              WHERE ((? = t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? =
                t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? =
                t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? =
                t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? =
                t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID") OR (? = t1."AREAID"))]]>
              <clusteredparameters>
              <variable kind="LET" name="$l5433">
                                  </variable>
              </clusteredparameters>
              </source>
              </for>
              </right>
              <left>
              <let kind="LET" name="$l5433">
              <operator name="data" ns="fn" tip="{http://www.w3.org/2004/07/xpath-functions}data">
              <test kind="/AreaID" tip="Node test">
              <variable kind="EXTERNAL" name="__fparam0">
                                  </variable>
              </test>
              </operator>
              </let>
              </left>
              <condition>
              <EQ tip="{http://www.bea.com/xquery/xquery-operators}integer-equal">
              <variable kind="LET" name="$l5433">
                                  </variable>
              <variable from="$f5454" kind="extracted" name="(0)">
                                  </variable>
              </EQ>
              </condition>
              </join>
              </FLWOR>
              </typeMatch>
              • 4. Re: Error retrieving resource
                666705
                Please zip up and attach your server log. Perhaps you are having other problems that cause this.
                • 5. Re: Error retrieving resource
                  666705
                  hi ,
                  Thank you for your response. please find the attached server log file and Dataservice project. Whatever the data services i developed except physical data service, I am getting the same error.I think it may be some server side problem, please help me.

                  Thanks & regards,
                  Suresh Varma.
                  • 6. Re: Error retrieving resource
                    666705
                    Hi,
                    I am usig Weblogic 8.1 sp6 and Aqualogic DSP 2.5. And i created two data sources for two different data bases(MS SQL and Oracle)in Weblogic. I have a table named AREAS in MSSQL and AREADETAILS in Oracle. My requirement is, I have to develop one DataService which will return the consolidated data from both tables. For this I developoed MyLogicalDS.ds(Which u can see in my previous posting). Please let me know if is it correct way or not. If you have any suggestion to accomplish this task, always welcome.

                    Thanks
                    Suresh Varma
                    • 7. Re: Error retrieving resource
                      666705
                      I can't figure out what you're doing.

                      You do not have a ld:DSProj/getAreaByID.ds in your project, so it's no surprise that DSP cannot find it.

                      There is nothing in your project that references ld:DSProj/getAreaByID.ds - so I can only assume you've written an ad-hoc query in the Test View or making a client-call and giving a data service name that does not exist.

                      Pay close attention to the examples.

                      - mike
                      • 8. Re: Error retrieving resource
                        666705
                        Hi Mike,

                        Avtually in my latest project i have ld:DSProj/getAreaByID.ds . I posted latest version of project in my previous posting. In this posting also i attached the latest version of my DSProject and server log file.please review it and post your suggestions.

                        -Thanks,
                        Suresh varma
                        • 9. Re: Error retrieving resource
                          666705
                          There is no attachment in your posting.
                          • 10. Re: Error retrieving resource
                            666705
                            Ok - I have the correct project now.

                            Now, explain exactly what you did to get this error message. If you are calling this with client code, please provide the client code.
                            • 11. Re: Error retrieving resource
                              666705
                              Hi,
                              thank you for your response. I resolved my problem. the problem is due to database connection drivers(XA). Now i am uring non-XA drivers, then it is working fine.

                              Thank you.

                              regards,
                              SUresh Varma.
                              • 12. Re: Error retrieving resource
                                666705
                                Your error occurs at query compile time - long before a data source access is made, so I doubt that your problem is related to jdbc drivers.
                                • 13. Re: Error retrieving resource
                                  666705
                                  Hi Mike:

                                  I have this same error showing up in my DSP application. I built the application in workshop and deployed to my local windows machine and everything worked fine. (weblogic 8.1.6 with DSP 2.5)

                                  I exposed the DSP result in a weblogic control and then used weblogic web service to wrap the control for client application to consume. The web service test pages worked fine.

                                  However this error showed up when I deployed my EAR to our Linux box running 8.1.6 with DSP 2.5. It showed the error when I submit the request through the web service test page.

                                  Any suggestion?

                                  thanks!!
                                  • 14. Re: Error retrieving resource
                                    666705
                                    Exactly the same error? Hmmm... what's different between Windows and Linux? Windows file systems are not case sensitive, while Linux file systems are. If your DSP project remains in the jar when deployed (it should), then case sensitivity of the file system won't come into play.

                                    Can you post the stack trace you are getting, your server log file, the EAR (if it's not too big), and zip up and post your workshop application (delete .workshop and APP-INF before zipping).

                                    - Mike R
                                    1 2 Назад Вперед