Crystal Report Error Invalid Mapping Type Value
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Cystal Rpt Invalid mapping type value. Want to Advertise Here? Solved Cystal Rpt Invalid mapping type value. Posted on 2011-02-07 .NET Programming DB Reporting Tools Crystal Reports 2 Verified Solutions 4 Comments 2,661 Views Last Modified: 2013-11-26 Hi, I have moved my application(vb.net) from a 32bit 2k3 server to a 64bit 2k8 server. Had millions of issue just getting my reopts to even attempt to load but I think I'm nearly there. When my application attempts to open a report I get the error attached below. I've opened the report in VS 2005, it runs and can connect to the database on the 2K8 server. When i move the same report over to the server it won't work. I think that the error may be due to the fact the only distributable I could get to work on the server was the 2008x64 whereas the report I make it in is vs.net 2005 with x86. Do x86 reports not work in x64 redist? Please help! TIA Routine: [DisplayReport] Error : CrystalDecisions.CrystalReports.Engine.InternalException: Error in File C:\Users\ADMINI~1.GPL\AppData\Local\Temp\2\rptOrdersOnHold {F3302EC7-D136-44A5-89BC-9ADF341C2839}.rpt: Invalid mapping type value. ---> System.Runtime.InteropServices.COMException (0x80000276): Error in File C:\Users\ADMINI~1.GPL\AppData\Local\Temp\2\rptOrdersOnHold {F3302EC7-D136-44A5-89BC-9ADF341C2839}.rpt: Invalid mapping type value. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.VerifyDatabase() Se
Newbie Joined: 05 Aug 2010 Location: Canada Online Status: Offline Posts: 8 Topic: Crystal Report 2005 DataSourcePosted: 23 Mar 2011 at 9:57am Hi!I'm having a problem with my report, build with Visual Studio 2005 with is version 10, if I remember well.To build my report I've first save a DataTable to a XML file, then bind that XML file to a new Report, has a Report schema, to help me building it.At RunTime, I'm setting the report DataSource to a new DataTable witch have the same schema (same SQL Query) has the one used to build the report and using the command MyReport.SetDataSource(MyDataTable)Everything goes well, until I remove the XML file that I use to build the report.When I call the VerifyDatabase, after setting SetDataSource, crystal thrown a exception "Log On failed" and sometime thrown a exception "Invalid mapping https://www.experts-exchange.com/questions/26803054/Cystal-Rpt-Invalid-mapping-type-value.html type value".I'm really stock with that one, I've recreate my report from scratch without success.Need help Hugo IP Logged lockwelle Senior Member Joined: 21 Dec 2007 Online Status: Offline Posts: 4248 Posted: 24 Mar 2011 at 3:38am have you tried not verifying the database? I have created many reports using the method you describe, but I have never removed the file and aske to verify the database. Look at it from CR's point of view. The only schema that it knows for how http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12687 the data should look is located in that file. If it is gone, it has nothing to look at to see if the data it has matches what it should have. It has no reference to see if the fields in the report match the datasource. You can create the report and deploy it and use, you just can't verify the database without the file. If you decided to change the schema of the report, say by adding or removing a field, you would bring out a new XML file. Let say you forgot the name of the original file, and you saved the new schema as a different file in a different place. You could verify database until the cows come home, and the report would never see the change. Once you went into Database Expert and changed the file that the report is looking for, only then will you see the changes in your schema. In short, you're not doing anything incorrect, until you try to verify the database without the database(XML file) to verify against. HTH IP Logged Hugo Newbie Joined: 05 Aug 2010 Location: Canada Online Status: Offline Posts: 8 Posted: 25 Mar 2011 at 2:43am Thanks for your reply,Well your point of view is not bad, but many other report that I've made are working OK with my method. But no this one.I've try not to do the VerifyDatabase, but the error raise anyway a little further in my code.What do you suggest for
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick http://www.codeproject.com/Questions/376107/I-am-getting-Invalid-mapping-type-value-this-error answersQ&A Ask a Question View Unanswered Questions View All Questions... C# questions http://scn.sap.com/thread/1564788 Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free crystal report Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most crystal report error Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ I am getting “Invalid mapping type value” this error while calling in c# Rate this: Please Sign up or sign in to vote. See more: SQL-server-2005 C# SQL-Server , + i created method to show my report then i give connectioninfo at runtime but when i connect to remote server i got error public bool ShowReport() { try { //CrystalDecisions.CrystalReports.Engine.ReportDocument oRepDoc; //CrystalDecisions.Shared.TableLogOnInfo oLogInfo; //CrystalDecisions.CrystalReports.Engine.Table oTable; //CrystalDecisions.CrystalReports.Engine.FieldDefinition oField; //CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition oParamFieldDef; //CrystalDecisions.Shared.ParameterValues oParamValues; //CrystalDecisions.Shared.ParameterDiscreteValue oDiscretParamValue; //ParameterFields oParamList; //ParameterField oParamItem; if (!System.IO.File.Exists(ReportPath)) { MessageBox.Show("ملف التقرير غير موجود فى المسار الصحيح", MainClass.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } else { oRepDoc = new ReportDocument(); oLogInfo = new TableLogOnInfo(); Tables t; oRepDoc.Load(ReportPath, OpenReportMethod.OpenReportByTempCopy); //******************
BusinessObjects Integration KitsWhere is this place located?All Places BI Platform BusinessObjects Integration Kits 7 Replies Latest reply: Jan 19, 2010 6:22 AM by Carlos Chen Tweet Error when trying to connect Crystal Enterprise to Peoplesoft (tools 8.49) savina chidella Dec 22, 2009 6:04 PM Currently Being Moderated We have been using crystal enterprise with our peoplesoft for a while now, but with the tools version 8.43 on DB2 database. We are now upgrading our tools to version 8.49 on Oracle database. We have tons of crystal reports developed on crystal enterprise on the tools version 8.43 on DB2 database, connecting to peoplesoft thru peoplesoft user authentication and accessing the peoplesoft queries. We are now trying to point the crystal enterprise to peoplesoft on tools version 8.49 on Oracle database and are receiving the below error. Is anyone familiar with this error and know how to fix it. Please help!ThanksSavinaEdited by: SChidella on Dec 22, 2009 6:01 PMSorry the screenshot didn't get copied for some reason. Here is the error message...." Query Engine Error: 'An error occured in the crystal query server for peoplesoft while accessing a component interface. The interface may have encountered an application error within peoplesoft. "ThanksSavina 3079Views Re: Error when trying to connect Crystal Enterprise to Peoplesoft (tools 8.49) Carlos Chen Dec 28, 2009 6:07 PM (in response to savina chidella) Currently Being Moderated Hi Savina In the PeopleSoft integration ktis, for different versions of PeopleSoft system, there are different interfaces used to access PeopleSoft systems. PeopleSoft version 8.42 to 8.45 (aka PS8), and PeopleSoft version 8.46 - 8.49 and 8.50 (aka PSEnterprise) use different interfaces to access PeopleSoft systems, they have different authentication, they have different Crystal Reports data access drivers. Currently in the PeopleSoft IK, there is no migration tool provided for migrating between the two. You'll need to use Crystal Reports 2008 Designer, and go from menu-Database-Set Database location choose to create a PeopleSoft 8.49 connection and set location to the new PeopleSoft 8.49 connection. Hope this help to clarify.Best RegardsCarlos Chen Alert Moderator Like (0) Re: Error when trying to connect Crystal Enterprise to Peoplesoft (tools 8.49) Kevin Doherty Jan 13, 2010 6:08 PM (in response to Carlos Chen) Currently Being Moderated Hello Carlos,I had a follow-up question that I hope you can help with.You outlined the manual process of pointing to a new datasource as follows.You'll need to use Crystal Reports 2008 Designer, and go from menu-Database-Set Database locationc