on 11-20-2007 4:47 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
User | Count |
---|---|
4 | |
4 | |
1 | |
1 | |
1 | |
1 | |
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.