I have installed CICSPA 3.2.1 Plugin in CICS Explorer 220.127.116.11.
I suceeded to load data into the plugin using CSV files.
While trying to use the Records view I get the following error.
Any idea what's wrong?
An internal error occurred during: "".
java.fullversion=JRE 1.6.0 IBM J9 2.4 Windows XP x86-32 jvmwi3260sr9-20110203_74623 (JIT enabled, AOT enabled)
J9VM - 20110203_074623
JIT - r9_20101028_17488ifx3
GC - 20101027_AA
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=iw_IL
Framework arguments: -showlocation
Command-line arguments: -os win32 -ws win32 -arch x86 -showlocation
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
6 replies Latest Post - 2013-01-10T14:58:48Z by blueway
Pinned topic CICSPA Plugin 3.2.1 Records view does not work
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-10T14:58:48Z at 2013-01-10T14:58:48Z by blueway
Re: CICSPA Plugin 3.2.1 Records view does not work2012-11-08T16:45:52Z in response to bluewayHi Amir, thank you for looking at the PA plugin. Sorry you got this NPE, I've not seen this before so I would be grateful if you could supply the trace information in this case.
The records view allows you to see database records once you have got connected to a PA database. Reading into what you were doing you state that you have loaded csv data into the plugin. Was this into the projects view or do you have a DB2 database you are connected to? Also it would help me if you told me what steps you were taking before this error happened.
Re: CICSPA Plugin 3.2.1 Records view does not work2012-11-11T08:31:29Z in response to Colin_StoneHello Colin,
I am using CSV data in the project view (no Db2 connection).
1. Selecting sheet view with CSV data (no data is displayed in the records view).
2. The NPE occurs upon clicking the filter view button in the Records view.
Where whould you like me to send the trace data?
Re: CICSPA Plugin 3.2.1 Records view does not work2012-11-12T09:35:26Z in response to bluewayHi Amir.
Thanks for giving me the steps for recreation I can see the issue now so I won't need the trace data after all.
The PA plugin works with both database and csv formated files. The records view is designed for database connections only so will not work with csv files. CSV files only work with the project explorer view where you can drill into them.
If you wish to use the records view you will need to create the DB2 tables on your server. You will find information about this in chapter 4 of the IBM CICS Performance Analyzer for z/OS: User guide.
But any NPE like this is important so I am grateful to you for highlighting the issue to me.
Re: CICSPA Plugin 3.2.1 Records view does not work2013-01-10T13:01:25Z in response to Colin_StoneHi Colin,
It took me sometime... but when I had the time I have created DB2 database for HDB performance.
I had to updated the manifest table as the name of the table listed in the manifest was wrong (CPA_EXPLOR41 instead of CPA_CMFPSUM).
This change enabled the CICSPA Plugin connection. I am able to watch and filter the performance records but I can't display any of the charts.
The charts are empty and the following message are listed in the error log:
SelectableColumn: Column missing issue, invalid input file Suspend time average
SelectableColumn: Column missing issue, invalid input file User Dispatch time average
Re: CICSPA Plugin 3.2.1 Records view does not work2013-01-10T13:22:28Z in response to bluewayHi Amir. Almost there, but sounds like you need to complete the create DB2 view step.
It's the view that essentially does the summarisation (i.e averaging) of the data. Hence by changing the name you have pointed at the original table which has the un-summarised data and hence the strange messages you are seeing are quoting that the columns don't exist.
I'll defer to the docs for this as they cover this area better than I can.