Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem where I can't load in a an Ultralite XML Schema or SQL File that has been dumped from an Ultralite db

4 posts in Ultralite Last posting was on 2011-03-24 07:27:36.0Z
Shao Chan Posted on 2011-03-18 18:32:58.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Problem where I can't load in a an Ultralite XML Schema or SQL File that has been dumped from an Ultralite db
Lines: 2567
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d83a55a@forums-1-dub>
Date: 18 Mar 2011 10:32:58 -0800
X-Trace: forums-1-dub 1300473178 10.22.241.152 (18 Mar 2011 10:32:58 -0800)
X-Original-Trace: 18 Mar 2011 10:32:58 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12421
Article PK: 1048313

SQL Anywhere 12.0.1. upgrade from 11.0.1.latest.ebf

Hi all,

I have a script that:
1) Creates an SQLA database.
2) Reads in some SQL with publications etc.
3) Creates an Ultralite from the SQLA database.
4) Exports the database as XML.
5) Exports the database as SQL.
6) Creates 2 more Ultralites.
7) Imports the XML into one Ultralite.
8) Imports the SQL into another Ultralite.

Now, both the XML load and the SQL load give the same error but in a
slightly different way (see Dos Screen info below).

I have attached the 2 files exported from the Ultralite generated from SQLA.

In essense, I can export the schema, but can't import it into a new
Ultralite database. But I can do this in 11.0.1. Is there something I am
doing wrong?

I have attached the exported files.

Thanks,

Shao

Dos Screen info:

*** stopping Remote ASA database.
*** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
***
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.
udb
*** EXPORT ULTRALITE SCHEMA
*** D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
*** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.
udb
*** LOAD ULTRALITE XML SCHEMA FILE
Error: SQL error: Foreign key 'primary' for table 'contractItem' duplicates
an e
xisting foreign key
*** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.
udb
*** LOAD ULTRALITE SQL SCHEMA FILE
Could not execute statement.
[UltraLite Database] Foreign key 'primary' for table 'contractItem'
duplicates an existing foreign key [SQL Offset: 142]
SQLCODE=-251, ODBC 3 State="ERROR"
File: "mobileServitor.sql" on line 1028, column 1
-- Done publications
-------------------
-- Create indexes
-------------------
...
You can continue executing or stop.
1. Stop
2. Continue
Select an option: 1
*** END createASADb.cmd

D:\environments\development\mobileServitor\Remote\bin>


Log Info:

Erasing database file
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
Erasing transaction log file
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.log"
"D:\Program Files\SQL Anywhere 12\BIN64\dbinit.exe"
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.db" -p
4096
SQL Anywhere Initialization Utility Version 12.0.1.3152
CHAR collation sequence: 1252LATIN1(CaseSensitivity=Ignore)
CHAR character set encoding: windows-1252
NCHAR collation sequence:
UCA(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary)
NCHAR character set encoding: UTF-8
Creating system tables
Creating system views
Setting option values
Database
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
created successfully
SQL Anywhere Start Server In Background Utility Version 12.0.1.3152
"D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
"UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
"D:\environments\development\mobileServitor\Remote\bin\scripts\remoteSchema.sql"
Execution time: 1.892 seconds
"D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
"UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
"D:\environments\development\mobileServitor\Remote\bin\scripts\remoteOnlySchema.sql"
Execution time: 0.047 seconds
"D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
"UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
"D:\environments\development\mobileServitor\Remote\bin\scripts\remotePublication.sql"
Execution time: 0.078 seconds
SQL Anywhere Stop Server Utility Version 12.0.1.3152
*** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
***
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
"D:\Program Files\SQL Anywhere 12\BIN64\ulinit" -a
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor.db;UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote"
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
-u dba,sql -y -n SERVITOR -n MOBILE_NOSYNC -n UPLOAD_JOB -n UPLOAD_TIME -n
DOWNLOAD_LOGIN -s SERVITOR -s UPLOAD_JOB -s UPLOAD_TIME -s DOWNLOAD_LOGIN
SQL Anywhere UltraLite Initialization Utility Version 12.0.1.3152
Loading schema
Creating empty UltraLite database
Collation: 1252LATIN1
Done creating database
*** EXPORT ULTRALITE SCHEMA
*** D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
"D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
-n -y
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql" -s
"D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
-n -y
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
*** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
"D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
-u dba,sql -y
*** LOAD ULTRALITE XML SCHEMA FILE
"D:\Program Files\SQL Anywhere 12\BIN64\ulload" -c
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb;UID=dba;PWD=sql"
-n -y
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
SQL Anywhere UltraLite Load Utility Version 12.0.1.3152
1 error(s)
*** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
"D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
-u dba,sql -y
*** LOAD ULTRALITE SQL SCHEMA FILE
"D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
read
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
"D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
"DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
read
"D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"


Shao Chan Posted on 2011-03-21 14:24:09.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4d83a55a@forums-1-dub>
Subject: Re: Problem where I can't load in a an Ultralite XML Schema or SQL File that has been dumped from an Ultralite db
Lines: 176
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d875f89@forums-1-dub>
Date: 21 Mar 2011 06:24:09 -0800
X-Trace: forums-1-dub 1300717449 10.22.241.152 (21 Mar 2011 06:24:09 -0800)
X-Original-Trace: 21 Mar 2011 06:24:09 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12425
Article PK: 1048192

Hi all,

I have raised case 11662583 with a cut down reproduceable.

I believe its the ulunload not unloading the correct DDL rather than the
ulload.

Cheers,

Shao

"Shao Chan" <nospam@nospam.com> wrote in message
news:4d83a55a@forums-1-dub...
> SQL Anywhere 12.0.1. upgrade from 11.0.1.latest.ebf
>
> Hi all,
>
> I have a script that:
> 1) Creates an SQLA database.
> 2) Reads in some SQL with publications etc.
> 3) Creates an Ultralite from the SQLA database.
> 4) Exports the database as XML.
> 5) Exports the database as SQL.
> 6) Creates 2 more Ultralites.
> 7) Imports the XML into one Ultralite.
> 8) Imports the SQL into another Ultralite.
>
> Now, both the XML load and the SQL load give the same error but in a
> slightly different way (see Dos Screen info below).
>
> I have attached the 2 files exported from the Ultralite generated from
> SQLA.
>
> In essense, I can export the schema, but can't import it into a new
> Ultralite database. But I can do this in 11.0.1. Is there something I am
> doing wrong?
>
> I have attached the exported files.
>
> Thanks,
>
> Shao
>
> Dos Screen info:
>
> *** stopping Remote ASA database.
> *** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
> ***
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.
> udb
> *** EXPORT ULTRALITE SCHEMA
> ***
> D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.
> udb
> *** LOAD ULTRALITE XML SCHEMA FILE
> Error: SQL error: Foreign key 'primary' for table 'contractItem'
> duplicates an e
> xisting foreign key
> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.
> udb
> *** LOAD ULTRALITE SQL SCHEMA FILE
> Could not execute statement.
> [UltraLite Database] Foreign key 'primary' for table 'contractItem'
> duplicates an existing foreign key [SQL Offset: 142]
> SQLCODE=-251, ODBC 3 State="ERROR"
> File: "mobileServitor.sql" on line 1028, column 1
> -- Done publications
> -------------------
> -- Create indexes
> -------------------
> ...
> You can continue executing or stop.
> 1. Stop
> 2. Continue
> Select an option: 1
> *** END createASADb.cmd
>
> D:\environments\development\mobileServitor\Remote\bin>
>
>
> Log Info:
>
> Erasing database file
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
> Erasing transaction log file
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.log"
> "D:\Program Files\SQL Anywhere 12\BIN64\dbinit.exe"
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db" -p
> 4096
> SQL Anywhere Initialization Utility Version 12.0.1.3152
> CHAR collation sequence: 1252LATIN1(CaseSensitivity=Ignore)
> CHAR character set encoding: windows-1252
> NCHAR collation sequence:
> UCA(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary)
> NCHAR character set encoding: UTF-8
> Creating system tables
> Creating system views
> Setting option values
> Database
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
> created successfully
> SQL Anywhere Start Server In Background Utility Version 12.0.1.3152
> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
> "D:\environments\development\mobileServitor\Remote\bin\scripts\remoteSchema.sql"
> Execution time: 1.892 seconds
> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
> "D:\environments\development\mobileServitor\Remote\bin\scripts\remoteOnlySchema.sql"
> Execution time: 0.047 seconds
> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
> "D:\environments\development\mobileServitor\Remote\bin\scripts\remotePublication.sql"
> Execution time: 0.078 seconds
> SQL Anywhere Stop Server Utility Version 12.0.1.3152
> *** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
> ***
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit" -a
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor.db;UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote"
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
> -u dba,sql -y -n SERVITOR -n MOBILE_NOSYNC -n UPLOAD_JOB -n
> UPLOAD_TIME -n DOWNLOAD_LOGIN -s SERVITOR -s UPLOAD_JOB -s UPLOAD_TIME -s
> DOWNLOAD_LOGIN
> SQL Anywhere UltraLite Initialization Utility Version 12.0.1.3152
> Loading schema
> Creating empty UltraLite database
> Collation: 1252LATIN1
> Done creating database
> *** EXPORT ULTRALITE SCHEMA
> ***
> D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
> "D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
> -n -y
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
> -s
> "D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
> -n -y
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
> -u dba,sql -y
> *** LOAD ULTRALITE XML SCHEMA FILE
> "D:\Program Files\SQL Anywhere 12\BIN64\ulload" -c
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb;UID=dba;PWD=sql"
> -n -y
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
> SQL Anywhere UltraLite Load Utility Version 12.0.1.3152
> 1 error(s)
> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
> -u dba,sql -y
> *** LOAD ULTRALITE SQL SCHEMA FILE
> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
> read
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
> read
> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>
>
>


Tim McClements [Sybase] Posted on 2011-03-24 02:02:34.0Z
From: "Tim McClements [Sybase]" <mcclemenXnospam@sybase.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4d83a55a@forums-1-dub> <4d875f89@forums-1-dub>
Subject: Re: Problem where I can't load in a an Ultralite XML Schema or SQL File that has been dumped from an Ultralite db
Lines: 187
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d8aa63a$1@forums-1-dub>
Date: 23 Mar 2011 18:02:34 -0800
X-Trace: forums-1-dub 1300932154 10.22.241.152 (23 Mar 2011 18:02:34 -0800)
X-Original-Trace: 23 Mar 2011 18:02:34 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12434
Article PK: 1048207

Thank you for reporting this bug. A fix was recently made to ulunload
because it wasn't extracting the foreign keys properly in some cases. This
looks like the same problem. That fix is available in version 12.0.1 build
3301 and later.

- Tim

"Shao Chan" <nospam@nospam.com> wrote in message
news:4d875f89@forums-1-dub...
> Hi all,
>
> I have raised case 11662583 with a cut down reproduceable.
>
> I believe its the ulunload not unloading the correct DDL rather than the
> ulload.
>
> Cheers,
>
> Shao
>
>
> "Shao Chan" <nospam@nospam.com> wrote in message
> news:4d83a55a@forums-1-dub...
>> SQL Anywhere 12.0.1. upgrade from 11.0.1.latest.ebf
>>
>> Hi all,
>>
>> I have a script that:
>> 1) Creates an SQLA database.
>> 2) Reads in some SQL with publications etc.
>> 3) Creates an Ultralite from the SQLA database.
>> 4) Exports the database as XML.
>> 5) Exports the database as SQL.
>> 6) Creates 2 more Ultralites.
>> 7) Imports the XML into one Ultralite.
>> 8) Imports the SQL into another Ultralite.
>>
>> Now, both the XML load and the SQL load give the same error but in a
>> slightly different way (see Dos Screen info below).
>>
>> I have attached the 2 files exported from the Ultralite generated from
>> SQLA.
>>
>> In essense, I can export the schema, but can't import it into a new
>> Ultralite database. But I can do this in 11.0.1. Is there something I
>> am doing wrong?
>>
>> I have attached the exported files.
>>
>> Thanks,
>>
>> Shao
>>
>> Dos Screen info:
>>
>> *** stopping Remote ASA database.
>> *** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
>> ***
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.
>> udb
>> *** EXPORT ULTRALITE SCHEMA
>> ***
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.
>> udb
>> *** LOAD ULTRALITE XML SCHEMA FILE
>> Error: SQL error: Foreign key 'primary' for table 'contractItem'
>> duplicates an e
>> xisting foreign key
>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.
>> udb
>> *** LOAD ULTRALITE SQL SCHEMA FILE
>> Could not execute statement.
>> [UltraLite Database] Foreign key 'primary' for table 'contractItem'
>> duplicates an existing foreign key [SQL Offset: 142]
>> SQLCODE=-251, ODBC 3 State="ERROR"
>> File: "mobileServitor.sql" on line 1028, column 1
>> -- Done publications
>> -------------------
>> -- Create indexes
>> -------------------
>> ...
>> You can continue executing or stop.
>> 1. Stop
>> 2. Continue
>> Select an option: 1
>> *** END createASADb.cmd
>>
>> D:\environments\development\mobileServitor\Remote\bin>
>>
>>
>> Log Info:
>>
>> Erasing database file
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
>> Erasing transaction log file
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.log"
>> "D:\Program Files\SQL Anywhere 12\BIN64\dbinit.exe"
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
>> -p 4096
>> SQL Anywhere Initialization Utility Version 12.0.1.3152
>> CHAR collation sequence: 1252LATIN1(CaseSensitivity=Ignore)
>> CHAR character set encoding: windows-1252
>> NCHAR collation sequence:
>> UCA(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary)
>> NCHAR character set encoding: UTF-8
>> Creating system tables
>> Creating system views
>> Setting option values
>> Database
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
>> created successfully
>> SQL Anywhere Start Server In Background Utility Version 12.0.1.3152
>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
>> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
>> "D:\environments\development\mobileServitor\Remote\bin\scripts\remoteSchema.sql"
>> Execution time: 1.892 seconds
>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
>> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
>> "D:\environments\development\mobileServitor\Remote\bin\scripts\remoteOnlySchema.sql"
>> Execution time: 0.047 seconds
>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
>> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
>> "D:\environments\development\mobileServitor\Remote\bin\scripts\remotePublication.sql"
>> Execution time: 0.078 seconds
>> SQL Anywhere Stop Server Utility Version 12.0.1.3152
>> *** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
>> ***
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
>> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit" -a
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor.db;UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote"
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
>> -u dba,sql -y -n SERVITOR -n MOBILE_NOSYNC -n UPLOAD_JOB -n
>> UPLOAD_TIME -n DOWNLOAD_LOGIN -s SERVITOR -s UPLOAD_JOB -s UPLOAD_TIME -s
>> DOWNLOAD_LOGIN
>> SQL Anywhere UltraLite Initialization Utility Version 12.0.1.3152
>> Loading schema
>> Creating empty UltraLite database
>> Collation: 1252LATIN1
>> Done creating database
>> *** EXPORT ULTRALITE SCHEMA
>> ***
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
>> "D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
>> -n -y
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>> -s
>> "D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
>> -n -y
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
>> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
>> -u dba,sql -y
>> *** LOAD ULTRALITE XML SCHEMA FILE
>> "D:\Program Files\SQL Anywhere 12\BIN64\ulload" -c
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb;UID=dba;PWD=sql"
>> -n -y
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
>> SQL Anywhere UltraLite Load Utility Version 12.0.1.3152
>> 1 error(s)
>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
>> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
>> -u dba,sql -y
>> *** LOAD ULTRALITE SQL SCHEMA FILE
>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>> read
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>> read
>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>
>>
>>
>
>


Shao Chan Posted on 2011-03-24 07:27:36.0Z
Reply-To: "Shao Chan" <nospam@nospam.com>
From: "Shao Chan" <nospam@nospam.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4d83a55a@forums-1-dub> <4d875f89@forums-1-dub> <4d8aa63a$1@forums-1-dub>
Subject: Re: Problem where I can't load in a an Ultralite XML Schema or SQL File that has been dumped from an Ultralite db
Lines: 199
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d8af268@forums-1-dub>
Date: 23 Mar 2011 23:27:36 -0800
X-Trace: forums-1-dub 1300951656 10.22.241.152 (23 Mar 2011 23:27:36 -0800)
X-Original-Trace: 23 Mar 2011 23:27:36 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12436
Article PK: 1048217

Hi Tim,

Thanks for that.

Cheers,

Shao

"Tim McClements [Sybase]" <mcclemenXnospam@sybase.com> wrote in message
news:4d8aa63a$1@forums-1-dub...
> Thank you for reporting this bug. A fix was recently made to ulunload
> because it wasn't extracting the foreign keys properly in some cases. This
> looks like the same problem. That fix is available in version 12.0.1 build
> 3301 and later.
>
> - Tim
>
> "Shao Chan" <nospam@nospam.com> wrote in message
> news:4d875f89@forums-1-dub...
>> Hi all,
>>
>> I have raised case 11662583 with a cut down reproduceable.
>>
>> I believe its the ulunload not unloading the correct DDL rather than the
>> ulload.
>>
>> Cheers,
>>
>> Shao
>>
>>
>> "Shao Chan" <nospam@nospam.com> wrote in message
>> news:4d83a55a@forums-1-dub...
>>> SQL Anywhere 12.0.1. upgrade from 11.0.1.latest.ebf
>>>
>>> Hi all,
>>>
>>> I have a script that:
>>> 1) Creates an SQLA database.
>>> 2) Reads in some SQL with publications etc.
>>> 3) Creates an Ultralite from the SQLA database.
>>> 4) Exports the database as XML.
>>> 5) Exports the database as SQL.
>>> 6) Creates 2 more Ultralites.
>>> 7) Imports the XML into one Ultralite.
>>> 8) Imports the SQL into another Ultralite.
>>>
>>> Now, both the XML load and the SQL load give the same error but in a
>>> slightly different way (see Dos Screen info below).
>>>
>>> I have attached the 2 files exported from the Ultralite generated from
>>> SQLA.
>>>
>>> In essense, I can export the schema, but can't import it into a new
>>> Ultralite database. But I can do this in 11.0.1. Is there something I
>>> am doing wrong?
>>>
>>> I have attached the exported files.
>>>
>>> Thanks,
>>>
>>> Shao
>>>
>>> Dos Screen info:
>>>
>>> *** stopping Remote ASA database.
>>> *** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
>>> ***
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.
>>> udb
>>> *** EXPORT ULTRALITE SCHEMA
>>> ***
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
>>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.
>>> udb
>>> *** LOAD ULTRALITE XML SCHEMA FILE
>>> Error: SQL error: Foreign key 'primary' for table 'contractItem'
>>> duplicates an e
>>> xisting foreign key
>>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.
>>> udb
>>> *** LOAD ULTRALITE SQL SCHEMA FILE
>>> Could not execute statement.
>>> [UltraLite Database] Foreign key 'primary' for table 'contractItem'
>>> duplicates an existing foreign key [SQL Offset: 142]
>>> SQLCODE=-251, ODBC 3 State="ERROR"
>>> File: "mobileServitor.sql" on line 1028, column 1
>>> -- Done publications
>>> -------------------
>>> -- Create indexes
>>> -------------------
>>> ...
>>> You can continue executing or stop.
>>> 1. Stop
>>> 2. Continue
>>> Select an option: 1
>>> *** END createASADb.cmd
>>>
>>> D:\environments\development\mobileServitor\Remote\bin>
>>>
>>>
>>> Log Info:
>>>
>>> Erasing database file
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
>>> Erasing transaction log file
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.log"
>>> "D:\Program Files\SQL Anywhere 12\BIN64\dbinit.exe"
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
>>> -p 4096
>>> SQL Anywhere Initialization Utility Version 12.0.1.3152
>>> CHAR collation sequence: 1252LATIN1(CaseSensitivity=Ignore)
>>> CHAR character set encoding: windows-1252
>>> NCHAR collation sequence:
>>> UCA(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary)
>>> NCHAR character set encoding: UTF-8
>>> Creating system tables
>>> Creating system views
>>> Setting option values
>>> Database
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.db"
>>> created successfully
>>> SQL Anywhere Start Server In Background Utility Version 12.0.1.3152
>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
>>> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
>>> "D:\environments\development\mobileServitor\Remote\bin\scripts\remoteSchema.sql"
>>> Execution time: 1.892 seconds
>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
>>> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
>>> "D:\environments\development\mobileServitor\Remote\bin\scripts\remoteOnlySchema.sql"
>>> Execution time: 0.047 seconds
>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -c
>>> "UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote;ASTOP=YES" read
>>> "D:\environments\development\mobileServitor\Remote\bin\scripts\remotePublication.sql"
>>> Execution time: 0.078 seconds
>>> SQL Anywhere Stop Server Utility Version 12.0.1.3152
>>> *** CREATE ULTRALITE DATABASE FROM REMOTE ASA DATABASE
>>> ***
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
>>> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit" -a
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor.db;UID=dba;PWD=sql;ENG=mobileServitor_DEV_Remote"
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb
>>> -u dba,sql -y -n SERVITOR -n MOBILE_NOSYNC -n UPLOAD_JOB -n
>>> UPLOAD_TIME -n DOWNLOAD_LOGIN -s SERVITOR -s UPLOAD_JOB -s
>>> UPLOAD_TIME -s DOWNLOAD_LOGIN
>>> SQL Anywhere UltraLite Initialization Utility Version 12.0.1.3152
>>> Loading schema
>>> Creating empty UltraLite database
>>> Collation: 1252LATIN1
>>> Done creating database
>>> *** EXPORT ULTRALITE SCHEMA
>>> ***
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql
>>> "D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
>>> -n -y
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>> -s
>>> "D:\Program Files\SQL Anywhere 12\BIN64\ulunload" -c
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromAsa.udb;UID=dba;PWD=sql"
>>> -n -y
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
>>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE XML SCHEMA FILE)
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
>>> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb
>>> -u dba,sql -y
>>> *** LOAD ULTRALITE XML SCHEMA FILE
>>> "D:\Program Files\SQL Anywhere 12\BIN64\ulload" -c
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromXmlFile.udb;UID=dba;PWD=sql"
>>> -n -y
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.xml"
>>> SQL Anywhere UltraLite Load Utility Version 12.0.1.3152
>>> 1 error(s)
>>> *** CREATING ULTRALITE DATABASE (FOR USE WITH ULTRALITE SQL SCHEMA FILE)
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
>>> "D:\Program Files\SQL Anywhere 12\BIN64\ulinit"
>>> D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb
>>> -u dba,sql -y
>>> *** LOAD ULTRALITE SQL SCHEMA FILE
>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>>> read
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>> "D:\Program Files\SQL Anywhere 12\BIN64\DBISQL.COM" -ul -c
>>> "DBF=D:\environments\development\mobileServitor\Remote\db\mobileServitor_fromSqlFile.udb;UID=dba;PWD=sql"
>>> read
>>> "D:\environments\development\mobileServitor\Remote\db\mobileServitor.sql"
>>>
>>>
>>>
>>
>>
>
>