Differences

This shows you the differences between two versions of the page.

--- normal_processing_steps [2021/02/02 15:24] – dlm
+++ normal_processing_steps [2021/02/09 10:37] (current) – dlm
@@ Line 1: / Line 1: @@
-===== 'Normal' Processing Steps =====
+[[main_page|NovoMotion Outbound  Menu]]
-==Here is a recommendation of steps to follow when a file is to be added to the NovoMotion outbound process:==
+====== Suggested Processing Steps ======
+\\
+====Recommended steps to follow when a file is added to the NovoMotion Outbound process:====
   - Create a new schema using either [[novo_motion_novo_gen.schema|NovoMotion NOVO.GEN.SCHEMA ]] or [[novo_motion_schema_editor|NovoMotion Schema Editor]].
@@ Line 12: / Line 15: @@
   - Use the [[load_bci.action|LOAD.BCI.ACTION]] process to load all the records from the U2 environment to the SQL server.
   - Check the SQL server to verify results.
+\\
+====Troubleshooting====
+^ Error Message                    ^ Analysis Steps ^
+| No BCI.ACTION record created 	   | Verify the trigger is on using LIST.TRIGGER. If the trigger exists, try logging off and back on. If the file is the TM, make sure the table number has been added on the NovoMotion Interface Control Trigger Controls tab. |
+| No Schema exists for filename    | Verify the schema is flagged as Active in the [[novo_motion_schema_editor|NovoMotion Schema Editor]]|
+| 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 |
+====Suggested Ways to Add a Column to a Schema That Already Exists====
+  * In SQL, execute a new query against the main database:
+<code>ALTER TABLE dbo.TABLENAME
+ADD New_field varchar(20) </code>
+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], and execute on SQL.
+  * On Windows click the "Execute on SQL Server" button.
+  *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  Menu]]