3 Replies Latest reply: Nov 6, 2013 8:27 AM by Alvaro Soares RSS

    Error while confoguring BI APPS

    Fesenko_Roman

      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

          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

            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

              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