11/25/2024 11:39:38 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Login Error during changing data connection
Posted: 21 Oct 08 1:02 PM
|
Hi,
We are in the process of changing data connection from regular Oracle server to Oracle RAC. We used the Connection Manager to make the change. When we did the test connection on the Connection Manager, it was successful. However, when we tried to login to SLX Client or Administrator, we got Log In error. We then use the SalesLogix Profiler to track the process. One of the key SQL is "SELECT DBTYPE, SITECODE, DBVERSION, PRIMARYSERVER FROM SYSTEMINFO WHERE SYSTEMINFOID = 'PRIMARY'" The retrieved result for PRIMARYSERVER is the SITECODE used for the next SQL - "SELECT SERVERPATH FROM SYNCSERVER WHERE SITECODE ='xxx' "
In regular Oracle, the SITECODE = '8J2F'; but in RAC, the SITECODE = '8'.
Does anyone know that any setting on SLX that can be changed to resolve this issue? Or is there other way?
Thanks for any help!
Wen
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|