Initial load from Oracle database fails

[Former Member]

Hello,

I have a small oracle DB, where external users are stored. So I want to configure an initial load job, which reads the users from the oracle DB (the identity center db is a MS SQL DB).

So I configured a Job "To identity store" with following parameters:

Database: jdbc:oracle:thin:oracleadmin/myPassword@localhost:1521:xe

SQL Statement: SELECT * FROM external_user

But this configuration didn't work...

Maybe you have any help for me.

[Former Member]

Hi Peter,

I would try using a From Database pass first and then write everything into the identity store using a To Identity Store pass.

Best regards

Holger

[Former Member]

Hi Holger,

thank you for your answer.

But theres no difference for the connection oracle-string. So I got the same error: I can not connect to the oracle DB

[Former Member]

Hi Peter,

are there any additional information or error messages available?

Best regards

Holger

[Former Member]

After I configured the source-Tab, I change to the destination-tab and choose "Insert template" - "Data source template".

But the fields from the oracle DB aren't loaded, rather I get a pop up where I can modify the connection string and the SQL syntax

Error message is: Fetching the data source template failed.

[former_member2987]

Hello Peter,

Have you made sure that you have the correct database drivers installed? Make sure you are using 32 Bit drivers, even if it's a 64 bit system.

Matt

[Former Member]

I am not sure with the database drivers...?! Have I add the Oracle DB as an ODBC datasource? Maybe you can explain, which driver I need exactly? I have no experience with oracle databases..

OS is MS Windows Server 2008 x64

Oracle DB is 10g Express edition

Thanks in advance

EDIT:

I have found a logfile:

23.09.2010 10:07:41 :X:Loaded JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver Version: 1.1

23.09.2010 10:07:41 :X:Loaded JDBC Driver class: oracle.jdbc.driver.OracleDriver Version: 10.2

23.09.2010 10:07:41 :X:Loading Internal JDBC Driver class com.sap.idm.ic.XML.XMLDriver

23.09.2010 10:07:41 :D:Opening connection to database.

23.09.2010 10:07:41 :D:Max table name length is: 30

23.09.2010 10:07:42 :X:Opened connection to database jdbc:oracle:thin:oracleadmin/********@localhost:1521:xe

23.09.2010 10:07:42 :X:Enabling ORACLE extensions.

23.09.2010 10:07:42 :X:JDBC driver: Oracle JDBC driver Version 10.2.0.1.0XE

23.09.2010 10:07:42 :X:Database server: Oracle Version Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

23.09.2010 10:07:42 :T:Calling getTableMetaDataBySQL using SELECT * FROM external_user

23.09.2010 10:07:42 :T:Executing: "SELECT * FROM external_user" to get meta data

23.09.2010 10:07:42 :D:executeQuery:SELECT * FROM external_user - got exception: Error code 942 SQL state:42000(!) - java.sql.SQLException: ORA-00942: Tabelle oder View nicht vorhanden

23.09.2010 10:07:42 :D:executeQuery:SELECT * FROM external_user - time used: 18 ms

23.09.2010 10:07:42 :E:Exception getting meta data from jdbc:oracle:thin:oracleadmin/********@localhost:1521:xe SQL:SELECT * FROM external_user Error code 942 SQL state:42000(!) - java.sql.SQLException: ORA-00942: Tabelle oder View nicht vorhanden

23.09.2010 10:07:42 :X:Execution completed in 0.669 seconds.

23.09.2010 10:07:42 :T:Time used loading main class: 0.134 seconds.

But I don't understand... The table external_user exists

Edited by: Peter Dornheim on Sep 23, 2010 10:10 AM

[Former Member]

OK, I have no idea why, but oracle lost my configured database.... I add a new one and it works.

Regards

Peter

[former_member2987]

I think you might want to check the PAM. I do not believe that Oracle Express is supported.

If you need to, I believe you can download a full copy of Oracle DB from their Web site.

In my experience MS SQL has always been an easier install and configuration. I'd use that if at all possible.

Matt