Uploading a Microsoft Access Database to start a new applica

Posted by vholford on 21-May-2015 17:56

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"

All Replies

Posted by Anoop Premachandran on 22-May-2015 07:52

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 ?

Posted by vholford on 22-May-2015 10:49
I tried to attach the file yor email rejected it.
 
 
Vern Holford
818-539-5943
Posted by Anoop Premachandran on 22-May-2015 11:47

Zip the file and try to attach

Posted by vholford on 23-May-2015 10:16

Message

 
[View:~/cfs-file.ashx/__key/communityserver-discussions-components-files/25/CWT2.zip:550:0] 
 
Vern Holford
818-539-5943
Posted by Anoop Premachandran on 25-May-2015 07:23

I was able to reproduce the error. I will log a defect for this.

Posted by Orchid Corpin on 28-May-2015 18:49

Hi Anoop,

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

Thank you.

Regards,

Orchid

Posted by Ranjana sinha on 29-May-2015 00:44

Defect PSC00333711 has been created for this.

Regards,

Ranjana Sinha

Posted by Orchid Corpin on 29-May-2015 11:07

Thank you Ranjana.

Regards,

Orchid

Posted by Orchid Corpin on 05-Jun-2015 10:02

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

This thread is closed