[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 808
  • Last Modified:

Crystal Lawson Report Error

There ia a current report in crystal 10 that was made by the Lawson Query Builder that is not currently working. I was told that it worked at one time, but it doesn't now. I tried re-creating the report, but got the same error. I know that lawson uses the OLE driver for data checking, so using ODBC is out of the question.

Here is the sql code:
dme:PROD=WEBUSER.PRODLINE&FILE=POLINE&FIELD=PO-NUMBER;PO-RELEASE;PO-CODE;ITEM;ITEM-DESC-1;EBUY-UOM-MULT;ENT-BUY-UOM;ENT-UNIT-CST;EXTENDED-AMT;MMDIST.ACCOUNT;MMDIST.ACCT-UNIT;MMDIST.SUB-ACCT;RQSRC-MACHINE;RQSRC-MACHINE,xlt;QUANTITY;PURCHORDER.PO-DATE&SELECT=PURCHORDER.PO-DATE%3E12%2f31%2f05%26MMDIST.ACCT-UNIT%3D92000

Here is the error I get:
Failed to open a rowset

Failed to open a rowset
Details: ADO Error Code: 0x80004005
Source: Rowset
Description: An error message was returned from DME. The m essage is Invalid number of columns in output.

|109|-2147467259|80004005|Rowset|dmecolddvr.cpp|1204|-1|-1|-1||
Native Error: 109

Can some shed some light on this error for me.

Thank you
0
metalteck
Asked:
metalteck
  • 5
  • 4
1 Solution
 
bdreed35Commented:
Can you create a brand new, simple basic report using the Lawson OLEDB driver?  This will help you determine if the driver is working or not on your PC.
The driver in my experience has been a pain in the neck, although it has good intentions.
0
 
metalteckAuthor Commented:
I don't understand? Do you mean create the same report without using the query builder utility using oledb?
0
 
bdreed35Commented:
The OLEDB driver provided by Lawson can be problematic.  I want you to see if you can create a brand new report using the driver to see if the problem is with the driver or not.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
metalteckAuthor Commented:
I re-created the same report using query builder, but got the same error. I eliminated one table from the exisiting report and tried running it again, and it worked. I also created a brand new report and it worked. The table I eliminated is the mmdist table. Any suggestions?
0
 
bdreed35Commented:
Will it let you write a report just using MMDIST?
0
 
metalteckAuthor Commented:
i"m new to lawson, so please forgive my novice questions.
If I use the query builder to write a report with mmdist tables only it works.
If I use the query builder to write a report without the mmdist table and the poline and purchorder table, it works fine.  When I put them together, it doesn't work.

I tried creating the report without using the query builder and just creating an OLEDB connection from crystal, but before I run the report, it tells me that the tables were not found and if I would like to remove them.  Do you have any suggestions?
0
 
bdreed35Commented:
No worries!

I have used the Query Builder in Lawson a few times and have run into errors, though not this specific one.
Do you know if they upgraded the driver recently?  You may have to contact the Lawson GSC to get this one resolved because it sounds like the driver is the issue.

You can connect directly to the database if you have a user name and password and the correct driver for the database.  I would recommend doing it that way rather than trying to connect via the Lawson OLEDB and not using there interface.  So, if it is Oracle, then if you have the Oracle client installed and your database configured, you can connect via the ORacle OLEDB driver rather than the Lawson one.
0
 
metalteckAuthor Commented:
Unfortunately, I believe the database is all ms sql server. Is it the same way?
0
 
bdreed35Commented:
SQL Server is even easier, I was just using Oracle as as example since that is what most of the Lawson implementations that I haev worked with are using.
You will need to know the SQL Server name, the actual database name on that server, and then a valid user name and password for the database.
Once you have that, you can navigate down to Create New Connection in the Database Expert, go to OLEDB, then New Connection.
Pick the Microsoft OLEDB Driver for SQL Server ( I think that is the name, but if not, it should be very similar), and then provide the values when prompted.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now