Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
12 replies Latest Post - ‏2012-10-18T13:20:07Z by Sreejith.kanneri
NCDD_Joe_Norton
NCDD_Joe_Norton
8 Posts
ACCEPTED ANSWER

Pinned topic Commerce 7 Instance Creation Error

‏2012-10-08T22:51:34Z |
Hello, I am new to Commerce and trying to create an instance, I have installed DB2 and WAS using a standalone profile, if I try to create it using an existing database I get the following
2012.10.08 15:03:16 CheckInstanceName:

2012.10.08 15:03:16 CheckMerchantKey:

2012.10.08 15:03:16 CheckSitePassword:

2012.10.08 15:03:16 CheckUserPassword:

2012.10.08 15:03:16 CreateInstance:

2012.10.08 15:03:16 CheckInstanceName:

2012.10.08 15:03:16 PrepareDeployment:
2012.10.08 15:03:16 mkdir Created dir: C:\IBM\WebSphere\CommerceServer70\instances\demo4\temp
2012.10.08 15:03:16 copy Warning: Could not find file C:\IBM\WebSphere\CommerceServer70\properties\version\update\backup\NIFHistory.xml to copy.

2012.10.08 15:03:16 PreInstanceCreation:

2012.10.08 15:03:16 ConfigureDatabase:

2012.10.08 15:03:16 CheckInstanceName:

2012.10.08 15:03:16 dbCheck:

2012.10.08 15:03:16 CreateDatabase:

2012.10.08 15:03:16 VariableCheck:

2012.10.08 15:03:16 CheckInstanceName:

2012.10.08 15:03:16 GetJDBCDriverVersion:

2012.10.08 15:03:16 CheckUserPassword:

2012.10.08 15:03:16 CreateSchema:
2012.10.08 15:03:16 EchoNL Creating tables ...

2012.10.08 15:03:16 VariableCheck:

2012.10.08 15:03:16 CheckInstanceName:

2012.10.08 15:03:16 RunSQLFile:
2012.10.08 15:03:17 sql Executing file: C:\IBM\WebSphere\CommerceServer70\schema\db2\wcs.schema.sql
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
0 rows affected
2012.10.08 15:03:18 sql Failed to execute: CREATE TABLE account ( account_id BIGINT NOT NULL, name VARCHAR(200) NOT NULL, member_id BIGINT NOT NULL, store_id INTEGER, state INTEGER NOT NULL DEFAULT 0, currency CHAR(3), defaultcontract INTEGER NOT NULL DEFAULT 0, markfordelete INTEGER NOT NULL DEFAULT 0, comments VARCHAR(4000), timecreated TIMESTAMP, timeupdated TIMESTAMP, timeapproved TIMESTAMP, timeactivated TIMESTAMP, optcounter SMALLINT, prcplcypref VARCHAR(32), useprcplcypref SMALLINT ) IN TAB8K INDEX IN TAB8K

2012.10.08 15:03:18 BUILD FAILED
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\CREATE~2.XML:55: The following error occurred while executing this line:
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\configureDatabase.xml:189: The following error occurred while executing this line:
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\createBaseSchema.xml:61: The following error occurred while executing this line:
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\createBaseSchema.xml:140: com.ibm.db2.jcc.a.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=TAB8K, DRIVER=4.3.111

Total time: 2 seconds

and if it tries to create the database I get this

2012.10.08 17:52:53 CheckInstanceName:

2012.10.08 17:52:53 CheckMerchantKey:

2012.10.08 17:52:53 CheckSitePassword:

2012.10.08 17:52:53 CheckUserPassword:

2012.10.08 17:52:53 CreateInstance:

2012.10.08 17:52:53 CheckInstanceName:

2012.10.08 17:52:53 PrepareDeployment:
2012.10.08 17:52:53 mkdir Created dir: C:\IBM\WebSphere\CommerceServer70\instances\demo8\temp
2012.10.08 17:52:53 copy Warning: Could not find file C:\IBM\WebSphere\CommerceServer70\properties\version\update\backup\NIFHistory.xml to copy.

2012.10.08 17:52:53 PreInstanceCreation:

2012.10.08 17:52:54 ConfigureDatabase:

2012.10.08 17:52:54 CheckInstanceName:

2012.10.08 17:52:54 dbCheck:

2012.10.08 17:52:54 CreateDatabase:

2012.10.08 17:52:54 CheckDbaPassword:

2012.10.08 17:52:54 CheckUserPassword:

2012.10.08 17:52:54 CreateDatabase_db2:
2012.10.08 17:52:54 echo isRemote is false

2012.10.08 17:52:54 dbCheck:

2012.10.08 17:52:54 CreateLocalDB2Database:

2012.10.08 17:52:54 dbCheck:

2012.10.08 17:52:54 CreateRemoteDB2Database:

2012.10.08 17:52:54 dbCheck:

2012.10.08 17:52:54 GrantAccess:

2012.10.08 17:52:54 VariableCheck:

2012.10.08 17:52:54 CheckInstanceName:

2012.10.08 17:52:54 GetJDBCDriverVersion:

2012.10.08 17:52:54 CheckUserPassword:

2012.10.08 17:52:54 CreateSchema:
2012.10.08 17:52:54 EchoNL Creating tables ...

2012.10.08 17:52:54 VariableCheck:

2012.10.08 17:52:54 CheckInstanceName:

2012.10.08 17:52:54 RunSQLFile:

2012.10.08 17:52:54 BUILD FAILED
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\CREATE~2.XML:55: The following error occurred while executing this line:
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\configureDatabase.xml:189: The following error occurred while executing this line:
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\createBaseSchema.xml:61: The following error occurred while executing this line:
C:\IBM\WEBSPH~1\COMMER~1\config\DEPLOY~1\xml\createBaseSchema.xml:140: com.ibm.db2.jcc.a.eo: jcct4205711264http://4.3.111 The application server rejected establishment of the connection.
An attempt was made to access a database, testdb, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004

Total time: 1 second

Thanks,

Joe
Updated on 2012-10-18T13:20:07Z at 2012-10-18T13:20:07Z by Sreejith.kanneri
  • Raj.S
    Raj.S
    519 Posts
    ACCEPTED ANSWER

    Re: Commerce 7 Instance Creation Error

    ‏2012-10-09T06:15:36Z  in response to NCDD_Joe_Norton
    Can you please give the steps you have followed. That would help understand the issue better.

    Regards,
    Rajesh
    • Sreejith.kanneri
      Sreejith.kanneri
      81 Posts
      ACCEPTED ANSWER

      Re: Commerce 7 Instance Creation Error

      ‏2012-10-09T11:40:54Z  in response to Raj.S
      We are trying to do the same and get the exact same error. These are the steps ;

      Installed WAS 7.0.0.0 fix pack 23
      Installed WCS 7.0.0.0 Server.
      Installed DB2 9.5.0.4 - 32 bit.

      All on one node. And then tried to create WCS instance during which we get the error!

      Any help would be appreciated.
      • Raj.S
        Raj.S
        519 Posts
        ACCEPTED ANSWER

        Re: Commerce 7 Instance Creation Error

        ‏2012-10-09T12:09:09Z  in response to Sreejith.kanneri
        Check if the DB2 services are up and try connecting to it. Assuming this as an issue on runtime environment, the below link may help you on this.

        (For Linux)
        http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/index.jsp?topic=%2Fcom.ibm.commerce.install.doc%2Fconcepts%2Fcigdbconsiderations_linux.htm
        Regards,
        Raj
        • NCDD_Joe_Norton
          NCDD_Joe_Norton
          8 Posts
          ACCEPTED ANSWER

          Re: Commerce 7 Instance Creation Error

          ‏2012-10-09T21:39:30Z  in response to Raj.S
          Ok, here are the steps I followed:

          I downloaded the media images that appear on this link http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/index.jsp?topic=%2Fcom.ibm.commerce.install.doc%2Frefs%2Frigbackuppak.htm

          I am on Windows 7 Ultimate 64 bit VMWare

          I first installed CZ7Q1ML IBM WebSphere Commerce V7.0 - DB2 Enterprise Server Edition V9.5 for Windows on 32-bit AMD and Intel systems (x86) Multilingual and created the sample database with no problem (I disabled OS administrative security)

          I then installed CZ7QIML IBM WebSphere Commerce V7.0 - WebSphere Application Server Network Deployment, IHS, WebServer plugin, migration tools V7.0.0.3 (32-bit) Windows Multilingual only WAS and ran the verify tool it was OK.

          Finally I installed CZ6CDML IBM WebSphere Commerce V7.0 - WebSphere Commerce Enterprise V7.0 for Multiplatform Multilingual and installed IHS from here with a custom install and used the OS credentials for the DB config part.

          It was ok apparently no errors, then I tried to create an instance and came up with these errors.
          • NCDD_Joe_Norton
            NCDD_Joe_Norton
            8 Posts
            ACCEPTED ANSWER

            Re: Commerce 7 Instance Creation Error

            ‏2012-10-09T23:22:37Z  in response to NCDD_Joe_Norton
            DB2 is up and WAS is using a standalone server profile.
            • NCDD_Joe_Norton
              NCDD_Joe_Norton
              8 Posts
              ACCEPTED ANSWER

              Re: Commerce 7 Instance Creation Error

              ‏2012-10-11T14:51:20Z  in response to NCDD_Joe_Norton
              I got the answer, don't install on Windows 7, installed on Windows Server 2008 and it worked fine!
              • BKWEB
                BKWEB
                4 Posts
                ACCEPTED ANSWER

                Re: Commerce 7 Instance Creation Error

                ‏2012-10-11T15:15:56Z  in response to NCDD_Joe_Norton
                That's great.
                Did the same set of above steps work on Windows 2008 Server ? Did you have any problem with Installation Manager version during the install ?

                Thanks
                BK
                • NCDD_Joe_Norton
                  NCDD_Joe_Norton
                  8 Posts
                  ACCEPTED ANSWER

                  Re: Commerce 7 Instance Creation Error

                  ‏2012-10-11T18:59:10Z  in response to BKWEB
                  No problem at all, though the steps were slightly different, I installed Websphere Commerce and had it ask for the disks and it created the instance automatically all fine. Now when I installed Websphere Commerce Developer and launched it didn't have any projects loaded, the workspace is empty even though I deployed a Madisons store correctly, how to visualize the projects in the workspace? Is there a guide for that?

                  Thanks.
                  • RamkumarKuppuchamy
                    RamkumarKuppuchamy
                    1 Post
                    ACCEPTED ANSWER

                    Re: Commerce 7 Instance Creation Error

                    ‏2012-10-12T03:13:47Z  in response to NCDD_Joe_Norton
                    Sometimes that happens,

                    Try restarting the Developer(RAD). If not, then
                    just you can add the projects from <WCS_Install_dir>(C:\IBM\WCDE_ENT70)\workspace this directory to your workspace.
                    • Sreejith.kanneri
                      Sreejith.kanneri
                      81 Posts
                      ACCEPTED ANSWER

                      Re: Commerce 7 Instance Creation Error

                      ‏2012-10-12T08:42:33Z  in response to RamkumarKuppuchamy
                      Hi,

                      We faced the similar issue while creating instance on Windows 7 x64. We could solve it by creating a new DB2 database and suggested tablespaces (from ). Then the existing database could be configured to create the commerce instance.

                      http://publib.boulder.ibm.com/infocenter/wchelp/v5r6/index.jsp?topic=/com.ibm.commerce.esupport.doc/html/Configuration/swg21200714.html
                      But we hit a roadblock with MassLoad ,although the instance creation works fine .Get the following exception :

                      jcc1016510044http://4.3.111 Invalid database URL syntax: jdbc:db2://:0/WCSDEMO. ERRORCODE=-4461, SQLSTATE=42815
                      • Sreejith.kanneri
                        Sreejith.kanneri
                        81 Posts
                        ACCEPTED ANSWER

                        Re: Commerce 7 Instance Creation Error

                        ‏2012-10-17T13:57:10Z  in response to Sreejith.kanneri
                        The solution was straight forward - installed the WCS server in windows 2008 server (standard edition r2 ) and it worked like a charm.

                        Install only on a Windows server installation , even the infocenter recommends the same . Do not waste time on win 7.

                        http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/index.jsp?topic=%2Fcom.ibm.commerce.install.doc%2Frefs%2Frigsrvswprereqwin.htm

                        in win 2008 server we could do all installation using the commerce install wizard (including the Db2)
                        • Sreejith.kanneri
                          Sreejith.kanneri
                          81 Posts
                          ACCEPTED ANSWER

                          Re: Commerce 7 Instance Creation Error

                          ‏2012-10-18T13:20:07Z  in response to Sreejith.kanneri
                          Hi NCDD_Joe_Norton ,

                          One small query did u face any issue with HTTP server in win 2008 installation.
                          Post installation my HTTPServer is not coming at all .

                          were you using the WAS 64 bit or 32 bit installation

                          http://www.ibm.com/developerworks/forums/thread.jspa?threadID=459137&tstart=0

                          Any Help appreciated.