[FMWGEN][SQLSERVER JDBC Driver] [SQL SERVER] Invalid column name 'attr 15'

SreenuR

Hello Experts,

We have upgraded from 11.1.2.4 to 11.2.5 using SQL Server 2012 DB Export and Imported into 11.2.5 FDMEE DB.

After copying the root folder we can see all the components as we see 11.1.2.4

But while Importing using a source file we are facing the below error

[FMWGEN][SQLSERVER JDBC Driver] [SQL SERVER] Invalid column name 'attr 15'

Please suggest your inputs to fix this issue

Krishna Chukkaluru

Just adding the same information updated in duplicate thread. You can close one of them

I hope you followed the instructions listed in below Oracle document in regards to FDMEE database/schema export/import as part of upgrade steps.

Installation and Configuration Guide

https://docs.oracle.com/en/applications/enterprise-performance-management/11.2/hitis/upgrading_importing_fdmee_data_106x7cc6b4ba.html

To upgrade Oracle Hyperion Financial Data Quality Management, Enterprise Edition, import the schema and artifacts from Release 11.1.2.4.xxx to Release 11.2.

One more important thing to note is, you can upgrade only from Release 11.1.2.4.220 ( PSU .220 is included in Release 11.1.2.4.700 and Release 11.1.2.4.900). Could you confirm your FDMEE 11.1.2.4 patch set?

Regards,

Krishna

SreenuR

Hi Krishna,

It seems we upgraded from 11.1.2.4 only,What is the alternative now if we would like to aviod this issue?

Should we upgrade FDMEE 11.1.2.4 to 11.1.2.4.220 and do the FDMEE Database Export and Import into FDMEE 11.2.5?

Krishna Chukkaluru

Yes you have to apply FDMEE 11.1.2.4.220 patch set in your source environment and proceed with the exports.

Below is the supported paths to release 11.2. I guess the issue you mentioned could be possible that you are missing the changes supposed to be applied to FDMEE database tables by .220 patch set.