Skip to main content
A
akesana1-Visitor
1-Visitor
July 6, 2017
Question

Problem while inserting records in datat tables after 500 records?

  • July 6, 2017
  • 2 replies
  • 2011 views

Hi,

We have couple of data tables we are trying to insert data in them, we ware able to inset 500 records successfully after that it is not allowing us to insert. Is there any limit for data tables records insert? If we want to increase that limit what would be the procedure.

Please help us we got struck due to this issue.

Thanks,

Anil Kesana

    2 replies

    C
    CarlesColl1-Visitor
    1-Visitor
    July 6, 2017

    Hi Anil,

    I think that you look at it on the wrong side of the equation, you "can't" query more than 500 records if you don't change maxItems to a higher value, as maxItems has a hard coded default of 500 records.

    Best Regards,

      A
      akesana1-VisitorAuthor
      1-Visitor
      July 6, 2017

      Hi Carles,

      We have csv file with 20000 records we are iterating it for inserting of all the records into data table. we are not getting from  data table trying to insert in to data table.

      Thanks,

      Anil Kesana

      C
      CarlesColl1-Visitor
      1-Visitor
      July 6, 2017

      But how do you know that you only inserted 500 rows? querying It, I'm right? here it's the problem.

      D
      dupatel5-Regular Member
      5-Regular Member
      July 6, 2017

      Anil Kesana​:

      Yes,I agree with Carles it would be related to fetching record and it will be good if you can clarify.

      Could you please confirm the Thingworx version and database( H2, PostgreSQL) used in your environment. How many datatable you are having currently.

      Data table storage is limited only by the amount of available disk space that the database has access to so do not have specific limitation on rows.

      -Durgesh

      Terms & ConditionsAccessibility statement