AuditStage error: missing QA_MD_COMPLETE table

This forum is in support of all issues about Data Quality regarding DataStage and other strategies.

Moderators: chulett, rschirm

Post Reply
datastage
Participant
Posts: 229
Joined: Wed Oct 23, 2002 10:10 am
Location: Omaha

AuditStage error: missing QA_MD_COMPLETE table

Post by datastage »

I am trying to complete a completeness snapshot. I can correctly output to the screen but not to the database. I get an error for each column and noticed the QA_MD_COMPLETE table doesn't exist in the database.

Anyone seen this? There appears to be only a few tables for AuditStage and their structure is not secret, yet I couldn't find a sql script in the install directory to create these or anything. I have no idea why AS couldn't create it on its own. There doesn't appear to be a place in the GUI for the user to create these table either, correct?

Thanks

environment:
AuditStage 7.0
SQL Server 2000 SP3
Windows 2000 SP3
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.

"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
Post Reply