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.

dbunload error

5 posts in General Discussion Last posting was on 2007-03-07 02:15:40.0Z
Diego Posted on 2007-03-06 18:40:06.0Z
From: "Diego" <soft@gic-noemail.com>
Newsgroups: ianywhere.public.general
Subject: dbunload error
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 172.red-213-96-32.staticip.rima-tde.net
X-Original-NNTP-Posting-Host: 172.red-213-96-32.staticip.rima-tde.net
Message-ID: <45edb586@forums-1-dub>
Date: 6 Mar 2007 10:40:06 -0800
X-Trace: forums-1-dub 1173206406 213.96.32.172 (6 Mar 2007 10:40:06 -0800)
X-Original-Trace: 6 Mar 2007 10:40:06 -0800, 172.red-213-96-32.staticip.rima-tde.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5865
Article PK: 1850

I am a database administrator
I try to unload database with a utility dbunload (SQL Anywhere 10). I am an
error
< "first_pkcol" in "sa_unloaded_table" cannot be null >
and stop the proces

Can us help me?


Chris Keating Posted on 2007-03-06 19:21:06.0Z
From: Chris Keating <keating@ianywhereDOT.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: dbunload error
References: <45edb586@forums-1-dub>
In-Reply-To: <45edb586@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <45edbf22@forums-1-dub>
Date: 6 Mar 2007 11:21:06 -0800
X-Trace: forums-1-dub 1173208866 10.25.98.170 (6 Mar 2007 11:21:06 -0800)
X-Original-Trace: 6 Mar 2007 11:21:06 -0800, keating-dm20.sybase.com
Lines: 45
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5866
Article PK: 1851

Looks like you have a data problem in the source database. Does the
column first_pkcol restrict NULLs? If so, check the data for the table
and column to see if it has a NULL value in a row.

You can force the load by changing the NULL-ability of the column to
allow nulls and then decide how to handle the problem row(s).

Diego wrote:
> I am a database administrator
> I try to unload database with a utility dbunload (SQL Anywhere 10). I am an
> error
> < "first_pkcol" in "sa_unloaded_table" cannot be null >
> and stop the proces
>
> Can us help me?
>
>

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Breck Carter [Team iAnywhere] Posted on 2007-03-06 21:49:00.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: dbunload error
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <9aoru2p1ol4iq5oss5r2mm070udbr1oss6@4ax.com>
References: <45edb586@forums-1-dub> <45edbf22@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 6 Mar 2007 13:49:00 -0800
X-Trace: forums-1-dub 1173217740 64.7.134.118 (6 Mar 2007 13:49:00 -0800)
X-Original-Trace: 6 Mar 2007 13:49:00 -0800, bcarter.sentex.ca
Lines: 38
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5867
Article PK: 1849

FWIW that looks like a *system* table it's complaining about, although
it does not appear permanent.

In any event, I'm not sure how you would get a NULL into a NOT NULL
column... we're not talking about an application error here, we're
talking about dbunload failing on an *existing* database.

Breck

On 6 Mar 2007 11:21:06 -0800, Chris Keating <keating@ianywhereDOT.com>

wrote:

>Looks like you have a data problem in the source database. Does the
>column first_pkcol restrict NULLs? If so, check the data for the table
>and column to see if it has a NULL value in a row.
>
>You can force the load by changing the NULL-ability of the column to
>allow nulls and then decide how to handle the problem row(s).
>
>
>
>Diego wrote:
>> I am a database administrator
>> I try to unload database with a utility dbunload (SQL Anywhere 10). I am an
>> error
>> < "first_pkcol" in "sa_unloaded_table" cannot be null >
>> and stop the proces
>>
>> Can us help me?
>>
>>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


anil k goel Posted on 2007-03-06 22:05:35.0Z
From: "anil k goel" <firstname.no-junk.lastname@spam.ianywhere.com>
Newsgroups: ianywhere.public.general
References: <45edb586@forums-1-dub> <45edbf22@forums-1-dub> <9aoru2p1ol4iq5oss5r2mm070udbr1oss6@4ax.com>
Subject: Re: dbunload error
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: iarouter.sybase.com
X-Original-NNTP-Posting-Host: iarouter.sybase.com
Message-ID: <45ede5af@forums-1-dub>
Date: 6 Mar 2007 14:05:35 -0800
X-Trace: forums-1-dub 1173218735 10.25.106.45 (6 Mar 2007 14:05:35 -0800)
X-Original-Trace: 6 Mar 2007 14:05:35 -0800, iarouter.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5868
Article PK: 1852

Correct -- sa_unloaded_table is a temp table created by the dbunload
processing.

Looking at the schema for this table, the most likely cause of the error is
the setting of the allow_nulls_by_default option in the database that is
being unloaded. We will fix this problem in a future release.

Diego, will you please try the following to see if it resolves your problem:

1. Check to see if the value of allow_nulls_by_default is set to OFF.
2. If yes, set the option value to ON
3. Do the unload/reload -- it should succeed now.
4. You can set the option value back to OFF in the new and/or old databases
at this stage.

Thanks for bringing this to our attention.

--
-anil
Query Processing, SQLAnywhere Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:9aoru2p1ol4iq5oss5r2mm070udbr1oss6@4ax.com...
> FWIW that looks like a *system* table it's complaining about, although
> it does not appear permanent.
>
> In any event, I'm not sure how you would get a NULL into a NOT NULL
> column... we're not talking about an application error here, we're
> talking about dbunload failing on an *existing* database.
>
> Breck
>
> On 6 Mar 2007 11:21:06 -0800, Chris Keating <keating@ianywhereDOT.com>
> wrote:
>
>>Looks like you have a data problem in the source database. Does the
>>column first_pkcol restrict NULLs? If so, check the data for the table
>>and column to see if it has a NULL value in a row.
>>
>>You can force the load by changing the NULL-ability of the column to
>>allow nulls and then decide how to handle the problem row(s).
>>
>>
>>
>>Diego wrote:
>>> I am a database administrator
>>> I try to unload database with a utility dbunload (SQL Anywhere 10). I
>>> am an
>>> error
>>> < "first_pkcol" in "sa_unloaded_table" cannot be null >
>>> and stop the proces
>>>
>>> Can us help me?
>>>
>>>
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Chris Keating Posted on 2007-03-07 02:15:40.0Z
From: Chris Keating <keating@ianywhereDOT.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: dbunload error
References: <45edb586@forums-1-dub> <45edbf22@forums-1-dub> <9aoru2p1ol4iq5oss5r2mm070udbr1oss6@4ax.com>
In-Reply-To: <9aoru2p1ol4iq5oss5r2mm070udbr1oss6@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpneast-client-018.sybase.com
X-Original-NNTP-Posting-Host: vpneast-client-018.sybase.com
Message-ID: <45ee204c$1@forums-1-dub>
Date: 6 Mar 2007 18:15:40 -0800
X-Trace: forums-1-dub 1173233740 10.18.242.25 (6 Mar 2007 18:15:40 -0800)
X-Original-Trace: 6 Mar 2007 18:15:40 -0800, vpneast-client-018.sybase.com
Lines: 69
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5869
Article PK: 1853

Thanks. I did not look closely at the table name. Good thing you keep us
honest :-)

Breck Carter [Team iAnywhere] wrote:
> FWIW that looks like a *system* table it's complaining about, although
> it does not appear permanent.
>
> In any event, I'm not sure how you would get a NULL into a NOT NULL
> column... we're not talking about an application error here, we're
> talking about dbunload failing on an *existing* database.
>
> Breck
>
> On 6 Mar 2007 11:21:06 -0800, Chris Keating <keating@ianywhereDOT.com>
> wrote:
>
>> Looks like you have a data problem in the source database. Does the
>> column first_pkcol restrict NULLs? If so, check the data for the table
>> and column to see if it has a NULL value in a row.
>>
>> You can force the load by changing the NULL-ability of the column to
>> allow nulls and then decide how to handle the problem row(s).
>>
>>
>>
>> Diego wrote:
>>> I am a database administrator
>>> I try to unload database with a utility dbunload (SQL Anywhere 10). I am an
>>> error
>>> < "first_pkcol" in "sa_unloaded_table" cannot be null >
>>> and stop the proces
>>>
>>> Can us help me?
>>>
>>>
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************