6 Replies Latest reply on Jul 13, 2016 10:15 PM by Evan John

    can't export licensefile  for bbsa

    Evan John

      Hello all,

      I had some errors with exporting licensefile  with bbsa,the operation is in bmc official pdf.When i excuted the command,the error such as :

      I don't know what's wrong,please help me .Thanks very much.

        • 1. Re: can't export licensefile  for bbsa
          Jim Wilson

          What is the character set used for your BSA Database?

           

          SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

          SELECT * FROM NLS_DATABASE_PARAMETERS;

          • 2. Re: can't export licensefile  for bbsa
            Evan John

            Hi JIm,

            Thanks for your attention with my problem.Our bsa version is 8.7.I collected the infomation about our database with your command.  We have two databases for two bbsa app servers.The first database is :

            SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

             

            VALUE$

            --------------------------------------------------------------------------------

            AL32UTF8

             

            SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_LANGUAGE

            AMERICAN

             

            NLS_TERRITORY

            AMERICA

             

            NLS_CURRENCY

            $

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_ISO_CURRENCY

            AMERICA

             

            NLS_NUMERIC_CHARACTERS

            .,

             

            NLS_CHARACTERSET

            AL32UTF8

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_CALENDAR

            GREGORIAN

             

            NLS_DATE_FORMAT

            DD-MON-RR

             

            NLS_DATE_LANGUAGE

            AMERICAN

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_SORT

            BINARY

             

            NLS_TIME_FORMAT

            HH.MI.SSXFF AM

             

            NLS_TIMESTAMP_FORMAT

            DD-MON-RR HH.MI.SSXFF AM

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_TIME_TZ_FORMAT

            HH.MI.SSXFF AM TZR

             

            NLS_TIMESTAMP_TZ_FORMAT

            DD-MON-RR HH.MI.SSXFF AM TZR

             

            NLS_DUAL_CURRENCY

            $

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_COMP

            BINARY

             

            NLS_LENGTH_SEMANTICS

            BYTE

             

            NLS_NCHAR_CONV_EXCP

            FALSE

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_NCHAR_CHARACTERSET

            AL16UTF16

             

            NLS_RDBMS_VERSION

            11.2.0.1.0

             

             

            20 rows selected.

             

            SQL>

            #################################

            #######################################

            #######################################

            ##########################################

            And the second database is:

            SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

             

            VALUE$

            --------------------------------------------------------------------------------

            ZHS16GBK

             

            SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_LANGUAGE

            AMERICAN

             

            NLS_TERRITORY

            AMERICA

             

            NLS_CURRENCY

            $

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_ISO_CURRENCY

            AMERICA

             

            NLS_NUMERIC_CHARACTERS

            .,

             

            NLS_CHARACTERSET

            ZHS16GBK

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_CALENDAR

            GREGORIAN

             

            NLS_DATE_FORMAT

            DD-MON-RR

             

            NLS_DATE_LANGUAGE

            AMERICAN

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_SORT

            BINARY

             

            NLS_TIME_FORMAT

            HH.MI.SSXFF AM

             

            NLS_TIMESTAMP_FORMAT

            DD-MON-RR HH.MI.SSXFF AM

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_TIME_TZ_FORMAT

            HH.MI.SSXFF AM TZR

             

            NLS_TIMESTAMP_TZ_FORMAT

            DD-MON-RR HH.MI.SSXFF AM TZR

             

            NLS_DUAL_CURRENCY

            $

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_COMP

            BINARY

             

            NLS_LENGTH_SEMANTICS

            BYTE

             

            NLS_NCHAR_CONV_EXCP

            FALSE

             

             

            PARAMETER

            ------------------------------

            VALUE

            --------------------------------------------------------------------------------

            NLS_NCHAR_CHARACTERSET

            UTF8

             

            NLS_RDBMS_VERSION

            11.2.0.3.0

             

             

            20 rows selected.

             

            SQL>

            They are diffrent. Thanks again for your help .

            • 3. Re: can't export licensefile  for bbsa
              Jim Wilson

              Does the same exception occur for both implementations?

              • 4. Re: can't export licensefile  for bbsa
                Evan John

                Hi JIm,

                Thanks for your help.Yes they have the same exception.

                • 5. Re: can't export licensefile  for bbsa
                  Jim Wilson

                  The first DB (Character Set AL32UTF8) matched mine and my execution of the command (as you have presented it) works just fine.

                   

                  The other DB (Character Set ZHS16GBK) I am unable to test

                   

                  Do other BLCLI commands work OK?

                   

                  Unless anyone else in the community has anything to offer, my suggestion would be to log a support case

                  • 6. Re: can't export licensefile  for bbsa
                    Evan John

                    Hi Jim,

                    Thanks for your testing with my problem.I'm very grateful.That's strange.I can't excute the command with the first DB.I also used the license tools to do it and it was the same error.The other Blcli commands work well.That's so strange!.Thanks again for your help and have nice day!