User Tools
normal_processing_steps
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
normal_processing_steps [2021/02/02 20:38] dlm [Troubleshooting] |
normal_processing_steps [2021/02/09 15:37] (current) dlm |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== | + | [[main_page|NovoMotion Outbound |
| + | |||
| + | |||
| + | ====== | ||
| \\ | \\ | ||
| - | ====Here is a recommendation of steps to follow when a file is to be added to the NovoMotion Outbound process: | + | ====Recommended |
| - Create a new schema using either [[novo_motion_novo_gen.schema|NovoMotion NOVO.GEN.SCHEMA ]] or [[novo_motion_schema_editor|NovoMotion Schema Editor]]. | - Create a new schema using either [[novo_motion_novo_gen.schema|NovoMotion NOVO.GEN.SCHEMA ]] or [[novo_motion_schema_editor|NovoMotion Schema Editor]]. | ||
| Line 20: | Line 23: | ||
| | Connection does not exist | Verify the correct login and password are entered in the SQL Options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]]. If they are, verify the datasource is set up. If it is, verify the login has permission to the database on the SQL server. | | | Connection does not exist | Verify the correct login and password are entered in the SQL Options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]]. If they are, verify the datasource is set up. If it is, verify the login has permission to the database on the SQL server. | | ||
| | Invalid Object Name error | Verify the database name on the SQL options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]] is fully qualified i.e dbo.filename | | | Invalid Object Name error | Verify the database name on the SQL options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]] is fully qualified i.e dbo.filename | | ||
| + | |||
| + | |||
| + | ====Suggested Ways to Add a Column to a Schema That Already Exists==== | ||
| + | |||
| + | * In SQL, execute a new query against the main database: | ||
| + | < | ||
| + | ADD New_field varchar(20) </ | ||
| + | This step can also be done by right-clicking on the SQL table and using Design. | ||
| + | |||
| + | * In the [[novo_motion_schema_editor|NovoMotion Schema Editor]], add the new column with the exact same name – (New_field in previous step). | ||
| + | * Save the schema and generate the code, Uncheck ‘Generate Primary Table’. | ||
| + | * On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], | ||
| + | * On Windows click the " | ||
| + | *Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps. | ||
| + | *[[load_bci.action|LOAD.BCI.ACTION]] for any records that need the new column. | ||
| + | |||
| + | \\ | ||
| + | [[main_page|NovoMotion Outbound | ||
| + | |||
normal_processing_steps.1612298282.txt.gz · Last modified: 2021/02/02 20:38 by dlm
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
