Error while loading data into Oracle table

s21564 — Tue, 13 Feb 2018 18:30:38 GMT

Hi,

I have facing data loading related issue at the time of data loading into oracle table, following errors has occurred for all tables of my oracle library this is “XYZ”.

1: ERROR:WRITE ACCESS TO MEMBER XYZ.TRANS_DIM.DATA IS DENIED.

2: ERROR: ORACLE EXECUTE ERROR: ORA-00942 TABLE OR VIEW DOES NOT EXIST.

This all happens In SAS Data Integration studio. while data loading into dimensions table.

my source table is sas table and target table is oracle table in between i have used SCD type 2 transformation for loading data that time this error has occurred. i have tried so many time but my issue not resolve please give me right direction.

I have work on same issue from last 6 days, For that i have applied different techniques to solve it

Like:

1> I have check all permission of DATABASE And Application level Permissions.

2> i have create new job using all the oracle table to data processing.

3> Restarting object spawner in unix.

4> To implement all possible properties in the scd type 2

but still this issue comes in.

Please help me to solve it.

Re: Error while loading data into Oracle table

kiranv_ — Tue, 13 Feb 2018 19:19:03 GMT

some of this below links tell you why this might happen

http://support.sas.com/kb/16/843.html

http://support.sas.com/kb/16/504.html

topic Re: Error while loading data into Oracle table in SAS Studio

Error while loading data into Oracle table

Re: Error while loading data into Oracle table