Hello,

We are working on a project with pda's for barcode scanning (with windows
mobile 5) and we want to put a V11 database on them because they have to
work offline.

The consolidated database is V8.

My plan was to set up a mobilink between V8 and V11, but I get errors about
missing system tables (example: sysuser).

On upgrade from 8 to 11 is for the moment out of the question.We have a
large number of databases all over the world and the current software is not
supporting any version higher than V9.

Is there a workaround procedure to create the necessary systemtables on the
V8?



Note: Versions mentionned are all Sql Anywhere.



Regards

"Kevin Saegerman" <kevin.saegerman (AT) jandenul (DOT) com> wrote in
news:49771a2f@forums-1-dub of sybase.public.sqlanywhere.mobilink:

We need a bit more information.

First:
Exact build of 8
Exact build of 11 (i.e. 11.0.0.1526)

In general, older software remotes can synchronize with newer
software.

So a V8 dbmlsync can sync with a V11 MobiLink server.

You of course want to reverse that, which is not tested or supported.

What _may_ work is (on a test system of course):
1. Take your V8 consolidated database.
2. Apply the %SQLANY11%\MobiLink\Setup\syncsa.sql against it
- This will upgrade the MobiLink system tables.
3. Start MobiLink using the -xo switch (for backwards compatibility
with version 8 remotes).
4. Attempt to synchronize from the V8 remote to the V11 ML server
which is connected to a V8 SQL Anywhere database.

If that does not work (it certainly is not tested) then we have to
look for other options. There may be other things we can try.

If it does work, you really have to test it hard to try to get all the
fringe cases. And of course it is _unsupported_.


--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

We are using version 8.0.2.4542 and 11.0.0.1264.


"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote

Hello,

I first dropped al ml% tables from consolidated V8 database and executed
syncsa.sql from V11.

After step 2, following error appeared in the sync wizard.

Detected an unknown or corrupt version of the MobiLink system setup under
owner 'DBA'.
The consolidated database is missing current versions of these objects in
the MobiLink system setup.
ml_add_java_connection_script.@script
ml_qa_get_agent_property.ml_qa_get_agent_property
ml_add_table_script.@script
ml_add_java_table_script.@script
ml_qa_get_message_property.ml_qa_get_message_prope rty
ml_qa_upsert_global_prop.@value
ml_add_lang_conn_script_chk.@script
ml_qa_get_agent_object_property.ml_qa_get_agent_ob ject_property
ml_add_passthrough_script.@affected_pubs
ml_add_passthrough_script.@script
ml_add_connection_script.@script
ml_add_lang_table_script_chk.@script
ml_qa_get_agent_network_property.ml_qa_get_agent_n etwork_property
ml_add_dnet_table_script.@script
ml_add_lang_table_script.@script
ml_qa_add_message.@props
ml_qa_add_message.@content
ml_add_lang_connection_script.@script
ml_add_dnet_connection_script.@script
ml_property.property_value
ml_qa_messages_archive.content
ml_qa_messages_archive.props
ml_passthrough.ml_passthrough_trigger
ml_qa_repository_staging.content
ml_qa_repository_staging.props
ml_qa_delivery.ml_qa_delivery_trigger
ml_qa_repository_props.value
ml_qa_global_props.value
ml_passthrough_status.error_text
ml_script_version.description
ml_qa_repository_archive.content
ml_qa_repository_archive.props
ml_qa_repository.content
ml_qa_repository.props
ml_connection_scripts.script
ml_table_scripts.script
ml_qa_messages.content
ml_qa_messages.props
ml_script.script
ml_passthrough_script.affected_pubs
ml_passthrough_script.script
ml_qa_repository_props_archive.value

Some objects in the consolidated database belong to old versions of the
MobiLink system setup and should be removed to avoid confusion.
ml_add_java_connection_script.@script
ml_qa_get_agent_property.ml_qa_get_agent_property
ml_add_table_script.@script
ml_add_java_table_script.@script
ml_qa_get_message_property.ml_qa_get_message_prope rty
ml_qa_upsert_global_prop.@value
ml_add_lang_conn_script_chk.@script
ml_qa_get_agent_object_property.ml_qa_get_agent_ob ject_property
ml_add_passthrough_script.@affected_pubs
ml_add_passthrough_script.@script
ml_add_connection_script.@script
ml_add_lang_table_script_chk.@script
ml_qa_get_agent_network_property.ml_qa_get_agent_n etwork_property
ml_add_dnet_table_script.@script
ml_add_lang_table_script.@script
ml_qa_add_message.@props
ml_qa_add_message.@content
ml_add_lang_connection_script.@script
ml_add_dnet_connection_script.@script
ml_property.property_value
ml_qa_messages_archive.content
ml_qa_messages_archive.props
ml_passthrough.ml_passthrough_trigger
ml_qa_repository_staging.content
ml_qa_repository_staging.props
ml_qa_delivery.ml_qa_delivery_trigger
ml_qa_repository_props.value
ml_qa_global_props.value
ml_passthrough_status.error_text
ml_script_version.description
ml_qa_repository_archive.content
ml_qa_repository_archive.props
ml_qa_repository.content
ml_qa_repository.props
ml_connection_scripts.script
ml_table_scripts.script
ml_qa_messages.content
ml_qa_messages.props
ml_script.script
ml_passthrough_script.affected_pubs
ml_passthrough_script.script
ml_qa_repository_props_archive.value

I could ignore this error and continued the wizard.

As additional mobilink server command-line options I filled in -xo.

At the end I still got the error about the missing sysuser table. In fact
this table is not included in the syncsa.sql file.

The synchronization model could not be deployed.
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found:
Table 'SYSUSER' not found
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found:
Table 'SYSUSER' not found
SQLCODE=-141, ODBC 3 State="42S02"
SQL:
IF EXISTS (
SELECT 1
FROM SYS.SYSTABLE
INNER JOIN SYS.SYSUSER ON user_id = creator
WHERE table_name = 'Department_del'
AND user_name = 'amos'
) THEN
DROP TABLE "amos"."Department_del"
END IF

Error for: Rendering macro COMMIT
Error while generating output from templates
ianywhere.ml.design.generate.ScriptGenerationExcep tion: Error while
generating output from templates


Did I forget something or should I try it in another way?

Kind Regards


"Kevin Saegerman" <kevin.saegerman (AT) jandenul (DOT) com> wrote

Hello,

Can we expect a solution for this problem or should we find another way to
synchronize a V8 and V11 database.
Could SQL Remote be a solution?

Regards

"Kevin Saegerman" <kevin.saegerman (AT) jandenul (DOT) com> wrote

"Kevin Saegerman" <kevin.saegerman (AT) jandenul (DOT) com> wrote in
news:497d827d@forums-1-dub of sybase.public.sqlanywhere.mobilink:

KS> Hello,
KS>
KS> I first dropped al ml% tables from consolidated V8 database and
KS> executed syncsa.sql from V11.
KS>
KS> After step 2, following error appeared in the sync wizard.

KS> Detected an unknown or corrupt version of the MobiLink system setup
KS> under owner 'DBA'.

I think we want to try and get these cleaned up first.

....
KS> I could ignore this error and continued the wizard.

I wouldn't, but you could also try to just to sync using your old
sync scripts from version 8 without using the MobiLink plugin for
version 11.


KS> As additional mobilink server command-line options I filled in -xo.

Right.

KS> At the end I still got the error about the missing sysuser table. In
KS> fact this table is not included in the syncsa.sql file.
KS>
KS> The synchronization model could not be deployed.
KS> [Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not
KS> found: Table 'SYSUSER' not found
KS> [Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not
KS> found: Table 'SYSUSER' not found
KS> SQLCODE=-141, ODBC 3 State="42S02"
KS> SQL:
KS> IF EXISTS (
KS> SELECT 1
KS> FROM SYS.SYSTABLE
KS> INNER JOIN SYS.SYSUSER ON user_id = creator
KS> WHERE table_name = 'Department_del'
KS> AND user_name = 'amos'
KS> ) THEN
KS> DROP TABLE "amos"."Department_del"
KS> END IF

Okay, this is the ML plugin deploying the changes to a SQL file.

I think this SQL should work:

IF EXISTS( SELECT 1
FROM sys.systable st KEY JOIN sys.sysuserperms sup
WHERE st.table_name = 'Department_del'
AND sup.user_name = user_name() ) THEN
DROP TABLE replace_me;
END IF;

You could also just delete the checks, and hit Continue when you run the
script a second time.


KS> Error for: Rendering macro COMMIT
KS> Error while generating output from templates
KS> ianywhere.ml.design.generate.ScriptGenerationExcep tion: Error while
KS> generating output from templates

Never seen this one before.
When do you get it?
Is this reported inside the ML plugin deployment wizard?
At what point?
You can also run the SQL file directly using DBISQL.


--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

"Kevin Saegerman" <kevin.saegerman (AT) jandenul (DOT) com> wrote in
news:49815a02$1@forums-1-dub of sybase.public.sqlanywhere.mobilink:

Yes, SQL Remote will work between v8 and v11.
It might be a good viable solution.


--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/

Are you still working on this?

"Upgrading remotes before consolidated" is not an unreasonable
scenario IMO.

What *exactly* was the original message, and *where* exactly did it
appear? (e.g., in the dbmlsrv*.exe log or the dbmlsync.exe log)

What *exactly* was the configuration your ran; i.e., dbmlsrv8.exe
versus mlsrv11.exe, and what version of dbmlsync.exe.

Are you willing to have a "proxy consolidated database" running V11,
between the MobiLink server and the real V8 consolidated database, if
nothing simpler works? This is what people have done, historically,
with unsupported consolidated DBMS software, you know, MeGoofy,
Firedupon, PostGrokSQL, CloudScud, BerkeleySlacker, stuff like that.

More questions are likely, depending on the answer to question 1.

Breck Lives For This Kind Of Problem



On 21 Jan 2009 04:50:55 -0800, "Kevin Saegerman"
<kevin.saegerman (AT) jandenul (DOT) com> wrote:

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

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

I executed syncsa.sql from V11 on V8 without problems with login "dbo".
Then I used Mobilink Sync Model Wizard in V11.
After choosing consolidated db, I received error "detected an unknown or
corrupt version of the mobilink system setup under owner "dbo" with a list
of missing objects or other versions of objects.

I deleted again all the objects and ran the script again, but still get
error about missing or corrupt version.
I already made script to delete all ml_ tables, views, procs and funcs, but
still got errors. I think with this script I delete to many objects.
Could it be that the syncsa.sql of V11 does not contain all ml_ objects?
If I could get a list with all ml_ objects in V8 and V11 and differences
between them, it could be easier to find the solution.

regards

"Breck Carter [TeamSybase]" <NOSPAM__breck.carter (AT) gmail (DOT) com> wrote in
message news:ku34o45pbo5p41f66onveu0outfs3d449o (AT) 4ax (DOT) com...

Sybase Central V8 and V11 can be used to see the ml_* tables. Use
brand-new empty databases for this (dbinit - dbeng8 / 11, then run the
respective ML setup scripts) so you will be seeing original
configurations.

You might also try this technique, on the same empty databases:

http://sqlanywhere.blogspot.com/2008...e-schemas.html

You will have to upgrade the empty V8 database to V11 but that
shouldn't change the ml_* things (I think

Breck

On 30 Jan 2009 06:19:02 -0800, "Kevin Saegerman"
<kevin.saegerman (AT) jandenul (DOT) com> wrote:

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

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com