Hi,
When i created a TestMatch data pool. Is it necessary my target connection should have privileges to create new objects ?
I have a connection profile that has only DML operation on Oracle schema that stores all my Data Mart cubes and Views. but when i have use same profile in configuring test match, I am getting error Unable to create 'FNV_11302_8598'. But i can see this object exists in TDM repository.
Why every execution needs this object creation for Test Match and Report ?
Is there a way i can just perform TestMatch and skip Report generation Part ?
Clear Down: N
Create temporary tables: False
Is working in remote support mode: True
Last query executed was:
CREATE TABLE FNV_11302_8598 (
ORA-01031: insufficient privileges
at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at TestMatch.TestMatchProcessor.CreateTMCTableInDatabase(String newTableName, Database dbToUse, DbConnection openConn, Boolean isRemote)
at TestMatch.Program.Main(String[] args)
Database connection cannot be established