Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 234646 - StackOverflowError when invoke Work Offline action in DSE
Summary: StackOverflowError when invoke Work Offline action in DSE
Status: RESOLVED FIXED
Alias: None
Product: Data Tools
Classification: Tools
Component: Data Source Explorer (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: 1.6.1M1   Edit
Assignee: Brian Fitzpatrick CLA
QA Contact:
URL:
Whiteboard:
Keywords:
: 235358 (view as bug list)
Depends on: 231005
Blocks:
  Show dependency tree
 
Reported: 2008-05-29 11:05 EDT by Dimiter Dimitrov CLA
Modified: 2008-08-11 14:32 EDT (History)
2 users (show)

See Also:

Attachments
exception was thrown (108.90 KB, text/plain)
2008-05-29 11:07 EDT, Dimiter Dimitrov CLA 		no flags Details
stack trace of loadParameters (4.85 KB, text/plain)
2008-05-29 11:58 EDT, Wolfgang Auer CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dimiter Dimitrov CLA 2008-05-29 11:05:24 EDT 
Build ID: I20080502-0100

Steps To Reproduce:
I知 working against MaxDB v7.6.04.11. When I try to prepare for offline work (DSE -> context menu of the base ->Work Offline) the attached exception appears. It seems to have cycle in the following (see the attached exception):

at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUserDefinedFunction.loadParameters(JDBCUserDefinedFunction.java:135)
at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUserDefinedFunction.getParameters(JDBCUserDefinedFunction.java:74)

Could you investigate the reason please? You could download the latest version of MaxDB here:
https://www.sdn.sap.com/irj/sdn/software-downloads


More information:
Comment 1 Dimiter Dimitrov CLA 2008-05-29 11:07:12 EDT 
Created attachment 102652 [details]
exception was thrown
Comment 2 Wolfgang Auer CLA 2008-05-29 11:57:53 EDT 
Hello,

In the stack trace you can clearly see that DTP calls loadParameters very often for the Procedure FORCE_CHECKPOINT which is owned by the DBA.

The error can be reproduced by log on as a SYSDBA user. 
 
Best Regards
  Wolfgang
Comment 3 Wolfgang Auer CLA 2008-05-29 11:58:49 EDT 
Created attachment 102674 [details]
stack trace of loadParameters
Comment 4 Brian Fitzpatrick CLA 2008-05-29 12:01:48 EDT 
This is related to similar issues with the Work Offline/Save Offline functionality reported in bug 231005
Comment 5 Brian Fitzpatrick CLA 2008-06-03 11:37:06 EDT 
*** Bug 235358 has been marked as a duplicate of this bug. ***
Comment 6 Brian Fitzpatrick CLA 2008-06-05 16:02:59 EDT 
Dimiter or Wolfgang, can you try again with the RC3 build?
Comment 7 Wolfgang Auer CLA 2008-06-09 05:43:01 EDT 
Hi,

I tested with dtp-sdk-1.6RC3-200806031057 and I still receive the StackOverFlow error.

Regards
Wolfgang
Comment 8 Brian Fitzpatrick CLA 2008-06-09 09:21:24 EDT 
I don't believe the fixes for 231005 would have shown up until the RC4 build today or tomorrow. So please give it one more shot. Thanks for your patience.
Comment 9 Wolfgang Auer CLA 2008-06-11 09:43:39 EDT 
Hi,

I tested with dtp-sdk-1.6RC4-200806101113 and I still receive the StackOverFlow
error.

Regards
Wolfgang
Comment 10 Brian Fitzpatrick CLA 2008-06-11 10:06:28 EDT 
Unfortunately we're at the end of the Ganymede release and can't really check anything else in... 

What's the easiest way to reproduce this and we'll work on a fix for the 1.6.1 release in September?

Can you reproduce it with Derby? or just MaxDB?
Comment 11 Brian Fitzpatrick CLA 2008-06-11 10:07:08 EDT 
Is there a particular MaxDB database that's throwing the error or all MaxDB databases? (Might be helpful to have SQL scripts to create tables/data/etc...)
Comment 12 Wolfgang Auer CLA 2008-06-11 10:47:14 EDT 
Hello,

the error can easily be reproduced.

1) MaxDB 7.6 Installation https://www.sdn.sap.com/irj/sdn/software-downloads
2) Add MaxDB datasource to DTP with DBA user. Should be DBADMIN if default values from installation are not changed.
3) Connect to database with DBADMIN user.
4) Choose Work Offline menu.

Regards
   Wolfgang
Comment 13 Brian Fitzpatrick CLA 2008-07-21 13:16:13 EDT 
Hi Wolfgang & Dimiter... Can you give it another shot with the most recent 1.6.1M1 nightly build? We fixed some issues in bug 239968 that were causing issues that should have resolved this.
Comment 14 Wolfgang Auer CLA 2008-07-22 04:22:27 EDT 
Hello,

I checked with the new DTP version and it seems to work.
There seems to be no memory problem now.

Dimiter can you confirm this?

Regards
   Wolfgang
Comment 15 Brian Fitzpatrick CLA 2008-08-11 14:32:40 EDT 
Marking as fixed. Dimiter, can you confirm?