Custom Portal Activity Reports

[former_member187970]

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.

[detlev_beutner]

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

[former_member187970]

Hi Detlev,

Thanks for your replay, where can i use  this "progressiveStreaming=2" in  JDBC-Connector string.

Please explain me exact path to change JDBC-Connector string.

It is DB2 ( 9.5 )

Thanks,

Prasad.

[detlev_beutner]

Hi Prasad,

I don't know details of VC nor of your technical scenario, so I only can guess where your JDBC connection is defined - you definitely should know this!

It might be a connection defined under

Visual administrator (j2ee admin) -> Server -> Services -> JDBC Connector

or

If you use a JDBC BI system, it might be defined as a portal system, see http://help.sap.com/saphelp_nw70/helpdata/de/5e/4d48b62fe54c23a8dbef364a289d8f/frameset.htm

Hope it helps

Detlev