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
OdbcOutput errors management
-
pandinus
- Posts: 78
- Joined: Tue Mar 18, 2014 8:02 am
- OLAP Product: TM1, Cognos Express
- Version: 10.2.2
- Excel Version: 2013
Re: OdbcOutput errors management
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.
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.