Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Problem Using DB_LOOKUP and RC = 18708

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem Using DB_LOOKUP and RC = 18708
 Login/Join
 
Member
posted
Using the Data Migrator DMC, I followed the tutorials in the users guide for the DB_LOOKUP function, and it resulted in the following error:

Issuing PREPARE
Request will process data via NON-Pass Through (NON-APT)
HOLD file will be created for output file named: SQLIN.
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1407) SQL FETCH CURSOR ERROR. : COMPINFO
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1407) SQL FETCH CURSOR ERROR. : INVINFO
...RETRIEVAL KILLED
(FOC026) THE REPORT IS NO LONGER AVAILABLE
Return Code = 18708

... the problem is reproducable only when trying to include and insert the column looked- up into the target table. DB_LOOKUP would be very useful to my development, but I'm about to abandon it as a broken feature.


Webfocus relase 764
Linux
All mentioned including AHTML
 
Posts: 13 | Registered: July 10, 2009Report This Post
Platinum Member
posted Hide Post
A 18708 message isn't really an error. It's a warning saying there weren't any records returned. Which I'm going to guess is a result of the SQL FETCH CURSOR ERROR messages you received. Make sure you have access to COMPINFO and INVINFO.

If you want to stop the 18708 message, open your data flow, right click anywhere on the canvas, click in PROPERTIES, click on EXECUTION, and uncheck "STOP PROCESSING IF 0 ROWS SELECTED". This won't stop the other error messages in your case. What this is good for is in situations where getting zero records to load is a valid scenario and you don't want the 18708 to trigger some sort of error processing.

For your particular problem, if you confirm that you have access, I recommend opening a case with IBI.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Report This Post
Member
posted Hide Post
Mostly ignorant of Data Migrator, but DB savvy. What made my pause about the problem description was the fact that a DB_Lookup (select in my mind) function was being used to insert data. Is there a separate function that should be used to insert?

I guess I am asking mostly for my education, but maybe it will help others.


------
Livin' down on the cube farm. Left, right, right.

iWay 5.6
Windows
Excel, Tab-delimited, XML
 
Posts: 23 | Location: Minnesota | Registered: July 27, 2009Report This Post
Guru
posted Hide Post
DB_LOOKUP itself doesn't do an insert. In the first tutorial example it would do something equvialent to SELECT STORENAME FROM DMCOMP WHERE STORE_CODE = ? where the input values are substituted for each row and the result is assigned to the specified name.

That implies you need to be able to read from DMCOMP; can you do a Sample Data on that table? If not you may need to recreate the sample procedures and data for DataMigrator.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Problem Using DB_LOOKUP and RC = 18708

Copyright © 1996-2020 Information Builders