May I ask what issue you are facing because of the column name change, in any of the expected functionality/system behaviour? Depending on the version, there will be additional tables/columns also created. These shouldn't ideally create any issue during upgrade, but may be in scripts.
Below is what we get when we installed the 12.1.
Error: Platform error: FAP Error code=904 ODBC Error S0022 904 [Oracle][ODBC][Ora]ORA-00904: "A"."MODE": invalid identifier".
I see our MRL when I view the navigation bar but I don't see anything when viewing the workspace tree.
I'm not sure that the column names were changed between versions. However there have been times when the default column names conflict with a keyword with the underlying database system. In those cases, you can rename the column in the table and then use the INI file to tell Documaker about the change. In your case, you may need the following settings.
< ODBC_FieldConvert >
MODE = MODES
RESOURCE = RESOURCES
DATE = DATES
If you have installed 12.1 in parallel and did not import your existing setup, look in your old INI files and see if you had similar settings there.
Our old ini files did not have these settings. It seems like the new column names are in LBYI and LBYLOG tables. Instead of MODE it is "MODES" (with the quotations) etc. We were a bit skeptical of just changing the underlying column names our selves not knowing what other changes we might be missing. Not sure if this will be supported or not if we just go ahead and update the column names our selves.
I have to tell you that I have not seen that. I just recently did an install of 12.2 and created a new workspace with tables. I'm using and Oracle DB behind the ODBC. I'll go check and see what actual column names were generated.
Yeah, it appears that the column names for the Library log (LBYI) are the same as before. I'm not sure why you are seeing what you do. (Assuming this pastes correctly, below is what I see.) Did you allow DMStudio to create the tables? Or did you generate DDLs and then have a DBA create them based upon those files? It would be interesting to know where the disconnect has occurred.
We did not allow 12.1 to create the tables and nor did we generate DDLs. We did not do anything with the back end. We installed 12.1 in a different directory and pointed it to the existing database we have for 11.3.
Are you saying that you are just trying to run a Gendata step on your existing MRL without changes? If so, that should just work. However, if you are trying to do something in DMStudio, then you would need to create a workspace.I guess I don't understand exactly where you are in the process when this message occurs.