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, GROUP# 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 ?
Zip the file and try to attach
Message
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 [mention:78ff9874fc914b759e633c5af5c30d89:e9ed411860ed4f2ba0265705b8793d05],
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