I am getting following error when i tired to view the data thru Oracle stage, any ideas? it looks like permissions but i am not able to find which permissions and which file?
Look in the lib directory under PXEngine. You will probably find a couple of orchoracle libraries there, one for 9i and one for 10g. Check that you have permissions on those and on the symbolic links that point to them.
SQLConnect error: Status = -1 SQLState = IM003 Natcode = 0
[ODBC] [DataDirect][ODBC lib] Specified driver could not be loaded
Invalid parameter(s) found in configuration file
Is it related to the above one also...could be ...
why it is saying invalid parameters found in configuration file.... i checked configurations directory for *.apt files all looks good to me.
Am i missing anything....
FYI... we just installed DS 7.5.2 on Unix AIX box and we are having these issues.
Hi,
Your first problem, "orchoracle" permission denied, has something to with your login ID, assuming you are using the "dsadm", that is not in the Oracle DBA group.
Second problem, [ODBC lib] Specified driver couldn't be found....., has nothing to do with your default.apt file in the Configurations directory. Check your .odbc.ini file instead.
Yes, DBA did not give the correct permissions on all the needed files for dsadm id, he gave necessary permission and all permissions and ODBC issues resolved.
basically i was having issues with Oracle stage - with permissions but meanwhile i wanted to run the same job with using ODBC stage, there also i got the issues. I raised a ticket to DBA to look into this and he gave 775 on all the Oracle files - so the issues got resolved for Oracle and ODBC stages.
I still need to find out what file were causing the issues ... i will try to post the reply one i get back from DBA.
basically i was having issues with Oracle stage - with permissions but meanwhile i wanted to run the same job with using ODBC stage, there also i got the issues. I raised a ticket to DBA to look into this and he gave 775 on all the Oracle files - so the issues got resolved for Oracle and ODBC stages.
I still need to find out what file were causing the issues ... i will try to post the reply one i get back from DBA.
Thanks,
T
Hi Titto,
Could you please help me regarding what permissions and on which files I need to set. I am getting the same error that you faced in oracle stage as well as in ODBC stage.