Livereport java webservices

Hi everyone,

I'm trying to call the method runreport from the documentmanagement webservice through java code.
In the javadoc(https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=18047148&objAction=browse&viewType=1 > API documentation > Class DocumentManagement_JAXWS) it only says which parameters to send.

runReport (int reportID, DataValue [] inputs)

Now my question is which parameter do I need to send and how?

My report has one parameter(Integer).

Thanks!

Find more posts tagged with

Comments

eLink User

Hi Yannick,

I did this a couple of months back and I can tell you my experience with an example

If my LR was for instance select name,subtype from dtree where parentid=%1

Usually in the Web gui a person would type in a valid # say for e.g 345678

In the java code you would send the value of 345678.The code treats them as

positional params as on the server side it makes that kind of decision so if you

had %1 and %2 in your LR you would put the first param & the second param values.

I may have the code in C#(you probably can understand what I do ) but I ran into a

real problem.The WS code when hitting the livelink server would actually work and

I could see from the server everything going right but at my client C# layer

it was looking at getting something and would go into exceptions.I basically could

get it working by spoofing the value on the server.I did not report this to OT because

I never needed this for anything really but I was just trying to learn this fro my own benefit.

I tried this on a CS10 Upd 10 perhaps the new edition may not have this problem

let me know and I will send you a snippet from my code.

1 Use Share Point, 2 Use Web Report, 3 Use Spreadsheet

On Mon, Sep 2, 2013 at 8:27 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

Livereport java webservices Posted byyannick.tordoir@extern.eandis.be (Tordoir, Yannick)On 09-02-2013 09:25

Hi everyone, I'm trying to call the method runreport from the documentmanagement webservice through java code.
In the javadoc(https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=18047148&objAction=browse&viewType=1 > API documentation > Class DocumentManagement_JAXWS) it only says which parameters to send. runReport (int reportID, DataValue [] inputs) Now my question is which parameter do I need to send and how? My report has one parameter(Integer). Thanks!
[To post a comment, use the normal reply function]
Forum: Content Web Services Forum
Content Server: Knowledge Center

Yannick_Tordoir

Hi,

First all thanks for your quick response.

Maybe I had to add that I get an exception when I call the method RunReport.

"Expected report input is missing"

And yes maybe it would help me if you send me your code.

Thanks in advance!

eLink User

Here was my attempt and the code I give this to you with the statement that I could not get this to work all the way and not sure if I am doing this right was more like reverse engineering

Pls let me know if this works in java and better code if you have it

1 Use Share Point, 2 Use Web Report, 3 Use Spreadsheet

On Mon, Sep 2, 2013 at 9:08 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

Re Livereport java webservices Posted byyannick.tordoir@extern.eandis.be (Tordoir, Yannick)On 09-02-2013 10:05

Hi, First all thanks for your quick response. Maybe I had to add that I get an exception when I call the method RunReport. "Expected report input is missing" And yes maybe it would help me if you send me your code. Thanks in advance!

[To post a comment, use the normal reply function]
Topic: Livereport java webservices
Forum: Content Web Services Forum
Content Server: Knowledge Center

Yannick_Tordoir

Hi,

So I checked your code and I found some differences with the java class that I have. So I started to look at the generated classes and I found out that there classes like StringValue and IntegerValue where we have the function:

setKey(String k);
setDescription(String d);

But what I didn't know is that you have a method getValues() and in the generated class I found this text:

* For example, to add a new item, do as follows:

* <pre>

* getValues().add(newItem);

* </pre>

So I did that but still no luck. After that I went to a opentext specialist(I'm just a java developer who needs to use the opentext webservices

) and we used the opentext debugger(builder) . In the code of opentext we saw that there is a check on inputs[1].fValues which means that we have to add an object in the list.

So did this:

IntegerValue v5 = new IntegerValue();

v5.setKey("Value");

v5.setDescription("Value");

v5.getValues().add(new Integer(190106));

Afther doing this the list fValues was still empty. So I checked in eclipse with the debugger what I send to opentext and there I saw that in the outputbuffer the list fValues is not send to opentext only the key and description.

So I think it has something to do in the java part. I'm still looking in to this. I will let you know if I found something.

eLink User

Hi Yannick,

I am surprised that nobody else even OT is coming out with a sample for you:) so I continue mine....

I am not convinced it is client code that is at fault because I do not completely understand the in/out parameters.However I was able to make my java client do the same errors I was getting with C#

Here's what I put in a working java client to pass an input argument of string
                       ReportResult appu;
                       StringValue what= new StringValue();
                       what.getValues().add("Admin");
                       List <DataValue> inputs = new ArrayList <DataValue>();
                       inputs.add(what);
                       appu= dm.runReport(700177, inputs);

I have a word document that I attach.ask your OT colleague if he agrees with what I am seeing:)

I don't have a vanilla system at hand so not sure if it is something I am doing
https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=39532007

PLEASE DO NOT OPEN CORE OSPACES AS I DO AND GET IN TROUBLE.

If this is a OT bug they should fix it and provide a patch to you.

If you do find a better way and run it post it so I would know the next time

BTW-I do not intend my analysis to be correct or binding on OT.I was just trying to do what a client developer would try to do ).If I was doing something that I should not have there was no example to follow:)

..Appu

1 Use Share Point, 2 Use Web Report, 3 Use Spread Sheet

Jason_Smith

Here is another code sample for running a LiveReport with a single input parameter.

Hope this helps.

eLink User

Thanks Jason for posting this sample so the original poster has something better than I was just imagining and confusing him

could you please post a sample where the

LR SQL will be something like

select name,id,deleted from kuaf where name = %1

I tried adapting your IntegerValue sample which works I see .fislimit =true set by livelink

but when I try a string not sure if this is how you should do it

          DocumentManagement.StringValue valueToSearch= new DocumentManagement.StringValue();
             //the code for my LR is like select name,id,mailaddress from kuaf where name=%1
            valueToSearch.Values = new string[1];
           valueToSearch.Values[0]= "Admin" ; //this is the %1 to my report
            DocumentManagement.DataValue[] inputs = new DocumentManagement.DataValue[1] ;
            inputs[0]= valueToSearch ;

It fails because it is not getting IsLimit from the livelink server

..Appu

1 Use Share Point, 2 Use Web Report, 3 Use Spread Sheet

Jason_Smith

What you have looks exactly like what I did. I quickly just changed the sample I posted before to point to a new LiveReport with the SQL query you have. Here is the new code with the changes I made.

eLink User

When you are setting up the LR in your livelink do you go to the GUI and put a value where it says something like

Record Limit see my screen cap which comes from installing LR Extensions

If I leave it at 100 and the returned row is 1 then my WS will go into that exception.

The Integer sample you posted also will catch the exception if it does not hit the limit

Not everybody uses LR extensions so it may be because of that

I have to try to find a vanilla livelink server to see if that is the case

..Appu

1 Use Share Point, 2 Use Web Report, 3 Use Spread Sheet

On Thu, Sep 5, 2013 at 3:26 PM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

Thanks Jason for posting this sample Posted byjsmith@opentext.com (Smith, Jason)On 09-05-2013 16:14

What you have looks exactly like what I did. I quickly just changed the sample I posted before to point to a new LiveReport with the SQL query you have. Here is the new code with the changes I made. J

Attachment Links:
Program.cs(5 KB)
[To post a comment, use the normal reply function]
Topic: Livereport java webservices
Forum: Content Web Services Forum
Content Server: Knowledge Center

Yannick_Tordoir

Hi guys,

Again thank you for your effort!

So I've looked at your C# code but the classes generated from the webservices a different in java then in C#.

In C# the input has to be DataValue[ ] in java it has to be List<DataValue[ ]>.

But I copy pasted the code:

ReportResult appu;
                       StringValue what= new StringValue();
                       what.getValues().add("Admin");
                       List <DataValue> inputs = new ArrayList <DataValue>();
                       inputs.add(what);
                       appu= dm.runReport(700177, inputs);

I can't see any difference between my code but now I get a different error. When I look into the logs of the livelink server I get this:

Start Stack Crawl ...

Thread: 00000000307B0EB0

Depth: 6

Status: Illegal type or value specified

R0: ?

Frame: 000000003CD14930 RunReport (0)

But still not working.

Jason_Smith

I don't have LR Extensions on my system, but I do have the Record Limit set to 100 like yours shows.

Sounds like there could be a bug somewhere, but it would need some more investigation. You could post your full trace file here to start. It should at least pinpoint where the problem is occuring.

Appu_Nair1

Hi Jason
I went and tried the samples you posted and those I was trying to run on a vanilla livelink system CS10 Upd 10.No problems there
In vanilla livelink when the RunReport code executes this variable isLimit comes out as false or true based on the Limit the
person sets on the LR.With LR extensions enabled the variable is ?(undefined) for the WS so it misbehaves.If you make the LR hit
the limit it will work in LR extensions livelink as well
inArgs: A<1,?,'Arguments'=A<1,?,'inputs'={A<1,?,'Description'=?,'Key'=?,'Values'={'Admin'},'_SDOName'='Core.StringValue'>},'reportID'=99233>>
outArgs: A<1,?,'Results''>},'IsLimit'=false,'SubReportID'=?,'SubReportParameters'={},>,'>
status: (0)
NO TRACE will be thrown as you can see it is building an OutArgs

For Yannick and other Java WS developers: you may want to try the code that I attach in this links.It has a screen shot
of what my LR looks in a vanilla system I tried to be as close to Jason's samples as possible.

You might want to observe what you do in the GUI and try to do something similar in code

My java code when I was trying a string LR parameter passing
https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=39660740

MY java code when I was trying a Integer LR parameter passing
https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=39663024

For people in OT WebServices Groups trying to help
Is it hard for you to post web service samples in C# and Java simultaneously as official samples.Many WS programmers are not very
fluent in livelink per se.With the absence of good samples they basically will start hating the software.Since I do not mess with
java as well it took me a while trying to learn the data structures.
In the old lapi world there was more than one code stream samples produced
I am not too familar with the java debugger in C# the debugger helps a lot.

Amy_Gordon

Hello,

I also ran into the "Error loading ReportResult.IsLimit" exception when trying to use the RunReport service. This will only happen for companies using the LiveReports Extensions module because this module masks an update that was made to the core ExecuteReport function. This prevents the IsLimit variable from being initialized when the report returns less than the maximum number of results. I opened a ticket with Open Text and they created the following bug report:

LLWR-2762: LiveReport Extensions breaks RunReport Web Services API for the LiveReports module by setting fIsLimit to Undefined when it should be false

They're working on a patch for LiveReports Extension 10 update 2. If you're also experiencing this issue, you may want to open a ticket and reference the above bug number to get notified when the patch is released.

In the meantime, to work around the problem, I set my test report to have a very low Record Limit (i.e. 1) so that the IsLimit value gets initialized properly and I can at least continue developing the code to read the report results.

Thanks,

Amy

Appu_Nair1

Thanks a lot for confirming what I saw .actually I was trying to help another person in some java code .Appreciate if you can look at what I did if that is way it is supposed to be done in java.

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Monday, September 09, 2013 3:58 PM
To: eLink Recipient
Subject: [EXTERNAL]Re Thanks Jason for posting this sample 4

Re Thanks Jason for posting this sample 4

Posted by amy.gordon@encana.com (Gordon, Amy) On 09-09-2013 16:52

Hello,

LLWR-2762: LiveReport Extensions breaks RunReport Web Services API for the LiveReports module by setting fIsLimit to Undefined when it should be false

In the meantime, to work around the problem, I set my test report to h ave a very low Record Limit (i.e. 1) so that the IsLimit value gets initialized properly and I can at least continue developing the code to read the report results.

Thanks,

Amy

[To post a comment, use the normal reply function]
Topic:	Livereport java webservices
Forum:	Content Web Services Forum
Content Server:	Knowledge Center

Yannick_Tordoir

Hi guys,

I tried to post something in this topic yesterday but I was not able to. Also tried to attach the trace file that I have but that also didn't work. I will you post the content of the trace file in here:

Start Stack Crawl ...

Thread: 00000000307B0EB0

Depth: 6

Status: Illegal type or value specified

R0: ?

Frame: 000000003CD14930 RunReport (0)

ObjRef: <LL:Frame>{{:#38000107}fFileAttributes:N,fInArgs:A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>,fOutArgs:A<1,?,'_apiError'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_errMsg'='','_Status'=0,'_StatusMessage'='','_TimeLogin'='09 09 13 113352'>,fPrgSession:#423bd42,fSocket:U<Socket(-102)=000000003D35DFF0>}</LL:Frame>.'RunReport'

PC: 239

Line: 89:89

NStkVal: 4

NLocals: 19

NArgs: 2

Stack: SP-1 = ?

Stack: SP-2 = 1

Stack: SP-3 = 1

Stack: SP-4 = 1

Local: retVal (0) = A<1,?>

Local: extendedData (1) = A<1,?,'conf_names'='','conf_values'='','dangerBox'='','DataSrc'='Sql','displaytype'='autoreport','fields'={'DComment','VersionNum','ModifyDate','DataSize'},'headers'={'Title','Version','Date','Size'},'inputOrder'=A<1,?,'inputLabel1'=1>,'inputs'={A<1,?,'inputType'='String','label'='inputLabel1','prompt'='parentid'>},'params'={'USERINPUT1'},'promptIf'='','recordlimit'=1000,'securemode'=true,'sql'='Select dataid, name\r\nfrom dtree\r\nwhere dtree.parentid = %1 ','subreport_id'=?,'subreport_parms'={},'subreport_path'='','templates'={},'title'='Items By [parentid]','usecursor'=true,'usetransact'=true>

Local: report (2) = U<DAPINode(-72)=000000003CD331C0>

Local: apiError (3) = ?

Local: inputValue (4) = ?

Local: result (5) = A<1,?,'ApiError'=?,'ErrDetail'=?,'ErrMsg'='','OK'=true>

Local: i (6) = 1

Local: nodePermissions (7) = -2130706433

Local: reportResult (8) = ?

Local: serviceNode (9) = ?

Local: errCode (10) = ''

Local: errMsg (11) = ''

Local: ok (12) = true

Local: requiredPermissions (13) = 36865

Local: prgCtx (14) = #423bd42

Local: dapiCtx (15) = #423bd44

Local: inputscopy (16) = ?

Local: isfeaturcopy (17) = ?

Local: lengthcopy (18) = ?

Args: reportID (0) = 236414

Args: inputs (1) = ?

Frame: 000000003F3E6530 Dispatch (0)

PC: 167

Line: 43:43

NStkVal: 2

NLocals: 1

NArgs: 2

Stack: SP-1 = ?

Stack: SP-2 = 236414

Local: retVal (0) = A<1,?>

Args: methodName (0) = 'RunReport'

Args: args (1) = {236414,?}

Frame: 000000003C3A3A20 Dispatch (1)

ObjRef: #3600257c.'Execute'

PC: 288

Line: 231:231

NStkVal: 2

NLocals: 7

NArgs: 2

Stack: SP-1 = {236414,?}

Stack: SP-2 = 'RunReport'

Local: retVal (0) = A<1,?>

Local: result (1) = ?

Local: args (2) = {236414,?}

Local: service (3) = <LL:Frame>{{:#38000107}fFileAttributes:N,fInArgs:A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>,fOutArgs:A<1,?,'_apiError'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_errMsg'='','_Status'=0,'_StatusMessage'='','_TimeLogin'='09 09 13 113352'>,fPrgSession:#423bd42,fSocket:U<Socket(-102)=000000003D35DFF0>}</LL:Frame>

Local: uapiCtx (4) = ?

Local: locale (5) = ''

Local: methodName (6) = 'RunReport'

Args: serviceName (0) = 'DocumentManagement'

Args: operationDef (1) = A<1,?,'DeprecatedReason'='','Description'='Runs a LiveReport.','FaultCodes'={A<1,?,'Description'='An error occured when trying to get the report node. Possibly an invalid node ID.','Name'='DocMan.InvalidReportID'>,A<1,?,'Description'='The node ID given is not an ID of a report node.','Name'='DocMan.InvalidNodeType'>,A<1,?,'Description'='The user does not have permissions to run the report.','Name'='DocMan.PermissionsError'>,A<1,?,'Description'='The given inputs do not match the expected inputs for the report.','Name'='DocMan.InvalidReportInputs'>,A<1,?,'Description'='An error occured when trying to run the report.','Name'='DocMan.ErrorRunningReport'>},'Name'='RunReport','Parameters'={A<1,?,'Description'='The ID of the LiveReport.','IsArray'=false,'IsEnum'=false,'IsNillable'=false,'IsSDO'=false,'Name'='reportID','Namespace'='DocMan','NativeType'=2,'TypeName'='Integer'>,A<1,?,'Description'='The user input values.','IsArray'=true,'IsEnum'=false,'IsNillable'=false,'IsSDO'=true,'Name'='inputs','Namespace'='Core','NativeType'=0,'TypeName'='DataValue'>},'RequiresServiceToken'=true,'ReturnDef'=A<1,?,'Description'='The result of running the LiveReport.','IsArray'=false,'IsEnum'=false,'IsNillable'=false,'IsSDO'=true,'Name'='ReportResult','Namespace'='DocMan','NativeType'=0,'TypeName'='ReportResult'>,'SinceVersion'='10.0.9'>

Frame: 000000003EC4E0F0 DispatchLLServer (0)

ObjRef: ?.<LL:Script><//\n//This script is invoked by APISrv and by the LLServer to handle a LLServer\n//protocol request. It invokes either a Web request handler or an API handler,\n//depending upon whether there is an _ApiName feature in the request.\n//\n//Note that the current implementation of LLServer does NOT invoke this script\n//on the $Webdsp.RequestHandlerSubsystem object. Instead, it copies the source from the\n//script, compiles it, and invokes it in isolation. Thus, do NOT assume that\n//'this' is any specific object.\n//\n\nfunction void DispatchLLServer( Dynamic inArgs, Dynamic ctxOut )\n\nDynamicerr\nDynamicresult\nFilelogFile\nStringtheFunc\nString IPEntry\nString logFileName\nString logFilePath\n\nAssocconfig = $ConfigOptions\nBooleanwantWeb = config.wantWeb\nBoolean wantLAPI = config.wantLAPI\nBooleanwantLogs = config.wantLogs\nBooleanwantNotification = config.wantNotification\nBooleanwantVerbose = config.wantVerbose\nBooleanwantTimings = config.wantTimings\nBooleanwantSearch = config.wantSearch\nBoolean wantPlayback = config.wantPlayback\nBoolean wantPlaybackLogs = config.wantPlaybackLogs\nBoolean wantSummaryTimings = config.wantSummaryTimings\nBoolean wantProfile = config.wantProfileTimings && isDefined( $Profiler ) \nObjectsysPrefs = $Kernel.SystemPreferences\nObjectwebTimings = $WebDsp.WebTimingsPkg\nBoolean connectLogs = sysPrefs.GetPrefBoolean( 'options', 'wantLogs', false )\n\n\n// first check to see that we have some kind of request\nif ( IsUndefined( inArgs ) || IsError( inArgs ) ) \n\necho( "Dispatch Error - Invalid request arguments." )\nreturn\nend\n\nif ( wantLogs && !connectLogs && IsDefined( $LogFile ) ) \n\nCAPI.FreeLog( $LogFile )\n$LogFile = UNDEFINED\nconfig.wantLogs = connectLogs\nwantLogs = config.wantLogs\nelseif ( !wantLogs && connectLogs ) \n\nif ( $LogFileOpenedOnce ) \n\n$LogFile = CAPI.AllocLog( $LogFileFilename, CAPI.LOG_APPEND )\nelse\n\n$LogFile = CAPI.AllocLog( $LogFileFilename )\nend\n\n$LogFileOpenedOnce = TRUE\nconfig.wantLogs = connectLogs\nwantLogs = config.wantLogs\nend\n\n// make sure we don't log a playback of a log\n\nif ( wantPlaybackLogs && isDefined( wantPlaybackLogs ) && ( isUndefined( wantPlayback ) || !wantPlayback ) ) \n\n// Build the logFileName based on the threadID\nlogFileName = "inargs" + Str.String( System.ThreadIndex() ) + ".log"\n\nif ( IsDefined( logFileName ) && !IsError( logFileName ) ) \n\nlogFile = File.OpenStream( logFileName, File.AppendMode )\n\nif ( IsDefined( logFile ) && !IsError( logFile ) ) \n\nresult = File.WriteValue( logFile, inArgs )\nFile.Close( logFile )\nend\nend\nend\n\nif ( wantVerbose )\n\nEchoParameters( inArgs, wantLogs )\nend\n\nwantTimings = IsDefined( wantTimings ) && wantTimings\nwantSummaryTimings = IsDefined( wantSummaryTimings ) && wantSummaryTimings\n\nif ( wantSummaryTimings )\n\nwebTimings.ResetTimingData()\nSQL.ResetTimeData()\nend\n\n\n//\n// Check X-Forwarded-For header to verify communication path\n//\nresult = $WEBDSP.RequestHandlerUtils.ValidateForwardedForHeader( inArgs )\n\nif ( result.cookieForward == TRUE )\n\ninArgs.REMOTE_ADDR = result.REMOTE_ADDR\n\nif ( IsFeature( inArgs, "LLENVIRON_ASSOC" ) && IsDefined( inArgs.LLENVIRON_ASSOC ) )\n\ninArgs.LLENVIRON_ASSOC.REMOTE_ADDR = result.REMOTE_ADDR\nend\n\nif ( IsFeature( inArgs, "_LLENVIRON_ASSOC" ) && IsDefined( inArgs._LLENVIRON_ASSOC ) )\n\ninArgs._LLENVIRON_ASSOC.REMOTE_ADDR = result.REMOTE_ADDR\nend\nend\n\n\nDynamic startTick\nDynamic startMicro\nDynamic startClock\nDynamic endTick\nDynamic endMicro\nDynamic endClock\n\ntheFunc = CrackTheFunc( inArgs ) \n\nLLServer.ApplContextString( theFunc )\n\n// Start the timing of the request after all of the overhead \n// of information retrieval is done. The timings then are\n// based on the code execution.\nif ( wantTimings || wantSummaryTimings || wantProfile )\n\nstartTick = Date.Tick()\nstartClock = Date.Clock()\nstartMicro = Date.MicroTick()\nend\n\n// This is the actual request execution being done. \nif ( Type( inArgs._ApiName ) == StringType ) \n\n// LAPI request\n$APIBASE.APIDispatcher.APIDispatch( inArgs, ctxOut )\n\nelseif IsDefined( inArgs._LLENVIRON_ASSOC )\n\necho( 'Ignoring web request with misconstructed LAPI arguments' )\nelse\n\n// Web request -- first verify that requests from this IP address\n// are permitted if it's coming from a socket.\nBooleanvalidIP = TRUE\n\nif ( Type( ctxOut ) == Socket.SocketType )\n\nStringCGIHosts = $Kernel.SystemPreferences.GetPref( "Security", "CGIHosts" )\n\nif IsDefined( CGIHosts ) && ( Length( CGIHosts ) \> 0 )\n\nListtmpList = Str.Elements( Str.Collapse( CGIHosts ), "," )\nList hostList\nString host\n\nfor host in tmpList \n// Check for all variations of localhost\nif( Str.CmpI( host, "localhost" ) == 0 || Str.Cmp( host, "127.0.0.1" ) == 0 || \\\nStr.Cmp( host, "::1" ) == 0 || Str.CmpI( host, "::ffff:127.0.0.1" ) == 0 )\nhostList = List.SetAdd( hostList, "::1" )\nhostList = List.SetAdd( hostList, "127.0.0.1" )\nhostList = List.SetAdd( hostList, "::ffff:127.0.0.1" )\nelse\nhostList = List.SetAdd( hostList, host )\n// if ":" found then assume an ipv6 address, otherwise ipv4\nif( !IsDefined( Str.Chr( host, ":" ) ) )\n// this is an ipv4 address, add the ipv6 version as well to the list\nhostList = List.SetAdd( hostList, ( "::ffff:" + host ) )\nend\nend\nend\n\nif !( ctxOut.pPeerIPAddress in hostList )\necho( Str.Format( 'Ignoring web request from unauthorized address (%1).', ctxOut.pPeerIPAddress ) )\nvalidIP = FALSE\nend\nend\nend\n\nif ( validIP )\n\nDynamic ctxIn\n$LLPrgCtx = undefined\n\nerr = $WebDsp.RequestHandlerSubsystem.Dispatch( ctxIn, ctxOut, Assoc.ToRecord( inArgs ) )\nif ( IsDefined( err ) )\necho( 'Dispatcher error: ', err )\nend\nend\n\nend\n\n// Capture the ending times here to ensure the execution \n// is timed not the reporting and cracking of data for \n// execution reporting. \nif ( wantTimings || wantSummaryTimings || wantProfile ) \n\nendMicro = Date.MicroTick()\nendClock = Date.Clock()\nendTick = Date.Tick()\nend\n\nif ( wantSummaryTimings )\n\n// pull out the ip address before closing the socket\n// this is used for the summary timing tracking only.\nIPEntry = CrackTheIP( inArgs, ctxOut )\nend\n\n// By closing the socket at this point the users client \n// can begin processing the data it has recieved.\n// After this point the client is gone and only \n// reporting and clean up should be done\nSocket.Close(ctxOut)\n\n// From this point on, it is all reporting of timings and \n// log file generation. \nif ( wantTimings ) \n\nStringmsg\n\nIntegertickDelta = endTick - startTick\nStringtickDeltaStr = _FormatTicksToSecs( tickDelta )\nStringclockDeltaStr = _FormatTicksToSecs( endClock - startClock )\nStringmicroDeltaStr = _FormatMicroToSecs( endMicro - startMicro )\n\nmsg = Str.Format( "%1 - %2Func=%3Timing:%4 %5 %6",\\\nDate.Now(),\\\n

eLink User

Are you passing a parameter of string 'Admin' to this LR from your trace?
'Select dataid, name\r\nfrom dtree\r\nwhere dtree.parentid = %1

I think you have setup the parameter to be string as well

'inputType'='String','label'='inputLabel1','prompt'='parentid'>

I doubt if this will run in your interface unless there is some casting in SQL

that I am unaware of

the parentid in this query should be an integer

If it helps I posted two word documents one passing a string and one passing
an integer .You could check that better still try to run the LR in the

livelink webgui for a clearer understanding....

..Appu

1 Use Share Point, 2 Use Web Report, 3 Use Spread Sheet

On Tue, Sep 10, 2013 at 2:37 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

RE Re Thanks Jason for posting this sample 4 2 Posted byyannick.tordoir@extern.eandis.be (Tordoir, Yannick)On 09-10-2013 03:32

Hi guys, I tried to post something in this topic yesterday but I was not able to. Also tried to attach the trace file that I have but that also didn't work. I will you post the content of the trace file in here: Start Stack Crawl ...
Thread: 00000000307B0EB0
Depth: 6
Status: Illegal type or value specified
R0: ?
Frame: 000000003CD14930 RunReport (0)
ObjRef: <LL:Frame>{{:#38000107}fFileAttributes:N,fInArgs:A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>,fOutArgs:A<1,?,'_apiError'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_errMsg'='','_Status'=0,'_StatusMessage'='','_TimeLogin'='09 09 13 113352'>,fPrgSession:#423bd42,fSocket:U<Socket(-102)=000000003D35DFF0>}</LL:Frame>.'RunReport'
PC: 239
Line: 89:89
NStkVal: 4
NLocals: 19
NArgs: 2
Stack: SP-1 = ?
Stack: SP-2 = 1
Stack: SP-3 = 1
Stack: SP-4 = 1
Local: retVal (0) = A<1,?>

Local: extendedData (1) = A<1,?,'conf_names'='','conf_values'='','dangerBox'='','DataSrc'='Sql','displaytype'='autoreport','fields'={'DComment','VersionNum','ModifyDate','DataSize'},'headers'={'Title','Version','Date','Size'},'inputOrder'=A<1,?,'inputLabel1'=1>,'inputs'={A<1,?,'inputType'='String','label'='inputLabel1','prompt'='parentid'>},'params'={'USERINPUT1'},'promptIf'='','recordlimit'=1000,'securemode'=true,'sql'='Select dataid, name\r\nfrom dtree\r\nwhere dtree.parentid = %1 ','subreport_id'=?,'subreport_parms'={},'subreport_path'='','templates'={},'title'='Items By [parentid]','usecursor'=true,'usetransact'=true>

Local: report (2) = U<DAPINode(-72)=000000003CD331C0>

Local: apiError (3) = ?

Local: inputValue (4) = ?

Local: result (5) = A<1,?,'ApiError'=?,'ErrDetail'=?,'ErrMsg'='','OK'=true>

Local: i (6) = 1

Local: nodePermissions (7) = -2130706433

Local: reportResult (8) = ?

Local: serviceNode (9) = ?

Local: errCode (10) = ''

Local: errMsg (11) = ''

Local: ok (12) = true

Local: requiredPermissions (13) = 36865

Local: prgCtx (14) = #423bd42

Local: dapiCtx (15) = #423bd44

Local: inputscopy (16) = ?

Local: isfeaturcopy (17) = ?

Local: lengthcopy (18) = ?

Args: reportID (0) = 236414

Args: inputs (1) = ?

Frame: 000000003F3E6530 Dispatch (0)

ObjRef: <LL:Frame>{{:#38000107}fFileAttributes:N,fInArgs:A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>,fOutArgs:A<1,?,'_apiError'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_errMsg'='','_Status'=0,'_StatusMessage'='','_TimeLogin'='09 09 13 113352'>,fPrgSession:#423bd42,fSocket:U<Socket(-102)=000000003D35DFF0>}</LL:Frame>.'Dispatch'

PC: 167

Line: 43:43

NStkVal: 2

NLocals: 1

NArgs: 2
Stack: SP-1 = ?

Stack: SP-2 = 236414

Local: retVal (0) = A<1,?>

Args: methodName (0) = 'RunReport'

Args: args (1) = {236414,?}

Frame: 000000003C3A3A20 Dispatch (1)

ObjRef: #3600257c.'Execute'

PC: 288

Line: 231:231

NStkVal: 2

NLocals: 7

NArgs: 2

Stack: SP-1 = {236414,?}

Stack: SP-2 = 'RunReport'

Local: retVal (0) = A<1,?>

Local: result (1) = ?

Local: args (2) = {236414,?}

Local: service (3) = <LL:Frame>{{:#38000107}fFileAttributes:N,fInArgs:A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>,fOutArgs:A<1,?,'_apiError'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_errMsg'='','_Status'=0,'_StatusMessage'='','_TimeLogin'='09 09 13 113352'>,fPrgSession:#423bd42,fSocket:U<Socket(-102)=000000003D35DFF0>}</LL:Frame>

Local: uapiCtx (4) = ?

Local: locale (5) = ''

Local: methodName (6) = 'RunReport'

Args: serviceName (0) = 'DocumentManagement'

Args: operationDef (1) = A<1,?,'DeprecatedReason'='','Description'='Runs a LiveReport.','FaultCodes'={A<1,?,'Description'='An error occured when trying to get the report node. Possibly an invalid node ID.','Name'='DocMan.InvalidReportID'>,A<1,?,'Description'='The node ID given is not an ID of a report node.','Name'='DocMan.InvalidNodeType'>,A<1,?,'Description'='The user does not have permissions to run the report.','Name'='DocMan.PermissionsError'>,A<1,?,'Description'='The given inputs do not match the expected inputs for the report.','Name'='DocMan.InvalidReportInputs'>,A<1,?,'Description'='An error occured when trying to run the report.','Name'='DocMan.ErrorRunningReport'>},'Name'='RunReport','Parameters'={A<1,?,'Description'='The ID of the LiveReport.','IsArray'=false,'IsEnum'=false,'IsNillable'=false,'IsSDO'=false,'Name'='reportID','Namespace'='DocMan','NativeType'=2,'TypeName'='Integer'>,A<1,?,'Description'='The user input values.','IsArray'=true,'IsEnum'=false,'IsNillable'=false,'IsSDO'=true,'Name'='inputs','Namespace'='Core','NativeType'=0,'TypeName'='DataValue'>},'RequiresServiceToken'=true,'ReturnDef'=A<1,?,'Description'='The result of running the LiveReport.','IsArray'=false,'IsEnum'=false,'IsNillable'=false,'IsSDO'=true,'Name'='ReportResult','Namespace'='DocMan','NativeType'=0,'TypeName'='ReportResult'>,'SinceVersion'='10.0.9'>

Frame: 000000003EC4E0F0 DispatchLLServer (0)

ObjRef: ?.<LL:Script><//\n//This script is invoked by APISrv and by the LLServer to handle a LLServer\n//protocol request. It invokes either a Web request handler or an API handler,\n//depending upon whether there is an _ApiName feature in the request.\n//\n//Note that the current implementation of LLServer does NOT invoke this script\n//on the $Webdsp.RequestHandlerSubsystem object. Instead, it copies the source from the\n//script, compiles it, and invokes it in isolation. Thus, do NOT assume that\n//'this' is any specific object.\n//\n\nfunction void DispatchLLServer( Dynamic inArgs, Dynamic ctxOut )\n\nDynamicerr\nDynamicresult\nFilelogFile\nStringtheFunc\nString IPEntry\nString logFileName\nString logFilePath\n\nAssocconfig = $ConfigOptions\nBooleanwantWeb = config.wantWeb\nBoolean wantLAPI = config.wantLAPI\nBooleanwantLogs = config.wantLogs\nBooleanwantNotification = config.wantNotification\nBooleanwantVerbose = config.wantVerbose\nBooleanwantTimings = config.wantTimings\nBooleanwantSearch = config.wantSearch\nBoolean wantPlayback = config.wantPlayback\nBoolean wantPlaybackLogs = config.wantPlaybackLogs\nBoolean wantSummaryTimings = config.wantSummaryTimings\nBoolean wantProfile = config.wantProfileTimings && isDefined( $Profiler ) \nObjectsysPrefs = $Kernel.SystemPreferences\nObjectwebTimings = $WebDsp.WebTimingsPkg\nBoolean connectLogs = sysPrefs.GetPrefBoolean( 'options', 'wantLogs', false )\n\n\n// first check to see that we have some kind of request\nif ( IsUndefined( inArgs ) || IsError( inArgs ) ) \n\necho( "Dispatch Error - Invalid request arguments." )\nreturn\nend\n\nif ( wantLogs && !connectLogs && IsDefined( $LogFile ) ) \n\nCAPI.FreeLog( $LogFile )\n$LogFile = UNDEFINED\nconfig.wantLogs = connectLogs\nwantLogs = config.wantLogs\nelseif ( !wantLogs && connectLogs ) \n\nif ( $LogFileOpenedOnce ) \n\n$LogFile = CAPI.AllocLog( $LogFileFilename, CAPI.LOG_APPEND )\nelse\n\n$LogFile = CAPI.AllocLog( $LogFileFilename )\nend\n\n$LogFileOpenedOnce = TRUE\nconfig.wantLogs = connectLogs\nwantLogs = config.wantLogs\nend\n\n// make sure we don't log a playback of a log\n\nif ( wantPlaybackLogs && isDefined( wantPlaybackLogs ) && ( isUndefined( wantPlayback ) || !wantPlayback ) ) \n\n// Build the logFileName based on the threadID\nlogFileName = "inargs" + Str.String( System.ThreadIndex() ) + ".log"\n\nif ( IsDefined( logFileName ) && !IsError( logFileName ) ) \n\nlogFile = File.OpenStream( logFileName, File.AppendMode )\n\nif ( IsDefined( logFile ) && !IsError( logFile ) ) \n\nresult = File.WriteValue( logFile, inArgs )\nFile.Close( logFile )\nend\nend\nend\n\nif ( wantVerbose )\n\nEchoParameters( inArgs, wantLogs )\nend\n\nwantTimings = IsDefined( wantTimings ) && wantTimings\nwantSummaryTimings = IsDefined( wantSummaryTimings ) && wantSummaryTimings\n\nif ( wantSummaryTimings )\n\nwebTimings.ResetTimingData()\nSQL.ResetTimeData()\nend\n\n\n//\n// Check X-Forwarded-For header to verify communication path\n//\nresult = $WEBDSP.RequestHandlerUtils.ValidateForwardedForHeader( inArgs )\n\nif ( result.cookieForward == TRUE )\n\ninArgs.REMOTE_ADDR = result.REMOTE_ADDR\n\nif ( IsFeature( inArgs, "LLENVIRON_ASSOC" ) && IsDefined( inArgs.LLENVIRON_ASSOC ) )\n\ninArgs.LLENVIRON_ASSOC.REMOTE_ADDR = result.REMOTE_ADDR\nend\n\nif ( IsFeature( inArgs, "_LLENVIRON_ASSOC" ) && IsDefined( inArgs._LLENVIRON_ASSOC ) )\n\ninArgs._LLENVIRON_ASSOC.REMOTE_ADDR = result.REMOTE_ADDR\nend\nend\n\n\nDynamic startTick\nDynamic startMicro\nDynamic startClock\nDynamic endTick\nDynamic endMicro\nDynamic endClock\n\ntheFunc = CrackTheFunc( inArgs ) \n\nLLServer.ApplContextString( theFunc )\n\n// Start the timing of the request after all of the overhead \n// of information retrieval is done. The timings then are\n// based on the code execution.\nif ( wantTimings || wantSummaryTimings || wantProfile )\n\nstartTick = Date.Tick()\nstartClock = Date.Clock()\nstartMicro = Date.MicroTick()\nend\n\n// This is the actual request execution being done. \nif ( Type( inArgs._ApiName ) == StringType ) \n\n// LAPI request\n$APIBASE.APIDispatcher.APIDispatch( inArgs, ctxOut )\n\nelseif IsDefined( inArgs._LLENVIRON_ASSOC )\n\necho( 'Ignoring web request with misconstructed LAPI arguments' )\nelse\n\n// Web request -- first verify that requests from this IP address\n// are permitted if it's coming from a socket.\nBooleanvalidIP = TRUE\n\nif ( Type( ctxOut ) == Socket.SocketType )\n\nStringCGIHosts = $Kernel.SystemPreferences.GetPref( "Security", "CGIHosts" )\n\nif IsDefined( CGIHosts ) && ( Length( CGIHosts ) \> 0 )\n\nListtmpList = Str.Elements( Str.Collapse( CGIHosts ), "," )\nList hostList\nString host\n\nfor host in tmpList \n// Check for all variations of localhost\nif( Str.CmpI( host, "localhost" ) == 0 || Str.Cmp( host, "127.0.0.1" ) == 0 || \\\nStr.Cmp( host, "::1" ) == 0 || Str.CmpI( host, "::ffff:127.0.0.1" ) == 0 )\nhostList = List.SetAdd( hostList, "::1" )\nhostList = List.SetAdd( hostList, "127.0.0.1" )\nhostList = List.SetAdd( hostList, "::ffff:127.0.0.1" )\nelse\nhostList = List.SetAdd( hostList, host )\n// if ":" found then assume an ipv6 address, otherwise ipv4\nif( !IsDefined( Str.Chr( host, ":" ) ) )\n// this is an ipv4 address, add the ipv6 version as well to the list\nhostList = List.SetAdd( hostList, ( "::ffff:" + host ) )\nend\nend\nend\n\nif !( ctxOut.pPeerIPAddress in hostList )\necho( Str.Format( 'Ignoring web request from unauthorized address (%1).', ctxOut.pPeerIPAddress ) )\nvalidIP = FALSE\nend\nend\nend\n\nif ( validIP )\n\nDynamic ctxIn\n$LLPrgCtx = undefined\n\nerr = $WebDsp.RequestHandlerSubsystem.Dispatch( ctxIn, ctxOut, Assoc.ToRecord( inArgs ) )\nif ( IsDefined( err ) )\necho( 'Dispatcher error: ', err )\nend\nend\n\nend\n\n// Capture the ending times here to ensure the execution \n// is timed not the reporting and cracking of data for \n// execution reporting. \nif ( wantTimings || wantSummaryTimings || wantProfile ) \n\nendMicro = Date.MicroTick()\nendClock = Date.Clock()\nendTick = Date.Tick()\nend\n\nif ( wantSummaryTimings )\n\n// pull out the ip address before closing the socket\n// this is used for the summary timing tracking only.\nIPEntry = CrackTheIP( inArgs, ctxOut )\nend\n\n// By closing the socket at this point the users client \n// can begin processing the data it has recieved.\n// After this point the client is gone and only \n// reporting and clean up should be done\nSocket.Close(ctxOut)\n\n// From this point on, it is all reporting of timings and \n// log file generation. \nif ( wantTimings ) \n\nStringmsg\n\nIntegertickDelta = endTick - startTick\nStringtickDeltaStr = _FormatTicksToSecs( tickDelta )\nStringclockDeltaStr = _FormatTicksToSecs( endClock - startClock )\nStringmicroDeltaStr = _FormatMicroToSecs( endMicro - startMicro )\n\nmsg = Str.Format( "%1 - %2Func=%3Timing:%4 %5 %6",\\\nDate.Now(),\\\nStr.String( endTick ),\\\ntheFunc,\\\nclockDeltaStr,\\\nmicroDeltaStr,\\\ntickDeltaStr )\necho( msg )\n\nif ( wantSummaryTimings ) \n\nwebTimings.AddTimingData( 'TimingTicks', tickDeltaStr )\nwebTimings.AddTimingData( 'Timing', microDeltaStr )\nwebTimings.AddTimingData( 'TimingClock', clockDeltaStr )\nend\n\nif ( IsDefined( wantLogs ) && wantLogs && IsDefined( $LogFile ) ) \n\nCAPI.Log( $LogFile, msg )\nend\nend\n\nif ( wantSummaryTimings )\n\nwebTimings.MergeTimingData( SQL.GetTimeData( 'XpostX_' ) )\nwebTimings.AddTimingData( 'EndTick', endTick )\nwebTimings.AddTimingData( 'StartTick', startTick )\nwebTimings.AddTimingData( 'EndMicro', endMicro )\nwebTimings.AddTimingData( 'StartMicro', startMicro )\nwebTimings.AddTimingData( 'EndClock', endClock )\nwebTimings.AddTimingData( 'StartClock', startClock )\nwebTimings.AddTimingData( 'ExecTime', endTick - startTick )\nwebTimings.AddTimingData( 'ApplCtx', LLServer.ApplContextString() )\nwebTimings.AddTimingData( 'QueueTime', LLServer.QueueTime() )\nwebTimings.AddTimingData( 'QueueDepthIn', LLServer.QueueDepthIn() )\nwebTimings.AddTimingData( 'QueueDepthOut', LLServer.QueueDepthOut() )\n\nwebTimings.GenerateSummaryTimings( inArgs, IPEntry, startTick, endTick, err )\necho( webTimings.fTimingData )\nend\n\nif ( isDefined( wantProfile ) )\n\n$Profiler.ProfileUtils.Log( Str.Format( "Ending request: %1 %2ֳ.", theFunc, endMicro - startMicro ) )\n$Profiler.ProfileUtils.Log( "" )\n$Profiler.ProfileUtils.WriteLogData()\n$Profiler.ProfileUtils.ResetLogData()\nend\nend\n\nfunction String _FormatTicksToSecs( Integer tickDelta )\n\nStringMilliStr = '000'\nStringnumMillisStr = Str.ValueToString( tickDelta % 1000 )\n\n\nMilliStr = MilliStr[ : ( 3 - Length( numMillisStr ) ) ] + numMillisStr\n\nreturn Str.Format( "%1.%2", ( tickDelta / 1000 ), MilliStr )\nend\n\nfunction String _FormatMicroToSecs( Integer microDelta )\n\nStringMilliStr = '000000'\nStringnumMillisStr = Str.ValueToString( microDelta % 1000000 )\n\n\nMilliStr = MilliStr[ : ( 6 - Length( numMillisStr ) ) ] + numMillisStr\n\nreturn Str.Format( "%1.%2", ( microDelta / 1000000 ), MilliStr[ ] )\nend\n\n//\n// Write the parameters of this request to the logs.\n//\nfunction void EchoParameters(\\\nDynamicinArgs,\\\nBooleanwantLogs )\n\nAssocparamCopy\nDynamicparam\nStringkey1\nDynamickey2\nStringlogString\nDynamicargLogger\nAssocretVal\nDynamicmodifiedInArgs\n\n\nmodifiedInArgs = Assoc.Copy( inArgs )\n\n//Execute all ArgumentLoggerSusystems\nfor argLogger in $WEBDSP.ArgumentLoggingSubsystem.GetItems()\n\nif( IsDefined ( argLogger ) )\n\nretVal = argLogger.ModifyAssoc( modifiedInArgs )\n\nif( retVal.ok )\n\nmodifiedInArgs = retVal.modifiedInArgs\n\nend\nend\nend\n\necho()\necho( Date.Now() )\n\n\nfor key1 in Assoc.Keys( modifiedInArgs )\n\n// Mask password entry.\nif ( IsDefined( Str.Locate( Str.Lower( key1 ), 'password' ) ) )\n\nlogString = key1 + " = 'XXXXXXXXXX'"\n\necho( logString )\n\nif wantLogs && IsDefined( $LogFile )\nCAPI.Log( $LogFile, logString )\nend\nelseif ( key1 == 'LLPARAMS_LIST' )\n// do not echo the redundant PARAMS_LIST\nelseif ( key1 == 'LLENVIRON_ASSOC' )\n// do not echo the redundant PARAMS_LIST\nelse\n\nparam = modifiedInArgs.( key1 )\n\n// Mask the password entries in an Assoc parameter.\nif ( Type( param ) == Assoc.AssocType )\n\n// Create a shallow copy of the Assoc parameter with the password entries masked out.\nparamCopy = Assoc.CreateAssoc()\n\nfor key2 in Assoc.Keys( param )\nif ( ( Type( key2 ) == StringType ) && IsDefined( Str.Locate( Str.Lower( key2 ), 'password' ) ) )\n\nparamCopy.( key2 ) = 'XXXXXXXXXX'\nelse\n\nparamCopy.( key2 ) = param.( key2 )\nend\nend\n\nlogString = Str.Format( '%1 = %2', key1, Str.Quote( Str.String( paramCopy ) ) )\nelse\n\nlogString = Str.Format( '%1 = %2', key1, Str.Quote( Str.String( param ) ) )\nend\n\necho( logString[ :130 ] )\n\nif ( wantLogs && IsDefined( $LogFile ) )\nCAPI.Log( $LogFile, logString )\nend\n\nend\nend\nend\n\nfunction String CrackTheFunc( \\\nDynamic inArgs ) \n\nListitems\nString path\n\nStringtheFunc = "?"\n\n\nif ( IsDefined( inArgs.func ) && Type( inArgs.func ) == StringType )\n\n// set the default func string \ntheFunc = inArgs.func\n\nif ( Str.Lower( inArgs.func ) == 'll' )\n\nif ( IsDefined( inArgs.parentid ) )\n\ntheFunc = Str.Format( "%1(%2)", theFunc, inArgs.parentid )\nend\n\nif ( IsDefined( inArgs.objid ) )\n\ntheFunc = Str.Format( "%1.%2", theFunc, inArgs.objid )\nend\n\nif ( IsDefined( inArgs.objaction ) )\n\ntheFunc = Str.Format( "%1.%2", theFunc, inArgs.objaction )\nend\n\nif ( IsDefined( inArgs.objtype ) )\n\ntheFunc = Str.Format( "%1[%2]", theFunc, inArgs.objtype )\nend\n\nelse\n\nif ( IsDefined( inArgs.nodeid ) )\n\ntheFunc = Str.Format( "%1.%2", theFunc, inArgs.nodeid )\nend\nend\n\nelseif ( IsDefined( inArgs._ApiName ) && Type( inArgs._ApiName ) == StringType )\n\ntheFunc = Str.Format( "lapi.%1", inArgs._ApiName )\n\n// Add the service and method names if calling a web service\nif ( 0 == Str.CmpI( "InvokeService", inArgs._ApiName ) )\n\ntheFunc = Str.Format( "%1:%2.%3()", \\\ntheFunc, \\\ninArgs.ServiceName, \\\ninArgs.ServiceMethod )\nend\n\nelseif ( IsDefined( inArgs.PATH_INFO ) && \\\nType( inArgs.PATH_INFO ) == StringType && \\\nLength( inArgs.PATH_INFO ) \> 1 )\n\npath = inArgs.PATH_INFO\n\nif ( path[ 1 ] == "/" )\n\npath = path[ 2: ]\nend\n\nitems = Str.Elements( path, "/" )\n\ntheFunc = items[ 1 ]\n\nif ( Length( items ) \> 1 ) \n\nif ( Length( items ) \> 2 )\n\ntheFunc = Str.Format( "%1(%2)", theFunc, items[ Length( items ) - 1 ] )\nend\n\ntheFunc = Str.Format( "%1.%2", theFunc, items[ Length( items ) ] )\nend\nend\n\nif ( IsDefined( theFunc ) ) \n\ntheFunc = Str.Quote( theFunc )\nend\n\nif ( isDefined( $Profiler ) )\n\n$Profiler.ProfileUtils.Log( "Beginning request: " + theFunc )\nend\n\nreturn theFunc \nend\n\nfunction String CrackTheIP( Dynamic inArgs, Dynamic ctxOut )\n\nString IPEntry = "?"\n\n//\n// Find IP address of the calling client\n//\n\nif ( IsFeature( inArgs, 'LLENVIRON_ASSOC' ) && IsDefined( inArgs.LLENVIRON_ASSOC ) \\\n&& IsFeature( inArgs.LLENVIRON_ASSOC, 'REMOTE_ADDR' ) && IsDefined( inArgs.LLENVIRON_ASSOC.REMOTE_ADDR ) )\nIPEntry = Str.Lower( inArgs.LLENVIRON_ASSOC.REMOTE_ADDR )\nelseif ( Assoc.IsKey( inArgs, "_ApiName" ) && IsDefined( ctxOut.pPeerIPAddress ) )\nIPEntry = Str.Lower( ctxOut.pPeerIPAddress )\nelseif Assoc.IsKey( inArgs, "REMOTE_ADDR" )\nIPEntry = Str.Lower( inArgs.REMOTE_ADDR )\nend\n\nreturn IPEntry\n\nend></LL:Script>

PC: 691

Line: 147:147

NStkVal: 2

NLocals: 39

NArgs: 2

Stack: SP-1 = U<Socket(-102)=000000003D35DFF0>

Stack: SP-2 = A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>

Local: err (0) = ?

Local: result (1) = A<1,?,'cookieForward'=false,'REMOTE_ADDR'='10.250.33.248'>

Local: logFile (2) = ?

Local: theFunc (3) = '\'lapi.InvokeService:DocumentManagement.RunReport()\''

Local: IPEntry (4) = ''

Local: logFileName (5) = ''

Local: logFilePath (6) = ''

Local: config (7) = A<1,?,'categoryNumToUpgrade'=200,'EnableAgents'=true,'EnableAgentsTestAll'=false,'EnableAgentsTrace'=false,'EnableNotification'=false,'errorMessageWantDebugInfo'=false,'MaxOpenSessions'=100,'maxRightsString'=250,'ObjectRankEnabled'=true,'wantByteServing'=false,'WantDirectFetch'=false,'wantHTMLView'=true,'wantIcons'=false,'wantLogs'=false,'wantSearch'=true,'wantSearchLogs'=false,'wantSecureCookies'=true,'wantTimings'=true,'wantVerbose'=true,'wantWeb'=true>

Local: wantWeb (8) = true

Local: wantLAPI (9) = ?

Local: wantLogs (10) = false

Local: wantNotification (11) = ?

Local: wantVerbose (12) = true

Local: wantTimings (13) = true

Local: wantSearch (14) = true

 Local: wantPlayback (15) = ?

Local: wantPlaybackLogs (16) = ?

Local: wantSummaryTimings (17) = false

Local: wantProfile (18) = ?

Local: sysPrefs (19) = #100358d

Local: webTimings (20) = #700148e

Local: connectLogs (21) = false

Local: startTick (22) = 441065051

Local: startMicro (23) = 2131863757

Local: startClock (24) = 441065066

Local: endTick (25) = ?

Local: endMicro (26) = ?

Local: endClock (27) = ?

Local: validIP (28) = false

Local: CGIHosts (29) = ''

Local: tmpList (30) = {}

Local: hostList (31) = {}

Local: host (32) = ''

Local: ctxIn (33) = ?

Local: msg (34) = ''

Local: tickDelta (35) = 0

Local: tickDeltaStr (36) = ''

Local: clockDeltaStr (37) = ''

Local: microDeltaStr (38) = ''

Args: inArgs (0) = A<1,N,'Arguments'=A<1,?,'reportID'=236414>,'MethodName'=?,'ServiceMethod'='RunReport','ServiceName'='DocumentManagement','_ApiName'='InvokeService','_ClientVersion'='9.7.1','_ConnectionName'='','_Cookie'='GHe%2B3DRk%2Bz0vuFFLVNKk9JjGmmCpzcZVDB96n2ctWUI%3D','_DomainName'='','_ImpersonateUser'=?,'_ImpersonateUserDomain'='','_LLENVIRON_ASSOC'=A<1,?,'REMOTE_ADDR'='10.250.33.248'>,'_Request'='llweb','_SessionObject'=?,'_UserName'='','_UserPassword'=''>

Args: ctxOut (1) = U<Socket(-102)=000000003D35DFF0>

End Stack Crawl.
[To post a comment, use the normal reply function]
Topic: Livereport java webservices
Forum: Content Web Services Forum
Content Server: Knowledge Center

Yannick_Tordoir

Hi,

I tried the two option so first parentid was of type number but that didn't work so I tried to change it to string but that didn't change anything.

eLink User

Auto live report setting perhaps?

Sent from my iPhone

On Sep 10, 2013, at 6:31 AM, "eLink Entry: Content Web Services Forum" <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

eLink : Re RE Re Thanks Jason for posting this sample 4 2
Re RE Re Thanks Jason for posting this sample 4 2 Posted byyannick.tordoir@extern.eandis.be (Tordoir, Yannick)On 09-10-2013 07:31

Hi, I tried the two option so first parentid was of type number but that didn't work so I tried to change it to string but that didn't change anything.
[To post a comment, use the normal reply function]
Topic: Livereport java webservices
Forum: Content Web Services Forum
Content Server: Knowledge Center

Kyle_Swidrovich

Hi Appu,

Samples appearing in this forum are written in our spare time (of which there unfortunately isn’t much of).

I’d love to be able to publish both Java and C# samples when I write them, but honestly it’s a matter of time.

Perhaps another thread could be started on the topic of publishing community-authored samples in the central sample area.

Best regards,

Kyle

Appu_Nair1

Thanks Kyle you guys are doing a swell job. In the absence of good readable samples developers who are called in to code something in livelink do get very edgy.

Half of them would not even take the effort to understand the product and its business rules. I would never get a head start on CWS if it was not for your C# sample

the same thing I can say because I got a beautifully written Java sample by Brad Ceballo (too bad he left )

Some starter java samples would benefit this community.

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Tuesday, September 10, 2013 12:17 PM
To: eLink Recipient
Subject: [EXTERNAL]RE Re Thanks Jason for posting this sample 4

RE Re Thanks Jason for posting this sample 4

Posted by kswidrov@opentext.com (Swidrovich, Kyle) On 09-10-2013 13:16

Hi Appu,

Samples appearing in this forum are written in our spare time (of which there unfortunately isn’t much of).

I’d love to be able to publish both Java and C# samples when I write them, but honestly it’s a matter of time.

Perhaps another thread could be started on the topic of publishing community-authored samples in the central sample area.

Best regards,

Kyle

[To post a comment, use the normal reply function]
Topic:	Livereport java webservices
Forum:	Content Web Services Forum
Content Server:	Knowledge Center

Yannick_Tordoir

Hi guys,

Maybe this can help:

Below you can find a request of the method runreport of the documentmanagement webservice (loaded in soapUI).
You can see that we only have two input parameters (Description and Key) and not values...

Doest this means that the value in the list values (what.getValues().add(190106) see previous post example) is not added in the soaprequest ?

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:api.ecm.opentext.com" xmlns:urn1="urn:DocMan.service.livelink.opentext.com" xmlns:urn2="urn:Core.service.livelink.opentext.com">

<soapenv:Header>

<urn:OTAuthentication>

<urn:AuthenticationToken>?</urn:AuthenticationToken>

</urn:OTAuthentication>

</soapenv:Header>

<soapenv:Body>

<urn1:RunReport>

<urn1:reportID>?</urn1:reportID>

<urn1:inputs>

<urn2:Description>?</urn2:Description>

<urn2:Key>?</urn2:Key>

</urn1:inputs>

</urn1:RunReport>

</soapenv:Body>

</soapenv:Envelope>

Brian_Funke

Jason,

I've tried to load this script into my project and I always get a message "best overloaded method match for 'DocumentManagementClient.RunReport(ref OTAuthentication, int, DataValue[])' has some invalid arguments. What am I missing?

Arun Sobti

We recently ran into the same issue, where running a LR in C# was giving us the 'Expected report input is missing' exception being thrown.

It turned out that we needed to supply an input paramter for each param defined in the LR. Our LR was generically defined with a number of (what we thought) were optional input params, so dynamic queries could be built. It turns out these params were not optional.

Our solution was to create a new LR to address our business needs and everything started working as expected.

Pramod Mohandas

I concur with Arun’s finding as well.

Unless I’m overlooking something, the current CS16 web services are incapable of executing LRs that have dynamic SQL queries or inputs. This forces me to create multiple individual LRs that could have gotten me what I required using just one LR.

Is this a current limitation of LR web services?

Livereport java webservices

Posted byarun.sobti@canada.ca (Sobti, Arun) On 01/04/2018 10:09 AM

We recently ran into the same issue, where running a LR in C# was giving us the 'Expected report input is missing' exception being thrown.

Our solution was to create a new LR to address our business needs and everything started working as expected.

Disclaimer: This electronic message and all contents contain information from Mannai Corporation which may be privileged, confidential or otherwise protected from discloser. The information is intended to be for the addressee only. If you are not addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error please notify the sender immediately and destroy the original and all copies.

Ian_Whitfield

Hi,

Just to follow up on this. This is correct and dynamic parameter usage e.g. chaining inputs together in the SQL like %1%2 and only passing in one value or using SQL Templates to implement optional parameters doesn't currently work via the LiveReports SOAP WebServices API. The logic that processes the inputs expects the API to have one input passed in for each input defined in the LiveReport.

There isn't currently a bug or feature request logged for this so feel free to log a ticket via support for this. In the mean time the workaround would be to pass inputs with empty values for parameters that aren't needed. Not sure if this workaround covers the scenarios mentioned so far or not.

Regards
Ian