Uploading a Microsoft Access Database to start a new application. - Forum - Rollbase - Progress Community

Uploading a Microsoft Access Database to start a new application.

 Forum

Uploading a Microsoft Access Database to start a new application.

  • I am getting a huge error message from trying to upload a Microsoft Access Database Using the option Create from external data under New Rollbase Web App under Create a New Application. Any Ideas would be helpful. Here is the error message am getting "[StelsMDB JDBC driver] Can't load the file 'COLONY FACTORY GROUPS' to H2 database. Error was: Syntax error in SQL statement "CREATE TABLE ""COLONY FACTORY GROUPS""(COLONY INTEGER, GROUPStar# INTEGER CHECK GROUP# >= 0 AND GROUP# = 0 AND FACTORYTL = 0 AND ITMTL = 0 AND ""1TL"" = 0 AND ""2TL"" = 0 AND ""3TL"" = 0 AND ""4TL"" = 0 AND GROUP# = 0 AND FACTORYTL = 0 AND ITMTL = 0 AND "1TL" = 0 AND "2TL" = 0 AND "3TL" = 0 AND "4TL"
  • The library we use to read MS Access files (STelsMDB) uses an internal H2 database. It looks like it is unable to import MS Access Table COLONY FACTORY GROUPS into the H2 database. Can you share a copy of MS access file (Please remove data from tables for security reasons ) for us to reproduce the issue ?

  • I tried to attach the file yor email rejected it.
     
     
    Vern Holford
    818-539-5943
  • Zip the file and try to attach

  • Message

     
     
    Vern Holford
    818-539-5943
  • I was able to reproduce the error. I will log a defect for this.

  • Hi Anoop,

    Does the defect has been filed already? Can we have the defect number on this for tracking?

    Thank you.

    Regards,

    Orchid

  • Defect PSC00333711 has been created for this.

    Regards,

    Ranjana Sinha

  • Thank you Ranjana.

    Regards,

    Orchid

  • Hi ,

    Development is currently investigating the issue and found some constraint violation error for the record in the 11th row of the table Colony factory Groups.

    Can you verify if there are duplication of data etc.

    Thank you.

    Regards,

    Orchid