on 02-20-2014 10:03 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.