Aurora - Watch out Madison! ;)

Aurora - is the new starter store launched with WCS 7 FEP 5 - it has really sleek and neat look.
Though it looks like it is still in the nascent state and does not support all the features which are available in the Madisons store - but I am sure we will see her growing fast.

Looks like Madisons has a competition in the B2C space. ;)

To read more about Aurora , refer the below link :
Aurora Starter Store

Catch the below video to know more about Aurora :

References :
Bob Balfe - blog.balfes.net

RESOLVED : DB2 9.7 setdbtype createdb issues

Issues Faced during the database creation while executing the setdbtype.bat

When we checked the “reorgdb2.err.log”, we found the few of the packaged failed during the reorg operations and we can find errors similar to below in the log file:

SQL0551N: The user “XXXXXX” does not sufficient priviliges to rebind the package 'SYSIBMADM.P201372405' of database 'WCS7DB'. UniqueId=213123…..

Problem (Abstract)

In DB2 Version 9.7, a user who holds SYSADM authority no longer has implicit DBADM authority and therefore has limited capabilities compared to those available in Version 9.5.  

Symptom

Example authorization errors are SQL1092N, SQL0551N and SQL0552N:

SQL1092N

authorization-ID does not have the authority to perform the requested command or operation.

SQL0551N

authorization-ID does not have the required authorization or privilege to perform operation operation on object object-name.

SQL0552N

authorization-ID does not have the privilege to perform operation operation.
 

Cause

Prior to DB2 Version 9.7 a user with SYSADM authority had implicit DBADM authority. Common configurations have the instance owner account as a member of the SYSADM group. Applications that are run under the instance owner account had unlimited authority on the database.

In DB2 V9.7 a user with SYSADM authority no longer has implicit DBADM authority. As a result any applications that are run under the instance owner account might experience authorization errors when trying to perform operations that are no longer within the scope of a SYSADM.
 

Environment

The UPGRADE DATABASE command and the RESTORE DATABASE command (for a downlevel database) grant DBADM authority to the SYSADM group, however this is not the case for any new V9.7 database.

Resolving the problem

The resolution to the errors is to verify the authorities for the userid.

To get the list of authorities held by the instance owner authorization ID perform these steps:

1.       Use the SYSPROC.AUTH_GET_INSTANCE_AUTHID() scalar function to determine the instance owner authorization ID.
For example:

VALUES SYSPROC.AUTH_GET_INSTANCE_AUTHID()

1
-----------------------------------------------------------------
XXXXXX

1 record(s) selected.

2.       Get the list of authorities for this authorization ID.
For example:
SELECT * FROM
TABLE (SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID (XXXXXX, 'U'))AS T
ORDER BY AUTHORITY

3.       Grant any missing authorities.
For example:
GRANT DBADM ON DATABASE TO USER XXXXXX

Connect to database using db2admin/password and then execute the above grant query.

4.       Execute a reorg for the entire database.

1.       Run the db2cmd

2.       Navigate to the WCInstall_Dir\bin

3.       Execute the following command

reorg.db2.bat databasename username password schemaname

Example:

reorg.db2.bat WCS7DB xxxxxx passw0rd XXXXXX

4.       Monitor the “reorgdb2.err.log” to ensure there are no errors.

Reference Link:

http://www-01.ibm.com/support/docview.wss?uid=swg21385801

SQL1032N - Issues with DB2START - DB2 9.5 ESE & DB2 9.7 ESE

If db2start command fails giving the error code SQL1042C SQL1032N

SQL8000N DB2START processing failed; a valid product license was not found.
SQL1032N No start database manager command was issued. SQLSTATE=57019

Cause

These error typically indicate that the DB2 UDB product license has not been activated.

Answer

To activate the DB2 UDB product license, run this command:

db2licm -a license_filename

Where license_filename is the name of the license file.

Example:

The file db2ese.lic is the DB2 Enterprise Server Edition license file. The license file should be copied to a local directory (e.g. /tmp) and updated with the following command (resulting output shown):

=> db2licm -a /tmp/db2ese.lic
DBI1402I License added successfully.

DBI1426I This product is now licensed for use as specified in
the License Acceptance and License Information
documents pertaining to the licensed copy of this
product. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF
THE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSE
INFORMATION DOCUMENTS, LOCATED IN THE FOLLOWING
DIRECTORY: /usr/opt/db2_08_01/license/en_US.iso88591

The license information can be queried with this command (resulting output shown):

=> db2licm -l
Product Name = "DB2 Enterprise Server Edition"
Product Password = "DB2ESE"
Version Information = "8.1"
Expiry Date = "Permanent"
Registered Connect User Policy = "Disabled"
Number Of Entitled Users = "5"
Enforcement Policy = "Soft Stop"
Number of processors = "1"
Number of licensed processors = "1"
Annotation = ""
Other information = ""

Management Center : Increasing the Promotion Code Upload Limit

By default, the maximum file size of your CSV file or .zip is 10 MB. You can change the maximum file size.

The maximum file size limit is defined in both the Open Lazlo client and Websphere Commerce instance file.

Below are the steps required to be performed to increase the promotion code upload limit :

1. Update the client

1. Open WebSphere Commerce Developer and switch to the Enterprise Explorer view.
2. In the Enterprise Explorer view, expand LOBTools > WebContent > config> commerce> promotion> objectDefinitions
3. Open the PromotionCodeImportPrimaryObjectDefinition.def file, and locate the defination name proBasePromotionCodeImportPrimaryObjectDefinition.
4. Update the value of the maximumFileSize attribute. The default value is 10000000 bytes. You can change this value as needed, however, keep in mind the impact that larger files might have on your server.
   <PrimaryObjectDefinition copyProtected="true" creatable="true" definitionName="proBasePromotionCodeImportPrimaryObjectDefinition" displayName="${promotionResources.promotionCodeImportObjectName}" displayNameProperty="fileName" fileNamePropertyName="fileName" fileSizePropertyName="fileSize" headerIcon="promotionCodeImportHeaderIcon" helpLink="tasks/tprimportpromo.htm" icon="promotionCodeImportIcon" idProperty="promotionCodeImportId" isBaseDefinition="true" isFileObject="true" maximumFileSize="new_size" newDisplayName="${promotionResources.promotionCodeImport_newPromotionDisplayName}" newObjectMenuItemText="${promotionResources.contextMenuNewPromotionCodeImport}" objectGroups="PromotionCodeImportGroup" propertiesDefinitionName="proPromotionCodeImportProperties" searchType="FindPromotionCodeImports" writeUsage="IBM_ManagePromotionTool"> 
   
   where new_size is the size you want (in bytes).

2. Update the server.
   1. Open the Updating the WebSphere Commerce configuration file, and locate the command element for com.ibm.commerce.promotion.commands.CreatePromotionCodeImportCmd name.
   2. Change the value of the maxuploadsize attribute to match the value specified for the client.
   3. Run the ANT target: UpdateEAR target to update the runtime configuration with the master configuration file.

After you complete your customization:

1. Right-click LOBTools Project; then click Build OpenLaszlo Project to produce an updated ManagementCenter.swf file under the workspace_dir\LOBTools\WebContent directory. This setting is the default environment setting.
2. Test your changes by viewing them in the Management Center, using this URL: https://hostname:8000/lobtools.
3. Deploy your changes to your production environment.

Remote Widgets

Found this cool video which talks about Remote Widgets.. Hope this post also goes viral ! ;)

RESOLVED : An EJB JAR does not exist for the selected project and Map Validation cannot run

Issue:

1. Incase if you ever see the below error in the "Problems" tab of the RAD -

    "An EJB JAR does not exist for the selected project and Map Validation cannot run"

2. The Deployment Descriptor file is not seen/found in the "WebsphereCommerceServerExtensionData" project

3. Clicking on the Map.mapxmi , the file does not open and an error is displayed "The ejb or database is nor defined in the ejb-jar.xml"

Resolution:

It is implicitly assumed in RAD 6 that the source folder which contains the deployment descriptor xml file (DD) should be the FIRST source folder of the project. Otherwise the DD cannot be found.

So, the solution for this problem is to put the folder that contains the deployment descriptor at the top of the Order and Export list in the Project Properties. Then the DD can be found.

So, move the folder "WebsphereCommerceServerExtensionData/ejbModule" to the top in the Order/Export list in the Project Properties.

Incase you do not find that folder in the list , use the following steps to create the new folder -

1. Open RAD and create a new EJB project
2. Right click on the Project in Project Explorer, and choose: Properties
3. Select Java Build Path
4. Go to the Source tab
5. Click Add Folder...> Create New Folder...
6. Go to Order and Export, move the new folder upwards so that it is found at the top of the list.
7. Press OK to close the properties View
8. Run Project > Clean (followed by Build Automatically)
9. Check the Problems view; you will see the above errors

 

A file does not exist for module element having uri: Rest.war

When you start the WebSphere Commerce Test Server, you receive an error that states that a file does not exist.

Problem

When starting the WebSphere Test Server after enabling the Management Center feature, a file does not exist error is displayed in the startup logs. For example,

[11-3-1 15:02:39:484 CST] 00000009 ApplicationMg E   WSVR0100W: An error occurred 

initializing, WC
org.eclipse.jst.j2ee.commonarchivecore.internal.exception.NoModuleFileException: 

A file does not exist for module element having uri: Rest.war

Solution

To resolve this issue, you need to rebuild the LOBTools project and republish the test server, as follows:

1. Open your WebSphere Commerce Developer workspace.
2. Right-click the LOBTools project and rebuild it.
3. If necessary, start the test server in the Servers view and ignore the error that states the file does not exist.
4. After the test server starts, right-click the test server and click Publish. After publishing is complete, the error should no longer be displayed when you subsequently restart the test server.