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.

Can't create or edit datawindows anymore...

4 posts in DataWindow Last posting was on 2008-07-02 13:30:30.0Z
jason Posted on 2008-07-02 12:42:03.0Z
Sender: 1258.486a8575.1804289383@sybase.com
From: Jason
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Can't create or edit datawindows anymore...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <486b779b.310d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jul 2008 05:42:03 -0700
X-Trace: forums-1-dub 1215002523 10.22.241.41 (2 Jul 2008 05:42:03 -0700)
X-Original-Trace: 2 Jul 2008 05:42:03 -0700, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87297
Article PK: 416555

I could use some help figuring out why I can't create
datawindows anymore. PB 10.5.2 build 7699 crashes every
time I try to create a new datawindow or edit the SQL of an
existing one.

When creating a new one, it lets me build the SQL and I get
to the last step and click the finish button, I see where it
puts "(Untitled)" in the title bar of the window but then PB
crashes. I've tried creating dws against different database
bases, using quick select and external datawindows w/o
success. It crashes when trying to render the datawindow to
the screen.

For existing datawindows, same thing, I crashes when trying
to render them. I can't even open them. (I can do a right
click and view source though.)

Finally, when I run an app from PB, I can see the datawindow
controls on my windows, but not of them appear to contain
any datawindow objects.

This issues was precipitated by a failed compile attempt. I
have since recompiled all objects successfully, but I still
can't create and new or edit any existing datawindows - even
those in PBLs not affected by the original failed compile.

Any ideas?

The issue occured under 10.5.0. I tried to upgrade to
10.5.2 to see if that would resolve the issue but it didn't.
My event viewer application error logs state (for the most
recent crash): Faulting application pb105.exe, version
10.5.0.4523, faulting module pbdev105.dll, version
10.5.2.7699, fault address 0x0002fa8d.


Bruce Armstrong [TeamSybase] Posted on 2008-07-02 13:20:19.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Can't create or edit datawindows anymore...
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <vuvm64he90skvi22qq45pr2vkp52p5be13@4ax.com>
References: <486b779b.310d.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.652
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
Date: 2 Jul 2008 06:20:19 -0700
X-Trace: forums-1-dub 1215004819 10.22.241.152 (2 Jul 2008 06:20:19 -0700)
X-Original-Trace: 2 Jul 2008 06:20:19 -0700, vip152.sybase.com
Lines: 41
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87300
Article PK: 416557

See the last item under Painter Layouts
http://www.techno-kitten.com/PowerBuilder_Help/Troubleshooting/Abnormal_Termination/abnormal_termination.html

On 2 Jul 2008 05:42:03 -0700, Jason wrote:

>I could use some help figuring out why I can't create
>datawindows anymore. PB 10.5.2 build 7699 crashes every
>time I try to create a new datawindow or edit the SQL of an
>existing one.
>
>When creating a new one, it lets me build the SQL and I get
>to the last step and click the finish button, I see where it
>puts "(Untitled)" in the title bar of the window but then PB
>crashes. I've tried creating dws against different database
>bases, using quick select and external datawindows w/o
>success. It crashes when trying to render the datawindow to
>the screen.
>
>For existing datawindows, same thing, I crashes when trying
>to render them. I can't even open them. (I can do a right
>click and view source though.)
>
>Finally, when I run an app from PB, I can see the datawindow
>controls on my windows, but not of them appear to contain
>any datawindow objects.
>
>This issues was precipitated by a failed compile attempt. I
>have since recompiled all objects successfully, but I still
>can't create and new or edit any existing datawindows - even
>those in PBLs not affected by the original failed compile.
>
>Any ideas?
>
>The issue occured under 10.5.0. I tried to upgrade to
>10.5.2 to see if that would resolve the issue but it didn't.
> My event viewer application error logs state (for the most
>recent crash): Faulting application pb105.exe, version
>10.5.0.4523, faulting module pbdev105.dll, version
>10.5.2.7699, fault address 0x0002fa8d.


jason Posted on 2008-07-02 13:30:30.0Z
Sender: 1258.486a8575.1804289383@sybase.com
From: Jason
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Can't create or edit datawindows anymore...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <486b82f6.3298.1681692777@sybase.com>
References: <vuvm64he90skvi22qq45pr2vkp52p5be13@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jul 2008 06:30:30 -0700
X-Trace: forums-1-dub 1215005430 10.22.241.41 (2 Jul 2008 06:30:30 -0700)
X-Original-Trace: 2 Jul 2008 06:30:30 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87302
Article PK: 416559

Bruce,

That worked perfectly. Thank you!

Jason


Roland Smith [TeamSybase] Posted on 2008-07-02 13:27:03.0Z
From: "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <486b779b.310d.1681692777@sybase.com>
Subject: Re: Can't create or edit datawindows anymore...
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <486b8227$1@forums-1-dub>
Date: 2 Jul 2008 06:27:03 -0700
X-Trace: forums-1-dub 1215005223 10.22.241.152 (2 Jul 2008 06:27:03 -0700)
X-Original-Trace: 2 Jul 2008 06:27:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87301
Article PK: 416558

This could be a painter layout problem. Open the registry editor and find
this key:

HKEY_CURRENT_USER\Software\Sybase\PowerBuilder\10.5\Layout\Default

Delete the Datawindow value.

If that does not fix it, try these steps:

Optimize each library in the application. You can do this from the System
Tree by right clicking on the library and choosing Optimize from the popup
menu.

Right click on the target and choose Migrate from the popup menu.

When that is done, do the optimize again. Answer Yes to the prompt to
overwrite the backup.

Exit PB and then start it again.