Error Importing MetaData in ProfileStage.
Posted: Wed Jul 12, 2006 11:23 pm
Hi,
I have installed Profilestage on windows box and installed messageswitch and Analysis server on same server. The oracle DB used as the PSDB is also on the same server.
I have set up both System DSNs for Oracle connectivity and Southbreeze (Text driver) on server.
ON the Profilestage client in my PC, I tried importing SouthBreeze Source Metadata into Oracle instance PSDB, but I get the following error.
**************
7/13 10:51:55: NTBOMSAP05\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: NTBOMSAP05. Process ID: 3196. Program ID: 34.
7/13 10:51:55: NTBOMSAP05\GenOdbc2Mxf: 5130 0 Unable to connect to database using DSN/service 'PSDB'. Review connection information and correct if needed. Connection error: AccessType: 'ODBC' DSN: 'PSDB' DataManager: 'Oracle' Database: '' LoginUser: 'PSDBADMIN' Server: ''
7/13 10:51:56: NTBOMSAP05\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
7/13 10:51:56: Meta Data Loader Done.
Process halted due to problem(s).
*************
I tried importing metadata directly on the ProfileStage Server and I am getting errors. Log entries are as follows
******************
main::Init: Unable to create Hash2Sql object for table 'SystemConfig':
Hash2Sql: Failure on &ExecSQLColumns for table 'SystemConfig':
CoreOdbc::_ExecCatalogFetchAll: Problem encountered during FETCH:
*****************
Please help me resolve this issue.
Santhosh S
I have installed Profilestage on windows box and installed messageswitch and Analysis server on same server. The oracle DB used as the PSDB is also on the same server.
I have set up both System DSNs for Oracle connectivity and Southbreeze (Text driver) on server.
ON the Profilestage client in my PC, I tried importing SouthBreeze Source Metadata into Oracle instance PSDB, but I get the following error.
**************
7/13 10:51:55: NTBOMSAP05\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: NTBOMSAP05. Process ID: 3196. Program ID: 34.
7/13 10:51:55: NTBOMSAP05\GenOdbc2Mxf: 5130 0 Unable to connect to database using DSN/service 'PSDB'. Review connection information and correct if needed. Connection error: AccessType: 'ODBC' DSN: 'PSDB' DataManager: 'Oracle' Database: '' LoginUser: 'PSDBADMIN' Server: ''
7/13 10:51:56: NTBOMSAP05\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
7/13 10:51:56: Meta Data Loader Done.
Process halted due to problem(s).
*************
I tried importing metadata directly on the ProfileStage Server and I am getting errors. Log entries are as follows
******************
main::Init: Unable to create Hash2Sql object for table 'SystemConfig':
Hash2Sql: Failure on &ExecSQLColumns for table 'SystemConfig':
CoreOdbc::_ExecCatalogFetchAll: Problem encountered during FETCH:
*****************
Please help me resolve this issue.
Santhosh S