copy_to API When Loading Data into PTI Table - Teradata Python Package

When the copy_to API fails with the Database error message “4358 Time Series: TD_TIMECODE| TD_SEQNO out of range for table”, you must check the permitted TD_TIMECODE and TD_SEQNO range using the following:

con = get_connection().connection
cur = con.cursor()
td_cur = cur.execute(“exec DBC.TD_TIMESERIES_RANGE('MyDB.<table_name>')”)
td_cur.fetchall()

Where:

• MyDB is the schema name
• <table_name> is the name of the table to be created

And correct the data or the arguments like "seq.max" to suit the data.