Application cannot find column mapping?
If Arkieva is not fable to map the columns to the table, the table is probably in another schema than the dbo.
Even if you are able to map the column to other tables, if the table is in another schema, the column mapping will not function because the table editor assumes the table is in the default dbo schema.
When column mapping do not use tables outside of the default dbo.shcema.
Related Articles
Column mapping not possible for a specific column?
Steps to try first: Check the Setup Manager and messages window for any errors that may point to the issue. Look through the System Model for a role in the user table (None Found) in SQL run a query to check the columns in the table When the ...
How do I find job duration in minutes?
The below script shows the duration in minutes based on dbo.Log for a given job (replace the parameter below by Job.Name). EXEC PrsDropObject #JobLog SELECT * INTO #JobLog FROM Log WHERE Category = ‘RunJob’ AND Timestamp > DATEADD(month, -6, ...
Application is not binding to a dimension table?
Arkieva first searches for a Dimension table to bind to, and if not possible it will bind to an ATTU (attribute). There are a few possibilities that may explain why its not binding to the dimension table. The dimension and attribute tables are not in ...
I am not able to create Jobs within the application?
Make sure the user has dbo permissions or ddl admin.
"Object reference not set to an instance of an object" error?
This error occurs when the source table does not have CD values for the selected attributes. Column mapping must be done to whichever attributes you want to be able to sort by CD & TX.