TM1 Forum

Hi All.

Is there any possibility to manage errors done by an OdbcOutput command in TI process?
My need is to continue to process all the data (even if I'm have an error, as an ex., in an insert for duplicate key) and don't stop immediately the process.

Thx in advance
Ottavio

The key solution is to not use the TI command ODBCOUPUT, but write the output to a csv file instead using ASCIIOUTPUT. This way you ensure that all data is being exported from TM1.
Now read the generated csv file to the database and keep track of any errors on the DB-side.

In addition, this will give you a massive improvement in performance when you are exporting more than (say) 10 items.