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
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Require correct dependency to setup birt in springboot project
- how to get using RE API for birt report in struts2, trying to render birt report with pagination(paginated html) with navbar
- Birt Rows to Columns + Break -> Row Duplication
- BIRT report with an optional currency parameter - how to specify the parameter in both the ide and the maximo gui
- How to extract project from BIRT report designer into a WAR file
- Eclipse BIRT - Java bytecode compilation done at compile time or runtime?
- BIRT report parameter not accepting mutiple values seperated by ','
- Errors with Eclipse BIRT report generation
- BIRT Report Engine API createFactoryObject returns null
- BIRT Report having trouble with accented characters coming from database
- Birt changing by script the number format in one column table
- BIRT log levels and details
- Birt report - Return requested data and nulls
- Birt graph drill through on date range
Related Questions in DATABASE-CURSOR
- ORACLE: Build 'INSERT INTO' statements from SELECT * results
- What is the difference between Cursor For update and general update in SQL Server
- Snowflake Cursor Loop with IF statement
- Optimized Alternative of CURSOR
- Using a cursor in SQL Developer to generate a subsequent query for each record
- Find and update duplicate values held in a column with a unique constraint? - Msg 402 The data types are incompatible in the add operator
- MySQLdb call procedure with long name
- SQL cursor take too long to complete
- Loop all the tables using whileloop
- CURSOR seems empty but SELECT returns non-empty data
- "commands out of sync; you can't run this command now" on first use of cursor
- On what criteria can While loops and Cursors be compared?
- pl/sql : Error when declaring a cursor in exception section
- How to copy values from a table into another table during PostgreSQL EF migration?
- How do I update mutiple rows of a table using Cursor loop?
Related Questions in OPENTEXT
- ALM Octane UFT Discovery Job not working as expected
- Not able to create a web service configuration in Service Manger client 9.80 with newly created table
- I want to modify the default values of a category template from a content script in Groovy within OpenText
- OpenText VIM: How to implement a custom filter to delete certain E-Mail attachments?
- How to create MetaData in Teamsite
- How to open port 5814 on AWS EC2 machine. I need to open it for autopass licence server. UFT licence will be installed on autpass server
- Content server search function doenst work
- Opentext Extended ECM Custom column Workspace Name fr not found
- How to override SYS variable in Exstream
- Select a default value of a Combo box in Centura/Gupta (Team Developert)
- OpenText server - how to handle Azure authentication with API REST?
- Deleting columns from a table opentext BIRT Report in the beforeFactory
- REST API call in OpenText TeamSite
- Where to find logs of DB request
- C# - Auto populate the field of Currency Type if the Code is entered
Related Questions in MAGELLAN
- Nested table in BIRT opens too meny db cursors, causing cursor error
- How to transform a DataFrame to and RDD[Point] instead of RDD[ROW]?
- Foundation's Magellan not working with fixed topbar
- Why does Foundation Magellan not work when following original demo?
- In Magellan / Nightwatch, if we do .waitForElementNotVisible() but the element fade out or in, does the test actually work?
- Using magellan-nightwatch, is there a way to assert some element is hidden / displayed?
- In Magellan / Nightwatch, how do we assert that an element comes before another element?
- In the Magellan / Nightwatch framework, how to set a CSS outline on an element?
- How to import libraries in Spark Notebook
- Foundation sticky magellan not working
- Expanding and Collapsing Foundation 6 Accordion Menu on Scroll with Magellan
- Foundation 6 Magellan sticky not working with Zurb template cli install
- Megamenu disappears after scroll using Foundation/Magellan
- Error when initializing Zurb Magellan 6
- Nightwatch-friendly command or javascript function to reload a page
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 # Hahtags
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.