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.

Errors in uploading DataWindow SQL

3 posts in Appeon (partner product) Last posting was on 2009-12-22 16:42:46.0Z
larry stevens Posted on 2009-12-19 19:43:10.0Z
From: "larry stevens" <lstevens@accesso.com>
Newsgroups: sybase.public.appeon
Organization: 67.132.66.2
X-Newsreader: AspNNTP 1.50 (JodoHost)
Subject: Errors in uploading DataWindow SQL
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2d2cce$1@forums-1-dub>
Date: 19 Dec 2009 11:43:10 -0800
X-Trace: forums-1-dub 1261251790 10.22.241.152 (19 Dec 2009 11:43:10 -0800)
X-Original-Trace: 19 Dec 2009 11:43:10 -0800, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2447
Article PK: 13439

appeon version 5.1
powerbuilder version 10.5

During the deployment of the application, I am getting "errors in uploading
datawindow sql".

Does anyone know what can cause this error?

How do i determine what datawindow is causing an error?


---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Larry Stevens Posted on 2009-12-20 21:54:55.0Z
Sender: 5d44.4b2e9bb5.1804289383@sybase.com
From: Larry Stevens
Newsgroups: sybase.public.appeon
Subject: Re: Errors in uploading DataWindow SQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b2e9d2f.5d66.1681692777@sybase.com>
References: <4b2d2cce$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Dec 2009 13:54:55 -0800
X-Trace: forums-1-dub 1261346095 10.22.241.41 (20 Dec 2009 13:54:55 -0800)
X-Original-Trace: 20 Dec 2009 13:54:55 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2448
Article PK: 13440


> appeon version 5.1
> powerbuilder version 10.5
>
> During the deployment of the application, I am getting
> "errors in uploading datawindow sql".
>
> Does anyone know what can cause this error?
>
> How do i determine what datawindow is causing an error?
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp

A followup to my original message, I found this in the
AppeonErrolog: Primary key for table
't_datawindowsqlstring' is not unique.

Has anyone seen this before?


Larry Stevens Posted on 2009-12-22 16:42:46.0Z
Sender: 1753.4b30f511.1804289383@sybase.com
From: Larry Stevens
Newsgroups: sybase.public.appeon
Subject: Re: Errors in uploading DataWindow SQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b30f706.17a0.1681692777@sybase.com>
References: <4b2e9d2f.5d66.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Dec 2009 08:42:46 -0800
X-Trace: forums-1-dub 1261500166 10.22.241.41 (22 Dec 2009 08:42:46 -0800)
X-Original-Trace: 22 Dec 2009 08:42:46 -0800, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2452
Article PK: 13441


> > appeon version 5.1
> > powerbuilder version 10.5
> >
> > During the deployment of the application, I am getting
> > "errors in uploading datawindow sql".
> >
> > Does anyone know what can cause this error?
> >
> > How do i determine what datawindow is causing an error?
> >
> >
> > ---== Posted via the PFCGuide Web Newsreader ==---
> > http://www.pfcguide.com/_newsgroups/group_list.asp
>
> A followup to my original message, I found this in the
> AppeonErrolog: Primary key for table
> 't_datawindowsqlstring' is not unique.
>
> Has anyone seen this before?

I resolved my issue. I had two datawindows whose names have
the same value up through the 50th character. So perhaps
there is a 50 character limit to the primary key column?