JAS Generation:

Hello, List!
I install new JAS on our customer site:
Windows 2000 server, Websphere 4.0.7 (7 fixpack), JAS_SP22_K1

I try generate objects and recieve errors:
1. In DOS screen window:
Error Message: <Errors on JAS: >, Error list: :
szError: SVPX03
subText:
alphaDescriptionTemplate: Unknow Exception: class java.lang.reflect.InvocationTargetException->null
glossaryTextTemplate:
errorLevel: 1
idItem: -1

2. In jas.log on JAS server:
trying jmiMethod.getMethod().invoke (e instanceof InvocationTargetException) >*log*> com.jdedwards.jas.sql.JASSQLException: getIndexInfo errors:ORA-01031:insufficient privileges

What should I do in with two problems?

Looks like your Oracle permissions are missing / too tight on some tables...

Hello, but how to find out on wich tables these permissions is too tight? Thank you beforehand.

Hello,

Start with the F989998 and F989999 tables as these are the tables used by the eGeneration process.

To fix, just generate the tables via OMW. JDE's default permissions for tables is set to allow PUBLIC all access to the table. If this still does not work, you will need to get your DBAs involved to see if they have a process in place to revoke PUBLIC from the tables.

That will eliminate the issue if it is table specific.

It sounds more like the backend system user that you use to connect to JDE may not have enough priviledges. In which case, your DBAs will need to grant your system user more access to the Oracle DB.

Good luck!