cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Re : Database error - invalid name pattern

Highlighted
Newbie

Re : Database error - invalid name pattern

maybe the content of the table wtuser (in one of your database schema) does not match with your user accounts in the Ldap (Aphelion)

- Nicolas




----- Message d'origine ----
De : Prathap <->
À : Rajesh Balasundaram <rajesh.balasundaram@corning.com>
Cc : -
Envoyé le : Lundi, 28 Juillet 2008, 19h00mn 14s
Objet : [solutions] - RE: Database error - invalid name pattern


Hi Rajesh,
I am importing an exported 9.0 schema and it will create the necessary tables. I don't have to run the create_ddl_wt.sql and the import fails if I run this script first.

Thanks,
Prathap


1 REPLY 1
Highlighted

Re : Database error - invalid name pattern

Hi Nicolas,
Thanks for the hint. I exported the database and ldap information at
the same time from the source server and they seem to have same user
accounts details in both places.

Thanks,
Prathap

On Mon, Jul 28, 2008 at 4:39 PM, WEYDERT Nicolas
<->wrote:

> maybe the content of the table wtuser (in one of your database schema) does
> not match with your user accounts in the Ldap (Aphelion)
>
> - Nicolas
>
>
> ----- Message d'origine ----
> De : Prathap <->
> À : Rajesh Balasundaram <rajesh.balasundaram@corning.com>
> Cc : -
> Envoyé le : Lundi, 28 Juillet 2008, 19h00mn 14s
> Objet : [solutions] - RE: Database error - invalid name pattern
>
>
> Hi Rajesh,
> I am importing an exported 9.0 schema and it will create the
> necessary tables. I don't have to run the create_ddl_wt.sql and the import
> fails if I run this script first.
>
> Thanks,
> Prathap
>
> On Mon, Jul 28, 2008 at 1:55 PM, Rajesh Balasundaram <
> rajesh.balasundaram@corning.com> wrote:
>
>> did you run the create_ddl_wt.sql after you created the instance.
>>
>>
>>
>> Regards,
>>
>> Rajesh
>>
>> In Reply to:
>>
>> I am getting the following database error whenever I create a second
>> instance in the same Oracle server. It seems to be a configuration issue. I
>> got the same error in three different servers and yet I couldn't figure out
>> the actual problem. Any info would be greatly appreciated.
>>
>> Thanks,
>>
>> Prathap
>>
>>
>> Mon 7/28/08 11:52:05: main: INFO : wt.pom.statementCache -
>> WTConnection(): statementManager=wt.pom.StandardCacheStatementManager
>> Mon 7/28/08 11:52:05: main: INFO : wt.pom.properties - Connection:
>> datastore=Oracle(Oracle Database 10g Release 10.2.0.1.0 - Production)
>> jdbcVersion=10.2 driver=Oracle JDBC driver(10.2.0.3.0) driverVersion=10.2
>> Mon 7/28/08 11:52:06: main: ERROR : wt.pom.jdbc - *** SQLException caught
>> ***
>> Mon 7/28/08 11:52:06: main: WARN : wt.pom.jdbc - SQLState: null
>> Mon 7/28/08 11:52:06: main: WARN : wt.pom.jdbc - *Message: invalid name
>> pattern: WTUSER.FTCELLINFO*
>> Mon 7/28/08 11:52:06: main: WARN : wt.pom.jdbc - *ErrorCode: 17074*
>> Mon 7/28/08 11:52:06: main: WARN : wt.pom.jdbc -
>> Mon 7/28/08 11:52:06: main: Testing for lost connection: errorCode=17074
>> checkCodes=[3114, 12571, 17002, 17410, 17401, 1012, 17008, 3113]
>> Mon 7/28/08 11:52:06: main: wt.ufid.UfidException:
>> wt.pom.DatastoreException: A persistence error occurred. System message
>> follows:
>> Mon 7/28/08 11:52:06: main: wt.pom.ConnectionException: A persistence
>> error occurred. System message follows:
>> Mon 7/28/08 11:52:06: main: (wt.pom.pomResource/0)
>> wt.pom.PersistenceException: A persistence error occurred. System message
>> follows:
>> Mon 7/28/08 11:52:06: main: Nested exception is: java.sql.SQLException:
>> invalid name pattern: WTUSER.FTCELLINFO
>> Mon 7/28/08 11:52:06: main: Nested exception is:
>> wt.pom.DatastoreException: A persistence error occurred. System message
>> follows:
>> Mon 7/28/08 11:52:06: main: Nested exception is:
>> wt.pom.ConnectionException: A persistence error occurred. System message
>> follows:
>> Mon 7/28/08 11:52:06: main: Nested exception is: (wt.pom.pomResource/0)
>> wt.pom.PersistenceException: A persistence error occurred. System message
>> follows:
>> Mon 7/28/08 11:52:06: main: Nested exception is: java.sql.SQLException:
>> invalid name pattern: WTUSER.FTCELLINFO
>> Mon 7/28/08 11:52:06: main: at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:463)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:362)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.sql.StructDescriptor.initPickler(StructDescriptor.java:317)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.sql.StructDescriptor.(StructDescriptor.java:281)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:192)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:161)
>> Mon 7/28/08 11:52:06: main: at
>> oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:130)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pds.oracle81.OracleStatementParameterFactory.getStructType(OracleStatementParameterFactory.java:286)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pds.oracle81.OracleStatementParameterFactory.initializeStruct(OracleStatementParameterFactory.java:191)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pds.StatementParameterFactory.initializeTypes(StatementParameterFactory.java:298)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pds.oracle81.OracleStatementParameterFactory.initializeTypes(OracleStatementParameterFactory.java:96)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pds.SQLDatabasePds.initializeConnection(SQLDatabasePds.java:1513)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pds.OraclePds.initializeConnection(OraclePds.java:483)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.WTConnection.connect(WTConnection.java:141)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.WTConnection.(WTConnection.java:105)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:303)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.POMHandler.getConnection(POMHandler.java:105)
>> Mon 7/28/08 11:52:06: main: at
>> wt.method.MethodContext.getConnection(MethodContext.java:1650)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:336)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1097)
>> Mon 7/28/08 11:52:06: main: at
>> wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1007)
>> Mon 7/28/08 11:52:06: main: at
>> wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:4543)
>> Mon 7/28/08 11:52:06: main: at
>> wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:4598)
>> Mon 7/28/08 11:52:06: main: at
>> wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:1594)
>> Mon 7/28/08 11:52:06: main: at
>> wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:623)
>> Mon 7/28/08 11:52:06: main: at
>> wt.fc.PersistenceManagerFwd.find(PersistenceManagerFwd.java:212)
>> Mon 7/28/08 11:52:06: main: at
>> wt.ufid.FederatableServerHelper.getRepositoryFromDB(FederatableServerHelper.java:1162)
>> Mon 7/28/08 11:52:06: main: at
>> wt.ufid.FederatableServerHelper.getRepository(FederatableServerHelper.java:231)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Regards,
>>
>> Rajesh Balasundaram
>>
>>
>>
>
Announcements