Skip to content
Validation messages

Validation messages

Validate in XrmToolBox, replisteer validate, and every run check the project. Errors prevent a run; warnings are reported but do not stop it. Each message names the area: Source, Target ’name’, Step ’name’, Variable ’name’ or Steps.

Connections

MessageSeverityWhat to do
The project has no sourceErrorConfigure the Source tab.
The connection has no nameErrorGive the source or target a name.
Connection names must be uniqueErrorRename one of the connections with the same name.
The connection is not configuredErrorChoose (Dataverse) or configure (SQL Server) the connection.
No CSV file is selectedErrorSelect the file in the CSV dialog.
The source query is emptyErrorEnter the FetchXML or SQL query.
Target ids must be unique positive numbersErrorOnly happens with hand-edited project files: fix the id of the targets.
Target ‘…’ has no table / file configuredErrorChoose the table, procedure, workflow or file the target writes to.
Not linked to an open XrmToolBox connection; choose an environmentErrorXrmToolBox only: choose the Dataverse connection with Choose….

Steps

MessageSeverityWhat to do
The project has no stepsErrorAdd a step.
No step is marked as the starting stepErrorSelect a step and click Set as first.
Only one step can be the starting stepErrorHand-edited files only: keep one isStartingStep.
Step ids must be unique positive numbersErrorHand-edited files only.
A step cannot continue with itselfErrorChoose another Then / If it fails step.
The next step … does not existErrorChoose an existing step.
A step cannot continue with the starting stepErrorRows always start with the first step; link to another step.
The step has no target connectionErrorChoose the step’s target.
Map at least one target columnErrorInsert, update, upsert and execute need at least one mapping.
A field mapping has no target columnErrorFill in or remove the empty mapping row.
Column ‘…’ is mapped more than onceErrorRemove the duplicate row (it is marked with a red icon).
… needs at least one match criterion, otherwise it would affect every recordErrorAdd a match criterion to the update, upsert or delete step.
A match criterion has no target columnErrorFill in or remove the empty criterion.
CSV files can only be written with Insert (rows are appended)ErrorUse Insert for CSV targets.
Execute needs a target configured as a stored procedure or an on-demand workflowErrorChange the target’s Writes to, or the operation.
… needs a target table; target ‘…’ is configured for ExecuteErrorChange the target’s Writes to to a table, or use Execute.
Column ‘…’ does not exist in …WarningThe column is not in the loaded target columns: check the spelling, or Load columns again. A run fails the rows with an unknown column.
Required column ‘…’ is not mappedWarningMap it, unless the target fills it itself (for example a default value or a plug-in).
The step is never executed; link it from another stepWarningLink it with Then or If it fails of another step, or remove it.

Formulas and variables

MessageSeverityWhat to do
… has no formulaErrorEnter a formula (for a value that should be empty, write NULL).
… : syntax error (at position n)ErrorFix the formula; the formula editor shows the error while typing.
… uses ‘…’, which is not a source field or variable (it will be empty)WarningCheck the spelling, load the source fields, or use brackets for names with spaces: [First Name].
Variable names must start with a letter or ‘’ and contain only letters, digits and ‘’ErrorRename the variable.
The variable name is used more than onceErrorRename one of them.
A source field has the same name; formulas will see the variableWarningRename the variable if you need the source field.

Command line only

The runner checks the command line and the connection strings before anything else; see Connection strings. These messages end with Nothing was run. and exit code 3.

MessageWhat to do
–project is requiredGive the project file.
The project file does not exist: …Check the path (relative paths are relative to the current folder).
The project could not be read: …The file is not a Replisteer project, or it is damaged.
Unknown command / option ‘…’See replisteer help.
–rows must be a whole number greater than 0Fix the value.
Unexpected argument ‘…’. Values with spaces or ‘;’ must be in double quotesQuote the value.
–target: no target named ‘…’Use a name or id from the list in the message.
–target: say which target the connection string is forWith several targets, write --target "<name>=<connection string>".
… needs a connection string: …Give it with --source / --target, the connections file, or an environment variable.
–connections: no connection named ‘…’ in the projectFix the key in the connections file.
Last updated on