The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Temp. change timezone on production SLX Server
Posted: 14 Nov 06 1:28 PM
|
fiogf49gjkf0d I have a script that imports some data from Goldmine into SLX. When I convert the data, it passes through the SLX Provider which views the Goldmine data as Greenwich Mean time - 4 hours ahead of EST. So when I convert it, it subtract 4 hours from the date - so in goldmine it is showing as 2004-03-24 00:00:00.000 - then when it is converted is showing as 2004-03-22 20:00:00.000.
A work around Tech support gave me is to set the Time Zone on the Production SLX Server to Greenwich mean time, convert the data, then set it back. This data must sync out.
My question is: Will changing the time zone, converting the data, then changing the time zone back have any ill effects on syncing or other parts of the SLX system? The sync service will be turned off during the conversion. Thanks
Steve K. |
|
|
|
Re: Temp. change timezone on production SLX Server
Posted: 14 Nov 06 4:37 PM
|
fiogf49gjkf0d I don't know if changing the time zone will have any ill effects or not. If you do go down this path I would suggest that you do it off hours and make sure the syncserver does not cycle.
Why don't you just fix the script?
BTW, if the Goldmine data is just date information then all you need to do is define the target field as a DATE field (vs DATETIME) in the DBManager and the provider will not adjust the values for GMT. |
|
|
|
Re: Temp. change timezone on production SLX Server
Posted: 15 Nov 06 10:43 AM
|
fiogf49gjkf0d Just for the record - I did move the data to DATE (vs DATETIME) field and still experienced the time difference. I was suprised as I recreated a bunch of DATETIME fields as DATE fields a few months ago to prevent this very problem. Seems to only apply to data manipulation on the frontend.. |
|
|
|
Re: Temp. change timezone on production SLX Server
Posted: 15 Nov 06 10:45 AM
|
fiogf49gjkf0d GMT adjustment is applied at the provider level, not the UI. If you set a field as Date only then the provider does not adjust for GMT. Did you restart the slxserver service after you made the change?
Note that we use this all the time without issue. If you have found a case where it is not working, you have found a defect and I would really like to know about it 
Timmus |
|
|
| |
|