Access via Synonyms - DatabaseMetaData.getColumns returns no columns.Catalog=null Schema=XXXXXX_CATA

[NewBie]

HI Experts,

We are trying to see whether we can connect ATG Schema (CATA/CATB and Core).

But this is schema does not hold any of the below tables, it has access thru the public synonym.

Tested the connection via SQLDeveloper and is able to connect.

But connecting having the below entry in Store.xml, i tried to bounce the instance, I am getting the below exception in ths Jboss startup.

Any thoughts on this issue ?


13:54:25,844 ERROR [nucleusNamespace.atg.commerce.pricing.priceLists.PriceLists] (pool-7-thread-1) Table 'DCS_PLFOL_CHLD' in item-descriptor: 'priceListFolder' does not exist in a table space accessible by the data source.  DatabaseMetaData.getColumns returns no columns.  Catalog=null Schema=XXXXXX_CATA
13:54:26,298 ERROR [nucleusNamespace.atg.repository.dynamic.DynamicMetadataRepository] (pool-7-thread-1) Table 'DAS_GSA_DYN_TYPE' in item-descriptor: 'das_gsa_dynamic_type' does not exist in a table space accessible by the data source.  DatabaseMetaData.getColumns returns no columns.  Catalog=null Schema=XXXXXX_CATA
13:54:26,549 ERROR [nucleusNamespace.atg.repository.dynamic.DynamicMetadataRepository] (pool-7-thread-1) Table 'DAS_GSA_DYN_TYPE_ATTR' in item-descriptor: 'das_gsa_dynamic_type' does not exist in a table space accessible by the data source.  DatabaseMetaData.getColumns returns no columns.  Catalog=null Schema=XXXXXX_CATA
13:54:26,726 ERROR [nucleusNamespace.atg.repository.dynamic.DynamicMetadataRepository] (pool-7-thread-1) Table 'DAS_GSA_DYN_PROP' in item-descriptor: 'das_gsa_dynamic_prop' does not exist in a table space accessible by the data source.  DatabaseMetaData.getColumns returns no columns.  Catalog=null Schema=XXXXXX_CATA




<xa-datasource jndi-name="java:/ATGSwitchingDS_A" pool-name="ATGSwitchingDS_A" enabled="true" use-java-context="true">
                    <xa-datasource-property name="URL">
            jdbc:oracle:thin:@da-xxxx-db:15x1:xxxxdevdb
                    </xa-datasource-property>
                    <xa-datasource-property name="User">
                        xxxxxx_cata
                    </xa-datasource-property>
                    <xa-datasource-property name="Password">
                        jonhatfield
                    </xa-datasource-property>
                    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                    <driver>ojdbcxxxx.jar</driver>
                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <xa-pool>
                        <min-pool-size>5</min-pool-size>
                        <max-pool-size>100</max-pool-size>
                        <is-same-rm-override>false</is-same-rm-override>
                        <no-tx-separate-pools>true</no-tx-separate-pools>
                    </xa-pool>
                    <security>
                        <user-name>prvt_synonym_cata</user-name> <!-- this is hte new schema user -->
                        <password>xxxxxxx</password>
                    </security>
                    <validation>
                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
                    </validation>
                    <timeout>
                        <blocking-timeout-millis>5000</blocking-timeout-millis>
                        <idle-timeout-minutes>15</idle-timeout-minutes>
                    </timeout>
</xa-datasource>


Hope to hear from you ,
KdM

[Naga]

Did you read this - https://docs.oracle.com/cd/E41069_01/Platform.11-0/ATGRepositoryGuide/html/s0810tableownershipissues01.html ??

--
--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en
---
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To unsubscribe from this group and stop receiving emails from it, send an email to atg_tech+u...@googlegroups.com.
To post to this group, send email to atg_...@googlegroups.com.
Visit this group at https://groups.google.com/group/atg_tech.
To view this discussion on the web visit https://groups.google.com/d/msgid/atg_tech/d2ad1475-37c2-44e9-ba16-7c5e39f581e9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.