Xl Reporter does not work after the upgrade to 2007A PL 47

[Former Member]

Hi Experts

UPgraded to 2007A PL 47 from 2005A. Upgrade was done successfully. However the XL reporter is

not functioning. When you go to Tools and click on XL reporter nothing happens. No error message

comes up even.

Client is using SQL 2005 MS server 2003

I ahve done the test upgarde in an image of the live server

thank you

Regards

Aosara

Edited by: Apsara Senaratna on Feb 10, 2010 4:33 AM

[Former Member · Accepted solution]

Hi!

Do you getting the message XL Repoter connected successfuly when u log on to ur company ?

[Former Member · Accepted solution]

Hi Thannga

The answer is no.

I believe when i logon to SAP add on at the bottom of the menu it should come up " connecting Addon: XL reporter" (i get this on other dB's when connecting to SAP)

Could this be related to the environment. As other than this there was no issues with the Upgrade.

Thank you

Regards

Apsara

[Former Member]

Is this just on the server client, or on all clients. I recommend reinstalling the client, after uninstalling, elete the XL Reporter folder under SAP>SAP Business One> Add ons

[Former Member]

Hi Julie

Thank you for your comment. The xl doesnt work on the server client I have upgraded the server client only.

So are you suggesting i uninstall and reinstall the server client

Thank you

Regards

Apsara

[Former Member]

That will be the easiest option, yes.

There is a SAP note that details a number of steps to be undertaken between the uninstall & reinstall - from memory:

Use add/remove programs to uninstall

Start>Run>%temp% then delete SM_OBS_DLL folder

delete XL Reporter folder under the SAP Business One program files folder

reinstall

[Former Member]

Hi Julie

Thank you for your reply. Since XL reporter is integrated to SAP you XL reporter is not available under add on administrator to be removed

Thanks

Regards

Apsara

[Former Member]

Remove the entire SAP client from the server using Add / Remove programs.

Delete the XL Reporter folder under the C:Program Files SAP Business One directory

Delete the SM_OBS_DLL folder from the temp files

Reinstall the SAP Business One client from the B1SHR directory

[Former Member]

Hi Aosara,

If your got the menu item from Tools, the connection should be no problem. You may need to check all available error logs everywhere to find anything wrong.

Thanks,

Gordon

[Former Member]

Hi Gordon

Thanks for the reply. I infact created a log file as per SAP note 913236 so that a log entry will be entered when XL is started.

However lo log entery is made. I belive this is because XL reporter is not started or connected enev though it appears under the tools

Thank you

Regards

Apsara

[Former Member]

That note may not work for 2007. Remove that log to see.