Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CDF's used not running. ODBC error

3336830May 16 2017 — edited May 29 2017

Hi All,

We are in middle of migrating Hyperion from 11.1.2.1 to 11.1.2.4 and we have few CDF's to be migrated.

We performed following steps to migrate the existing CDF's

1. Copied the jar and rdb.properties (changed the pointings to new env) files to new location.

2. Copied the CDF's from existing env to new env through EAS.

3. Registered the CDF's from maxl and we could see them getting registered successfully through EAS.

4. We also ran odbc.sh file at below location successfully:

pastedImage_1.png

5. We made the additions to .bash_profile as well.

6. Earlier Businessrules /calc scripts were not getting validated but now they are validating but giving us the below error for executing calc scripts and BR's respectively.

Calc script error:

[Mon May 15 16:39:49 2017]Local/BSP/BSP/essadmin-bsp@Native Directory/139730486740736/Info(1021041) Connection String is [DSN=BSPDB;UID=...;PWD=...;]

[Mon May 15 16:39:502017]Local/BSP/BSP/essadmin-bsp@Native Directory/139730486740736/Info(1021013)ODBC Layer Error: [28000] ==>[[DataDirect][ODBC Oracle Wire Protocol driver]Oracle]ORA-01017: invalid
username/password; logon denied]

[Mon May 15 16:39:50
2017]Local/BSP/BSP/essadmin-bsp@Native Directory/139730486740736/Info(1021014)ODBC Layer Error: Native Errorcode [1017]

BR Error:

pastedImage_0.png

Has anyone of you faced any similar issue?

Regards,

VS

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2017
Added on May 16 2017
9 comments
660 views