Mobilink 11

Hi all,

I am running my scripts through SQL Anywhere 11 and I get
this error message when starting my Mobilink server:

E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
was unable to calculate the timestamp precision on the
consolidated database using the ml_scripts_modified table. 
Timestamp precision related warnings will not be generated

Any ideas why this is occuring?

(Can't find the SQL 11 documentation online with the same
error).
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbmren9/00000492.htm

Cheers,

Shao
v 11.0.0

I. 2008-07-21 15:34:46. SQL Anywhere MobiLink Server Version
11.0.0.1264
I. 2008-07-21 15:34:46.
I. 2008-07-21 15:34:46. Copyright =a9 2001-2008, iAnywhere
Solutions, Inc.
I. 2008-07-21 15:34:46. Portions copyright =a9 1988-2008,
Sybase, Inc. All rights reserved.
I. 2008-07-21 15:34:46. Use of this software is governed by
the Sybase License Agreement. Refer to
http://www.sybase.com/softwarelicenses
I. 2008-07-21 15:34:46.
I. 2008-07-21 15:34:46. This server is licensed to:
I. 2008-07-21 15:34:46.     Civica
I. 2008-07-21 15:34:46.     Civica
I. 2008-07-21 15:34:46. Running Windows 2003 Build 3790
Service Pack 2 on X86 (X86_64)
I. 2008-07-21 15:34:46. Server built for X86 processor
architecture
I. 2008-07-21 15:34:46. <Main> Option 1: -c
I. 2008-07-21 15:34:46. <Main> Option 2:
dsn=3dMTM_DEV11_Central
I. 2008-07-21 15:34:46. <Main> Option 3: -x
I. 2008-07-21 15:34:46. <Main> Option 4: tcpip{port=3d7030}
I. 2008-07-21 15:34:46. <Main> Option 5: -v+
I. 2008-07-21 15:34:46. <Main> Option 6: -e
I. 2008-07-21 15:34:46. <Main> Option 7:
E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log
I. 2008-07-21 15:34:46. <Main> Option 8: -zu+
I. 2008-07-21 15:34:46. <Main> Option 9: -fr
I. 2008-07-21 15:34:46. <Main> Option 10: -sl
I. 2008-07-21 15:34:46. <Main> Option 11:
dnet(-clrVersion=3dv2.0.50727
I. 2008-07-21 15:34:46. <Main> Option 12:
-MLAutoLoadPath=3dE:\Environments\development11\mobileTranman\Central\bin
I. 2008-07-21 15:34:46. <Main> Option 13:
-DmtmConfigPath=3dE:\Environments\development11\mobileTranman\Central\config
I. 2008-07-21 15:34:46. <Main> Verbose logging: show row
values
I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
names when invoked
I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
contents when invoked
I. 2008-07-21 15:34:46. <Main> Verbose logging: show schema
for each table
I. 2008-07-21 15:34:46. <Main> Verbose logging: show an
error when the first read of a synchronization fails
I. 2008-07-21 15:34:46. <Main> Verbose logging: show
translated SQL for prepared statements
I. 2008-07-21 15:34:46. <Main> Verbose logging: show
rowcount values
I. 2008-07-21 15:34:46. <Main> Cache size: 52428800 bytes
I. 2008-07-21 15:34:46. <Main> Download cache directory
size: 10485760 bytes
I. 2008-07-21 15:34:46. <Main> Local file for remote
synchronization logs:
'E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log'
I. 2008-07-21 15:34:46. <Main> Individual database
connections will be closed after synchronization errors
I. 2008-07-21 15:34:46. <Main> Maximum number of BLOB bytes
to compare: 4294967295
I. 2008-07-21 15:34:46. <Main> Maximum number of database
connections: 6
I. 2008-07-21 15:34:46. <Main> Maximum number of deadlock
retries: 10
I. 2008-07-21 15:34:46. <Main> Timeout for inactive database
connections: 60 minutes
I. 2008-07-21 15:34:46. <Main> Maximum delay between retries
after deadlock: 30 seconds
I. 2008-07-21 15:34:46. <Main> Rowset size: 10
I. 2008-07-21 15:34:46. <Main> Number of database worker
threads: 5
I. 2008-07-21 15:34:46. <Main> Maximum number of threads
uploading concurrently: 5
W. 2008-07-21 15:34:46. <Main> [10064] Unknown users will be
added automatically (when there is no authenticate_user
script)
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
10.00.0001
I. 2008-07-21 15:34:46. <Main> ODBC Version supported by the
driver: 3.52
I. 2008-07-21 15:34:46. <Main> Collation sequence of the
consolidated database is 'windows-1252'
I. 2008-07-21 15:34:46. <Main> System event:
                        set temporary option chained =3d
'ON'
I. 2008-07-21 15:34:46. <Main> Translated SQL:
                        set temporary option chained =3d
'ON'
I. 2008-07-21 15:34:46. <Main> ODBC isolation set to: Read
Committed
E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
was unable to calculate the timestamp precision on the
consolidated database using the ml_scripts_modified table. 
Timestamp precision related warnings will not be generated
0
Shao
7/21/2008 2:37:25 PM
sybase.sqlanywhere.mobilink 5254 articles. 0 followers. Follow

11 Replies
467 Views

Similar Articles

[PageSpeed] 22

There is a dedicated forum for discussion of Panorama beta issues.  You 
should have received instructions on how to post to that forum when you 
registered for the beta.

Paul Horan[TeamSybase]


<Shao Chan> wrote in message news:48849f25.6b03.1681692777@sybase.com...
Hi all,

I am running my scripts through SQL Anywhere 11 and I get
this error message when starting my Mobilink server:

E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
was unable to calculate the timestamp precision on the
consolidated database using the ml_scripts_modified table.
Timestamp precision related warnings will not be generated

Any ideas why this is occuring?

(Can't find the SQL 11 documentation online with the same
error).
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbmren9/00000492.htm

Cheers,

Shao
v 11.0.0

I. 2008-07-21 15:34:46. SQL Anywhere MobiLink Server Version
11.0.0.1264
I. 2008-07-21 15:34:46.
I. 2008-07-21 15:34:46. Copyright � 2001-2008, iAnywhere
Solutions, Inc.
I. 2008-07-21 15:34:46. Portions copyright � 1988-2008,
Sybase, Inc. All rights reserved.
I. 2008-07-21 15:34:46. Use of this software is governed by
the Sybase License Agreement. Refer to
http://www.sybase.com/softwarelicenses
I. 2008-07-21 15:34:46.
I. 2008-07-21 15:34:46. This server is licensed to:
I. 2008-07-21 15:34:46.     Civica
I. 2008-07-21 15:34:46.     Civica
I. 2008-07-21 15:34:46. Running Windows 2003 Build 3790
Service Pack 2 on X86 (X86_64)
I. 2008-07-21 15:34:46. Server built for X86 processor
architecture
I. 2008-07-21 15:34:46. <Main> Option 1: -c
I. 2008-07-21 15:34:46. <Main> Option 2:
dsn=MTM_DEV11_Central
I. 2008-07-21 15:34:46. <Main> Option 3: -x
I. 2008-07-21 15:34:46. <Main> Option 4: tcpip{port=7030}
I. 2008-07-21 15:34:46. <Main> Option 5: -v+
I. 2008-07-21 15:34:46. <Main> Option 6: -e
I. 2008-07-21 15:34:46. <Main> Option 7:
E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log
I. 2008-07-21 15:34:46. <Main> Option 8: -zu+
I. 2008-07-21 15:34:46. <Main> Option 9: -fr
I. 2008-07-21 15:34:46. <Main> Option 10: -sl
I. 2008-07-21 15:34:46. <Main> Option 11:
dnet(-clrVersion=v2.0.50727
I. 2008-07-21 15:34:46. <Main> Option 12:
-MLAutoLoadPath=E:\Environments\development11\mobileTranman\Central\bin
I. 2008-07-21 15:34:46. <Main> Option 13:
-DmtmConfigPath=E:\Environments\development11\mobileTranman\Central\config
I. 2008-07-21 15:34:46. <Main> Verbose logging: show row
values
I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
names when invoked
I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
contents when invoked
I. 2008-07-21 15:34:46. <Main> Verbose logging: show schema
for each table
I. 2008-07-21 15:34:46. <Main> Verbose logging: show an
error when the first read of a synchronization fails
I. 2008-07-21 15:34:46. <Main> Verbose logging: show
translated SQL for prepared statements
I. 2008-07-21 15:34:46. <Main> Verbose logging: show
rowcount values
I. 2008-07-21 15:34:46. <Main> Cache size: 52428800 bytes
I. 2008-07-21 15:34:46. <Main> Download cache directory
size: 10485760 bytes
I. 2008-07-21 15:34:46. <Main> Local file for remote
synchronization logs:
'E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log'
I. 2008-07-21 15:34:46. <Main> Individual database
connections will be closed after synchronization errors
I. 2008-07-21 15:34:46. <Main> Maximum number of BLOB bytes
to compare: 4294967295
I. 2008-07-21 15:34:46. <Main> Maximum number of database
connections: 6
I. 2008-07-21 15:34:46. <Main> Maximum number of deadlock
retries: 10
I. 2008-07-21 15:34:46. <Main> Timeout for inactive database
connections: 60 minutes
I. 2008-07-21 15:34:46. <Main> Maximum delay between retries
after deadlock: 30 seconds
I. 2008-07-21 15:34:46. <Main> Rowset size: 10
I. 2008-07-21 15:34:46. <Main> Number of database worker
threads: 5
I. 2008-07-21 15:34:46. <Main> Maximum number of threads
uploading concurrently: 5
W. 2008-07-21 15:34:46. <Main> [10064] Unknown users will be
added automatically (when there is no authenticate_user
script)
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
10.00.0001
I. 2008-07-21 15:34:46. <Main> ODBC Version supported by the
driver: 3.52
I. 2008-07-21 15:34:46. <Main> Collation sequence of the
consolidated database is 'windows-1252'
I. 2008-07-21 15:34:46. <Main> System event:
                        set temporary option chained =
'ON'
I. 2008-07-21 15:34:46. <Main> Translated SQL:
                        set temporary option chained =
'ON'
I. 2008-07-21 15:34:46. <Main> ODBC isolation set to: Read
Committed
E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
was unable to calculate the timestamp precision on the
consolidated database using the ml_scripts_modified table.
Timestamp precision related warnings will not be generated 


0
Paul
7/21/2008 6:17:39 PM
Hi Paul,

I am not using the beta release.  I am using the official release.

Cheers,

Shao

"Paul Horan[TeamSybase]" <phoran_nospam@sybase.com> wrote in message 
news:4884d2c3@forums-1-dub...
> There is a dedicated forum for discussion of Panorama beta issues.  You 
> should have received instructions on how to post to that forum when you 
> registered for the beta.
>
> Paul Horan[TeamSybase]
>
>
> <Shao Chan> wrote in message news:48849f25.6b03.1681692777@sybase.com...
> Hi all,
>
> I am running my scripts through SQL Anywhere 11 and I get
> this error message when starting my Mobilink server:
>
> E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
> was unable to calculate the timestamp precision on the
> consolidated database using the ml_scripts_modified table.
> Timestamp precision related warnings will not be generated
>
> Any ideas why this is occuring?
>
> (Can't find the SQL 11 documentation online with the same
> error).
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbmren9/00000492.htm
>
> Cheers,
>
> Shao
> v 11.0.0
>
> I. 2008-07-21 15:34:46. SQL Anywhere MobiLink Server Version
> 11.0.0.1264
> I. 2008-07-21 15:34:46.
> I. 2008-07-21 15:34:46. Copyright � 2001-2008, iAnywhere
> Solutions, Inc.
> I. 2008-07-21 15:34:46. Portions copyright � 1988-2008,
> Sybase, Inc. All rights reserved.
> I. 2008-07-21 15:34:46. Use of this software is governed by
> the Sybase License Agreement. Refer to
> http://www.sybase.com/softwarelicenses
> I. 2008-07-21 15:34:46.
> I. 2008-07-21 15:34:46. This server is licensed to:
> I. 2008-07-21 15:34:46.     Civica
> I. 2008-07-21 15:34:46.     Civica
> I. 2008-07-21 15:34:46. Running Windows 2003 Build 3790
> Service Pack 2 on X86 (X86_64)
> I. 2008-07-21 15:34:46. Server built for X86 processor
> architecture
> I. 2008-07-21 15:34:46. <Main> Option 1: -c
> I. 2008-07-21 15:34:46. <Main> Option 2:
> dsn=MTM_DEV11_Central
> I. 2008-07-21 15:34:46. <Main> Option 3: -x
> I. 2008-07-21 15:34:46. <Main> Option 4: tcpip{port=7030}
> I. 2008-07-21 15:34:46. <Main> Option 5: -v+
> I. 2008-07-21 15:34:46. <Main> Option 6: -e
> I. 2008-07-21 15:34:46. <Main> Option 7:
> E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log
> I. 2008-07-21 15:34:46. <Main> Option 8: -zu+
> I. 2008-07-21 15:34:46. <Main> Option 9: -fr
> I. 2008-07-21 15:34:46. <Main> Option 10: -sl
> I. 2008-07-21 15:34:46. <Main> Option 11:
> dnet(-clrVersion=v2.0.50727
> I. 2008-07-21 15:34:46. <Main> Option 12:
> -MLAutoLoadPath=E:\Environments\development11\mobileTranman\Central\bin
> I. 2008-07-21 15:34:46. <Main> Option 13:
> -DmtmConfigPath=E:\Environments\development11\mobileTranman\Central\config
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show row
> values
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
> names when invoked
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
> contents when invoked
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show schema
> for each table
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show an
> error when the first read of a synchronization fails
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show
> translated SQL for prepared statements
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show
> rowcount values
> I. 2008-07-21 15:34:46. <Main> Cache size: 52428800 bytes
> I. 2008-07-21 15:34:46. <Main> Download cache directory
> size: 10485760 bytes
> I. 2008-07-21 15:34:46. <Main> Local file for remote
> synchronization logs:
> 'E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log'
> I. 2008-07-21 15:34:46. <Main> Individual database
> connections will be closed after synchronization errors
> I. 2008-07-21 15:34:46. <Main> Maximum number of BLOB bytes
> to compare: 4294967295
> I. 2008-07-21 15:34:46. <Main> Maximum number of database
> connections: 6
> I. 2008-07-21 15:34:46. <Main> Maximum number of deadlock
> retries: 10
> I. 2008-07-21 15:34:46. <Main> Timeout for inactive database
> connections: 60 minutes
> I. 2008-07-21 15:34:46. <Main> Maximum delay between retries
> after deadlock: 30 seconds
> I. 2008-07-21 15:34:46. <Main> Rowset size: 10
> I. 2008-07-21 15:34:46. <Main> Number of database worker
> threads: 5
> I. 2008-07-21 15:34:46. <Main> Maximum number of threads
> uploading concurrently: 5
> W. 2008-07-21 15:34:46. <Main> [10064] Unknown users will be
> added automatically (when there is no authenticate_user
> script)
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
> 10.00.0001
> I. 2008-07-21 15:34:46. <Main> ODBC Version supported by the
> driver: 3.52
> I. 2008-07-21 15:34:46. <Main> Collation sequence of the
> consolidated database is 'windows-1252'
> I. 2008-07-21 15:34:46. <Main> System event:
>                        set temporary option chained =
> 'ON'
> I. 2008-07-21 15:34:46. <Main> Translated SQL:
>                        set temporary option chained =
> 'ON'
> I. 2008-07-21 15:34:46. <Main> ODBC isolation set to: Read
> Committed
> E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
> was unable to calculate the timestamp precision on the
> consolidated database using the ml_scripts_modified table.
> Timestamp precision related warnings will not be generated
> 


0
Shao
7/21/2008 7:02:30 PM
Shao,

Is the consolidated database SQL Anywhere?

The following lines show you are using the SQL Anywhere 10.00.0001 ODBC 
driver. What happens if you use the SQL Anywhere 11.00.0000 ODBC driver?

I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
10.00.0001

-- 
Joshua Savill
Sybase iAnywhere - Product Manager

Shao Chan wrote:
> Hi all,
> 
> I am running my scripts through SQL Anywhere 11 and I get
> this error message when starting my Mobilink server:
> 
> E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
> was unable to calculate the timestamp precision on the
> consolidated database using the ml_scripts_modified table. 
> Timestamp precision related warnings will not be generated
> 
> Any ideas why this is occuring?
> 
> (Can't find the SQL 11 documentation online with the same
> error).
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbmren9/00000492.htm
> 
> Cheers,
> 
> Shao
> v 11.0.0
> 
> I. 2008-07-21 15:34:46. SQL Anywhere MobiLink Server Version
> 11.0.0.1264
> I. 2008-07-21 15:34:46.
> I. 2008-07-21 15:34:46. Copyright � 2001-2008, iAnywhere
> Solutions, Inc.
> I. 2008-07-21 15:34:46. Portions copyright � 1988-2008,
> Sybase, Inc. All rights reserved.
> I. 2008-07-21 15:34:46. Use of this software is governed by
> the Sybase License Agreement. Refer to
> http://www.sybase.com/softwarelicenses
> I. 2008-07-21 15:34:46.
> I. 2008-07-21 15:34:46. This server is licensed to:
> I. 2008-07-21 15:34:46.     Civica
> I. 2008-07-21 15:34:46.     Civica
> I. 2008-07-21 15:34:46. Running Windows 2003 Build 3790
> Service Pack 2 on X86 (X86_64)
> I. 2008-07-21 15:34:46. Server built for X86 processor
> architecture
> I. 2008-07-21 15:34:46. <Main> Option 1: -c
> I. 2008-07-21 15:34:46. <Main> Option 2:
> dsn=MTM_DEV11_Central
> I. 2008-07-21 15:34:46. <Main> Option 3: -x
> I. 2008-07-21 15:34:46. <Main> Option 4: tcpip{port=7030}
> I. 2008-07-21 15:34:46. <Main> Option 5: -v+
> I. 2008-07-21 15:34:46. <Main> Option 6: -e
> I. 2008-07-21 15:34:46. <Main> Option 7:
> E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log
> I. 2008-07-21 15:34:46. <Main> Option 8: -zu+
> I. 2008-07-21 15:34:46. <Main> Option 9: -fr
> I. 2008-07-21 15:34:46. <Main> Option 10: -sl
> I. 2008-07-21 15:34:46. <Main> Option 11:
> dnet(-clrVersion=v2.0.50727
> I. 2008-07-21 15:34:46. <Main> Option 12:
> -MLAutoLoadPath=E:\Environments\development11\mobileTranman\Central\bin
> I. 2008-07-21 15:34:46. <Main> Option 13:
> -DmtmConfigPath=E:\Environments\development11\mobileTranman\Central\config
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show row
> values
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
> names when invoked
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
> contents when invoked
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show schema
> for each table
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show an
> error when the first read of a synchronization fails
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show
> translated SQL for prepared statements
> I. 2008-07-21 15:34:46. <Main> Verbose logging: show
> rowcount values
> I. 2008-07-21 15:34:46. <Main> Cache size: 52428800 bytes
> I. 2008-07-21 15:34:46. <Main> Download cache directory
> size: 10485760 bytes
> I. 2008-07-21 15:34:46. <Main> Local file for remote
> synchronization logs:
> 'E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log'
> I. 2008-07-21 15:34:46. <Main> Individual database
> connections will be closed after synchronization errors
> I. 2008-07-21 15:34:46. <Main> Maximum number of BLOB bytes
> to compare: 4294967295
> I. 2008-07-21 15:34:46. <Main> Maximum number of database
> connections: 6
> I. 2008-07-21 15:34:46. <Main> Maximum number of deadlock
> retries: 10
> I. 2008-07-21 15:34:46. <Main> Timeout for inactive database
> connections: 60 minutes
> I. 2008-07-21 15:34:46. <Main> Maximum delay between retries
> after deadlock: 30 seconds
> I. 2008-07-21 15:34:46. <Main> Rowset size: 10
> I. 2008-07-21 15:34:46. <Main> Number of database worker
> threads: 5
> I. 2008-07-21 15:34:46. <Main> Maximum number of threads
> uploading concurrently: 5
> W. 2008-07-21 15:34:46. <Main> [10064] Unknown users will be
> added automatically (when there is no authenticate_user
> script)
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
> 10.00.0001
> I. 2008-07-21 15:34:46. <Main> ODBC Version supported by the
> driver: 3.52
> I. 2008-07-21 15:34:46. <Main> Collation sequence of the
> consolidated database is 'windows-1252'
> I. 2008-07-21 15:34:46. <Main> System event:
>                         set temporary option chained =
> 'ON'
> I. 2008-07-21 15:34:46. <Main> Translated SQL:
>                         set temporary option chained =
> 'ON'
> I. 2008-07-21 15:34:46. <Main> ODBC isolation set to: Read
> Committed
> E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
> was unable to calculate the timestamp precision on the
> consolidated database using the ml_scripts_modified table. 
> Timestamp precision related warnings will not be generated
0
Josh
7/21/2008 7:45:36 PM
Shao,

Shao Chan wrote:
> (Can't find the SQL 11 documentation online with the same
> error).

Note: The new SQL Anywhere 11.0.0 documentation can be found online via 
"DocCommentXChange", found here: http://dcx.sybase.com/

(Specifically, the error message in question can be found here: 
http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1100en%2Fsaerrors_en11%2Fmlsrverrm10076.html 
)

Regards,

-- 
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community : 
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs : 
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
0
Jeff
7/21/2008 8:49:07 PM
Hi Josh,

Thanks for that.  I will check it out.  I have SQLA 10 and SQLA 11 on our 
server.  I will check why the DSN was created against the old ODBC driver.

I did notice that the ODBC driver was 10.x but couldn't be sure that the 
numbering followed the database numbering.

Cheers,

Shao


"Josh Savill" <no_spam_jsavill@ianywhere.com> wrote in message 
news:4884e760$1@forums-1-dub...
> Shao,
>
> Is the consolidated database SQL Anywhere?
>
> The following lines show you are using the SQL Anywhere 10.00.0001 ODBC 
> driver. What happens if you use the SQL Anywhere 11.00.0000 ODBC driver?
>
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
> 10.00.0001
>
> -- 
> Joshua Savill
> Sybase iAnywhere - Product Manager
>
> Shao Chan wrote:
>> Hi all,
>>
>> I am running my scripts through SQL Anywhere 11 and I get
>> this error message when starting my Mobilink server:
>>
>> E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
>> was unable to calculate the timestamp precision on the
>> consolidated database using the ml_scripts_modified table. Timestamp 
>> precision related warnings will not be generated
>>
>> Any ideas why this is occuring?
>>
>> (Can't find the SQL 11 documentation online with the same
>> error).
>> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbmren9/00000492.htm
>>
>> Cheers,
>>
>> Shao
>> v 11.0.0
>>
>> I. 2008-07-21 15:34:46. SQL Anywhere MobiLink Server Version
>> 11.0.0.1264
>> I. 2008-07-21 15:34:46.
>> I. 2008-07-21 15:34:46. Copyright � 2001-2008, iAnywhere
>> Solutions, Inc.
>> I. 2008-07-21 15:34:46. Portions copyright � 1988-2008,
>> Sybase, Inc. All rights reserved.
>> I. 2008-07-21 15:34:46. Use of this software is governed by
>> the Sybase License Agreement. Refer to
>> http://www.sybase.com/softwarelicenses
>> I. 2008-07-21 15:34:46.
>> I. 2008-07-21 15:34:46. This server is licensed to:
>> I. 2008-07-21 15:34:46.     Civica
>> I. 2008-07-21 15:34:46.     Civica
>> I. 2008-07-21 15:34:46. Running Windows 2003 Build 3790
>> Service Pack 2 on X86 (X86_64)
>> I. 2008-07-21 15:34:46. Server built for X86 processor
>> architecture
>> I. 2008-07-21 15:34:46. <Main> Option 1: -c
>> I. 2008-07-21 15:34:46. <Main> Option 2:
>> dsn=MTM_DEV11_Central
>> I. 2008-07-21 15:34:46. <Main> Option 3: -x
>> I. 2008-07-21 15:34:46. <Main> Option 4: tcpip{port=7030}
>> I. 2008-07-21 15:34:46. <Main> Option 5: -v+
>> I. 2008-07-21 15:34:46. <Main> Option 6: -e
>> I. 2008-07-21 15:34:46. <Main> Option 7:
>> E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log
>> I. 2008-07-21 15:34:46. <Main> Option 8: -zu+
>> I. 2008-07-21 15:34:46. <Main> Option 9: -fr
>> I. 2008-07-21 15:34:46. <Main> Option 10: -sl
>> I. 2008-07-21 15:34:46. <Main> Option 11:
>> dnet(-clrVersion=v2.0.50727
>> I. 2008-07-21 15:34:46. <Main> Option 12:
>> -MLAutoLoadPath=E:\Environments\development11\mobileTranman\Central\bin
>> I. 2008-07-21 15:34:46. <Main> Option 13:
>> -DmtmConfigPath=E:\Environments\development11\mobileTranman\Central\config
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show row
>> values
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
>> names when invoked
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show script
>> contents when invoked
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show schema
>> for each table
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show an
>> error when the first read of a synchronization fails
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show
>> translated SQL for prepared statements
>> I. 2008-07-21 15:34:46. <Main> Verbose logging: show
>> rowcount values
>> I. 2008-07-21 15:34:46. <Main> Cache size: 52428800 bytes
>> I. 2008-07-21 15:34:46. <Main> Download cache directory
>> size: 10485760 bytes
>> I. 2008-07-21 15:34:46. <Main> Local file for remote
>> synchronization logs:
>> 'E:\Environments\development11\mobileTranman\Central\logs\Central_ml_error.log'
>> I. 2008-07-21 15:34:46. <Main> Individual database
>> connections will be closed after synchronization errors
>> I. 2008-07-21 15:34:46. <Main> Maximum number of BLOB bytes
>> to compare: 4294967295
>> I. 2008-07-21 15:34:46. <Main> Maximum number of database
>> connections: 6
>> I. 2008-07-21 15:34:46. <Main> Maximum number of deadlock
>> retries: 10
>> I. 2008-07-21 15:34:46. <Main> Timeout for inactive database
>> connections: 60 minutes
>> I. 2008-07-21 15:34:46. <Main> Maximum delay between retries
>> after deadlock: 30 seconds
>> I. 2008-07-21 15:34:46. <Main> Rowset size: 10
>> I. 2008-07-21 15:34:46. <Main> Number of database worker
>> threads: 5
>> I. 2008-07-21 15:34:46. <Main> Maximum number of threads
>> uploading concurrently: 5
>> W. 2008-07-21 15:34:46. <Main> [10064] Unknown users will be
>> added automatically (when there is no authenticate_user
>> script)
>> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Name: SQL Anywhere
>> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Version: 11.00.0000
>> I. 2008-07-21 15:34:46. <Main> ODBC DBMS Driver Version:
>> 10.00.0001
>> I. 2008-07-21 15:34:46. <Main> ODBC Version supported by the
>> driver: 3.52
>> I. 2008-07-21 15:34:46. <Main> Collation sequence of the
>> consolidated database is 'windows-1252'
>> I. 2008-07-21 15:34:46. <Main> System event:
>>                         set temporary option chained =
>> 'ON'
>> I. 2008-07-21 15:34:46. <Main> Translated SQL:
>>                         set temporary option chained =
>> 'ON'
>> I. 2008-07-21 15:34:46. <Main> ODBC isolation set to: Read
>> Committed
>> E. 2008-07-21 15:34:46. <Main> [-10076] The MobiLink server
>> was unable to calculate the timestamp precision on the
>> consolidated database using the ml_scripts_modified table. Timestamp 
>> precision related warnings will not be generated 


0
Shao
7/21/2008 9:09:24 PM
Hi Jeff,

Thanks for that.  This also seems to highlight ODBC issues.

I assume that this website is new which is why you can't Google it?

Cheers,

Shao

"Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com> wrote in 
message news:4884f643$1@forums-1-dub...
> Shao,
>
> Shao Chan wrote:
>> (Can't find the SQL 11 documentation online with the same
>> error).
>
> Note: The new SQL Anywhere 11.0.0 documentation can be found online via 
> "DocCommentXChange", found here: http://dcx.sybase.com/
>
> (Specifically, the error message in question can be found here: 
> http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1100en%2Fsaerrors_en11%2Fmlsrverrm10076.html )
>
> Regards,
>
> -- 
> Jeff Albion, Product Support Analyst
> Sybase iAnywhere
>
> iAnywhere Developer Community : 
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation : 
> http://www.ianywhere.com/developer/product_manuals
> SQL Anywhere Patches and EBFs : 
> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0 


0
Shao
7/21/2008 9:10:40 PM
On 21 Jul 2008 11:17:39 -0700, "Paul Horan[TeamSybase]"
<phoran_nospam@sybase.com> wrote:

>There is a dedicated forum for discussion of Panorama beta issues.

Hello! <g>... Check out Web 2.0, you know, blogs and stuff... it's
been GA for over a week, even the Developers Edition is available.

Breck Grinning Running And Ducking

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com
0
Breck
7/22/2008 9:57:48 AM
On 21 Jul 2008 14:10:40 -0700, "Shao Chan" <nospam@nospam.com> wrote:

>I assume that this website is new which is why you can't Google it?

dcx.sybase.com displays documentation stored in a SQL Anywhere
database, and I suspect there is no way for Google to "see" it yet...
but I am just guessing.

Breck

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com
0
Breck
7/22/2008 10:00:50 AM
Yikes!   I didn't get that memo for some reason...

-P-

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com> 
wrote in message news:qhbb84p9lbrc1g12j3fcvqvce6f3rlf5uv@4ax.com...
> On 21 Jul 2008 11:17:39 -0700, "Paul Horan[TeamSybase]"
> <phoran_nospam@sybase.com> wrote:
>
>>There is a dedicated forum for discussion of Panorama beta issues.
>
> Hello! <g>... Check out Web 2.0, you know, blogs and stuff... it's
> been GA for over a week, even the Developers Edition is available.
>
> Breck Grinning Running And Ducking
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com 


0
Paul
7/22/2008 12:03:48 PM
Hi Breck,

Thanks for that and your other responses! :)

Cheers,

Shao

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com> 
wrote in message news:0sbb84p4hfidltbn15na7jbs3mcgu4igad@4ax.com...
> On 21 Jul 2008 14:10:40 -0700, "Shao Chan" <nospam@nospam.com> wrote:
>
>>I assume that this website is new which is why you can't Google it?
>
> dcx.sybase.com displays documentation stored in a SQL Anywhere
> database, and I suspect there is no way for Google to "see" it yet...
> but I am just guessing.
>
> Breck
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com 


0
Shao
7/22/2008 9:51:28 PM
There has been no promotion yet, just an SPDC email.


On 22 Jul 2008 05:03:48 -0700, "Paul Horan[TeamSybase]"
<phoran_nospam@sybase.com> wrote:

>Yikes!   I didn't get that memo for some reason...
>
>-P-
>
>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com> 
>wrote in message news:qhbb84p9lbrc1g12j3fcvqvce6f3rlf5uv@4ax.com...
>> On 21 Jul 2008 11:17:39 -0700, "Paul Horan[TeamSybase]"
>> <phoran_nospam@sybase.com> wrote:
>>
>>>There is a dedicated forum for discussion of Panorama beta issues.
>>
>> Hello! <g>... Check out Web 2.0, you know, blogs and stuff... it's
>> been GA for over a week, even the Developers Edition is available.
>>
>> Breck Grinning Running And Ducking
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com 
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com
0
Breck
7/23/2008 9:26:16 AM
Reply: