Skip to Content

Custom Portal Activity Reports

Hi Experts,

I have strange issue in Visual composer .

i used data service and added one input form and output table.In input form i given "select * from schema.table wehre logonid != 'XXX' " its working fine with NOT EQUAL operator. if give EQUAL operator like "select * from schema.table wehre logonid = 'XXX' " its not working . Getting application error :

An error returned form the back-end system: [jcc][t4][10120][10898][3.61.65] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

Any suggestion to resolve this issue.

VC version details :

GML version : 702.7.0027

Client version: 702.7.0.1

VCServer version :702.7.0.1

Flex version : 702.7.0.1

Portal Content version : 702.7.0.1

Portal Connector version : 702.7.0.1

Thnaks,

Prasad.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 21, 2012 at 01:03 PM

    Hi Prasad,

    This sounds very much as if you have DB2 as the database system, right?!

    In that case, try to use "progressiveStreaming=2" in the JDBC-Connector string, which should eliminate this error.

    Also compare SAP notes 1512819 (for DB2 9.1) and 1480594 (for DB2 10).

    Hope it helps

    Detlev

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.