XL Reporter Installation - Error executing IXMetaProcs.sql

[Former Member]

Hi All,

During installation getting error-

Error Preparing Metadata Repository:

.........

..........

Executing SQL script 'IXMetaProcs.sql' (Start:....)

ExitCode -1073741819

!!! ERROR Error executing IXMetaProcs.sql ExitCode -1073741819

..................

...............

I have done the following checks.

1. XL Reporter has bee removed from Administrator->Add-On Administrator.

2. Add-Remove List Does not show XL Reporter.

3. Removed manually Database IXMetaSBOOEM from SQL Server.

4. %temp% - > SM_OBS_DLL folder not found.

5. ILytix folder not found in HKEY_CURRENT_USER -> Software

ILytix folder not found in HKEY_LOCAL_MACHINE-> Software

6. There is no other add-on installed

7. AddOnsInstall.sbo deleted.

AddOnsLocalRegistration.sbo not found.

8. C:\Prog Files\SAP\SAP Business One\Add-Ons folder not found.

But still I can't install XL Reporter.

[Former Member · Accepted solution]

hi,

first you have to check that you have install "dot. Net Framework 2.0" which is compulsory needed for installing XL reporter, also you have to install MS Office in your system.

uninstall the XL reporter and install using the following steps

installation steps of XL-reporter add-on,

1. goto add-on administration => Register Add-on(click).

give the XL reporter address. select default group as Manual.

update.

2. goto addon manager => pending Add-on tab => select the addon row and install.

in installation give the user id and pwd of SQL server.

3.goto addon manager =>installed addons tab, start the XL reporter, once it get connected as status.

4. go to tools menu in SAP B1, in that you will find XL reporter, click that XL reporter will open.(to view XL reporter)

follow the above steps you will get the XL repoter add-on running in SAP B1.

regards

sandip

[Former Member · Accepted solution]

Dot net framework 1.1 and MSOffice is installed.

[Former Member · Accepted solution]

Hi,

Is this error solved already? I have the same problem with this error and has followed the advised procedures.

Regards,

eco

[Former Member · Accepted solution]

What is your SBO Version and MS Office version? What is your client OS?

[Former Member · Accepted solution]

SBO 2005 A PL39, MS Office 2003. My OS is Win XP Prof Ver.2002 SP 2.

[Former Member · Accepted solution]

Uninstall Office and re-install it and follow the above said steps. In my case it was Office 2007 and hence I faced the problem. When I uninstalled 2007 and installed 2003 problem was solved.

If still you problem exists then start a new thread.

[Former Member]

hi

you have to uninstall sap b1 client and reinstall.

regards

Hariprasad

[Former Member]

I have uninstalled Client in server only but the result is same.

Should I uninstall all clients machies also?

[Former Member]

yes

[preety_goel]

Hi,

Please see SAP notes 840920 and 819501.

This issue could be related to the previous installation of XL

Reporter conflicting with the update. I advise cleaning the client of

the installed add-ons and attempting to install again.

There is also an EES which details how to remove the Add-On entirely in

order to make a clean installation:

The EES is available on the service marketplace:

Go to service.sap.com/smb/sbo. Click "Support" on the left of the

screen. Then click "Archive: Empowerment Sessions " on the right of the

screen.

Now click on "ADD-ONs - for DTW, XL Reporter, all SAP Add-Ons " and

scroll down to:

"Troubleshooting XL Reporter by making a complete reinstall (using

MSSQL 2005)"

Regards,

Preety Goel

SAP Business One Forums Team

[Former Member]

Thanx All for help.

I've gone through those documents and that's why I've give the check list at the beginning.

I have uninstalled XLR from all client workstations also.

But still I can't reinstall XLR in server.

Plz help me out of this situation.

[Former Member]

Hi,

I have seen those docs and followed but still I'm facing the same error while installing XLR.

Plz help me.