Kbase P158669: Error 234 and 196 loading data into Oracle using Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/01/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 234 and 196 loading data into Oracle using Oracle DataServer
** Insufficient access privilege for table <table>. (234)
** <program> Could not understand line <number>. (196)
<table_name>will not be loaded due to insufficient privileges.
FACT(s) (Environment):
Original Progress database has security set up in _user table
Table definitions load into Oracle without issues
Schema holder Progress database does not have user.d loaded
The Progress user logged in to load data does not have "can write" privilege defined for the table
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
When users are defined in _user table and tables have rights assigned to them, dictionary .r code would check Progress _user table security first to determine table access rights, since the user connected to load .d does not have "can write" permission, user is presented with error 234 and 196
FIX:
If you have progress database security enabled, you will need to dump user.d from progress database, and load into schema holder progress database (under admin->load table contents->user table), once user table is loaded, you will need to disconnect schema holder, sign in to schema holder database as the user that has "can write" permission, then load data.