Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Problem Using DB_LOOKUP and RC = 18708
Go
New
Search
Notify
Tools
Reply
  
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, 2009Reply With QuoteReport 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, 2007Reply With QuoteReport 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, 2009Reply With QuoteReport 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.
 
Posts: 383 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.