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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PBCS Following Text Values failed to import

1299734Jul 18 2017 — edited Jul 18 2017

Hi,

I am trying to clone my Production instance to Testing instance, but when I try to import the snapshot file from Production in Testing I got the following error:

[CODE]

/Relational Data/Text Values :- Following Text Values failed to import. Total - 2552, Failed - 228 error details - Id [543 with value Open Po] is in use with another Text Value [desc 2]. Id [544 with value Hyperion Phase 1] is in use with another Text Value [desc 3]. Id [545 with value free text] is in use with another Text Value [desc 4]. Id [546 with value Hyperion Phase 2] is in use with another Text Value [F&B1]. Id [582 with value Courier of Guest items] is in use with another Text Value [sad]. Id [600 with value White Paper Bag] is in use with another Text Value [Ppppppp]. Id [601 with value coffee stirir] is in use with another Text Value [esting]. Id [602 with ..

[/CODE]

Should I ignore this? Based on searching regarding this error, my understanding is that the Free-text data type stored using ID in Essbase and the string itself is stored in RDBMS.

Some article suggests going to the relational database and sync it manually, but in PBCS I don't know how to do that.

Could you help to guide me on what I need to do? My goal is to copy from PRD to Testing.

Thanks

This post has been answered by JohnGoodwin on Jul 18 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2017
Added on Jul 18 2017
4 comments
402 views