Load Database Metadata
Posted: Mon Mar 12, 2007 8:31 am
Hi Folks,
We have installed ProfileStage 7.5.1A and We are fairly new to ProfileStage.
Ascential ProfileStage Client
Ascential ProfileStage Analysis Server
Ascential ProfileStage Database (PSDB) Repository (DB2)
Ascential ProfileStage Message Switch
Data Sources - SouthBreeze
Ascential ODBC Drivers
On our Desktop running Windows 2000 Professional.
And followed the steps on the ProfileStage Tutorial for step 3
-Load Database Metadata
I receive this error and other messages below. Does any one knows what is not doing right?
3/12 8:21:03: New Log - 3/12 8:21:03
3/12 8:21:03: MessageSwitchConnect String:
HostIPAddress =
HostName = ISSUNDBYW83
HostPort = 3070
ApplicationID = 2
HostUserLogin = DBYW83
3/12 8:21:06: Meta Data Loader Done.
Problem number 88: The server program was terminated unexpectedly.
Please call technical support.
3/12 8:22:52:
__Run_Server_Program__
ProgramName: GenOdbc2Mxf
ServerName.: ISSUNDBYW83
IPAddress..: 10.118.100.28
Prog ID....: 10
3/12 8:22:54: ISSUNDBYW83\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: ISSUNDBYW83. Process ID: 2380. Program ID: 10.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 23 0 Program initialization is now complete.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Categories'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Cust_Info'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Division'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Employees'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'EmployeeTerritories'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'OrderDetails'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Orders'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Organization'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Products'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Shippers'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Suppliers'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Territories'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 24 0 Source database meta data extracted. Starting PSDB load.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
3/12 8:22:57: Meta Data Loader Done.
-I understand SouthBreeze Data does not have primary key, so the warning is expected. But it does not to continue to load the tables into the PSDB Repository.
Thanks . . . Bryceson
We have installed ProfileStage 7.5.1A and We are fairly new to ProfileStage.
Ascential ProfileStage Client
Ascential ProfileStage Analysis Server
Ascential ProfileStage Database (PSDB) Repository (DB2)
Ascential ProfileStage Message Switch
Data Sources - SouthBreeze
Ascential ODBC Drivers
On our Desktop running Windows 2000 Professional.
And followed the steps on the ProfileStage Tutorial for step 3
-Load Database Metadata
I receive this error and other messages below. Does any one knows what is not doing right?
3/12 8:21:03: New Log - 3/12 8:21:03
3/12 8:21:03: MessageSwitchConnect String:
HostIPAddress =
HostName = ISSUNDBYW83
HostPort = 3070
ApplicationID = 2
HostUserLogin = DBYW83
3/12 8:21:06: Meta Data Loader Done.
Problem number 88: The server program was terminated unexpectedly.
Please call technical support.
3/12 8:22:52:
__Run_Server_Program__
ProgramName: GenOdbc2Mxf
ServerName.: ISSUNDBYW83
IPAddress..: 10.118.100.28
Prog ID....: 10
3/12 8:22:54: ISSUNDBYW83\GenOdbc2Mxf: 5039 0 Program GenOdbc2Mxf running. Computer: ISSUNDBYW83. Process ID: 2380. Program ID: 10.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 23 0 Program initialization is now complete.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Categories'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Cust_Info'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Division'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Employees'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'EmployeeTerritories'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'OrderDetails'.
3/12 8:22:56: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Orders'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Organization'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Products'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Shippers'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Suppliers'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 5076 0 Primary key definition is not available for table 'Territories'.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 24 0 Source database meta data extracted. Starting PSDB load.
3/12 8:22:57: ISSUNDBYW83\GenOdbc2Mxf: 7 0 Unable to continue. Contact technical support.
3/12 8:22:57: Meta Data Loader Done.
-I understand SouthBreeze Data does not have primary key, so the warning is expected. But it does not to continue to load the tables into the PSDB Repository.
Thanks . . . Bryceson