Skip to Content
0
Former Member
Aug 02, 2011 at 12:02 AM

8,81 PL07 database login issue for Crystal layout

26 Views

Hi All

Upgraded from 8.8 PL18 to 8.81 PL07 running on Windows Server 2003 and SQL Server 2008 R2.

Testing on server.

Opened an existing doc layout which works fine in 8.8 PL18 based on OINV in Crystal designer, created a new datasource using SAP B1 data source type pointing to mu upgraded database.

Mapped all tables and the stored procedure to the required tables in the new datasource for the main report and subreports.

Did test run in Crystal and worked OK

Did 'Preview in SAP Business One' and got an error after entering the docentry and objectid fields as follows.

Database Connector Error :''

Failed to retrieve data from the database

Error in file ~crw{lots of junk for the temp file name}{more junk}.rpt

Database Connector Error

Looked in the SQL Profiler and had the error below when the parameter prompt was displayed in B1.

2011-08-01 14:20:07.93 Logon Error: 18456, Severity: 14, State: 8.

2011-08-01 14:20:07.93 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

I saved the report into B1 and tried to print an invoice and had the same errors.

In the profiler the error is preceded by calls reading the details froim the RDOC table. Looking at the queries after the error it looks like it is trying to read the various tables in the layout.

Rob