copy_to API When Loading Data into PTI Table | Teradata R Package - copy_to API When Loading Data into PTI Table - Teradata Package for R

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 ranges based on the other arguments of copy_to() using the following:

DBI::dbGetQuery(con, “exec DBC.TD_TIMESERIES_RANGE('TDAPUSERDB.<table_name>')”)

Where:

• con is the connection object;
• TDAPUSERDB is the database 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.