Prev: Cfmail possible firewall issue
Next: Xcopy sucks
From: okey on 23 Feb 2007 17:34 Hey All, I'm using a COM object to retrieve formatted information from a database and move it into another query - long story.... I'm able to retrieve 90% of the variables from the object class, but 3 or 4 variables error out when I try to access them; they throw the following exception: "The cause of this exception was that: java.lang.IllegalArgumentException: Argument is not a remote object: 3" The value "3" is the correct value for the parameter I'm calling so it's getting the information back; I don't know what's causing the error. I think it might be that the com "get" function is not returning a variant datatype - maybe it's specifying a datatype... Could that cause this error? Code.. *************** QuerySetCell(dataStore,"yrd_analyst","#dLA.Analyst#",currRow); /* QuerySetCell(dataStore,"ysd_cpd_rdl","#dLA.IniMRL#",currRow); QuerySetCell(dataStore,"ysd_RdlValue","#dLA.IniMRL#",currRow); */ QuerySetCell(dataStore,"ysd_cpd_rdl","#dLA.MRL#",currRow); QuerySetCell(dataStore,"ysd_RdlValue","#dLA.MRL#",currRow); QuerySetCell(dataStore,"ysd_mdlValue","#dLA.nMDL#",currRow); QuerySetCell(dataStore,"ysd_cpdParmWetValue","#dLA.WetResult#",currRow); ***************** dLA is the com object and all lines that aren't commented out work... The dla.IniMRL always throws.... A few others in the object have the same problem...I'm including a cfdump (some lines removed '....' indicates) of the dla object so you can see that variable IniMRL is in the the object under "get" and "put" properties... cfdump of dLA ******************************* object of coldfusion.runtime.com.ComProxy {7e14dd06-47b9-4177-bbb6-f9b212f7e481} Methods : QueryInterface([in]USERDEFINED, [out]VOID, [out, retval]VOID) AddRef([out, retval]UI4) GetIDsOfNames([in]USERDEFINED, [in]I1, [in]UINT, [in]UI4, [out]I4, [out, retval]VOID) GetAnalyteQuals([out, retval]VARIANT) GetTypeInfoCount([out]UINT, [out, retval]VOID) Invoke([in]I4, [in]USERDEFINED, [in]UI4, [in]UI2, [in]USERDEFINED, [out]VARIANT, [out]USERDEFINED, [out]UINT, [out, retval]VOID) GetTypeInfo([in]UINT, [in]UI4, [out]VOID, [out, retval]VOID) Release([out, retval]UI4) Put Properties: SourceResult([in]VARIANT, [out, retval]VOID) SurLL([in]VARIANT, [out, retval]VOID) SurrType([in]VARIANT, [out, retval]VOID) ResultSolids([in]VARIANT, [out, retval]VOID) RT([in]VARIANT, [out, retval]VOID) tResult([in]VARIANT, [out, retval]VOID) .... SpikeID([in]VARIANT, [out, retval]VOID) UNC([in]VARIANT, [out, retval]VOID) Storet([in]VARIANT, [out, retval]VOID) SurrAID([in]VARIANT, [out, retval]VOID) SurrAType([in]VARIANT, [out, retval]VOID) nResult([in]VARIANT, [out, retval]VOID) SpikeAAmount([in]VARIANT, [out, retval]VOID) PrepRatio([in]VARIANT, [out, retval]VOID) SurrAmount([in]VARIANT, [out, retval]VOID) isQC([in]VARIANT, [out, retval]VOID) cfpf([in]VARIANT, [out, retval]VOID) HazLevel([in]VARIANT, [out, retval]VOID) cfpi([in]VARIANT, [out, retval]VOID) Alias0([in]VARIANT, [out, retval]VOID) SurrAAmount([in]VARIANT, [out, retval]VOID) Instrument([in]VARIANT, [out, retval]VOID) FlagLevel3([in]VARIANT, [out, retval]VOID) RpToMDL([in]VARIANT, [out, retval]VOID) SurrAUnit([in]VARIANT, [out, retval]VOID) Wrk([in]VARIANT, [out, retval]VOID) AnalyteQuals([in]USERDEFINED, [out, retval]VOID) AnalyteInfo1([in]VARIANT, [out, retval]VOID) FlagLevel([in]VARIANT, [out, retval]VOID) AnalyteOrder([in]VARIANT, [out, retval]VOID) Analysis([in]VARIANT, [out, retval]VOID) Units([in]VARIANT, [out, retval]VOID) Decimals([in]VARIANT, [out, retval]VOID) Analyzed([in]VARIANT, [out, retval]VOID) Analyte([in]VARIANT, [out, retval]VOID) Batch([in]VARIANT, [out, retval]VOID) FiniVV([in]VARIANT, [out, retval]VOID) FlagLevel4([in]VARIANT, [out, retval]VOID) FlagLow([in]VARIANT, [out, retval]VOID) SpikeType([in]VARIANT, [out, retval]VOID) InitialUnits([in]VARIANT, [out, retval]VOID) SurrConc([in]VARIANT, [out, retval]VOID) cfi([in]VARIANT, [out, retval]VOID) UseAirFactor([in]VARIANT, [out, retval]VOID) InitialResult([in]VARIANT, [out, retval]VOID) FlagLevel2([in]VARIANT, [out, retval]VOID) Detect([in]VARIANT, [out, retval]VOID) CSVQuals([in]VARIANT, [out, retval]VOID) nMRL([in]VARIANT, [out, retval]VOID) Extraction([in]VARIANT, [out, retval]VOID) IniMDL([in]VARIANT, [out, retval]VOID) EXTRACT([in]VARIANT, [out, retval]VOID) IniVV([in]VARIANT, [out, retval]VOID) MDL([in]VARIANT, [out, retval]VOID) AnalyteInfo4([in]VARIANT, [out, retval]VOID) NoDilMDL([in]VARIANT, [out, retval]VOID) NoDilResult([in]VARIANT, [out, retval]VOID) nMDL([in]VARIANT, [out, retval]VOID) Alias4([in]VARIANT, [out, retval]VOID) AnalyteInfo3([in]VARIANT, [out, retval]VOID) CASNumber([in]VARIANT, [out, retval]VOID) AnalyteInfo5([in]VARIANT, [out, retval]VOID) AnalyteInfo2([in]VARIANT, [out, retval]VOID) MDA([in]VARIANT, [out, retval]VOID) Initial([in]VARIANT, [out, retval]VOID) MRLSolids([in]VARIANT, [out, retval]VOID) nWetResult([in]VARIANT, [out, retval]VOID) Matrix([in]VARIANT, [out, retval]VOID) MSolvent([in]VARIANT, [out, retval]VOID) SpikeAUnit([in]VARIANT, [out, retval]VOID) MolWt([in]VARIANT, [out, retval]VOID) ... Analyst([in]VARIANT, [out, retval]VOID) TInitial([in]VARIANT, [out, retval]VOID) RESP([in]VARIANT, [out, retval]VOID) TrueValue([in]VARIANT, [out, retval]VOID) ..... isSurr([in]VARIANT, [out, retval]VOID) FlagLevel1([in]VARIANT, [out, retval]VOID) QDecimals([in]VARIANT, [out, retval]VOID) MRL([in]VARIANT, [out, retval]VOID) Sample([in]VARIANT, [out, retval]VOID) isISTD([in]VARIANT, [out, retval]VOID) IniMRL([in]VARIANT, [out, retval]VOID) Extracted([in]VARIANT, [out, retval]VOID) Get Properties SourceResult([out, retval]VARIANT) SurLL([out, retval]VARIANT) SurrType([out, retval]VARIANT) ResultSolids([out, retval]VARIANT) RT([out, retval]VARIANT) tResult([out, retval]VARIANT) SurrUnit([out, retval]VARIANT) Rpt([out, retval]VARIANT) WetResult([out, retval]VARIANT) .... UNC([out, retval]VARIANT) Storet([out, retval]VARIANT) SurrAID([out, retval]VARIANT) SurrAType([out, retval]VARIANT) nResult([out, retval]VARIANT) ...... RESP([out, retval]VARIANT) TrueValue([out, retval]VARIANT) Dilution([out, retval]VARIANT) Solids([out, retval]VARIANT) PrepRatio([out, retval]VARIANT) Result([out, retval]VARIANT) SpikeUnit([out, retval]VARIANT) SpikeConc([out, retval]VARIANT) SurrAConc([out, retval]VARIANT) SpikeAmount([out, retval]VARIANT) SpikeAType([out, retval]VARIANT) SpikeAID([out, retval]VARIANT) tWetResult([out, retval]VARIANT) Alias3([out, retval]VARIANT) SigFigs([out, retval]VARIANT) PrepIUnit([out, retval]VARIANT) SpikeAConc([out, retval]VARIANT) isSurr([out, retval]VARIANT) FlagLevel1([out, retval]VARIANT) QDecimals([out, retval]VARIANT) MRL([out, retval]VARIANT) Sample([out, retval]VARIANT) isISTD([out, retval]VARIANT) IniMRL([out, retval]VARIANT) Extracted([out, retval]VARIANT)
From: BKBK on 24 Feb 2007 03:18 [i]"The cause of this exception was that: java.lang.IllegalArgumentException: Argument is not a remote object: 3" The value "3" is the correct value for the parameter I'm calling so it's getting the information back;[/i] I think the exception is telling us that an incorrect value was [i]sent[/i] as an argument, not received.
From: okey on 25 Feb 2007 22:29 Thanks for your response. The error is happening several lines after I have passed values to the com object, the code is using the data that is returned and is using the same object instance and its returned variables that the working lines are using above and below. I am looping through the returned data and when it hits this line in the loop it errors out. The lines directly above and below are accessing variables in the same object inside the same iteration of the loop. No data is being passed as an argument to the object between these lines... Further advice would be greatly appreciated.
From: BKBK on 25 Feb 2007 23:10 Which line throws an error? If it is one of the [i]QuerySetCell()[/i] invocations then check the datatype that you're attributing to dLA.IniMRL. In fact, I would dump dLA.IniMRL even before the query code.
From: okey on 25 Feb 2007 23:21
Hey, This is the line of code causing the problems... The column "ysd_cpd_rdl" is set to float and I've tried it with varchar, etc... QuerySetCell(dataStore,"ysd_cpd_rdl","#dLA.IniMRL#",currRow); I can't do a dump of dLA.IniMRL b/c it gives me the same error... I've tried the following and they all generate the same error: <cfdump var="#dLA.IniMRL#"> <cfset Variable.test = "#dLA.IniMRL#"> <cfset Variable.test = dLA.IniMRL> It only happens when I access the IniMRL variable inside of dLA... If I access dLA.result or dLA.analyte it works fine on cfdump and variable setting, but whenever I try to access IniMRL I hit the error. It's as if ColdFusion can't process the variable that inside the object even though it can see the value? |