Log parametric data

[vian_abduljalil]

hi ,

we run SAPME version 6.0.4.1, and i try to use the webservice LogParametricData to insert data in the database:

when i run the webbservice in SOAP and the response seems to be ok. as below:

<SOAP-ENV:Envelope xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <SOAP-ENV:Body>

      <ns2:ParametricConfirmation_sync xmlns="http://sap.com/xi/SAPGlobal/GDT" xmlns:ns2="http://sap.com/xi/ME">

         <ns2:parametricResponse>

            <ns2:SiteRef>

               <ns2:Site>TEST1</ns2:Site>

            </ns2:SiteRef>

            <ns2:TransactionId>125</ns2:TransactionId>

         </ns2:parametricResponse>

      </ns2:ParametricConfirmation_sync>

   </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

but I get no record when I search for this transactionid in the database. The data has not been inserted in the database.

what might be the reason??

thank you

[sergiy_katerinich · Accepted solution]

Hi Vian,

Once you have received Transaction ID back, it is likely that the data is in the database. Maybe you mixed WIP.PARAMETRIC.TRANSACTION_ID with WIP.PARAMETRIC_MEASURE.TRANSACTION_ID.

The former is the one which should be returned in the WS response.

At least this works fine in 6.0.4.4 and I do not see any change to this functionality sicne 6.0.2.

Regards,

Sergiy

[vian_abduljalil · Accepted solution]

Hi Sergiy,

yes it seems that the data is in the database but when i check the both tables for WIP.PARAMETRIC.TRANSACTION_ID AND WIP.PARAMETRIC_MESURE.TRANSACTION_ID so i cann't find the data.

i get the response:

<SOAP-ENV:Envelope xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <SOAP-ENV:Body>

      <ns2:ParametricConfirmation_sync xmlns="http://sap.com/xi/SAPGlobal/GDT" xmlns:ns2="http://sap.com/xi/ME">

         <ns2:parametricResponse>

            <ns2:SiteRef>

               <ns2:Site>TEST1</ns2:Site>

            </ns2:SiteRef>

            <ns2:TransactionId>125</ns2:TransactionId>

         </ns2:parametricResponse>

      </ns2:ParametricConfirmation_sync>

   </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

when i run the WS:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:me="http://sap.com/xi/ME" xmlns:gdt="http://sap.com/xi/SAPGlobal/GDT">

   <soapenv:Header/>

   <soapenv:Body>

      <me:ParametricRequest_sync>

         <me:ParametricRequest>

            <me:SiteRef>

               <me:Site>TEST1</me:Site>

            </me:SiteRef>

             <me:OperationRef>

               <!--Optional:-->

               <me:SiteRef>

                  <me:Site>TEST1</me:Site>

               </me:SiteRef>

               <me:Operation>ICT</me:Operation>

               <!--me:Revision>#</me:Revision-->

            </me:OperationRef>

            <!--Zero or more repetitions:-->

            <me:ParametricCustom>

               <me:Attribute>test</me:Attribute>

               <me:Value>test</me:Value>

            </me:ParametricCustom>

           <!--Optional:-->

            <me:ProgramId>mdi_pb</me:ProgramId>

            <!--Optional:-->

            <me:ProgramRev>v1</me:ProgramRev>

            <!--Optional:-->

            <me:ResourceRef>

               <!--You may enter the following 2 items in any order-->

               <!--Optional:-->

               <me:SiteRef>

                  <me:Site>TEST1</me:Site>

               </me:SiteRef>

               <me:Resource>ICT007</me:Resource>

            </me:ResourceRef>

            <me:SfcRef>

               <!--You may enter the following 2 items in any order-->

               <me:Sfc>SE12480001</me:Sfc>

               <!--Optional:-->

               <me:SiteRef>

                  <me:Site>TEST1</me:Site>

               </me:SiteRef>

            </me:SfcRef>

            <!--Optional:-->

            <me:UserRef>

               <!--You may enter the following 2 items in any order-->

               <!--Optional:-->

               <me:SiteRef>

                  <me:Site>TEST1</me:Site>

               </me:SiteRef>

               <me:UserId>XML</me:UserId>

            </me:UserRef>

         </me:ParametricRequest>

      </me:ParametricRequest_sync>

   </soapenv:Body>

</soapenv:Envelope>

but when i search for transaction_id =125 so i get no record from the WIP database.

Regards,

Vian

[former_member196557 · Accepted solution]

Do you have ME System Rules Maintenance - Miscellaneous - Store Data Collection Results in ODS set to True? if so, all your Parametric data is in the ODS database, not WIP.

Regards, Steve

[vian_abduljalil · Accepted solution]

Hi Steve,

thank you for your response, that's right the StoreDataCillection Results in ODS is set to TRUE. and i found the inserted parametric data in the table AR_PARAMETRIC.

what happend if i change the value to false?

thank you

Regards,

Vian

[former_member196557 · Accepted solution]

If your change the setting to False, then the Parametric results are placed in the tables in WIP. I beleive the records can be moved to ODS when you archive records in ME.

It may be advantageous to place the parametric data directly in ODS instead of in WIP (followed by archiving to ODS) if you plan on collecting large amounts of parametric data.

Regards, Steve

[vian_abduljalil · Accepted solution]

ok i understand ,

thanks for the information.

Regards,

Vian

[HariCS23 · Accepted solution]

Hi Vian, As far i know, If you keep your data collection values in ODS directly, it wont show up in device history record and you can't run SPC charts on measures if you have that requirement.

Any way, enabling that feature of keeping data collection in ODS directly would depend your needs/architecture.

Thanks

Hari