Hi everyone,
I'm having a problem when trying to add a Multiple Edit table tied to a database table. I drag and drop the table structure onto the Layout View and I remember that this action added a script (editabletable.js or something like that) and an HTML element at the bottom of the table (<<table_init>>). This isn't happening. Furthermore, I wanted to check if the table still worked so I generated, deployed and tested the application to find that it didn't work correctly. Checking the logs I found a java.lang.OutOfMemoryError: Java heap space error.
This was all done on a new installation in my box (version 3.1.2 up to 0007 patch). This is the latest version for the BizFlow version I have installed (11.5). I reinstalled since I though something was corrupt on my installation.
I attached the project export for your review.
Thank you for your help,
Daniel
I'm having a problem when trying to add a Multiple Edit table tied to a database table. I drag and drop the table structure onto the Layout View and I remember that this action added a script (editabletable.js or something like that) and an HTML element at the bottom of the table (<<table_init>>). This isn't happening. Furthermore, I wanted to check if the table still worked so I generated, deployed and tested the application to find that it didn't work correctly. Checking the logs I found a java.lang.OutOfMemoryError: Java heap space error.
This was all done on a new installation in my box (version 3.1.2 up to 0007 patch). This is the latest version for the BizFlow version I have installed (11.5). I reinstalled since I though something was corrupt on my installation.
I attached the project export for your review.
Thank you for your help,
Daniel
Attachment
RE: Editable Table Error - Doesn't Add Scripts Automatically
This does seem very strange. Without the extra components you mention being present (eg script and css file includes, and the table_init custom field) the editable table will not work properly.
I have been able to add an editable table to your project export without issues, so I don+?+?+?t think there is a major problem with that project.
Are you able to add an editable table correctly to any of you other projects? Can you try creating a brand new project and see if adding the editable table to it correctly creates the table_init section and adds the needed script file?
If you are getting this problem for all projects that would indicate a problem with your installation. I notice you mentioned reinstalling, but perhaps there is still an issue?
To help check this, could you send through copies of the following files from your installation:
+?+?-?\WebMaker\design\repository\common\palette_config.xml
+?+?-?\WebMaker\design\repository\generic\mvc\generic\paletteTemplates\EditableTable_template.xml
This should help us check whether the configuration settings for the design palette are correct in your installation.
It would also be useful to know what web browser you are using, and whether you are getting any JavaScript errors when you add the +?+?++Editable Row+?+?+? control from the palette onto your page.
I think your +?+?++out of memory+?+?+? error for the runtime is likely to be a different issue. This can happen sometimes if you have a lot of projects, and have been doing lots of deploy operations. Generally you should find that restarting the Runtime Tomcat server will resolve this problem.
Regards,
Gerard
RE: Editable Table Error - Doesn't Add Scripts Automatically
I have checked and the Out of Memory error only happens when adding editable tables in the following fashion:
1. Dragging a database table structure from its root and selecting the option for editing multiple records.
2. Dragging an Editable table object and replacing the repeating structure by dragging the database table structure from the record node.
I configured everything regarding the table manually and didn't have any problem:
1. Created an Editable table object by dragging it from the palette.
2. Created table fields manually by dragging the appropriate objects from the palette.
3. Configured controllers manually by adding rules and queries as needed instead of dragging table structures to generate these rules automatically.
4. Configured data bindings manually by modifying the XML structure and then assigning bindings to the different fields.
When doing it this way, it seems to generate the table_init HTML object and adds editabletable.js correctly. The table then works correctly, but everything has to be done manually. I don't think there is anything wrong with my installation and have been working on a clean environment (only one project deployed in the runtime environment).
I hope this information is useful in explaining the specific problem I'm having.
RE: Editable Table Error - Doesn't Add Scripts Automatically
Thanks for the extra information.
I have had a look at the second project export you have provided, and this does seem to have a working editable table structure. (I obviously can+?+?+?t actually test it properly as I don+?+?+?t have the required database.)
Was this export the one you created manually, or the one created by merging the database onto the editable table repeat?
Are you finding that both creation methods now include the correct editabletable.js script file and <table_init> custom field?
As you are only getting the Out of Memory error for the one specific project it is worth investigating this some more. Using the merge approach shouldn+?+?+?t create anything different to when you set it up manually. It is just trying to speed up the set up process.
How many records are you retrieving from the database? Is it likely to be a large data set? Is it definitely retrieving the same set of records in both projects?
Can you try setting the platform log level to +?+?++debug+?+?+? for the project that is giving you the out of memory errors, and then send through the log file you get when the error occurs?
Hopefully this will provide some indication as to what is causing it.
Regards,
Gerard