Count of Documents Created in A folder

I am at a loss here. I have a query (see below) that runs fine in SQL Developer, but when I try to run it via Livereports I am told:

Content Server Error: Error processing request.

[This LiveReport does not allow Database modifications.]

Why would the below query require Database modification????

SELECT COUNT(*) FROM dauditnew a, kuaf b ,dtree dt WHERE dt.parentid IN (SELECT dataid FROM dtree START WITH dataid =%1 CONNECT BY PRIOR dataid = ABS (parentid)) and a.dataid = dt.dataid AND a.auditstr = 'Create' AND a.performerid = b.ID AND a.auditdate BETWEEN %2 AND %3

User Input 1 = Container

User Input 2 = Date

User Input 3 = Date

Report Format = Auto LiveReport

Find more posts tagged with

Comments

Colin_Schmidt

No mystery here....I run into this too. You'll have to check the box that says you're going to modify the DB and it'll run. There is an explanation and someone will reply, but just check it and go.

Colin J.

On Tue, Dec 16, 2014 at 1:37 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Count of Documents Created in A folder Posted bywalter.ruppar@capitalone.com (Ruppar, Walt)On 12/16/2014 01:33 PM

I am at a loss here. I have a query (see below) that runs fine in SQL Developer, but when I try to run it via Livereports I am told:Content Server Error: Error processing request.[This LiveReport does not allow Database modifications.]Why would the below query require Database modification????SELECT COUNT(*) FROM dauditnew a, kuaf b ,dtree dt WHERE dt.parentid IN (SELECT dataid FROM dtree START WITH dataid =%1 CONNECT BY PRIOR dataid = ABS (parentid)) and a.dataid = dt.dataid AND a.auditstr = 'Create' AND a.performerid = b.ID AND a.auditdate BETWEEN %2 AND %3User Input 1 = ContainerUser Input 2 = DateUser Input 3 = DateReport Format = Auto LiveReport
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation (mwv.com) or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Walt_Ruppar

Sounds like a mystery to me... I have contacted support as it does not seem correct to need to check that box when there are no modifications going on. However it is good to know that it has happened to someone else.

Incidently I can run it fine in an envrionemnt where Livereport Extensions is installed...

Lindsay_Davies

Hi Walter,

The explanation is the string ‘Create’.

When some efforts were made to harden the protection for preventing SQL that could perform updates, the initial patches were not very accurate.

There is only a simple parsing of the statement.

So in your case the presence of ‘create’ is being misinterpreted. It could be part of a create table statement, for example.

You can avoid ticking Allow Database Modifications by testing where a.AuditID = 1 instead of AuditStr = ‘Create’

Regards

Lindsay

EU-Escalation Team

OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, December 16, 2014 6:45 PM
To: eLink Recipient
Subject: Re Count of Documents Created in A folder

Re Count of Documents Created in A folder

Posted bycolin.schmidt@mwv.com (Schmidt, Colin) On 12/16/2014 01:44 PM

No mystery here....I run into this too. You'll have to check the box that says you're going to modify the DB and it'll run. There is an explanation and someone will reply, but just check it and go.

Colin J.

On Tue, Dec 16, 2014 at 1:37 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Count of Documents Created in A folder

Posted by walter.ruppar@capitalone.com (Ruppar, Walt) On 12/16/2014 01:33 PM

I am at a loss here. I have a query (see below) that runs fine in SQL Developer, but when I try to run it via Livereports I am told:
Content Server Error: Error processing request.
[This LiveReport does not allow Database modifications.]
Why would the below query require Database modification????
SELECT COUNT(*) FROM dauditnew a, kuaf b ,dtree dt WHERE dt.parentid IN (SELECT dataid FROM dtree START WITH dataid =%1 CONNECT BY PRIOR dataid = ABS (parentid)) and a.dataid = dt.dataid AND a.auditstr = 'Create' AND a.performerid = b.ID AND a.auditdate BETWEEN %2 AND %3
User Input 1 = Container
User Input 2 = Date
User Input 3 = Date
Report Format = Auto LiveReport
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Count of Documents Created in A folder
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Walt_Ruppar

Mystery Solved! Thanks Much!!!