tag:blogger.com,1999:blog-2627747309936375689.post4775321774322860863..comments2024-01-09T08:11:30.701-06:00Comments on Blog posts around Oracle SOA Suite,Adobe Experience Manager(AEM),Dispatcher and Web technologies: Storing the Cross reference data to a custom table - Oracle SOA SuiteTech Forumhttp://www.blogger.com/profile/06872295047306188060noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2627747309936375689.post-57833104334726793662017-06-21T05:46:50.442-05:002017-06-21T05:46:50.442-05:00XPath expression failed to execute.
An error occur...XPath expression failed to execute.<br />An error occurs while processing the XPath expression; the expression is xref:populateXRefRow('oramds:/apps/XRef/Oracle_SOA.xref','SOA','soa','Oracle','oracle','ADD')<br />The XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: Invalid metadata for Cross Reference Table "oramds:/apps/XRef/Oracle_SOA.xref"<br />Please ensure the metadata confirms to the XSD.<br />Check the detailed root cause described in the exception message text and verify that the XPath query is correct.<br /><br />Pls find solution<br />Anonymoushttps://www.blogger.com/profile/05633651409544740716noreply@blogger.comtag:blogger.com,1999:blog-2627747309936375689.post-22104282150785564972015-05-07T12:24:38.233-05:002015-05-07T12:24:38.233-05:00can you verify the xref name and path(Test.xref) i...can you verify the xref name and path(Test.xref) is correct and also verify the table name specified while creating the xref is created in SOAINFRA schema?Albinhttps://www.blogger.com/profile/17147521573616511847noreply@blogger.comtag:blogger.com,1999:blog-2627747309936375689.post-50461846844231820932015-05-06T03:54:56.029-05:002015-05-06T03:54:56.029-05:00Hi Albin
I tried to follow the above steps to cre...Hi Albin<br />I tried to follow the above steps to create a xref table in external schema and tried executing the below xref fn.<br />xref:populateXRefRow("Test.xref","ERM","S001","SFDC","e001","ADD"). I am getting the below error:<br /><br />"Unable to access Cross Reference Values from Database.The SQL Exception is: "ORA-00942: table or view does not exist[[<br />"<br />Please ensure that the database is accessible. If accessible, please look at the stack trace and fix the issue. If unable to fix contact Oracle Support <br />]]"<br /><br />Can you please help me in fixing the issue.<br /><br />Thanks,<br />AvinashAnonymoushttps://www.blogger.com/profile/12963103547957673892noreply@blogger.comtag:blogger.com,1999:blog-2627747309936375689.post-42690886375250057892013-11-14T03:08:14.472-06:002013-11-14T03:08:14.472-06:00can you provide me the error details what you are ...can you provide me the error details what you are receivingAlbinhttps://www.blogger.com/profile/17147521573616511847noreply@blogger.comtag:blogger.com,1999:blog-2627747309936375689.post-49093394171601379022013-11-14T02:02:49.260-06:002013-11-14T02:02:49.260-06:00Thanks for information,
Im nt able to insert rows ...Thanks for information,<br />Im nt able to insert rows into the db after creating can u help me to sort out<br />Anonymousnoreply@blogger.com