|
| unix odbc DataDirect Optional feature not implemented
My database is Oracle 9,synchronization server is Solaris/Sparc.
1. I deploy synchronization server on windows is ok.
when i deploy it on Solaris/Sparc and try to SYNC ,there is a error .
And the /driver/locale/en_US/LC_MESSAGES/wqora19.mo not be modified
recently.
There is detailed log file
---------------------------------
I. 03/21 17:23:15. Adaptive Server Anywhere MobiLink Version 9.0.1.1996
I. 03/21 17:23:15.
I. 03/21 17:23:15. Copyright (c) 1989-2004 Sybase, Inc.
Portions Copyright (c) 2002-2004, iAnywhere Solutions,
Inc.
I. 03/21 17:23:15. All rights reserved. All unpublished rights reserved.
I. 03/21 17:23:15.
I. 03/21 17:23:15. This software contains confidential and trade secret
information of
I. 03/21 17:23:15. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 03/21 17:23:15. by the U.S. Government is subject to restrictions set
forth in a license
I. 03/21 17:23:15. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 03/21 17:23:15. other written agreement specifying the Government's
rights to use the
I. 03/21 17:23:15. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 03/21 17:23:15.
I. 03/21 17:23:15. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 03/21 17:23:15.
I. 03/21 17:23:15. Networked Seat (per-seat) model. Access to the server is
limited to 3 seat(s).
This server is licensed to:
I. 03/21 17:23:15. Developer Edition
I. 03/21 17:23:15. Restricted Use
I. 03/21 17:23:18. <Main>: MobiLink server started
I. 03/21 17:23:18. <Main>: Option 1: -c
I. 03/21 17:23:18. <Main>: Option 2: ****************
I. 03/21 17:23:18. <Main>: Option 3: -v
I. 03/21 17:23:18. <Main>: Option 4: +
I. 03/21 17:23:18. <Main>: Option 5: -zs
I. 03/21 17:23:18. <Main>: Option 6: synchttp
I. 03/21 17:23:18. <Main>: Option 7: -fr
I. 03/21 17:23:18. <Main>: Option 8: -zp
I. 03/21 17:23:18. <Main>: Option 9: -x
I. 03/21 17:23:18. <Main>: Option 10:
http(host=10.201.11. 164;port=8081;url_su
ffix=iaredirect/ml/;contd_timeout=60
;unknown_timeout=60)
I. 03/21 17:23:18. <Main>: Verbose logging: show row values
I. 03/21 17:23:18. <Main>: Verbose logging: show script names when invoked
I. 03/21 17:23:18. <Main>: Verbose logging: show script contents when
invoked
I. 03/21 17:23:18. <Main>: Verbose logging: show schema for each table
I. 03/21 17:23:18. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 03/21 17:23:18. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 03/21 17:23:18. <Main>: Verbose logging: show rowcount values
I. 03/21 17:23:18. <Main>: Individual database connections will be closed
after synchronization errors.
I. 03/21 17:23:18. <Main>: BLOB cache size: 524288
I. 03/21 17:23:18. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 03/21 17:23:18. <Main>: Maximum number of database connections: 6
I. 03/21 17:23:18. <Main>: Maximum number of deadlock retries: 10
I. 03/21 17:23:18. <Main>: Timeout for inactive database connections: 60
minutes
I. 03/21 17:23:18. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 03/21 17:23:18. <Main>: Rowset size: 10
I. 03/21 17:23:18. <Main>: Upload cache size: 524288 bytes
I. 03/21 17:23:18. <Main>: Download cache memory size: 1048576 bytes
I. 03/21 17:23:18. <Main>: Download cache directory size: 10485760 bytes
I. 03/21 17:23:18. <Main>: Number of worker threads: 5
I. 03/21 17:23:18. <Main>: Maximum number of threads uploading concurrently:
5
I. 03/21 17:23:18. <Main>: Unknown users will be rejected (when there is no
authenticate_user script).
I. 03/21 17:23:18. <Main>: Example scripts will not be automatically
generated for unknown versions.
I. 03/21 17:23:18. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 03/21 17:23:18. <Main>: Stream specifier 1:
http(host=10.201.11. 164;port=8081;url_su
ffix=iaredirect/ml/;contd_timeout=60
;unknown_timeout=60)
W. 03/21 17:23:18. <Main>: Warning: [10050] ODBC: [DataDirect][ODBC Oracle
Wire Protocol driver]Optional feature not implemented. (ODBC State = HYC00,
Native error code = 0)
W. 03/21 17:23:18. <Main>: Warning: [10050] ODBC: [DataDirect][ODBC Oracle
Wire Protocol driver]Driver's SQLSetConnectAttr failed. (ODBC State = IM006,
Native error code = 0)
I. 03/21 17:23:18. <Main>: ODBC DBMS Name: Oracle
I. 03/21 17:23:18. <Main>: ODBC DBMS Version: 09.02.0000 Oracle 9.2.0.1.0
I. 03/21 17:23:18. <Main>: ODBC DBMS Driver Version: 04.20.0104 (B0080,
U0069)
I. 03/21 17:23:18. <Main>: ODBC Version supported by the driver: 3.52
I. 03/21 17:23:18. <Main>: ODBC isolation set to: Read Committed
I. 03/21 17:23:18. <Main>: Connected
I. 03/21 17:23:18. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 03/21 17:23:18. <thread 1.1>: Ready to handle requests
I. 03/21 17:23:18. <thread 1.2>: Ready to handle requests
I. 03/21 17:23:18. <thread 1.3>: Ready to handle requests
I. 03/21 17:23:18. <thread 1.4>: Ready to handle requests
I. 03/21 17:23:18. <thread 1.5>: Ready to handle requests
I. 03/21 17:23:20. <Main>: Press 'q' to quit MobiLink server
I. 03/21 17:23:25. <thread 1.4>: Working on a request
I. 03/21 17:23:25. <thread 1.4>: Translated SQL:
SELECT last_modified FROM ml_scripts_modified
I. 03/21 17:23:25. <thread 1.4>: ml_scripts_modified last modified at:
2005-03-21 09:00:31
I. 03/21 17:23:25. <thread 1.4>: Translated SQL:
SELECT version_id FROM ml_script_version WHERE name = ?
I. 03/21 17:23:25. <thread 1.4>: UltraLite synchronization request from:
pda1 (version: update)
W. 03/21 17:23:31. <1.4> [pda1]: Warning: [10050] ODBC: [DataDirect][ODBC
Oracle Wire Protocol driver]Optional feature not implemented. (ODBC State =
HYC00, Native error code = 0)
W. 03/21 17:23:31. <1.4> [pda1]: Warning: [10050] ODBC: [DataDirect][ODBC
Oracle Wire Protocol driver]Driver's SQLSetConnectAttr failed. (ODBC State =
IM006, Native error code = 0)
I. 03/21 17:23:31. <1.4> [pda1]: ODBC isolation set to: Read Committed
I. 03/21 17:23:31. <1.4> [pda1]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_connection_script
t1, ml_script t2 WHERE t1.version_id = ? AND
t1.script_id = t2.script_id
I. 03/21 17:23:31. <1.4> [pda1]: begin_connection <connection> (no script)
I. 03/21 17:23:31. <1.4> [pda1]: COMMIT Transaction: begin_connection
I. 03/21 17:23:31. <1.4> [pda1]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 03/21 17:23:31. <1.4> [pda1]: Translated SQL:
UPDATE ml_user SET hashed_password = ? WHERE name = ?
E. 03/21 17:23:31. <1.4> [pda1]: Error: [-10055] Unable to authenticate user
pda1
I. 03/21 17:23:31. <1.4> [pda1]: Translated SQL:
SELECT commit_state FROM ml_user WHERE user_id = ?
I. 03/21 17:23:31. <1.4> [pda1]: Remote sequence number is 00000005.
Consolidated sequence number is 00000000.
I. 03/21 17:23:32. <1.4> [pda1]: Synchronization failed
I. 03/21 17:24:24. <Main>: MobiLink server shutting down
I. 03/21 17:24:24. <Main>: MobiLink server undergoing hard shutdown.
I. 03/21 17:24:24. <Main>: All connections and synchronizations being
terminated.
I. 03/21 17:24:25. <thread 1.4>: Shutting down
I. 03/21 17:24:25. <thread 1.5>: Shutting down
I. 03/21 17:24:25. <thread 1.2>: Shutting down
I. 03/21 17:24:25. <thread 1.1>: Shutting down
I. 03/21 17:24:25. <thread 1.3>: Shutting down
I. 03/21 17:24:27. <Main>: end_connection <connection> (no script)
I. 03/21 17:24:27. <Main>: COMMIT Transaction: end_connection
I. 03/21 17:24:27. <Main>: Disconnected from consolidated database
I. 03/21 17:24:27. <Main>: Disconnected
I. 03/21 17:24:27. <Main>: MobiLink server finished
There is odbc.ini file content
-------------------------------
[ODBC Data Sources]
unicom_resource=iAny
where Solutions 9 - Oracle Wire Protocol Driver
[unicom_resource]
Driver=/export/home/sybase/SYBSsa9/drivers/lib/wqora19.so
Description=iAnywher
e Solutions 9 - unicom_resource
ApplicationUsingThre
ads=0
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynon
yms=0
CatalogOptions=0
DefaultLongDataBuffL
en=1024
DescribeAtPrepare=0
EnableDescribeParam=
0
EnableNcharSupport=0
EnableScrollableCurs
ors=1
EnableStaticCursorsF
orLongData=0
EnableTimestampWithT
imeZone=0
HostName=10.201.11.164
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=
0
SID=jszgdb
UseCurrentSchema=1
[ODBC]
IANAAppCodePage=4
InstallDir=/export/home/sybase/SYBSsa9/drivers
Trace=0
TraceDll=/export/home/sybase/SYBSsa9/drivers/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0
unix odbc DataDirect Optional feature not implemented
My database is Oracle 9,synchronization server is Solaris/Sparc.
1. I deploy synchronization server on windows is ok.
when i deploy it on Solaris/Sparc and try to SYNC ,there is a error .
And the /driver/locale/en_US/LC_MESSAGES/wqora19.mo not be modified
recently.
There is detailed log file
---------------------------------
I. 03/21 17:23:15. Adaptive Server Anywhere MobiLink Version 9.0.1.1996
I. 03/21 17:23:15.
I. 03/21 17:23:15. Copyright (c) 1989-2004 Sybase, Inc.
Portions Copyright (c) 2002-2004, iAnywhere Solutions,
Inc.
I. 03/21 17:23:15. All rights reserved. All unpublished rights reserved.
I
.. 03/21 17:23:15.
I. 03/21 17:23:15. This software contains confidential and trade secret
information of
|
|