No Data Found Error

wjm4 · Post by **wjm4** » Sun 17 Oct 2010 19:19

I just updated to 3.5.0.12 and I am now getting an Ora Error "No Data Found" being return from one of my TUniQuery's.
Steps Taken within development environment (Enable Session in Codegear XE c++ designer. Open Query and Execute.)
1) Execute Query as is. - This results in no data found error
2) Remove one field from the query (it does not matter which one) - This works without error
3) Do a NVL on one of the fields in the query and return 3 spaces. - This works for some of the records the original query did not work for but not all. (ex. NVL(Field, ' '))

My Query is below. I can not get a concrete example to send because it seems to not be consistent.

SELECT ITEMID
,MAX(ITEMDESC) ITEMDESC, GTIN, SUM(PQTY) PQTY, MAX(VALADD) VALADD, UPC, SUM(GQTY) GQTY, SUM(AUDQTY) AUDQTY, MAX(PICKLINE) PICKLINE
,MAX(GMFLAG) GMFLAG, MAX(CPCNV) CPCNV, SUM(AQTY) AQTY, MAX(PICKLOC) PICKLOC
,MAX(SHELF_PACK) SHELF_PACK
,MAX(BKWHO) BKWHO
FROM ITEM
WHERE
CRTNO = :cartNum
GROUP BY ITEMID, GTIN, UPC
ORDER BY VALADD

This is an issue that has only come up in the migration to Unidac 3.50.0.12. Has something changed in that version that would cause this issue? I am ruling out a programming error because I am running the query in the Codegear IDE without any of my program running. Also this same query runs fine when I put it into the ora developer sutdio and run it.

Any help would be appreciated. I know the explanation is not the clearest, but honestly the problem is very strange and hard to explain. Could this be a unicode issue in devart that Codegear XE Enforces? What differences in this version would be causing this issue as it has worked fine in previous issues?

Thanks

AlexP · Post by **AlexP** » Mon 18 Oct 2010 07:44

Hello,

I can not reproduce the problem.
Your example query executed without error. Please send a script to create the table and tell me which mode did you use to connect to the database - direct or OCI mode.

wjm4 · Post by **wjm4** » Mon 18 Oct 2010 18:47

I am using direct mode. I have sent an email with an oracle export file to [email protected].

The query you can use is:
SELECT ITEMID ,MAX(SUBSTR(ITEMDESC,1,35)) ITEMDESC, MAX(GTIN) GTIN, SUM(PQTY) PQTY,
MAX(VALADD) VALADD, MAX(UPC) UPC,
SUM(GQTY) GQTY, SUM(AUDQTY) AUDQTY, MAX(PICKLINE) PICKLINE,
MAX(GMFLAG) GMFLAG, MAX(CPCNV) CPCNV, SUM(AQTY) AQTY, MAX(PICKLOC) PICKLOC
,MAX(SHELF_PACK) SHELF_PACK
, MAX(BKWHO) BKWHO
FROM ITEM WHERE CRTNO = :cartNum
GROUP BY ITEMID
ORDER BY VALADD

Use for :cartNum: 00000316553088448229

AlexP · Post by **AlexP** » Tue 19 Oct 2010 10:11

Hello,

Unfortunately we have not received your mail, please send it again to alexp*devart*com

AlexP · Post by **AlexP** » Wed 20 Oct 2010 08:11

Hello,

We have fixed this bug
This fix will be include in the next build of UniDAC.
If you want we can send you the the fixed *.dcu files, please specify your IDE version and email address.

wjm4 · Post by **wjm4** » Wed 20 Oct 2010 15:02

Codegear XE Rad Studio
[email protected]

I will also need directions on how to install.

Just curious, What was the issue?

bork · Post by **bork** » Thu 21 Oct 2010 07:02

Hello

I sent the fix for Delphi XE by E-mail.

wjm4 · Post by **wjm4** » Thu 21 Oct 2010 13:55

I do not know how to install this dcu. I have tried to copy it to the directory that the previous one was installed in but that did not do it. I assume I need to re compile? I do not have source code.

Please provide with directions on how to install this dcu update into rad studio xe

AlexP · Post by **AlexP** » Fri 22 Oct 2010 08:45

Hello,

You should to put the *.dcu files into the ..\Devart\UniDac for Delphi 7\Lib\ folder.

But this fix will work only in the run-time mode, in design-time you will get the same error. It will be fix in the next UniDAC build.

wjm4 · Post by **wjm4** » Fri 22 Oct 2010 14:38

This did not fix the probelm. I have included the query I am running again as well as emailed the oracle export file to [email protected] again.
I am getting the same no data found error when I try to execute this query on the database.

Code: Select all

Cart Num: 00000316553088448229

Query

SELECT ITEMID ,MAX(SUBSTR(ITEMDESC,1,35)) ITEMDESC, MAX(GTIN) GTIN, SUM(PQTY) PQTY, 
MAX(VALADD) VALADD, MAX(UPC) UPC, 
SUM(GQTY) GQTY, SUM(AUDQTY) AUDQTY, MAX(PICKLINE) PICKLINE,
MAX(GMFLAG) GMFLAG, MAX(CPCNV) CPCNV, SUM(AQTY) AQTY, MAX(PICKLOC) PICKLOC
,MAX(SHELF_PACK) SHELF_PACK 
,MAX(BKWHO) BKWHO
FROM ITEM WHERE CRTNO = :cartNum
GROUP BY ITEMID
ORDER BY VALADD

I am using Rad Studio XE (c++ personality). I have tested at both design and run time. Please fix and send me another DCU to [email protected]

AlexP · Post by **AlexP** » Mon 25 Oct 2010 07:21

Hello,

If changing *.dcu files doesn't help, you have to wait for the official release of the new build.
We plan release it this week.

wjm4 · Post by **wjm4** » Tue 02 Nov 2010 13:14

I do not see a new version has been released. When is this update to be released.

AlexP · Post by **AlexP** » Tue 02 Nov 2010 13:51

Hello,

There were some problems, that's why the new release will be available this week.