Issue with Augmented Datasource from the DM Mixin

[Zaccak Solutions]

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

[David McAnuff]

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

0

[David McAnuff]

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

0

[Zaccak Solutions]

<p>Hi David, just wondering if this has been fixed in a newer NexJ version. I’m trying to do similar as above except different use case and having the same issues.. Seems the Augment can’t find the aspect (so I add it in) then it can’t find the PK.. so I remove it and it says its required. Seems like Augments aren’t aware of the DB it’s augmenting at all.</p>

0

• This reply was modified 3 years, 9 months ago by Zaccak Solutions.

[Author]

Posts