Xmii and Dates

[Former Member]

Hi

I have an issue where I believ there is a disconnect between my dates and the xmii server.

I am running the followign query against a UDS source

Select

time as OutputDate, value as OutputValue

From

picomp

Where

tag = '50210-LI-QVY-2101.01D-00' and

time >= '02-Sep-2007 06:30:00' and time <= '04-Sep-2007 06:29:00'

OutputDate OutputValue

09/01/2007 22:30:00 3311.10145501792

09/02/2007 22:30:00 3299.85427066684

This is unique to my machine, the same query in a different machine returns me the correct data

OutputDate OutputValue

09/02/2007 06:30:00 3311.10145501792

09/03/2007 06:30:00 3299.85427066684

As you can see the data is correct but the dates are not

I have noticed that my log fifiles have a timestamp that is 9 hours out (GMT) could this be affecting the return values ?

Any ideas greatly appreciated

[Former Member]

Hi,

can you tell us which logfile you are talking about? Is it xMII logfile or the SQL server logfiles or your system logfiles.

BTW... are you using select now(); as validation query while setting up the SQL server in xMII?

Regards,

Musarrat

[Former Member]

Hi Mussarat

thanks for the response

It is my my Xmii logfile i am talking about

The query is to a UDS server using oledb - not sql server

I found a link to a simlar problem

but this didnt work either

it looks like something is chnaging the date values before the data is returned

Chris

[Former Member]

sorry for misinterpreting your question....

Did you try reinstalling the JRE? Try to clear the JAVA cache first and then check if it helps

[Former Member]

Hi Chris,

this is an extract from SAP help which I stumbled across just now.

Hope this might give you an Idea.

<b>Time Synchronization of Servers and Clients</b>

In order for SAP xMII to operate correctly, the system clocks on the Web server, data servers, and client browsers should be maintained in reasonably close synchronization.

In the case where other applications on the Web server prevent the enabling of automatic daylight savings time adjustment, you must configure the time zone to use the option that does not include the auto adjust checkbox [e.g., use the (GMT-05:00) Bogota, Lima, Quito time zone instead of the (GMT-05:00) Eastern Time (US & Canada) time zone].

You can find it here...

http://help.sap.com/saphelp_xmii115/helpdata/en/Getting_Started/InstallationGuide.htm#System_Require...

[Former Member]

Hi Musarrat

Re-Installing Java AND setting the User Timezone seemed to fix the issue

I am still out by an hour (daylight savings) but my query results are correct

Thanks for your assistance

Chris