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.

Sybase Central

4 posts in General Discussion Last posting was on 2005-04-29 21:01:57.0Z
Eddie Sizemore Posted on 2005-04-29 13:45:17.0Z
From: "Eddie Sizemore" <esizemoreno@spamqx.net>
Newsgroups: ianywhere.public.general
Subject: Sybase Central
Lines: 75
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
NNTP-Posting-Host: 12-203-198-23.client.insightbb.com
X-Original-NNTP-Posting-Host: 12-203-198-23.client.insightbb.com
Message-ID: <42723a6d$1@forums-1-dub>
Date: 29 Apr 2005 06:45:17 -0700
X-Trace: forums-1-dub 1114782317 12.203.198.23 (29 Apr 2005 06:45:17 -0700)
X-Original-Trace: 29 Apr 2005 06:45:17 -0700, 12-203-198-23.client.insightbb.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4416
Article PK: 8227

Using Sybase Central Version: 4.3.0.2398 I get a stack trace when importing
a csv file into an existing table in my db. I am able to continue with the
import. I have included parts of the stack trace if anyone needs the
complete trace just let me know. I got a stack trace on three different csv
and tables.

Registered Plug-ins:
--------------------
Plug-in: Adaptive Server Anywhere 9
Plug-in Version: 9.0.2.3044

Current thread: AWT-EventQueue-0
java.lang.ArrayIndexOutOfBoundsException: 58 >= 58
at java.util.Vector.elementAt(Unknown Source)
at javax.swing.table.DefaultTableColumnModel.getColumn(Unknown Source)
at
sybase.isql.InputStatementWizard$ColumnDetailsPanel.setColumnHeadingText(InputStatementWizard.java:2998)
at
sybase.isql.InputStatementWizard$ColumnDetailsPanel.refresh(InputStatementWizard.java:2975)
at
sybase.isql.InputStatementWizard$ColumnDetailsPanel.componentShown(InputStatementWizard.java:3057)
at java.awt.AWTEventMulticaster.componentShown(Unknown Source)
at java.awt.Component.processComponentEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at sybase.isql.InputStatementWizard.create(InputStatementWizard.java:521)
at sybase.isql.ISQLPanel.handleImport(ISQLPanel.java:1810)
at sybase.isql.ISQLPanel.processMenu(ISQLPanel.java:1958)
at sybase.isql.ParentFrame.processMenu(ParentFrame.java:941)
at
sybase.isql.ParentFrame$ISQLAction.actionPerformed(ParentFrame.java:2233)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown
Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Unknown
Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)


Eddie Sizemore


Nick Elson Posted on 2005-04-29 16:07:18.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <42723a6d$1@forums-1-dub>
Subject: Re: Sybase Central
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <42725bb0$1@forums-2-dub>
X-Original-Trace: 29 Apr 2005 09:07:12 -0700, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Apr 2005 09:07:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Apr 2005 09:07:18 -0700
X-Trace: forums-1-dub 1114790838 10.22.108.75 (29 Apr 2005 09:07:18 -0700)
X-Original-Trace: 29 Apr 2005 09:07:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4420
Article PK: 8231

Is it possible that the number of columns in the data file is greater
than the number of columns? Or is the data itself bigger than the
column max size? [see 10901312]


If not, the it seems you have a repro. that someone should look
at. Please create a case/subcase/qts if you can package that up
so someone can look into this for you.

"Eddie Sizemore" <esizemoreno@spamqx.net> wrote in message
news:42723a6d$1@forums-1-dub...
> Using Sybase Central Version: 4.3.0.2398 I get a stack trace when
> importing a csv file into an existing table in my db. I am able to
> continue with the import. I have included parts of the stack trace if
> anyone needs the complete trace just let me know. I got a stack trace on
> three different csv and tables.
>
> Registered Plug-ins:
> --------------------
> Plug-in: Adaptive Server Anywhere 9
> Plug-in Version: 9.0.2.3044
>
> Current thread: AWT-EventQueue-0
> java.lang.ArrayIndexOutOfBoundsException: 58 >= 58
> at java.util.Vector.elementAt(Unknown Source)
> at javax.swing.table.DefaultTableColumnModel.getColumn(Unknown Source)
> at
> sybase.isql.InputStatementWizard$ColumnDetailsPanel.setColumnHeadingText(InputStatementWizard.java:2998)
> at
> sybase.isql.InputStatementWizard$ColumnDetailsPanel.refresh(InputStatementWizard.java:2975)
> at
> sybase.isql.InputStatementWizard$ColumnDetailsPanel.componentShown(InputStatementWizard.java:3057)
> at java.awt.AWTEventMulticaster.componentShown(Unknown Source)
> at java.awt.Component.processComponentEvent(Unknown Source)
> at java.awt.Component.processEvent(Unknown Source)
> at java.awt.Container.processEvent(Unknown Source)
> at java.awt.Component.dispatchEventImpl(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> at java.awt.Dialog$1.run(Unknown Source)
> at java.awt.Dialog.show(Unknown Source)
> at java.awt.Component.show(Unknown Source)
> at java.awt.Component.setVisible(Unknown Source)
> at sybase.isql.InputStatementWizard.create(InputStatementWizard.java:521)
> at sybase.isql.ISQLPanel.handleImport(ISQLPanel.java:1810)
> at sybase.isql.ISQLPanel.processMenu(ISQLPanel.java:1958)
> at sybase.isql.ParentFrame.processMenu(ParentFrame.java:941)
> at
> sybase.isql.ParentFrame$ISQLAction.actionPerformed(ParentFrame.java:2233)
> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown
> Source)
> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> at javax.swing.AbstractButton.doClick(Unknown Source)
> at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
> at
> javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Unknown
> Source)
> at java.awt.Component.processMouseEvent(Unknown Source)
> at java.awt.Component.processEvent(Unknown Source)
> at java.awt.Container.processEvent(Unknown Source)
> at java.awt.Component.dispatchEventImpl(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
> at java.awt.Container.dispatchEventImpl(Unknown Source)
> at java.awt.Window.dispatchEventImpl(Unknown Source)
> at java.awt.Component.dispatchEvent(Unknown Source)
> at java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.awt.EventDispatchThread.run(Unknown Source)
>
>
> Eddie Sizemore
>
>


Eddie Sizemore Posted on 2005-04-29 21:01:57.0Z
From: "Eddie Sizemore" <esizemoreno@spamqx.net>
Newsgroups: ianywhere.public.general
References: <42723a6d$1@forums-1-dub> <42725bb0$1@forums-2-dub>
Subject: Re: Sybase Central
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-Original-NNTP-Posting-Host: 12-203-198-23.client.insightbb.com
Message-ID: <4272a0c1$1@forums-2-dub>
X-Original-Trace: 29 Apr 2005 14:01:53 -0700, 12-203-198-23.client.insightbb.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Apr 2005 14:01:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Apr 2005 14:01:57 -0700
X-Trace: forums-1-dub 1114808517 10.22.108.75 (29 Apr 2005 14:01:57 -0700)
X-Original-Trace: 29 Apr 2005 14:01:57 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4423
Article PK: 8236

It was wrong number of columns. One db had a column that had not been
deleted from the tables.

Thanks for the help.

"Nick Elson" <no_spam_nicelson@sybase.com> wrote in message
news:42725bb0$1@forums-2-dub...
> Is it possible that the number of columns in the data file is greater
> than the number of columns? Or is the data itself bigger than the
> column max size? [see 10901312]
>


Greg Fenton Posted on 2005-04-29 18:58:20.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sybase Central
References: <42723a6d$1@forums-1-dub>
In-Reply-To: <42723a6d$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-t30.sybase.com
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <427283cc$1@forums-1-dub>
Date: 29 Apr 2005 11:58:20 -0700
X-Trace: forums-1-dub 1114801100 10.25.98.243 (29 Apr 2005 11:58:20 -0700)
X-Original-Trace: 29 Apr 2005 11:58:20 -0700, gfenton-t30.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4421
Article PK: 8232


Eddie Sizemore wrote:
> Using Sybase Central Version: 4.3.0.2398 I get a stack trace when importing
> a csv file into an existing table in my db. I am able to continue with the
> import. I have included parts of the stack trace if anyone needs the
> complete trace just let me know. I got a stack trace on three different csv
> and tables.
>

Could you provide a repro of this problem either via your Technical
Support contact or via CaseXpress (http://casexpress.sybase.com/)?

Please provide the CSV file and the table schema into which you are
loading it.

Thanks,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/