topic Re: SAP error Message when empty rows returned since TOS 3.1.3 in Talend Studio

SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Sat, 16 Nov 2024 13:52:07 GMT

Hello,
since i've updated my TOS from 3.1.1 to 3.1.3, i changed my tSAPInput components to work with the new configuration.
And i've got a major problem because when tSAPInput returned some values it works fine, but when it does not return values i've got the following error message :
Exception in component tSAPInput_3
com.sap.mw.jco.JCO$Exception: (106) JCO_ERROR_RESOURCE: Trying to access row values in a table which does not have any rows yet
In my job it can happend that SAP returns no values (one query to SAP is for a period from 01/01/2009 to today (there's always values returned), the other is from yesterday to today (it can happend that no values are returned)) and it worked well in 3.1.1...
The job is dying with the error message.
Is there a solution ? Please help me !
Fabrice

Re: SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Mon, 20 Jul 2009 09:15:58 GMT

up please...

Re: SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Wed, 22 Jul 2009 10:59:21 GMT

Hello, I test it as you said, find it is a bug(when the return table is empty).
It have been fixed at: http://talendforge.org/trac/tos/changeset/26764
if you are anxious on this bug, please modify the file as the same svn commit:26764 in your local file:
TOS-All-r26090-V3.1.3\plugins\org.talend.designer.components.localprovider_3.1.3.r26090\components\tSAPInput\tSAPInput_begin.javajet
for more convenient, you can download this file(26765) to replace the old file.
(It also support the "deactivate some output connction" for tSAPInput)
http://talendforge.org/trac/tos/browser/trunk/org.talend.designer.components.localprovider/components/tSAPInput/tSAPInput_begin.javajet?rev=26765&format=raw

Re: SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Wed, 22 Jul 2009 16:55:42 GMT

wyang, thanks for your help.
I will try the new file next week and post comments.

Re: SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Thu, 23 Jul 2009 15:29:49 GMT

Okay, I have tried and the JCO ERROR disappeared. Thanks for the fix !
I have discovered another error that didn't exist in 3.1.1 version.
When you specify a schema in the outputs of the tSapInput component which contains a Date field, you've got the following compilation error :
"ParserUtils.parseTo_java cannot be resolved"
Do you want me to post in the bugtracker ?

Re: SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Thu, 23 Jul 2009 15:50:20 GMT

Do you want me to post in the bugtracker ?

Yes, please !
Thx for your support !

Re: SAP error Message when empty rows returned since TOS 3.1.3

Anonymous — Thu, 23 Jul 2009 17:23:34 GMT

Done it.
https://community.talend.com/t5/Archive/resolved-Run-If-trigger-fails-when-upstream-tJavaRow-sets-output/td-p/171870
Thanks for the future fix