This discussion is archived
3 Replies Latest reply: Nov 6, 2013 6:27 AM by Alvaro Soares RSS

Error while confoguring BI APPS

Fesenko_Roman Newbie
Currently Being Moderated

Hello everybody!

I have made a post in ODI sections of this forum ealier.

Configuring ODI for BI APPS

 

I have installed last JDK version on AIX 6.1. also I have changed /etc/hosts and added

172.16.17.30 LocalODIMachine

string.

After that I decided to make f new installation of Oracle BI Applications 11.1.1.7.1

 

Now I have this error while configuring BI APPS:

 

http://fes.org.ua/img/bi_apps_config_error.png

 

and here is a last part of the log file:

http://fes.org.ua/img/err_log.txt

 

 

I want to ask is there anybody how already have had and resolved this issue?

And there is another question: is there anyway to DEconfigure BI APPS and to make it possible to run configuration again, after some workarounds?

It is ake too much time to deinstall all of the components and to install them once again and again.

Or maby there is any way to run the last steps of configuration manually?

Thank a lot for any information!

  • 1. Re: Error while confoguring BI APPS
    Fesenko_Roman Newbie
    Currently Being Moderated

    Hello!

    I have solved this problem in this way: I manually (startManagedWeblogic) started Oracle Data Integrator Server odi_server1 and installation go further and finished successfully.

    Now, when I am try to set up configuration project in "Manage Implementation Projects" section in functional setup, I get en error:

    Error:  An application error occurred. See the incident log for more information.

    This error  appears  when I try to Open newly created  " Implementation Projects".

     

    When I trying to change some parameters, I have an error in log-file:

     

    1. java.sql.SQLException: invalid name pattern: NEWBI_BIACOMP.FND_TABLE_OF_VARCHAR2_255

    at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:599)

    at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:506)

     

     

    NEWBI_BIACOMP - is the BIACOMP schema name. I can not see this Tbale or view in database. There is only this object in schema (see list below).

    So my question is how to make BI APPS working and what to do with the  FND_TABLE_OF_VARCHAR2_255 missing object?

     

    Thanks.

     

    FND_APPLICATION

    FND_APPLICATION_VL

    FND_APPL_TAXONOMY

    FND_APPL_TAXONOMY_ENT_APP_MAP

    FND_APPL_TAXONOMY_HIERARCHY

    FND_APPL_TAXONOMY_HIERARCHY_U1

    FND_APPL_TAXONOMY_N1

    FND_APPL_TAXONOMY_N2

    FND_APPL_TAXONOMY_N3

    FND_APPL_TAXONOMY_N4

    FND_APPL_TAXONOMY_N5

    FND_APPL_TAXONOMY_RF

    FND_APPL_TAXONOMY_RF_U1

    FND_APPL_TAXONOMY_TL

    FND_APPL_TAXONOMY_TL_U1

    FND_APPL_TAXONOMY_U1

    FND_APPL_TAXONOMY_U2

    FND_APPL_TAXONOMY_U3

    FND_APPL_TAXONOMY_U4

    FND_APPL_TAXONOMY_U5

    FND_APPL_TAXONOMY_U6

    FND_APPL_TAXONOMY_U7

    FND_APPL_TAXONOMY_U8

    FND_APPL_TAXONOMY_VL

    FND_CLIENT_LANGUAGE_VL

    FND_CURRENCIES_B

    FND_CURRENCIES_N1

    FND_CURRENCIES_TL

    FND_CURRENCIES_TL_U1

    FND_CURRENCIES_TL_U2

    FND_CURRENCIES_U1

    FND_CURRENCIES_VL

    FND_DUAL

    FND_FAVORITE_ITEMS

    FND_FAVORITE_ITEMS_N1

    FND_FAVORITE_ITEMS_N3

    FND_FAVORITE_ITEMS_U1

    FND_INDUSTRIES_B

    FND_INDUSTRIES_B_U1

    FND_INDUSTRIES_TL

    FND_INDUSTRIES_TL_U1

    FND_INDUSTRIES_TL_U2

    FND_INDUSTRIES_VL

    FND_INDUSTRY_IN_TERRITORY

    FND_INDUSTRY_IN_TERRITORY_U1

    FND_ISO_LANGUAGES_B

    FND_ISO_LANGUAGES_TL

    FND_ISO_LANGUAGES_TL_U1

    FND_ISO_LANGUAGES_TL_U2

    FND_ISO_LANGUAGES_U1

    FND_ISO_LANGUAGES_VL

    FND_LANGUAGES

    FND_LANGUAGES_B

    FND_LANGUAGES_N1

    FND_LANGUAGES_TL

    FND_LANGUAGES_TL_U1

    FND_LANGUAGES_TL_U2

    FND_LANGUAGES_U1

    FND_LANGUAGES_U2

    FND_LANGUAGES_U3

    FND_LANGUAGES_U4

    FND_LANGUAGES_VL

    FND_LOOKUPS

    FND_LOOKUP_TYPES

    FND_LOOKUP_TYPES_TL

    FND_LOOKUP_TYPES_TL_U1

    FND_LOOKUP_TYPES_TL_U2

    FND_LOOKUP_TYPES_U1

    FND_LOOKUP_TYPES_VL

    FND_LOOKUP_VALUES

    FND_LOOKUP_VALUES_B

    FND_LOOKUP_VALUES_B_U1

    FND_LOOKUP_VALUES_TL

    FND_LOOKUP_VALUES_TL_U1

    FND_LOOKUP_VALUES_TL_U2

    FND_LOOKUP_VALUES_VL

    FND_LOOKUP_VIEWS

    FND_LOOKUP_VIEWS_U1

    FND_MESSAGES

    FND_MESSAGES_B

    FND_MESSAGES_B_U1

    FND_MESSAGES_TL

    FND_MESSAGES_TL_U1

    FND_MESSAGES_VL

    FND_MESSAGE_TOKENS

    FND_MESSAGE_TOKENS_U1

    FND_NATURAL_LANGUAGES_B

    FND_NATURAL_LANGUAGES_TL

    FND_NATURAL_LANGUAGES_TL_U1

    FND_NATURAL_LANGUAGES_TL_U2

    FND_NATURAL_LANGUAGES_U1

    FND_NATURAL_LANGUAGES_VL

    FND_PRODUCT_FAMILY_DOMAIN_MAP

    FND_PROFILE_CATS_B

    FND_PROFILE_CATS_B_U1

    FND_PROFILE_CATS_TL

    FND_PROFILE_CATS_TL_U1

    FND_PROFILE_CATS_VL

    FND_PROFILE_CAT_OPTIONS_B

    FND_PROFILE_CAT_OPTIONS_B_U1

    FND_PROFILE_CAT_OPTIONS_B_U2

    FND_PROFILE_CAT_OPTIONS_TL

    FND_PROFILE_CAT_OPTIONS_TL_N2

    FND_PROFILE_CAT_OPTIONS_U1

    FND_PROFILE_CAT_OPTIONS_U2

    FND_PROFILE_CAT_OPTIONS_VL

    FND_PROFILE_HIERARCHIES

    FND_PROFILE_HIERARCHIES_U1

    FND_PROFILE_HIERARCHY_LEVELS

    FND_PROFILE_HIERARCHY_LEV_U1

    FND_PROFILE_LEVELS

    FND_PROFILE_LEVELS_U3

    FND_PROFILE_OPTIONS

    FND_PROFILE_OPTIONS_B

    FND_PROFILE_OPTIONS_TL

    FND_PROFILE_OPTIONS_TL_U1

    FND_PROFILE_OPTIONS_TL_U2

    FND_PROFILE_OPTIONS_U1

    FND_PROFILE_OPTIONS_U2

    FND_PROFILE_OPTIONS_VL

    FND_PROFILE_OPTION_LEVELS

    FND_PROFILE_OPTION_LEVELS_U1

    FND_PROFILE_OPTION_VALUES

    FND_PROFILE_OPTION_VALUES_U1

    FND_RAND_S

    FND_RECENT_ITEMS_LIST

    FND_RECENT_ITEMS_LIST_N1

    FND_RECENT_ITEMS_LIST_U1

    FND_SESSIONS

    FND_SESSIONS_U1

    FND_SESSIONS_U2

    FND_SESSION_ATTRIBUTES

    FND_SESSION_ATTRIBUTES_U1

    FND_SESSION_NAMESPACES

    FND_SESSION_NAMESPACES_U1

    FND_SESSION_ROLES

    FND_SESSION_ROLE_SETS

    FND_SESSION_ROLE_SETS_U1

    FND_SESSION_USERS

    FND_SESSION_USERS_U1

    FND_SESSION_USERS_U2

    FND_SETID_REFERENCE_GROUPS_B

    FND_SETID_REFERENCE_GROUPS_TL

    FND_SETID_REFERENCE_GROUPS_VL

    FND_SETID_REF_GROUPS_B_U1

    FND_SETID_REF_GROUPS_TL_U1

    FND_SETID_REF_GROUPS_TL_U2

    FND_SETID_SETS

    FND_SETID_SETS_S

    FND_SETID_SETS_U1

    FND_SETID_SETS_U2

    FND_SETID_SETS_U3

    FND_SETID_SETS_U4

    FND_SETID_SETS_U5

    FND_SETID_SETS_VL

    FND_SET_CLIENT_LANG

    FND_TERRITORIES_B

    FND_TERRITORIES_N1

    FND_TERRITORIES_TL

    FND_TERRITORIES_TL_U1

    FND_TERRITORIES_TL_U2

    FND_TERRITORIES_U1

    FND_TERRITORIES_VL

    FND_TIMEZONES_B

    FND_TIMEZONES_B_U1

    FND_TIMEZONES_B_U2

    FND_TIMEZONES_TL

    FND_TIMEZONES_TL_U1

    FND_TIMEZONES_TL_U2

    FND_TIMEZONES_VL

  • 2. Re: Error while confoguring BI APPS
    Fesenko_Roman Newbie
    Currently Being Moderated

    I have install BI APPS On other (Linux) system, have installed latest OBI EE Bundle patch

    17530796-Oracle Business Intelligence Enterprise Edition Suite Bundle Patch 11.1.1.7.131017

    Also I have updated weblogic to the latest 10.3.6.0.6 version (p13529623_1036_Generic.zip)

    And I am still having this error!:

    1. java.sql.SQLException: invalid name pattern: CENTOS_BIACOMP.FND_TABLE_OF_VARCHAR2_255

     

    Can anybody tell me what am I doing wrong?

    Thank you very much.

     

     


  • 3. Re: Error while confoguring BI APPS
    Alvaro Soares Explorer
    Currently Being Moderated

    Hi,

       I've got the same issue as you (ODI server step) on Linux server. I suggest you follow the instructions at this document (page 19) :

     

    Installing Oracle BI Applications 11.1.1.7.1 – Troubleshooting and Frequently Asked Questions (Doc ID 1589540.1)

     

     

      I hope it helps you.

     

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points