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!
|
|
Sync-Problems with 6.2.6
Posted: 07 Mar 08 2:53 AM
|
hi, we upgraded to SLX 6.2.6 (from 6.2.1), now we are facing two problems:
+ in Administrator > User Properties of Remote User > Tab "Sync" > Settings for SyncServer: the settings aren't saved, if you enter something, nothing is saved. For existing and new users.
+ sync works; but at some clients the sync is verrry slow: the getting and decompressing of datafiles is fast (connected via LAN), but the processing ("processing transactions") to the local MSDE is extremely slow, about 10 transactions per second. Normally it is 1000 transactions per second or faster.
Any ideas?
Thanks! |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 07 Mar 08 7:30 AM
|
Not sure if this is related but make sure ALL your admin consoles are upgraded. We've had problems were an older admin client updated a sync subscription and then it would blank out the conditions, effectively giving the user ALL accounts.
That might be why you are seeing users with very long syncs.
Just a thought. I could be way off.  |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 07 Mar 08 7:49 AM
|
| Thanks fot the hint - the "funny" thing is: with old version of admin the thing with not savable sync settings works... with new one not. today i managed to swith an existing network user to remote user (with new admin) and this worked?! strange... |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 2:53 AM
|
*bump*
sorry for bumping this one, but the problem still/again occurs. in slx admin 6.2.6 i can't change the settings "syncserver" and "sync transfer profile" in tab "Sync" of UserSettings. The input is not saved.
Anyone got this problem? i have no idea how to active sync for these users.
Does someone know where this is written in database so I write it directly to database if nothing else works?
Thanks!
Martin |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 8:02 AM
|
I had a nearly idential issue with a dev admin and production admin. The production one works fine but the dev one wouldn't work. I then found that the data provider (in our case Oracle) was an older version.
I'm not sure if that helps your situation or not but you want to make sure your data providers are up to date.
Marc |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 8:05 AM
|
hi marc,
good hint, we are using oracle as well - and yes, maybe this is our problem. we are having oracle 10g but using client version 9i (which works fine so far). but i will check this and tell you my results
thanks, martin |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 8:08 AM
|
Def upgrade the SLX servers (especially the sync server) to use the 10g client. The users can usually get by, but I recommend upgrading them as you can as well. It's well worth it. There are lots of little weird glitches that can occur with SLX and Oracle. Having everything on one version certainly helps clarify things when troubleshooting.
Marc |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 8:14 AM
|
hmm when trying to create a connection to our slx-server with 10g using a client pc with actually 10g installed i get: "could not connect to database. ensure:
+ ensure database server is running (is)
+ ensure slx server aliases are configured correctly (are) [slx server to connect to is using 9i client, not 10g to establish connection to our 10g database)
+ ensure oracle TNS ... (is)
any idea? |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 8:19 AM
|
Marty,
You'll have to copy the TNS data over into the 10g installation. You can have both 9i and 10g clients, though I don't recommend it personally.
I'd recommend:
1) Uninstall 9i
2) Reboot
3) Install 10g
4) Reboot
5) Copy over the TNSNames.ora file from a 9i machine. (In 10g it goes here: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN, or where your oracle installation folder is.)
Hope that helps,
Marc |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 3:14 PM
|
ok, now i have managed to reinstall oracle 10g on our test server. Using this server as ConnectionManager for test-database (on 10g) works fine. But it seems I cannot connect (using any kind of slx-application like admin, architect, ...) from this machine to the production connectionManager which uses 9i to connect to database. could this be true, or is there another problem?
upgrading the productive server to a oracle 10g client is not that easy because of the complex environment here  |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 3:17 PM
|
Marty,
The mismatched Oracle Client versions from the admin console and the connection manager system aren't good but shouldn't prevent you from connecting at all.
Don't you just LOVE Oracle??
This is a large reason we are migrating to MSSQL later this spring. |
|
|
|
Re: Sync-Problems with 6.2.6
Posted: 05 Jan 09 3:22 PM
|
>This is a large reason we are migrating to MSSQL later this spring
cant even image why you should do... ))
*sigh oracle is sooo fun*  |
|
|
|