XL Reporter Start Up Failed - "Report Initialize" Description (667)

[Former Member]

Hi experts,

I use SAP B1 2007 PL34. I'm trying to execute an XL reporter report and I got this message

"An Error Occurred During The Process "Report Initialize". Description(667) metainfo.XML not Found! (Please contact the administrator to fix the repository connection) XL reporter Start Up failed"

Afterwards the report open but had just the headers. I already searched through the forums but I only saw Description (666) errors, How can I resolve this ?

Any help will be greatly appreciated.

[ladislav_meszaros · Accepted solution]

Hi,

In order to resolve the reported issue, please try the following solution:

1. Please make sure that (a)Microsoft® .NET Framework 1.1 and (b) Microsoft® MDAC 2.7 or higher is installed in the machine, where you are running XL reporter if you have both .Net 1.1 and .Net 2.0 is installed then please refer to note no. 898635.

2. Once the error message popped up, please kill all processes of SBO and XLR, then restart. Try to see if the message still exists.

3. Goto Excel and check if the Macro Settings is correct as per note 853821.

4. Check the authorization of the folder C:Program FilesSAPSAP Business OneAddOnsXLRXLReporter to see if users have right to edit document in that folder.

5. If still you have the same issue, could you please copy a healthy Metainfo.xml from your workstation where the XL reporter is working fine to the workstation where you are facing the issue. After modifying the Database info in the Metainfo.xml file, execute XLR again.

Note: The Metainfo.xml file should be available in the following location :

C:Program FilesSAPSAP Business OneAddOnsXLRXLReporter.

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

[Former Member · Accepted solution]

Thanks guy, this last post by Ladislav fixed the problem.

Regards

[Former Member · Accepted solution]

Hi Chike,

I have the same problem as you previouslly had.

I am getting the same error as mentioned in subject line. Even i posted the thread with separate subject.

I have gone through the siolution that you already applied but not able to see SAP Note for having both .Netframework 1.1 and 2.0.

How did you solved the problem. P{lease guide me.

Regards

[Former Member · Accepted solution]

Here You Go,

The SA Note for runing bothe versions of .net concurrently.

Summary

Symptom

After installing .NET Framework 2.0 on a client, XL Reporter stops working. When starting XL Reporter the error message "Error!Unable to get document! Type: 1 Cause: Automation error".

Other terms

SAP Business One, B1, Add-On, Visual Studio 2005, SQL Server 2005

Reason and Prerequisites

The SBOXLReporter.exe is not a .NET application, but uses .NET 1.1 to run. Non .NET applications use the newest version of .NET installed, but XL Reporter do not work with .NET 2.0.

Solution

Download the attached file and unzip the .config file to ..\SAP Business One\AddOns\XLR\XLReporter\Client on the clients with .NET 2.0 installed. This .config file tells the SBOXLReporter.exe to use .NET 1.1 to run.

[jrme_burgaud · Accepted solution]

OK Chike

But what MS Server 2008 and

Framework

Framework 64

Changes to that ?

I am not sure that the xml file is sufficient to tell a 64 bits machine to run the appropriate Framework

Am I right ?

Thanking you in advance for a reply inside this "already answered" thread.

JB

[Former Member · Accepted solution]

This refers to an attached file. But there is no attachment. Does anyone have the attachment or can they advise me of the lines of code i need to modify.

Thanks

[Former Member · Accepted solution]

Thanks Ladislav

Your post fixed the same problem in my client too.

[Former Member · Accepted solution]

How to download pls tell me

Thanks

[Former Member]

See this link to solve easily the issue:

[;

Regards

YTO

[Former Member]

Thanks guyS, this last post by Ladislav fixed the problem.

Regards

[Former Member]

What Excel version are you using? Vista is not very friendly with XLR. You probably need quite a few times of try and error to solve the problem. Make sure you have .Net Framework 1.1 installed.

[Former Member]

I am using Excel 2003 version, my XL Reporter is Version 8.0.13.Windows vista comeswith .Net Framework 2.0 installed, I have now installed version 1.1, so effectively I have both versions runing.

I also noticed the following message when I close the blank report design 'Run-time error `91`:

Object variable or With block variable not set'

Based on the above error message,I have also extracted the exceldotNET20XLR.zip file(as recomended by Note 918188) to direct the system to usethe .Net Framework version 1.1 to run but the problem still persists.

Thanks

[Former Member]

Hi,

The error message indicates wrong installation or version mismatch. It is happening on one or all Clients?

Thanks,

Gordon

[Former Member]

XL Reporter came as a core part of SAP B1, I did not install it seperately.The problem affects only one workstation that is runing windows Vista.

Thanks