Generate HTML report

[suki]

Hi,

I have installed new version of EA (7.5.847) and now I have a trouble with HTML report generation. We use storage repository on oracle DB.

When I try to start HTML generation it shows the message
"ORA-01795: maximum number of expressions in a list is 1000". After  closing this message generation continue. But the result is not valid. Many objects missing.

On other computer which has older version of EA installed (7.1.834) is not this problem.

Please, exist some solution how to run HTML report with EA 7.5 version?

Thx.

[Geert Bellekens]

I you need a quick workaround you can do a project transfer to a local EAP file and try from there.
There's a good chance this will work as it seems like an Oracle-only error.

Geert

[suki]

I tried to transfer repository from DBMS to EAP (Tools | Data management | Project transfer) but it showed the other error during tranfer. "Transfer error - An error has occured: DAO.Recordset (3022)". Then went the transfer continue.
After finish I started "Generate HTML export" from EAP file repository and it brought the error: "DAO.QueryDef (3219) Invalid operation".

It realy seems some DB error but I don't understand how it arose and how repair it.

[suki]

Hi,

I have installed new version of EA (7.5.847) and now I have a trouble with HTML report generation. We use storage repository on oracle DB.

When I try to start HTML generation it shows the message
"ORA-01795: maximum number of expressions in a list is 1000". After  closing this message generation continue. But the result is not valid. Many objects missing.

On other computer which has older version of EA installed (7.1.834) is not this problem.

Please, exist some solution how to run HTML report with EA 7.5 version?

Thx.

Now, I tried "Generate HTML report" with the most recent version (848) and the error is the same. I'm not ORACLE specialist, but this error should be caused by the reason of  "more than 254 columns or expressions were specified in a list".
Recomended action from ORACLE: Remove some of the expressions from the list.

If I understand well, there were expanded some SELECT's uses the HTML export. I can't solve itself. It seems to be a problem EA.
(older version EA 7.1 has not problem with that)

Our repository is already quite big enough. HTML export takes about 2 hours.

Can anyone comment, please?

[«Midnight»]

This sounds fairly serious. Try checking the database with the Project Integrity Check dialog. Open the project and from the main menu choose Tools | Data Management | Project Integrity Check, Or use the Shift-F9 keyboard shortcut.

If things check out, or if the problem persists, send a bug report to Sparx right away. If at all possible attach a compressed copy of your project so they can see what's happening. [You will have to use the Registered Users version of the bug report to attach a file. If you cannot access that bug report version you should send an email to Sparx Support and attach the file.]

Please let us know what happens either way.

David

[suki]

This sounds fairly serious. Try checking the database with the Project Integrity Check dialog. Open the project and from the main menu choose Tools | Data Management | Project Integrity Check, Or use the Shift-F9 keyboard shortcut.

If things check out, or if the problem persists, send a bug report to Sparx right away. If at all possible attach a compressed copy of your project so they can see what's happening. [You will have to use the Registered Users version of the bug report to attach a file. If you cannot access that bug report version you should send an email to Sparx Support and attach the file.]

Please let us know what happens either way.

David

I tried to check database integrity but unfortunatelly nothing was improved.
I found additionally the LOG file which EA application saved when this error happend.
You can see it on this link.
http://www.photos-from-life.cz/prenos_souboru/DBError.txt
...many items in condition WHERE (more than 3200 !!)

Kamil

[Geert Bellekens]

I think your only option now is Sparx Support.

Geert

[suki]

I think your only option now is Sparx Support.

Geert

I have the same feeling. I sent email to sparx support today. Waiting for answer.

Kamil

[suki]

Hello,
I received answer from Sparx Team by email today.
You can read it bottom.
Bye Kamil


" ... Thanks for pointing this out.  
This problem is peculiar to Oracle and has already been submitted. We do hope to have a correction for it available in build 849 or 850.
In terms of a work-around - I understand the problem does relate to the number of element elements in a package.
I can only recommend you try to modularize these elements to sub packages if possible. ...."