|
Home > Archive > SQL Anywhere Mobile > May 2005 > Help! Error [-10019] in moblink v9 from asa v7.02 client
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help! Error [-10019] in moblink v9 from asa v7.02 client
|
|
| SusanB@Medvantx 2005-04-19, 8:24 pm |
| Hello, I'm trying to test upgrade of mobilink server to v
9.0.2. Client is asa v7.02 on linux, consolidated is Oracle
v 9.2.0.1.0 and just upgraded from v 7.02. Mobilink is
set-up as service on win2k using new wire protocol driver
(not the old oracle odbc).
Mobilink errors on the first 'upload_cursor' table script.
I tried adding -tt option to the service but it did not
produce decent information. the "user/pwd" can execute the
select without issue (unless one of the parameters is not
set?) select t1.event, t2.script_language, t2.script from
ml_table_script t1, ml_script t2 where t1.table_id = ?, and
t1.version_id = ? and t1.script_id = t2.script_id
do I need to specify any additional options for v9 moblink
service in order to "mobilink" the asa 7 client to the
oracle consolidated db?
we start the win2k service in a bat file attached.
| |
| Greg Fenton 2005-04-19, 8:24 pm |
| SusanB@Medvantx wrote:
> Hello, I'm trying to test upgrade of mobilink server to v
> 9.0.2. Client is asa v7.02 on linux, consolidated is Oracle
> v 9.2.0.1.0 and just upgraded from v 7.02. Mobilink is
> set-up as service on win2k using new wire protocol driver
> (not the old oracle odbc).
Can you show us the *exact* text from the ML log for the particular
error, including any preceeding lines that appear related to the error
(or simply post the entire synchronization session that fails from the
file logMVTXD2_dbmlsrv9.txt).
Also, did you apply the ML upgrade scripts to the Oracle consolidated
(%ASANY9%\MobiLink\u
pgrade\7.0.x\upgrade_ora.sql) ?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| SusanB @ Medvantx 2005-04-20, 11:24 am |
| Hello and thanks for responding. Yes I did run the
upgrade_ora.sql script and also added in direct grants for
all of the "ML" objects.
I also took the sql statement from the log and plugged in
the name, version and table and ran it in sql plus for the
username/pwd on the dbmlsrv9 win2k service. there is a
warning about the upload_cursor begin deprecated so I tried
changing that to an upload_insert and it still cannot get
the table script for that version. (output also attached).
I am using the wire protocol odbc so I also tested the odbc
connection and it came back ok. Any ideas/help is greatly
appreciated.
| |
| Greg Fenton 2005-04-20, 8:24 pm |
| SusanB @ Medvantx wrote:
>
> 1 SELECT t1.event, t2.script_language, t2.script
> 2 FROM ml_table_script t1, ml_script t2
> 3* WHERE t1.table_id = '45' AND t1.version_id = '5' AND t1.script_id = t2.script_id
Try this query against Oracle using the user account ML uses and post
its output:
SELECT v.name, v.version_id, t.name, t.table_id, ts.event,
s.script_language, s.script, s.script_id
FROM ml_table t,
ml_table_script ts,
ml_script s,
ml_script_version v
WHERE ts.version_id = v.version_id
AND t.table_id = ts.table_id
AND ts.script_id = s.script_id
AND v.name = 'R14'
AND t.name = 'CLAIMS_HISTORY'
The above query gets the script that ML is looking for without us
guessing as to which values are getting substituted for the '?'s.
> W. 04/13 12:10:41. <1.5> [214]: Warning: [10024] Table 'heartbeat' has no entry in the ml_table table
Why is the "heartbeat" table in your publication if you have no scripts
for it?
> E. 04/13 12:10:42. <1.5> [214]: Error: [-10019] Error fetching table script CLAIMS_HISTORY. begin_synchronizatio
n
This is a curious error.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-21, 9:24 am |
| Note that there are two built in views in MobiLink to make seeing scripts
easier called ml_table_scripts and ml_connection_script
s. It would turn
Greg's four way join SQL to a much more readable SQL command :
select * from ml_table_scripts where version = 'R14' and table_name =
'CLAIMS_HISTORY'
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:4266f3ee@forums
-1-dub...
> SusanB @ Medvantx wrote:
t2. script_id[color=dark
red]
>
> Try this query against Oracle using the user account ML uses and post
> its output:
>
> SELECT v.name, v.version_id, t.name, t.table_id, ts.event,
> s.script_language, s.script, s.script_id
> FROM ml_table t,
> ml_table_script ts,
> ml_script s,
> ml_script_version v
> WHERE ts.version_id = v.version_id
> AND t.table_id = ts.table_id
> AND ts.script_id = s.script_id
> AND v.name = 'R14'
> AND t.name = 'CLAIMS_HISTORY'
>
> The above query gets the script that ML is looking for without us
> guessing as to which values are getting substituted for the '?'s.
>
>
no entry in the ml_table table[color=darkred]
>
> Why is the "heartbeat" table in your publication if you have no scripts
> for it?
>
>
script CLAIMS_HISTORY. begin_synchronizatio
n[color=darkred]
>
> This is a curious error.
>
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| SusanB Medvantx 2005-04-21, 8:24 pm |
| Ok, I've attached both selects via a sql plus.
Here is another thought. Is it possible that the wire
protocol odbc driver is not reporting an error. When I ran
the upgrade script, it failed becuase I had to add special
code to convert the old LONG column data to CLOB using
oracle's to_lob function. Is it possible that the oracle
procedure is failing to read the now blob column from the
script table? It seems to be reading ok from the other
tables. And this is the one thing I do recall having a prob
with.
I will not be at work on Fri, but I can try converting that
column back to long reconvert the data (I save the old
table) and see if it works??? Have either you or Greg heard
of issues with the wire protocal driver and the CLOB columns
in ORacle.. (It could be that I don't have something set at
the Oracle db init too 'cause we don't typically have those
kinds of columns in the db...)
Thanks!
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-22, 9:24 am |
| Is it possible that you have rows defined in the ml_table_script table with
no corresponding rows in the ml_script table? What does the following SQL
return? Are there any NULL values in the second column?
select mts.event, ms.script
from ml_table_script mts left outer join ml_script ms
where table_id = 45
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SusanB Medvantx> wrote in message
news:42681da6.769.1681692777@sybase.com...
> Ok, I've attached both selects via a sql plus.
> Here is another thought. Is it possible that the wire
> protocol odbc driver is not reporting an error. When I ran
> the upgrade script, it failed becuase I had to add special
> code to convert the old LONG column data to CLOB using
> oracle's to_lob function. Is it possible that the oracle
> procedure is failing to read the now blob column from the
> script table? It seems to be reading ok from the other
> tables. And this is the one thing I do recall having a prob
> with.
> I will not be at work on Fri, but I can try converting that
> column back to long reconvert the data (I save the old
> table) and see if it works??? Have either you or Greg heard
> of issues with the wire protocal driver and the CLOB columns
> in ORacle.. (It could be that I don't have something set at
> the Oracle db init too 'cause we don't typically have those
> kinds of columns in the db...)
> Thanks!
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-22, 9:24 am |
| I don't know if the syntax I provided in my previous post is correct for
Oracle, but is fine for ASA. If you execute the SQL statement listed below,
it will return a list of script_id values.
select script_id from ml_table_script where table_id = 45
If this returns more than a single row whose value is 289, something is
wrong, and may explain the error you are seeing.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SusanB Medvantx> wrote in message
news:42681da6.769.1681692777@sybase.com...
> Ok, I've attached both selects via a sql plus.
> Here is another thought. Is it possible that the wire
> protocol odbc driver is not reporting an error. When I ran
> the upgrade script, it failed becuase I had to add special
> code to convert the old LONG column data to CLOB using
> oracle's to_lob function. Is it possible that the oracle
> procedure is failing to read the now blob column from the
> script table? It seems to be reading ok from the other
> tables. And this is the one thing I do recall having a prob
> with.
> I will not be at work on Fri, but I can try converting that
> column back to long reconvert the data (I save the old
> table) and see if it works??? Have either you or Greg heard
> of issues with the wire protocal driver and the CLOB columns
> in ORacle.. (It could be that I don't have something set at
> the Oracle db init too 'cause we don't typically have those
> kinds of columns in the db...)
> Thanks!
>
| |
| SusanBMedvantx 2005-04-26, 1:24 pm |
| fourth time I've tried submitting a response. the results
of selects attached. all are distinct. I've double checed
oracle db object grants. I also have a file of the odbc
calls. I can post in another response. where can i find
exactly what the mbl server is doing - so I can manually
walk through each step to see where/why it is failing? Or
is there a way to test the odbc from the mobilink win2k
server? (isql maybe?)
thanks
> I don't know if the syntax I provided in my previous post
> is correct for Oracle, but is fine for ASA. If you
> execute the SQL statement listed below, it will return a
> list of script_id values.
>
> select script_id from ml_table_script where table_id = 45
>
> If this returns more than a single row whose value is 289,
> something is wrong, and may explain the error you are
> seeing.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <SusanB Medvantx> wrote in message
> news:42681da6.769.1681692777@sybase.com...
>
>
| |
| SusanBMedVantx 2005-04-26, 1:24 pm |
| Ok tried submitting a response 5 times now. All script ids
unique for different versions. Also double checked oracle db
object grants. how can I manually test the odbc driver from
the win2k mobilink server? Also, is it possible that I need
to add another option to the mobilink win2k service to allow
the version 7.02 client data to mobilink via v9.0.2 win2k
server to the oracle 9.2.0.1.0 database?
> I don't know if the syntax I provided in my previous post
> is correct for Oracle, but is fine for ASA. If you
> execute the SQL statement listed below, it will return a
> list of script_id values.
>
> select script_id from ml_table_script where table_id = 45
>
> If this returns more than a single row whose value is 289,
> something is wrong, and may explain the error you are
> seeing.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <SusanB Medvantx> wrote in message
> news:42681da6.769.1681692777@sybase.com...
>
>
| |
| SusanBMedvantx 2005-04-26, 1:24 pm |
| this is the output of the odbc calls using the tt option on
creation of mobilink service on win2k box.
> I don't know if the syntax I provided in my previous post
> is correct for Oracle, but is fine for ASA. If you
> execute the SQL statement listed below, it will return a
> list of script_id values.
>
> select script_id from ml_table_script where table_id = 45
>
> If this returns more than a single row whose value is 289,
> something is wrong, and may explain the error you are
> seeing.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <SusanB Medvantx> wrote in message
> news:42681da6.769.1681692777@sybase.com...
>
>
| |
| SusanBMedvantx 2005-04-27, 8:25 pm |
| He Reg, Any chance you might be able to look at the results
of my posts? thanks. (I'm having a hard time getting
responses to post in the "right" spot" thanks.
> I don't know if the syntax I provided in my previous post
> is correct for Oracle, but is fine for ASA. If you
> execute the SQL statement listed below, it will return a
> list of script_id values.
>
> select script_id from ml_table_script where table_id = 45
>
> If this returns more than a single row whose value is 289,
> something is wrong, and may explain the error you are
> seeing.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <SusanB Medvantx> wrote in message
> news:42681da6.769.1681692777@sybase.com...
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-28, 11:24 am |
| I don't have time right now to look at an ODBC trace, and your ml_* tables
look fine. Can you tell me what platform MobiLink is running on and what
the contents of the 9iMVTXD2 dsn are?
PS : Have you been dealing with iAnywhere Tech Support and/or Prof Services
recently? I feel like I'm duplicating my efforts here.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SusanBMedvantx> wrote in message
news:426e8bce.2863.1681692777@sybase.com...
> this is the output of the odbc calls using the tt option on
> creation of mobilink service on win2k box.
>
| |
| SusanbMedvantx 2005-04-28, 8:26 pm |
| Hi, understand about the time. I too have been busy with
multiple "hot" issues. I had not yet called tech support.
But I did find an EBF for ASA and downloaded it and applied
it to get to build 3044! Apparently there were 2 fixes for
the new wire protocol driver! And it is FINALLY just now
working.....thanks for checking the post again.
> I don't have time right now to look at an ODBC trace, and
> your ml_* tables look fine. Can you tell me what platform
> MobiLink is running on and what the contents of the
> 9iMVTXD2 dsn are?
>
> PS : Have you been dealing with iAnywhere Tech Support
> and/or Prof Services recently? I feel like I'm
> duplicating my efforts here.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <SusanBMedvantx> wrote in message
> news:426e8bce.2863.1681692777@sybase.com...
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-29, 9:25 am |
| Thanks for the update Susan! We have a very similar case in Tech Support
right now that we've reproduced on the v901 code. I'll make sure we test
the same repro on v902.3044. I'll post back if we find that the problem
we've found still exists in v902.3044.
If you are still looking back on the newsgroup, I'm still very interested in
knowing what platform you were running MobiLink. Was it Windows or one of
the flavours of Unix?
Thanks.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SusanbMedvantx> wrote in message news:42718e2d.77e.1681692777@sybase.com...[color=darkred]
> Hi, understand about the time. I too have been busy with
> multiple "hot" issues. I had not yet called tech support.
> But I did find an EBF for ASA and downloaded it and applied
> it to get to build 3044! Apparently there were 2 fixes for
> the new wire protocol driver! And it is FINALLY just now
> working.....thanks for checking the post again.
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-29, 9:25 am |
| Susan, the Tech Support case we currently have that is very similar to your
problem also reproduces at v902.3044. Although this build may have resolved
your issue, I'm not positive it solved the underlying issue. Did that make
sense?
If you could provide the platform MobiLink is running on and what the
contents of the 9iMVTXD2 dsn are for me, it would be big help.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SusanbMedvantx> wrote in message news:42718e2d.77e.1681692777@sybase.com...[color=darkred]
> Hi, understand about the time. I too have been busy with
> multiple "hot" issues. I had not yet called tech support.
> But I did find an EBF for ASA and downloaded it and applied
> it to get to build 3044! Apparently there were 2 fixes for
> the new wire protocol driver! And it is FINALLY just now
> working.....thanks for checking the post again.
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-05-05, 11:24 am |
| Susan, I don't think you're still here, but we've actually fixed this
problem now. You appeared to have work around the problem by moving the
MobiLink server from Unix to Windows, where the default buffer size for
scripts was larger and this problem did not occur. The underlying problem
has now been fixed in the following builds :
803.5249, 901.2021, 902.3121
Customer Description:
MobiLink could fail to gather the synchronization scripts for a given table
and report the error "Error fetching table script t1. begin_synchronizatio
n",
even though table t1 did not have a begin_synchronizatio
n script. This
problem was more likely to occur when using an Oracle consolidated database
and the "iAnywhere Solution 9 - Oracle Wire Protocol" ODBC driver. This
problem has now been fixed.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SusanB@Medvantx> wrote in message
news:42658c73.315f.1681692777@sybase.com...
> Hello, I'm trying to test upgrade of mobilink server to v
> 9.0.2. Client is asa v7.02 on linux, consolidated is Oracle
> v 9.2.0.1.0 and just upgraded from v 7.02. Mobilink is
> set-up as service on win2k using new wire protocol driver
> (not the old oracle odbc).
> Mobilink errors on the first 'upload_cursor' table script.
> I tried adding -tt option to the service but it did not
> produce decent information. the "user/pwd" can execute the
> select without issue (unless one of the parameters is not
> set?) select t1.event, t2.script_language, t2.script from
> ml_table_script t1, ml_script t2 where t1.table_id = ?, and
> t1.version_id = ? and t1.script_id = t2.script_id
> do I need to specify any additional options for v9 moblink
> service in order to "mobilink" the asa 7 client to the
> oracle consolidated db?
> we start the win2k service in a bat file attached.
>
|
|
|
|
|