Friday, October 3, 2008

Reporting Services: Error in rendering: System.Security.CodeAccessPermission.Demand()

Error Message :
Error in rendering:Request for the permission of type 'System.Drawing.Printing.PrintingPermission, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed. - at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Drawing.Printing.PrinterSettings.get_InstalledPrinters()

at PrintWebControl.PrinterControl.PrinterControl_Load(Object sender, EventArgs e)

Resolution :
Delete PrintWebControl.DLL in C:\Documents and Settings\admin\Local Settings\Application Data\assembly\dl3\WA846YNJ.XG8\7N839JKE.BCK\c1eba29f\809a654b_d822c901 DIR then access the report again.

Thursday, October 2, 2008

Microsoft CRM 4.0: MB2-633 Actual Exam

I have just taken the MB2-633 Installation and Deployment exam and i passed it with flying colors. Anyone interested to get a copy of my reviewer, please email me at deverror.admin@gmail.com

Analysis Services : Unable to Connect to Analysis Services

Problem :
Status from the Excel sheet: “Waiting for query to be executed”

Solution:
Uninstalling the Firewall application (Integrity Agent)

Analysis Services : No mapping between account names and security IDs was done.

Problem :
The following system error occurred: No mapping between account names and security IDs was done.

Cause :
Domain User present in Roles are no longer in the domain server.

Resolution :
Remove the domain user from the roles.

Wednesday, September 24, 2008

Dynamics CRM : Cannot focus on pop-up window when we use JavaScript

Cannot focus on pop-up window when we set the URL in JavaScript parameter, instead in Url Parameter then set WinMode="2" of your isv.config.xml.

Scenario : I need to call the crmForm.Save(); function in JavaScript before I open a pop-up window. We cannot user Url parameters then set WinMode="2" anymore.

Solution :

Call the save function in JavaScript parameter then call the new window.



Then on the NewPopUpWindow.aspx add this code on the Body tag onBlur="window.focus();"

Tuesday, September 23, 2008

Analysis Services : Class not registered (Exception from HRESULT : 0x80040154 (REGDB_E_CLASSNOTREG))

Problem: Most likely the OWC component installation became corrupted.

Resolution:
Try to repair your "Microsoft Office 2003 Web Components" installation.

Analysis Services : ‘Unknown’ Attribute in Browser


Problem: An attribute with label ‘Unknown’ is showing in the browser.





Resolution: Set UnknownMember to Hidden or None.


Analysis Services : "Unexpected Error occured" When trying to view calculations tab

"Unexpected Error occured" When trying to view calculations tab

Problem: Cannot browse the calculation tab.

Resolution:
this might be caused by version mismatch between some binaries. i'd suggest checking the versions of msmdlocal.dll and msmgdsrv.dll and making sure that the ones installed into %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ are the same as those in %ProgramFiles%\Common Files\System\Ole DB\ (if they are not then try updating the ones in the PrivateAssemblies with the ones from ole db; you might want to save the original ones as to be able to get back to original state just in case...)

Friday, September 5, 2008

Integration Services : Error code 0x80004005

Microsoft SQL Server Integration Services : Error code 0x80004005

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Transaction (Process ID 135) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.".

Solution:
Add WITH (NOLOCK) on OLE DB Source query to release lock on table being queried. Lock occurs if 2 or more processes are waiting for a resource and neither can advance because the other process is preventing it from getting the resource.

Reporting Services: An Error occurred during local report processing. An error has occured during report processing. Query execution..

Microsoft Reporting Services: An Error occurred during local report processing. An error has occurred during report processing. Query execution failed for data set '???' Incorrect syntax near...

Solution:
Check your SQL statement query on the DATA tab. Try to execute your query in that tab first before you hit the preview Tab.