This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
normal_processing_steps [2021/02/02 20:11] dlm created |
normal_processing_steps [2021/02/02 20:38] dlm [Troubleshooting] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | === ' | + | ====== ' |
+ | \\ | ||
+ | ====Here is a recommendation of steps to follow when a file is to be added to the NovoMotion Outbound process:==== | ||
- | Here is a recommendation of steps to follow when a file is to be added to the NovoMotion | + | - Create |
+ | - In the [[novo_motion_schema_editor|NovoMotion Schema Editor]], establish the connection information on the SQL Options tab and activate the schema. | ||
+ | - In the [[novo_motion_schema_editor|NovoMotion Schema Editor]], use the SQL script creation ([[Creating a SQL Script]]) process | ||
+ | - If the ODBC datasource | ||
+ | - Use the [[load_bci.action|LOAD.BCI.ACTION]] process | ||
+ | - Correct dictionaries, | ||
+ | - Once there are no identified issues, use NOVO.E.T ([[novo_motion_trigger_generator|NovoMotion | ||
+ | - Use the [[load_bci.action|LOAD.BCI.ACTION]] | ||
+ | - Check the SQL server to verify results. | ||
+ | \\ | ||
+ | ====Troubleshooting==== | ||
- | - Create a new schema | + | ^ Error Message |
- | #In the [[NovoMotion Schema Editor]], establish | + | | 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. | |
- | #In the [[NovoMotion Schema Editor]], use the SQL script creation ([[Creating a SQL Script]]) process to generate a SQL script to copy and execute in the SQL database. <br /><br /> | + | | No Schema exists for filename |
- | #If the ODBC datasource is new, create | + | | Connection does not exist | Verify |
- | #Use the [[LOAD.BCI.ACTION]] process to test a load from the U2 server to 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 | |
- | #Correct dictionaries, | + | |
- | #Once there are no identified issues, use NOVO.E.T ([[NovoMotion Trigger Generator]]) to enable an UPDATE (and usually a DELETE) trigger | + | |
- | #Use the [[LOAD.BCI.ACTION]] process to load all the records from the U2 environment to the SQL server. <br /><br /> | + | |
- | #Check the SQL server to verify results.<br /><br /> | + |