Load Database Metadata

Bryceson · Post by **Bryceson** » 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

ray.wurlod · Post by **ray.wurlod** » Mon Mar 12, 2007 6:41 pm

Try making a copy of SouthBreeze and adding primary keys. Then try an import from that.

I would guess that ProfileStage should be able to import table definitions that lack primary keys, though lacking them will severely hinder some of the later analyses, especially table and cross-table analyses, so maybe "they" just decided to forbid them from being imported.

Do you get anything at all into the PSDB? The message indicates that the load was completed, so the interruption may have been during a status update or something else related to control.

Bryceson · Post by **Bryceson** » Mon Mar 12, 2007 8:38 pm

I figured out that I have to create the DNS for PSDB Repository using Ascential Drivers and was able to load database metadata fine. Thanks Ray for your input!!

Bryceson

ray.wurlod · Post by **ray.wurlod** » Tue Mar 13, 2007 6:15 am

It was not always thus. I wonder why they restrict you to those drivers?