Im designing a report in BIRT, where I have 2 data sets and one parent table and under that a child table. For each parent row, I'm firing child table, so it's hitting database everytime. For example if I'm having 100 rows of parent records, for each I'm processing child table. So child table query is executed 100 times. Thus 100 cursors are opened, and after 4/5 runs I'm getting maximum cursor open error. Is there any better approach ?
Nested table in BIRT opens too meny db cursors, causing cursor error
71 Views Asked by Soumyadeep At
1
There are 1 best solutions below
Related Questions in BIRT
- Customize BIRT "Export Report" dialogue box
- Exception when executing a BIRT report
- the pdf file is created but cannot be opened
- MySQL some rows to columns
- Adding columns in a query executed from a stored procedure
- Cross table with two datasets (one as the row and the other as the column)
- BIRT: change font chart axis
- Postgres Stored Procedures returing cursor in birt report
- "Unable to compute a percent/stacked axis containing non-numerical data" and "Not a number: NaN "
- Convert string with date text to date format in BIRT table
- BIRT chart label missing
- BIRT pagebreak depending on the data retrieved from the table
- Unknown source on BIRT report
- Passing blank string as report parameter BIRT
- Possible to Query Asterisk CEL info directly from the database? (PostgreSQL)
Related Questions in DATABASE-CURSOR
- What are the examples for @@fetch_status value -2 and -9
- MongoDB iterate cursor too slow
- How to use server side cursors with psycopg2
- Why does mysql not allow to fetch into user-defined variable in cursor?
- Cursor Vs Connection in Python
- Nested queries using MySQLdb
- Conditionally define a Cursor
- How to find number of rows in cursor
- Iterate through rows from Sqlite-query
- Access cursor by column name dynamically
- Get Multiple Values in SQL Server Cursor
- MongoDB - Why should I use a cursor instead of iterator_to_array (in PHP)
- Trouble understanding Database Cursors
- TSQL change cursor definition
- Deleting multiple records in IndexedDB based on index
Related Questions in OPENTEXT
- How to get audit trail info from Opentext Content Mgmt Server? Is there any RestAPI?
- vba XMLHTTP get xml from Content Server
- Opentext REST API Creating Binders
- Attaching category to items through OpenText content server Web services
- OpenText System Architecture Diagram
- work with custom database data from custom tables in OpenText
- Cypress.io: Server Error | 404 - File or director not found
- What is a Node in OpenText LiveLink?
- What is MetaData in OpenText LiveLink?
- FileInfo.OpenText() Fails To Read Special Characters E.G. üò°
- How do I provide windows domain account information to OpenText Livelink ECM programmatically?
- Tenable shows vulnerabilities to upgrade tomcat to 8.5.60 though the upgrade has been done in Archive Server
- How to separate lines of data read from a textfile? Customers with their orders
- Livelink - OpenText : Call to rmclassifications to update status via API
- OpenText Content Server how to get folder ID with path using REST API?
Related Questions in MAGELLAN
- Disable Magellan in Foundation 5
- How to register a custom view engine in magellan?
- How to make scrollspy effect in foundation 4
- Magellan sticky nav + sidebars
- horizontally align magellan menu
- Nested table in BIRT opens too meny db cursors, causing cursor error
- WPF Magellan: is there a way to navigate to a existing view?
- Error when initializing Zurb Magellan 6
- Nightwatch-friendly command or javascript function to reload a page
- Foundation Magellan - check if it's sticky
- Why does Foundation Magellan not work when following original demo?
- Foundation's Magellan not working with fixed topbar
- WPF Magellan ViewModel IOC
- Getting rid of Back/Forward buttons in XAML
- Issue with rewrite url and hash scrolling
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Which version of BIRT are you using? Maybe you are hitting a bug:
https://github.com/eclipse/birt/issues/875
This was fixed in March 2022.