cancel
Showing results for 
Search instead for 
Did you mean: 

We are getting different values in QT and different values in DB?

Former Member
0 Kudos

Hi ,

We are getting different values when we execute the QT and same SQL Query when we execute in Database we are getting different values .Can any one suggest?

We executed the query (Screen shot Attached)on both HCM PI Server using PI OLEDB  & on SAP XMII interface server. The result from the PI OLEDB is as expected (22476) but when we execute the same query on SAP XMII interface server we are getting a entirely different value (28228) .How is it possible?

Any responses on this iwll be highly appreciated.

Thanks,

Jayanth.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member193328
Active Participant
0 Kudos

Hi Jayanth

This may happen you one of your where clause is Time or Timestamp and the MII server and DB are in different timezones.

Please set the Timezone in MII Query Date and Time setup to get the information correctly.

MII converts the server time to the timezone of the DB and asks for the data. Any SQL tool does not do this and directly returns the data for the time provided. So you may see differences.

Regards

Partha