Shy report!!

[Chapulin]

Hi! I'am having a terrible and misterious problem with a custom Report in OneWorld. When I run a version i created locally, the "UBE window" opens in the task bar (like if the report started running) but one second after that it closes completely!! no PDF is generated! no error appears! it just closes!!
I debugged it with a break in the first line of the "Report header section" and it never stops there!! so no event rule is executed!!
any ideas?? i'm really scared cause the report it's really big and has a lot of sections...
any help is appreciated!!
thanks a lot!!

 

[eydeak]

Did you check the jde.log for errors? Also try turning debug logging on and
then check the jdedebug.log.



Ellen Deak

Senior Analyst/Programmer

Cooper Standard Automotive

OneWorld Xe Update 7 SP22_T, AS400 DB2 V5R2M0



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of Chapulin
Sent: Thursday, February 10, 2005 7:58 AM
To: [email protected]
Subject: Shy report!!



Hi! I'am having a terrible and misterious problem with a custom Report in
OneWorld. When I run a version i created locally, the "UBE window" opens in
the task bar (like if the report started running) but one second after that
it closes completely!! no PDF is generated! no error appears! it just
closes!!
I debugged it with a break in the first line of the "Report header section"
and it never stops there!! so no event rule is executed!!
any ideas?? i'm really scared cause the report it's really big and has a lot
of sections...
any help is appreciated!!
thanks a lot!!

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=3D&Board=3D> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job
Opportunites
forum


This is the JDELIST EnterpriseOne Developers Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards=AE.

 

[sviardot]

What do you have in jde.log ?

a solution to have more information go on debug. Go into JDE.ini and find the [UBE] section. You will find
UBEDebugLevel=0
UBESaveLogFile=0
set debug level to 6 and Log file to 1.
Don't forget to set output to file in debug section.
Please send the result.

 

[Chapulin]

Hi! here's the jde.log file. I hope it's not too big!
the UBE is R55RS14. The version I'm running is PRUEBA3.
I don't know how to attach a file so I copied the text.
-------------------------------------------------------

228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1081
The registry entries for jdeSplash.dll were removed successfully.

5228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1019
The registry entries for jdeSplash.dll were created successfully.

5228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1081
The registry entries for dataitem.ocx were removed successfully.

5228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1019
The registry entries for dataitem.ocx were created successfully.

5228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1081
The registry entries for design.ocx were removed successfully.

5228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1019
The registry entries for design.ocx were created successfully.

5228/5840 Thu Feb 10 09:13:30 2005 newmda.cpp1081
The registry entries for jdectocx.ocx were removed successfully.

5228/5840 Thu Feb 10 09:13:31 2005 newmda.cpp1019
The registry entries for jdectocx.ocx were created successfully.

5228/5840 Thu Feb 10 09:13:31 2005 newmda.cpp1081
The registry entries for jdeocx.ocx were removed successfully.

5228/5840 Thu Feb 10 09:13:31 2005 newmda.cpp1019
The registry entries for jdeocx.ocx were created successfully.

5228/5840 Thu Feb 10 09:13:31 2005 newmda.cpp1081
The registry entries for envcombobox.ocx were removed successfully.

5228/5840 Thu Feb 10 09:13:31 2005 newmda.cpp1019
The registry entries for envcombobox.ocx were created successfully.

5228/5840 Thu Feb 10 09:13:31 2005 jdb_ctl.c2763
Starting OneWorld

5228/7412 Thu Feb 10 09:14:28 2005 jdb_rq1.c456
JDB9900918 - Failed to find all requested columns in table

5228/7412 Thu Feb 10 09:14:28 2005 jdb_rq1.c3359
JDB3100029 - Failed to load table information

5228/8552 Thu Feb 10 09:14:30 2005 jdb_exef.c584
JDB9900899 - Inclusive Row Level Security Violation: JURODRIG attempted an INSERT on column PUOMWUR in table F98221

5228/8552 Thu Feb 10 09:14:37 2005 jdb_ctl.c4692
JDB4200003 - OPEN TABLE NOT CLOSED = F98230
-------------------------------------------------------

 

[sviardot]

Nothing to do with UBE It seems than you have not the rigth to include something in a projet (F98221). The column PUOMWUR is user role. I presume than JDE want to set the version in your default project.
Check than use a profile with a other status role or another profile with the same role. The first should be work, the second'll failed.
If it doesn't work look for security on your profile or role.

 

[Chapulin]

Thanks a lot.. I'll try those things you say.
I just copied the Ube to another one with a different name but it was no good at all. It's the same.

Anyway I run again the report setting "output=none" in the Debug section of jde.ini and the new jde.log has the following lines.. what about them??
perhaps there are another problem.. or part of the same..

---------------------
7880/7144 Thu Feb 10 10:09:34 2005 jdb_rq1.c449
JDB9900918 - Failed to find all requested columns in table

7880/7144 Thu Feb 10 10:09:34 2005 jdb_rq1.c3355
JDB3100029 - Failed to load table information
------------------
thanks a lot!!

 

[BBritain]

Chapulin,

Find out what business views are used in the report. I would guess that when you go into design on one of the business views that you will get an error where it found a column that is not in the table (the column was removed after bsvw was created). Save the fixed bsvw and then try the report (you may need to exit OW to clear the old bsvw out of memory).

Ben again,

 

[Chapulin]

Ben!! that was exactly what was happening. thanks a lot!!
A section was using a view that referenced a field of a table that didn't exist.
During design no message or alarm appears (an Event Rules validate ok) unless you edit that section in particular, that's why I never noticed the problem until running the UBE.
thanks again!! i'm really happy!