Home Forums Data Migration Issue with Augmented Datasource from the DM Mixin

This topic contains 4 replies, has 3 voices, and was last updated by Alice User alice user 4 months, 1 week ago.

  • Author
    Posts
  • #12436
    Henry Zaccak
    Zaccak Solutions
    Participant

    When trying to augment the dm:import: StagingImportDatabase by adding a table for Households I keep getting:

    Description Resource Path Location Type
    Unknown table “DM_DATALOAD” in relational schema “RelationalSchema clarity:StagingImportDatabase” . StagingImportDatabase. datasource /xxx/meta/datasources/xxx dataSource=xxx: StagingImportDatabase, table=Household Metadata Problem

    The DM_DATALOAD aspect is in the StagingImportDatabase datasource and if I do the changes as a customization instead of an augment then I wont get this error (but I run into another issue).

    The source looks like:

    <RelationalDatabaseAugment for=”dm:import: StagingImportDatabase”>
    <Tables>
    <Table aspects=”DM_DATALOAD” name=”Household” primaryKey=”Household.PK”>
    <Columns>

    … (similar to how Company is setup in the StagingImportDatabase)

    I’ve also tried to have the file in the same dm:import: folder but get the same error. I’ve even tried to add the dm:import: before he aspect name and still no luck.

    Any ideas?

    0
  • #12462
    David McAnuff
    David McAnuff
    Participant

    This is being investigated and will have an answer for you shortly.

    0
  • #12586
    David McAnuff
    David McAnuff
    Participant

    I presently do not have a solution, but as a workaround add the fields covered by DM_DATALOAD to the staging tables.

    0
  • #12646
    Alice User
    alice user
    Participant

    attack

    0
  • #12655
    Alice User
    alice user
    Participant

    aaa

    0

You must be logged in to reply to this topic.