After upgrading from 4.08 to 1.0, Im getting the message "Unknown column 'DB_NAME' in 'field list'" when trying to login. Any idea? I have executed the SQL statements...
Hello Bakar,
I've referred this issue to my fellow colleagues as well as the product management team. I will make sure that this thread is reviewed, please be sure to reply with any developments on your end. We'd appreciate it!
Thanks,
Corey Prak
Hi Corey,
Thanks for the update. I have done a rollback to version 4.08. I will test it again and keep you updated.
Hello Bakar,
I've received a response from one of our Software Engineers. Directly quoting,
"...
Following lines from upgrade_1_0_0_0.sql should have done the job of changing the previous DB_NAME field to DATABASE_NAME.
DROP INDEX RB_CUST_DATA_I2 ON RB_CUST_DATA;
ALTER TABLE RB_CUST_DATA CHANGE DB_NAME DATABASE_NAME VARCHAR(20);
CREATE INDEX RB_CUST_DATA_I2 ON RB_CUST_DATA(DATABASE_NAME);
UPDATE RB_FIELD_DEF SET COLUMN_NAME='DATABASE_NAME' WHERE CUST_ID=1 AND OBJ_DEF_ID=2 AND FIELD_NAME='dbName';
..."
To continue from here, could you please provide more detailed steps that were performed in upgrading? I will forward them, and we will be able to get closer to finding a more accurate solution.
Thanks,
Corey Prak
Hi Corey,
I have downloaded the newest binaries from the site (in stead of using the oldest 1.0 files). I have succesfully upgraded my development environment without any login problems...
Bakar,
thank you for the update, I'm very glad that it was successful! Please feel free to reply or create a new topic with any other questions/concerns that you may have. Enjoy Progress Rollbase 1.0!
Thanks,
Corey Prak