|
Home > Archive > SQL Anywhere ultralite > February 2006 > ulinit (9.0.2.3228) generates columns not selected in pub?
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 |
ulinit (9.0.2.3228) generates columns not selected in pub?
|
|
|
| If I add an article to my publication in my reference
database which contains a specific table and one column (as
a test), ulinit generates 4 other columns that I did not
select automatically. Those columns appear in both the
example scripts and the usm file; but they don't appear in
the consolidated pub. However, I don't want those columns.
Does anyone know why these extra columns might are
generated.
On all the other tables that I've created publication
articles; everything worked fine with no extra columns.
| |
| David Fishburn 2006-01-26, 4:56 pm |
| rr12 wrote in news:43d7cc56.3d25.1681692777@sybase.com
of sybase.public.sqlanywhere.ultralite:
rr12> If I add an article to my publication in my reference
rr12> database which contains a specific table and one column (as
rr12> a test), ulinit generates 4 other columns that I did not
rr12> select automatically. Those columns appear in both the
rr12> example scripts and the usm file; but they don't appear in
rr12> the consolidated pub. However, I don't want those columns.
rr12> Does anyone know why these extra columns might are
rr12> generated.
Can you run dbunload against the reference database:
dbunload -c ... -n (no schema)
Please include in your post:
1. The REMOTE DEFINITIONS section of that output.
2. The ULINIT command line and the output from running it.
3. Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).
Oh, I see it in the subject, I never remember to look there, can you
include it in the body of the message as well - 9.0.2.3228
We can start with that information.
--
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 (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
|
| As a workaround, I've been able to use the schema painter to
remove the extra columns and then manually create the
appropriate sync scripts, but it does seem pretty strange to
me...
reload.sql...
-------------------------------------------------
-- Create SQL Remote definitions
-------------------------------------------------
CREATE REMOTE TYPE "FILE" ADDRESS ''
go
CREATE REMOTE TYPE "MAPI" ADDRESS ''
go
CREATE REMOTE TYPE "VIM" ADDRESS ''
go
CREATE REMOTE TYPE "SMTP" ADDRESS ''
go
CREATE REMOTE TYPE "FTP" ADDRESS ''
go
GRANT PUBLISH TO "DBA"
go
GRANT REMOTE TO "My Laptop" TYPE "MAPI" ADDRESS 'xyz'
go
CALL SYS.sa_setremoteuser( 102, 3298534883328,
3298534883328, 0, 0, 0, 0, 0, 0 )
go
CREATE PUBLICATION "DBA"."TEST_ULINIT"
(
TABLE "DBA"."AUDIT"( "thekey" )
)
go
commit work
go
The ulinit command line and results...
ulinit -c " DSN=DVX;uid=dba;pwd=
sql" -f Test.usm -n
TEST_ULINIT -m delete_this
Adaptive Server Anywhere UltraLite Initialization Tool
Version 9.0.2.3228
Running analyzer ...
Loading schema information: 0.156 seconds
Loading SQL statements: 0.234 seconds
Analyzing access plans: 0.047 seconds
Generating source code for SQL statements: 0.047 seconds
Generating code for UltraLite schema: 0.063 seconds
Total analyzer execution time: 0.578 seconds
Thanks
rr12
| |
| Shuchit 2006-01-28, 9:23 am |
| rr12 wrote in news:43d7cc56.3d25.1681692777@sybase.com:
> If I add an article to my publication in my reference
> database which contains a specific table and one column (as
> a test), ulinit generates 4 other columns that I did not
> select automatically. Those columns appear in both the
> example scripts and the usm file; but they don't appear in
> the consolidated pub. However, I don't want those columns.
> Does anyone know why these extra columns might are
> generated.
Are these extra columns all part of the primary key in the reference
database ?
Shuchit
| |
|
| No, they are not part of the primary key (or any keys).
| |
| Usmanov A. 2006-01-31, 3:23 am |
| May be extra column created with UNIQUE constrain?
--
Sincerely yours,
Alex Usmanov.
| |
| Michael Thode 2006-02-01, 11:23 am |
| This shouldn't be causing the column to be included, but as an experiment
you could remove the UNIQUE constraint in your reference database and test
to see if it makes a difference.
Mike
"Usmanov A." <alex_u@pochtamt.ru> wrote in message
news:43df159b@forums
-2-dub...
> May be extra column created with UNIQUE constrain?
>
> --
>
> Sincerely yours,
> Alex Usmanov.
>
>
| |
|
| No, there are no unique constraints.
> May be extra column created with UNIQUE constrain?
>
> --
>
> Sincerely yours,
> Alex Usmanov.
>
>
|
|
|
|
|