Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass complex QuerySpec as the 'Bookmark' parameter to the XMLP Driver Service?

user8626968Jun 19 2014

We are using script to call the XMLP Driver Service to generate BIP report.

At the moment, we have only been successful when invoking the service with a simple one line query such as bookmark = "'Service Agreement'.Search = \"[Id]='" + someId + "'\"";

But we need to be able to have filters on child BCs too. We understand the query should be in the format same as PDQs. PDQs separate the queries on each BC separate lines, how should this be translated to a single string to pass on as the bookmark?

We've tried using \n or just a space like:

bookmark = "'Service Agreement'.Search = \"[Id]='" + someId + "'\"\n'Child BC'.Search = \"[Id]='"+ someOtherId +"'\"";

bookmark = "'Service Agreement'.Search = \"[Id]='" + someId + "'\" 'Child BC'.Search = \"[Id]='"+ someOtherId +"'\"";

In both cases, the service throws an error saying the bookmark is in invalid format. What should we do?

Comments

abrante
It looks like a jumpstart configuration error to me, i.e the directory of the flar is specified as " /flash_archives/TEST/js-client.flar" rather than " /flash_archives/TEST/"

.7/M.
912276
Just to provide an update.

I switched to using ftp to get the flar file from the jumpstart server, which works fine.

I do believe that the issue with NFS is because the Solaris in-built NFS will allow a file to be NFS-mounted, but the user-space NFS daemon I used ( unfsd ) does not allow this, although I've not done sufficient snooping to prove this.

Richard.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2014
Added on Jun 19 2014
#bi-publisher, #business-intelligence-peoplesoft, #error, #issue, #report, #search
0 comments
725 views