Unable to connect to XL Reporter

[Former Member]

Hi All

A client is experiencing difficulty connecting to XL reporter.

They were having issues before and thought it was because of the patch they were running, but could not get an error message..it just would not work. They upgraded to patch 42, 2007 version. but is having issues as well.

The error she got is

Unable to connect to XL Reporter

Error! User Authentication failed!

Cause: Invalid use of Null

Does she need to reset the permissions?

[ladislav_meszaros · Accepted solution]

Hi,

This issue occurs because the old stand-alone version of XL Reporter previously has been installed on the company database you are trying to use. This version used the partner code SAP, while the add-on version uses the code SBOOEM. The installation does not recognize this as an upgrade.

In order to solve the issue please do the following steps:

1. Start the SQL Management Studio and go to "Object Explorer".

2. Browse down to your Business one database, expand and choose tables.

3. Right click the table "XRDBV" and choose "open".

4. In the column 'Partner' change the text from SAP to SBOOEM and press Enter.

5. Close the "SQL Management Studio" and start the XL Reporter. The XL Reporter information in the database should now be upgraded.

Please find SAP note [847981|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=847981], which gives a detailed description of this issue.

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

[Former Member]

Hi

Check these notes

847981

924561 853343 853821

871222

Regard

Rashid

[Former Member]

Thanks alot

[Former Member]

Check this SAP Note: 847981 Unable to connect to XLR after installation

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=847981]