Status of package 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)' after install is 'InstallFailed'

Trying install Crystal Reports Basic for Visual Studio 2008 in XP Pro SP2 and hit bellow error.

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)', phase BuildList
Running MsiProductCheck with ProductCode '{AA467959-A1D6-4F45-90CD-11DC57733F32}'
MsiQueryProductState returned '-1'
Setting value '-1 {int}' for property 'CRVSInstalled'
Running MsiProductCheck with ProductCode '{CE26F10F-C80F-4377-908B-1B7882AE2CE3}'
MsiQueryProductState returned '-1'
Setting value '-1 {int}' for property 'CRVSRunTimex86Installed'
Running MsiProductCheck with ProductCode '{2BFA9B05-7418-4EDE-A6FC-620427BAAAA3}. '
MsiQueryProductState returned '-2'
Setting value '-2 {int}' for property 'CRVSRunTimex64Installed'
The following properties have been set for package 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)':
Property: [CRVSInstalled] = -1 {int}
Property: [CRVSRunTimex64Installed] = -2 {int}
Property: [CRVSRunTimex86Installed] = -1 {int}
Running checks for command 'CrystalReports10_5\CRRedist2008_x86.msi'
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueGreaterThan' on property 'CRVSInstalled' and value '0': false
Result of running operator 'ValueGreaterThan' on property 'CRVSRunTimex86Installed' and value '0': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Skipping FailIf because Property 'Version9x' was not defined
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.00': false
Result of checks for command 'CrystalReports10_5\CRRedist2008_x86.msi' is 'Install'
Running checks for command 'CrystalReports10_5\CRRedist2008_x64.msi'
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'AMD64': true
Result of checks for command 'CrystalReports10_5\CRRedist2008_x64.msi' is 'Bypass'
'Crystal Reports Basic for Visual Studio 2008 (x86, x64)' RunCheck result: Install Needed
EULA for components 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)' was accepted.
Copying files to temporary directory "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD1.tmp\"
Copying from 'C:\Documents and Settings\Administrator\Desktop\XinInvoiceSetup2_new\XinInvoiceSetup2\CrystalReports10_5\CRRedist2008_x86.msi' to 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD1.tmp\CrystalReports10_5\CRRedist2008_x86.msi'
Verifying file integrity of C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD1.tmp\CrystalReports10_5\CRRedist2008_x86.msi
WinVerifyTrust returned 0
File trusted
Running checks for package 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)', phase BeforePackage
Running MsiProductCheck with ProductCode '{AA467959-A1D6-4F45-90CD-11DC57733F32}'
MsiQueryProductState returned '-1'
Setting value '-1 {int}' for property 'CRVSInstalled'
Running MsiProductCheck with ProductCode '{CE26F10F-C80F-4377-908B-1B7882AE2CE3}'
MsiQueryProductState returned '-1'
Setting value '-1 {int}' for property 'CRVSRunTimex86Installed'
Running MsiProductCheck with ProductCode '{2BFA9B05-7418-4EDE-A6FC-620427BAAAA3}. '
MsiQueryProductState returned '-2'
Setting value '-2 {int}' for property 'CRVSRunTimex64Installed'
The following properties have been set for package 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)':
Property: [CRVSInstalled] = -1 {int}
Property: [CRVSRunTimex64Installed] = -2 {int}
Property: [CRVSRunTimex86Installed] = -1 {int}
Running checks for command 'CrystalReports10_5\CRRedist2008_x86.msi'
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueGreaterThan' on property 'CRVSInstalled' and value '0': false
Result of running operator 'ValueGreaterThan' on property 'CRVSRunTimex86Installed' and value '0': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Skipping FailIf because Property 'Version9x' was not defined
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.00': false
Result of checks for command 'CrystalReports10_5\CRRedist2008_x86.msi' is 'Install'
'Crystal Reports Basic for Visual Studio 2008 (x86, x64)' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD1.tmp\CrystalReports10_5\CRRedist2008_x86.msi
WinVerifyTrust returned 0
File trusted
Installing using command 'C:\WINDOWS\system32\msiexec.exe' and parameters ' -I "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD1.tmp\CrystalReports10_5\CRRedist2008_x86.msi" -q /norestart'
Process exited with code 1603
Status of package 'Crystal Reports Basic for Visual Studio 2008 (x86, x64)' after install is 'InstallFailed'

Fix:
Install .NET 2.0 Framework will solve the problem

Parser Error Message: Section or group name 'system.web.extensions' is already defined.

facing below error in my development machine when i try to access to one of my application that running in ASP.NET framework 2.0

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Section or group name 'system.web.extensions' is already defined. Updates to this may only occur at the configuration level where it is defined.

Source Error:

Line 2: Line 3: Line 4: Line 5: Line 6:

Source File: C:\Inetpub\wwwroot\xxxxx\web.config Line: 4

Show Additional Configuration Errors:

Section or group name 'scripting' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Inetpub\wwwroot\formlookup_ajax2\web.config line 5) Section or group name 'scriptResourceHandler' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Inetpub\wwwroot\formlookup_ajax2\web.config line 6) Section or group name 'webServices' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Inetpub\wwwroot\formlookup_ajax2\web.config line 7) Section or group name 'jsonSerialization' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Inetpub\wwwroot\formlookup_ajax2\web.config line 8) Section or group name 'profileService' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Inetpub\wwwroot\formlookup_ajax2\web.config line 9) Section or group name 'authenticationService' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Inetpub\wwwroot\formlookup_ajax2\web.config line 10)

Situation:

In My IIS setting

My Default Web Site Location path point to an application that running asp.net framework 3.5

When i access to one of my application that park under Default Web Site that running in asp.net framework 2.0, it hits error above.

Solution:

Remove the Default Web Site Location path solve my problem.

Exception Details: System.UnauthorizedAccessException: Access to the path C:\xx\aa.xml is denied. ASP.NET is not authorized to access the requested re

Access to the path 'C:\xxx\aa.xml' is denied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path 'C:\xxx\aa.xml' is denied.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via , the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[UnauthorizedAccessException: Access to the path 'C:\xxx\aa.xml' is denied.] System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +651 System.IO.File.Delete(String path) +157 Admin_PropertyEdit.GenerateXML(Int64 pPropertyID, String pPropertyTypeName) +124 Admin_PropertyEdit.btnRemove_Click(Object sender, EventArgs e) +248 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

Hit above error when trying to write a xml file in the web server. I've tried to set write permission for both internet guest user & also ASP.NET user but still the same.

Finally, i add into web.config and the problem solve.

<identity impersonate="true"/>

syntax

<configuration>

<system.web>

<identity impersonate="true"/>

</system.web>

</configuration >

I'm not sure why, to know more, please check on

http://msdn.microsoft.com/en-us/library/72wdk8cc.aspx

Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.

Received an error message on my windows desktop application (own developed) after install in a windows 7 64 bit (x64) machine.

____________________________________________
An error has occurred while attempting to load the Crystal Reports runtime.

Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.

Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required. Please go to http://www.businessobjects.com/support for more information.
____________________________________________

We already follow the steps suggested:
When compiling the application in Visual Studio .NET 2008 you will need to force it to 32 bit mode.
You can do this by right-clicking the project name in the Solution Explorer and select Properties.
For VB.NET
Click Compile, then Advanced Compile Options. For the Target CPU drop down box, change it from "AnyCPU" to "x86" then click OK.
For C#.NET
Click Build and change the Platform Target option from "Any CPU" to "x86".
You should then be able to run the application on a 64 bit OS without error.

But it still show the same error

___________________________________________
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.TypeInitializationException: The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception. ---> CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: An error has occurred while attempting to load the Crystal Reports runtime.

Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.

Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required. Please go to http://www.businessobjects.com/support for more information.

xxxxxxxxxxx .......................................

_________________________________________

but finally i'm able to figure out the solution. The solution is go to cost you USD 10 if you wish to know. Write to me ...

Happy Chinese New Year

Wish all Happy Chinese New Year! May this year of tiger bring you healthy, happy and wealthy!

windows upside down

don't panic ... my windows xp pro suddenly upside down after i press some key accidentally and the bad news is i dont know which key i've press. Luckily i finally found on web ..

To fix it:

answer: Ctrl & Alt & ↑ (up)

You will get it back to normal.

What causes the upside down?

answer: Ctrl & Alt & ↓ (down)

SQL query and optimization

I've run a simple test on sql query involve 2 tables, tblEmail & tblEmailPromotion

Table columns:

tblEmail (email varchar(255), IsDeleted int)

tblEmailPromotion (email varchar(255), PromotionID int)

Both tables without index

SELECT TOP (90) e.Email FROM tblEmail e

LEFT OUTER JOIN tblPromotionEmail pe ON e.Email = pe.Email AND pe.PromotionID = 6

WHERE pe.PromotionID IS NULL

AND e.IsDeleted = 0

AND e.Email LIKE '%hotmail%'

ORDER BY e.Email

It takes about 2:43 (2 minutes 43 seconds) to get the result

Change the question from "LEFT OUTER JOIN" to "IN" become

SELECT TOP (90) e.Email FROM tblEmail e

WHERE e.Email NOT IN (SELECT Email FROM tblPromotionEmail pe WHERE pe.PromotionID = 6)

AND e.IsDeleted = 0

AND e.Email LIKE '%hotmail%'

ORDER BY e.Email

Guest what? great improvement. Takes 1:07 (1 minute 7 seconds) to load the result.

Now, we index table tblEmail column Email (Unique)

SELECT TOP (90) e.Email FROM tblEmail e

LEFT OUTER JOIN tblPromotionEmail pe ON e.Email = pe.Email AND pe.PromotionID = 6

WHERE pe.PromotionID IS NULL

AND e.IsDeleted = 0

AND e.Email LIKE '%hotmail%'

ORDER BY e.Email

It takes about 1:22 (1 minute 22 seconds) to get the result

Now, we run the 2nd query:

SELECT TOP (90) e.Email FROM tblEmail e

WHERE e.Email NOT IN (SELECT Email FROM tblPromotionEmail pe WHERE pe.PromotionID = 6)

AND e.IsDeleted = 0

AND e.Email LIKE '%hotmail%'

ORDER BY e.Email

It only takes 27 Seconds

To make the 2nd query better:

SELECT TOP (90) e.Email FROM tblEmail e

WHERE e.Email NOT IN (SELECT Email FROM tblPromotionEmail pe WHERE pe.PromotionID = 6 AND pe.Email LIKE '%hotmail%')

AND e.IsDeleted = 0

AND e.Email LIKE '%hotmail%'

ORDER BY e.Email

This will give 15 seconds.

Summary:

We need to choose the query wisely.

Index will help to improve data retrieving process but must be careful with indexes. Wrong indexes may cause you more problem.

Are you an Entrepreneur?

Add Yahoo PingBox to Facebook fan page using FBML

Well, there do have Yahoo! Messenger Pingbox for facebook application but it's only able to add to personal profile and not to fan page.

What i'm going to do here is to add Yahoo! Messenger Pingbox to fan page using facebook static FBML application. Here, i'm not going to discuss on how to use FBML application, to see how FBML works, please check http://socialwants.com/development/adding-facebook-fan-page-applications/

Now, i have my Yahoo! Messenger Pingbox code.

<object id="pingbox0000000000000" type="application/x-shockwave-flash" data="http://wgweb.msg.yahoo.com/badge/Pingbox.swf" width="240" height="420"><param name="movie" value="http://wgweb.msg.yahoo.com/badge/Pingbox.swf" /><param name="allowScriptAccess" value="always" /><param name="flashvars" value="wid=xxxxxxxxxxxxxxxxxxx--" /></object>


In order to make it work in FBML, i have to change the above code to below

<fb:swf swfsrc='http://wgweb.msg.yahoo.com/badge/Pingbox.swf' imgsrc='http://www.encelabs.com/images/aaaaa.jpg' flashvars='wid=xxxxxxxxxxxxxxxxxxx--' width='184'height='320'/>



where imgscr is the image that will be displayed before pingbox load.

I'm able to get it run in my facebook fan page. Hope it work for you.

Invoice Software

Recently have downloaded and tested on a few invoice software/invoice system. Some are very complicated, some are not user friendly and some are very old design.

Surprisingly i found a very simple with very attractive user interface invoicing software. It can easily generate a quite professional quotation and invoice. It include delivery note as well but i'm not using it. It come with professional invoice template and we can customize the quotations & invoices's template field and wording and also can upload company logo.

It's very user friendly and the search feature is also very simple. Just nice customer maintenance module, and reporting module.

For the paid version, a very simple inventory module included in the software. Payment receive module and revenue reporting module. One thing want to highlight here is that the reports can drill down to more details level. Love it.

Simple and nice with very low price. Maybe you can try it. The software called Xin Invoice. The support is not bad and also there are some simple demo can find on their web and youtube. It's just suit my needs but i'm not sure for those who is running more complicated business.