MII 12.1 SP5 Patch 12 - QualityPortal(Comments table) used by iSPCChart

[lynda_grimard]

In xMII version 11.5, iSPCChart use the sql query 'ChartCommentQuery', under QualityPortal folder, to retreive comments (list of elementkey field) to be able to displayed red flags on iSPCChart. Comments information are stored into an Oracle table named 'Comments'. A Data Server exist to connect to this Oracle table (Data Server name is QualityPortal, Connector is IDBC and Connector type is SQL).

In MII version 12.1 SP5, iSPCChart stores comments not at the same place as xMII 11.5.

Can anybody tell me where comments are stored. I heard it's under a Netweaver database. Need more information....

Is it possible to defined a Data Server to access this Netweaver database? if yes, which kind of connector do we need?

Also, how the iSPCChart, in version 12.1, does to build red flags (which indicate a comment exist for a point)?

Do we have an equivalent at 'ChartCommentQuery' to retreive elementkey list?

P.S. My request concert also an other table of the QualityPortal: SUPPRESSEDDATAPOINTS

Thanks in advance for your collaboration.

[jcgood25 · Accepted solution]

Hi Lynda - hope all is well in Montreal

The database running underneath NW is the new home for what used to be an external database, so SQL Server, Oracle, MaxDB, etc. The table names should be very similar, just having an XMII_ prefix so you should be able to migrate your existing QualityPortal project folder and templates into 12.1 and redirect your 'QualityPortal' data server to the database. The necessary jdbc driver and configuration settings for the data server connection will depend upon the database used by NW.

There are also sample projects for QualityPortal on the downloads section of SDN if you would prefer using that instead.

[lynda_grimard]

Hi Jeremy,

Importing a 12.0 project into a 12.1 system works fine. Effectively, all files are there (under QualityPortal project) but queries use old tables name like Comments and SuppressedDataPointsu2026. And Iu2019m not sure these queries are really used in 12.1. As you will see below, I have created a comment via the iSPCChart and a red flag is displayed. When I remove the Query QualityPortal/ChartCommentQuery, nothing changed. Red flag continue to be on the iSPCChart.

In version 11.5, the SQL Query QualityPortal/ChartCommentQuery (which the output is a list of elementkey) is used by the iSPCChart to generate red flags. May you confirm me if in version 12.1, the iSPCChart use the sql query QualityPortal/ChartCommentQuery to generate red flags? Else, how red flags are now generated with version 12.1?

In version 11.5 (with the recommendation of Joe Denino - a Lighthammer consultant) we have changed the SQL Query QualityPortal/ChartCommentQuery for an Xacute Query which generate a list of elementkey based on R/3 system, instead of QualityPortal Comments table. All ours comments are stored into R/3 instead of QualityPortal DB, in order to be available for many applications (Operator Dashboard, Planner Dashboard, R/3 transactions). Same things for Suppressed Points (SuppressedPointQuery).So, itu2019s not required to import data (i.e. Comments and SuppressedPoints) from 11.5 to 12.1.

For testing purpose, I have selected a point (00000029) on my iSPCChart(version 12.1) and created a comment (via Setting>UpperChart>Comment) and a suppressed point (via Setting>UpperChart>TogglePointSuppression). Red flag and red X are visible on the iSPCChart using this standard procedure.

Then, I run a select on both tables XMII_QPComments and XMII_QPSUPPDPOINTS and all rows are effectively into these tables (see below, all rows except first row of each tables).

Then I have inserted a new row for an other point (00000001) (see below, first row of each tables), but nothing new on the iSPCChart. Nothing new even if java cache is cleared or page refreshed.

Do you know if others tables (or procedure, methot, etc...) is used to manage red X and red flag? To make of this Migration Project a success, we need a replacement solution.

Thanks in advance.

XMIIQPCOMMENTS:_

CHARTNAME CHARTTYPE CREATED CREATEDBY ELEMENTKEY COMMENTS MODIFIED MODIFIEDBY

PLANNER_0001_3910981-02_2020_0008_10000067 XBAR 09/23/2010 15:45:41 bi32772 PLANNER00013910981-022020000810000067000000012008-10-27T14:30:50 InsertQPComment Query tst TimeUnavailable

PLANNER_0001_3910981-02_2020_0008_10000067 XBAR 09/23/2010 14:22:51 bi32772 PLANNER00013910981-022020000810000067000000292007-08-14T15:45:24 TimeUnavailable

PLANNER_0001_3910981-02_2020_0008_10000067 XBAR 08/27/2010 13:27:11 bi32772 PLANNER00013910981-022020000810000067000000292007-08-14T15:45:24 test new sap mii 12.1 comment 3 TimeUnavailable

PLANNER_0001_3910981-02_2020_0008_10000067 XBAR 08/25/2010 15:01:36 bi32772 PLANNER00013910981-022020000810000067000000292007-08-14T15:45:24 ********test new sap mii 12.1 TimeUnavailable

PLANNER_0001_3910981-02_2020_0008_10000067 XBAR 08/25/2010 14:38:16 bi32772 PLANNER00013910981-022020000810000067000000292007-08-14T15:45:24 test new sap mii 12.1 TimeUnavailable

XMIIQPSUPPDPOINTS:

CHARTNAME ELEMENTKEY CREATED CREATEDBY

PLANNER_0001_3910981-02_2020_0008_10000067 PLANNER00013910981-022020000810000067000000012008-10-27T14:30:50 09/23/2010 14:25:01 bi32772

PLANNER_0001_3910981-02_2020_0008_10000067 PLANNER00013910981-022020000810000067000000292007-08-14T15:45:24 09/21/2010 15:32:22 bi32772

[lynda_grimard]

Hello Jeremy

All is well here. Hope all is well for you too.

Thank for the info. We found how to define the NW database. New tables are XMII_QPCOMMENTS and XMII_QPSUPPDPOINTS. We use Oracle here.

I found the sample projet for QualityPortal (QualityPortal.zip) on the download section of SDN but only for version 12.0 (Ref: http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/webcontent/uuid/e0171f05-98c6-2a10-f5a0-8f2ec7... [original link is broken])

Do you have the url to download QualityPortal for version 12.1 ?

[jcgood25]

Importing a 12.0 project into a 12.1 system should work fine - the contents should be migrated (if needed) as part of the project import.

I would suspect these tables to be already there on your 12.1 system (note: they will have to be used in the NW tables, not an external Oracle DB like before). The Configuration import mechanism can be used to pull in the xml results from your existing 11.5 database. If you run a test export and check the comments/suppressed options you'll see in the xml file what files are needed.