3 Replies Latest reply on Jul 22, 2013 9:24 AM by User236522

    Database Application Tables Connector problem

    user10233157
      Hi All,

      I am trying to reconcile data from a database using the Database Application Tables Connector version 9.1.0.5.0 on OIM 11.1.1.5.2. I am experiencing a problem due to the name of the schema of the database that I am trying to connect to - it contains a forward slash. The name of the schema is Acme/CAS. The error that I am getting is as follows:

      [2012-08-06T14:38:42.121+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize entered.
      [2012-08-06T14:38:42.122+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: driver - Value: org.postgresql.Driver
      [2012-08-06T14:38:42.123+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: url - Value: jdbc:postgresql://10.16.28.58:5432/wf5
      [2012-08-06T14:38:42.123+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: username - Value: postgresql
      [2012-08-06T14:38:42.123+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: password - Value: *******
      [2012-08-06T14:38:42.124+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: customizedQueries - Value: aperson_out.adname = 'wilymaan'
      [2012-08-06T14:38:42.124+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: useNativeQuery - Value: false
      [2012-08-06T14:38:42.124+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: parentContainerName - Value: Acme/CAS.aperson_out
      [2012-08-06T14:38:42.125+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/convertCSVToArraylist entered.
      [2012-08-06T14:38:42.125+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/convertCSVToArraylist: providerParams:
      [2012-08-06T14:38:42.125+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/convertCSVToArraylist left.
      [2012-08-06T14:38:42.126+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: childContainerTableNames - Value: []
      [2012-08-06T14:38:42.126+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: parentContainerUniqueKey - Value: id
      [2012-08-06T14:38:42.126+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: incrementalReconAttribute - Value:
      [2012-08-06T14:38:42.174+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: dbDateFormat - Value: yyyy/MM/dd HH:mm:ss z
      [2012-08-06T14:38:42.175+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize left.
      [2012-08-06T14:38:42.176+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getConnectionProp entered.
      [2012-08-06T14:38:42.176+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/setUpSSLPropertiesForDB2 entered.
      [2012-08-06T14:38:42.176+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] ExitingMethodDebug
      [2012-08-06T14:38:42.184+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T14:38:42.189+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingSchemaName - Data: found matching schema - Value: Acme/CAS
      [2012-08-06T14:38:42.190+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching schema:- - Value: Acme/CAS
      [2012-08-06T14:38:42.198+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found matching tables - Value: aperson_out
      [2012-08-06T14:38:42.199+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching table:- - Value: aperson_out
      [2012-08-06T14:38:42.203+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T14:38:42.206+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingSchemaName - Data: found matching schema - Value: Acme/CAS
      [2012-08-06T14:38:42.206+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching schema:- - Value: Acme/CAS
      [2012-08-06T14:38:42.212+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found matching tables - Value: aperson_out
      [2012-08-06T14:38:42.212+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching table:- - Value: aperson_out
      [2012-08-06T14:38:42.226+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T14:38:42.226+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T14:38:42.229+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingSchemaName - Data: found matching schema - Value: Acme/CAS
      [2012-08-06T14:38:42.229+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching schema:- - Value: Acme/CAS
      [2012-08-06T14:38:42.234+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found matching tables - Value: aperson_out
      [2012-08-06T14:38:42.235+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching table:- - Value: aperson_out
      [2012-08-06T14:38:42.241+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getPrimaryKeys - Data: Primary Keys - Value: [itemid]
      [2012-08-06T14:38:42.245+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Column Name: - Value: id
      [2012-08-06T14:38:42.245+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Column Dataype integer value: - Value: 4
      [2012-08-06T14:38:42.246+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Column Size: - Value: 10
      [2012-08-06T14:38:42.246+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Table Name: - Value: aperson_out
      ...
      [2012-08-06T14:38:42.328+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Column Name: - Value: sync_error
      [2012-08-06T14:38:42.328+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Column Dataype integer value: - Value: 12
      [2012-08-06T14:38:42.328+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Column Size: - Value: 2147483647
      [2012-08-06T14:38:42.329+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Table Name: - Value: aperson_out
      [2012-08-06T14:38:42.329+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getClumns - Data: Column Datatype Name: - Value: text
      [2012-08-06T14:38:42.329+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getColumns - Data: Database Type Name: - Value: PostgreSQL
      [2012-08-06T14:38:42.330+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getClumns - Data: Columns: - Value: [com.thortech.xl.gc.impl.common.Column@1867ff8, com.thortech.xl.gc.impl.common.Column@253b7390, com.thortech.xl.gc.impl.common.Column@62200608, com.thortech.xl.gc.impl.common.Column@246c298c, com.thortech.xl.gc.impl.common.Column@391bb902, com.thortech.xl.gc.impl.common.Column@4b0f4f98, com.thortech.xl.gc.impl.common.Column@5a32aaa7, com.thortech.xl.gc.impl.common.Column@3461e834, com.thortech.xl.gc.impl.common.Column@7d3c8ca, com.thortech.xl.gc.impl.common.Column@612349c9, com.thortech.xl.gc.impl.common.Column@53c15cf1, com.thortech.xl.gc.impl.common.Column@3bbcfd2c, com.thortech.xl.gc.impl.common.Column@74917257, com.thortech.xl.gc.impl.common.Column@78e9e98a, com.thortech.xl.gc.impl.common.Column@44e3a10a, com.thortech.xl.gc.impl.common.Column@3c61badb, com.thortech.xl.gc.impl.common.Column@34329ed5, com.thortech.xl.gc.impl.common.Column@6759ccb8, com.thortech.xl.gc.impl.common.Column@388f790a, com.thortech.xl.gc.impl.common.Column@53539c88, com.thortech.xl.gc.impl.common.Column@1649cf75, com.thortech.xl.gc.impl.common.Column@47d315c1, com.thortech.xl.gc.impl.common.Column@733956bd, com.thortech.xl.gc.impl.common.Column@396dcd64, com.thortech.xl.gc.impl.common.Column@57c77db0, com.thortech.xl.gc.impl.common.Column@6a0cdad5, com.thortech.xl.gc.impl.common.Column@71f30c57, com.thortech.xl.gc.impl.common.Column@baf5e33, com.thortech.xl.gc.impl.common.Column@26516c43, com.thortech.xl.gc.impl.common.Column@2b9ab65c, com.thortech.xl.gc.impl.common.Column@3a3a6861, com.thortech.xl.gc.impl.common.Column@509ad624, com.thortech.xl.gc.impl.common.Column@6560fed3, com.thortech.xl.gc.impl.common.Column@42fa02a4, com.thortech.xl.gc.impl.common.Column@2bc37f56, com.thortech.xl.gc.impl.common.Column@2fdcfd8c, com.thortech.xl.gc.impl.common.Column@558a0ae0, com.thortech.xl.gc.impl.common.Column@59d023ff, com.thortech.xl.gc.impl.common.Column@6feb6869, com.thortech.xl.gc.impl.common.Column@4813fee6, com.thortech.xl.gc.impl.common.Column@18c3d302, com.thortech.xl.gc.impl.common.Column@60523501, com.thortech.xl.gc.impl.common.Column@3516060e]
      [2012-08-06T14:38:42.330+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T14:38:42.330+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T14:38:42.333+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingSchemaName - Data: found matching schema - Value: Acme/CAS
      [2012-08-06T14:38:42.334+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching schema:- - Value: Acme/CAS
      [2012-08-06T14:38:42.339+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found matching tables - Value: aperson_out
      [2012-08-06T14:38:42.339+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getMatchingTableName - Data: found exact matching table:- - Value: aperson_out
      [2012-08-06T14:38:42.346+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getPrimaryKeys - Data: Primary Keys - Value: [itemid]
      [2012-08-06T14:38:42.346+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/getFirstPage - Data: Filter Query - Value: (aperson_out.adname = 'wilymaan')
      [2012-08-06T14:38:42.357+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getRecord - Data: SQL - Value: select * from Acme/CAS.aperson_out where (aperson_out.adname = 'wilymaan')
      [2012-08-06T14:38:42.371+02:00] [oim_server1] [ERROR] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] Class/Method: DBFacade/getRecord encounter some problems: ERROR: syntax error at or near "/"[[
      Position: 22 org.postgresql.util.PSQLException: ERROR: syntax error at or near "/"
      Position: 22
           at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
           at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
           at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
           at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
           at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
           at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
           at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
           at com.thortech.xl.gc.impl.common.DBFacade.getRecord(Unknown Source)
           at com.thortech.xl.gc.impl.common.DBFacade.getTargetRecord(Unknown Source)
           at com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getFirstPage(Unknown Source)
           at com.thortech.xl.gc.runtime.GCScheduleTask.execute(GCScheduleTask.java:103)
           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
           at postgresql.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
           at sun.reflect.GeneratedMethodAccessor1014.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at postgresql.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

      ]]
      [2012-08-06T14:38:42.373+02:00] [oim_server1] [ERROR] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] Class/Method: DBReconTransportProvider/getFirstPage encounter some problems: A database error was encountered when retrieving data from a database. [[
      com.thortech.xl.gc.exception.DBException: A database error was encountered when retrieving data from a database.
           at com.thortech.xl.gc.impl.common.DBFacade.getRecord(Unknown Source)
           at com.thortech.xl.gc.impl.common.DBFacade.getTargetRecord(Unknown Source)
           at com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getFirstPage(Unknown Source)
           at com.thortech.xl.gc.runtime.GCScheduleTask.execute(GCScheduleTask.java:103)
           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
           at postgresql.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
           at sun.reflect.GeneratedMethodAccessor1014.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at postgresql.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
      Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "/"
      Position: 22
           at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
           at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
           at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
           at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
           at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
           at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
           at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
           ... 12 more


      The configuration of the GTC is as follows:

      Name CRS
      Reconciliation
      Transport Provider Database Application Tables Reconciliation
      Format Provider Database Application Tables Reconciliation
      Trusted Source Reconciliation Yes

      Specify Parameter Values Change
      Database Driver org.postgresql.Driver
      Database URL jdbc:postgresql://10.16.28.58:5432/wf5
      Database User ID postgresql
      Database Password ********
      Customized Query aperson_out.adname = 'wilymaan'
      Use Native Query No
      Connection Properties
      Parent Table/View Name ACME/CAS.aperson_out
      Child Table/View Names
      Unique Attribute id
      Timestamp Attribute
      Database Date format
      Batch Size All
      Stop Reconciliation Threshold None
      Stop Threshold Minimum Records None
      Source Date Format yyyy/MM/dd HH:mm:ss z
      Reconcile Deletion of Multivalued Attribute Data Yes
      Reconciliation Type Full

      If I change the "Parent Table/View Name" to *"ACME/CAS.aperson_out"* (i.e. I add quotes to the schema name) I get the following error:

      [2012-08-06T15:04:24.334+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize entered.
      [2012-08-06T15:04:24.335+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: driver - Value: org.postgresql.Driver
      [2012-08-06T15:04:24.335+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: url - Value: jdbc:postgresql://10.16.28.58:5432/wf5
      [2012-08-06T15:04:24.335+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: username - Value: postgresql
      [2012-08-06T15:04:24.336+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: password - Value: *******
      [2012-08-06T15:04:24.336+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: customizedQueries - Value: aperson_out.adname = 'wilymaan'
      [2012-08-06T15:04:24.336+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: useNativeQuery - Value: false
      [2012-08-06T15:04:24.337+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: parentContainerName - Value: "Acme/CAS".aperson_out
      [2012-08-06T15:04:24.337+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/convertCSVToArraylist entered.
      [2012-08-06T15:04:24.337+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/convertCSVToArraylist: providerParams:
      [2012-08-06T15:04:24.338+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/convertCSVToArraylist left.
      [2012-08-06T15:04:24.338+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: childContainerTableNames - Value: []
      [2012-08-06T15:04:24.338+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: parentContainerUniqueKey - Value: id
      [2012-08-06T15:04:24.339+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: incrementalReconAttribute - Value:
      [2012-08-06T15:04:24.383+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize - Data: dbDateFormat - Value: yyyy/MM/dd HH:mm:ss z
      [2012-08-06T15:04:24.384+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBReconTransportProvider/initialize left.
      [2012-08-06T15:04:24.384+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/getConnectionProp entered.
      [2012-08-06T15:04:24.385+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] Class/Method: DBFacade/setUpSSLPropertiesForDB2 entered.
      [2012-08-06T15:04:24.385+02:00] [oim_server1] [TRACE] [] [OIMCP.DATC] [SRC_METHOD: debug] ExitingMethodDebug
      [2012-08-06T15:04:24.395+02:00] [oim_server1] [NOTIFICATION] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] dbType:::: = PostgreSQL
      [2012-08-06T15:04:24.400+02:00] [oim_server1] [ERROR] [] [OIMCP.DATC] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000JZvrj2eBp20LVyCCyc1G7vNt000002,0] [APP: oim#11.1.1.3.0] Class/Method: DBReconTransportProvider/getFirstPage encounter some problems: The target database schema "Acme/CAS" doesn't exist. Please provide the exact schema name (could be case sensitive).[[
      com.thortech.xl.gc.exception.DBException: The target database schema "Acme/CAS" doesn't exist. Please provide the exact schema name (could be case sensitive).
           at com.thortech.xl.gc.impl.common.DBFacade.getMatchingSchemaName(Unknown Source)
           at com.thortech.xl.gc.impl.common.DBFacade.getType(Unknown Source)
           at com.thortech.xl.gc.impl.common.DBFacade.getSchema(Unknown Source)
           at com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getSchema(Unknown Source)
           at com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getFirstPage(Unknown Source)
           at com.thortech.xl.gc.runtime.GCScheduleTask.execute(GCScheduleTask.java:103)
           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
           at postgresql.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
           at sun.reflect.GeneratedMethodAccessor1014.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at postgresql.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

      ]]

      How can I go about solving this issue? I know that the following SQL query works: select * from "ACME/CAS".aperson_out where (aperson_out.adname = 'wilymaan')