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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Scheduling ReportCaster job and distribute to Reports Library from Fex
Page 1 2 

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Scheduling ReportCaster job and distribute to Reports Library from Fex
 Login/Join
 
Platinum Member
posted Hide Post
Efrem - I highly appreciate this help. Thank you.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
OK. Here we go.

The following WebFOCUS Report, Master and Access file bring back a list of ReportLibrary Content by Category:

ENGINE SOAP SET CONNECTION_ATTRIBUTES RClibrary/,:'http://localhost:8080/rcaster/services/LibraryContentService file://c:/ibi/apps/reportcaster/LibraryContentService.wsdl'
-*
JOIN

GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.CATEGORY1
AND GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.NAME
AND GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.MRE
AND GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.ID IN
getaccessiblecategoryinfolistbycaller TO MULTIPLE
GETACCESSIBLECONTENTINFOLISTBYCALLER.GETACCESSIBLECONTENTINFOLISTBYCALLER.CATEGORY1
AND GETACCESSIBLECONTENTINFOLISTBYCALLER.GETACCESSIBLECONTENTINFOLISTBYCALLER.NAME
AND GETACCESSIBLECONTENTINFOLISTBYCALLER.GETACCESSIBLECONTENTINFOLISTBYCALLER.MRE
AND GETACCESSIBLECONTENTINFOLISTBYCALLER.GETACCESSIBLECONTENTINFOLISTBYCALLER.ID
IN getaccessiblecontentinfolistbycaller TAG J0 AS J0
END
-*
TABLE FILE GETACCESSIBLECATEGORYINFOLISTBYCALLER

PRINT
'GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.ID'
'GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.CATEGORY1'
'GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.MRE'
'GETACCESSIBLECATEGORYINFOLISTBYCALLER.CATEGORY.NAME'
'J0.CONTENT.ID3'
'J0.CONTENT.DESCRIPTION1'
HEADING
""
FOOTING
""
WHERE ( GETACCESSIBLECATEGORYINFOLISTBYCALLER.GETACCESSIBLECATEGORYINFOLISTBYCALLER.PASSWORD EQ '' ) AND ( GETACCESSIBLECATEGORYINFOLISTBYCALLER.GETACCESSIBLECATEGORYINFOLISTBYCALLER.USER1 EQ 'admin' );
WHERE ( GETACCESSIBLECONTENTINFOLISTBYCALLER.GETACCESSIBLECONTENTINFOLISTBYCALLER.PASSWORD EQ '' ) AND ( GETACCESSIBLECONTENTINFOLISTBYCALLER.GETACCESSIBLECONTENTINFOLISTBYCALLER.USER1 EQ 'admin' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END


FILENAME=M6ILO, SUFFIX=SOAP , $
SEGMENT=GETACCESSIBLECATEGORYINFOLISTBYCALLER, SEGTYPE=S0, $
GROUP=AUTHENTICATE, ALIAS=authenticate, ELEMENTS=3, $
FIELDNAME=PASSWORD, ALIAS=password, USAGE=A30, ACTUAL=A30,
MISSING=OFF, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=SECURITYTOKEN, ALIAS=securityToken, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=USER1, ALIAS=user, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=RESPONSE, SEGTYPE=S0, SEGSUF=XML , PARENT=GETACCESSIBLECATEGORYINFOLISTBYCALLER, POSITION=__RESPONSE, $
FIELDNAME=RESPONSE, ALIAS=getAccessibleCategoryInfoListByCallerResponse, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=GETACCESSIBLECATEGORYINFOLISTBYCALLERRETURN, SEGTYPE=S0, PARENT=RESPONSE, $
FIELDNAME=GETACCESSIBLECATEGORYINFOLISTBYCALLERRETURN, ALIAS=getAccessibleCategoryInfoListByCallerReturn, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=RESPONSE, PROPERTY=ELEMENT, $
SEGMENT=CATEGORY, SEGTYPE=S0, PARENT=GETACCESSIBLECATEGORYINFOLISTBYCALLERRETURN, $
FIELDNAME=CATEGORY, ALIAS=getAccessibleCategoryInfoListByCallerReturn, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL, ARRAY_ITEM),
REFERENCE=GETACCESSIBLECATEGORYINFOLISTBYCALLERRETURN, PROPERTY=ELEMENT, $
FIELDNAME=ID, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CATEGORY, PROPERTY=ELEMENT, $
FIELDNAME=CATEGORY1, ALIAS=category, USAGE=A5, ACTUAL=A5,
REFERENCE=CATEGORY, PROPERTY=ELEMENT, $
FIELDNAME=CONTENTLIST, ALIAS=contentList, USAGE=A1, ACTUAL=A1,
MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=CATEGORY, PROPERTY=ELEMENT, $
FIELDNAME=MRE, ALIAS=mre, USAGE=A5, ACTUAL=A5,
REFERENCE=CATEGORY, PROPERTY=ELEMENT, $
FIELDNAME=NAME, ALIAS=name, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CATEGORY, PROPERTY=ELEMENT, $
SEGMENT=CONTENT, SEGTYPE=S0, PARENT=CATEGORY, $
FIELDNAME=CONTENT, ALIAS=Content, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL, ARRAY_ITEM),
REFERENCE=CONTENTLIST, PROPERTY=ELEMENT, $
FIELDNAME=ID1, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=ACCESSLIST, ALIAS=accessList, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=ACCESSTYPE, ALIAS=accessType, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=BURSTVALUE, ALIAS=burstValue, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=DESCRIPTION, ALIAS=description, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=EXPIREINTERVAL, ALIAS=expireInterval, USAGE=I11, ACTUAL=A11,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=EXPIREMODE, ALIAS=expireMode, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=LASTEXECTIME, ALIAS=lastExecTime, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=LASTVERSION, ALIAS=lastVersion, USAGE=I11, ACTUAL=A11,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=OWNER, ALIAS=owner, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=SCHEDULEID, ALIAS=scheduleId, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=VERSIONLIST, ALIAS=versionList, USAGE=A1, ACTUAL=A1,
MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
SEGMENT=VERSION, SEGTYPE=S0, PARENT=CONTENT, $
FIELDNAME=VERSION, ALIAS=Version, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL, ARRAY_ITEM),
REFERENCE=VERSIONLIST, PROPERTY=ELEMENT, $
FIELDNAME=ID2, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=COMPRESSFORMAT, ALIAS=compressFormat, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=COMPRESSSIZE, ALIAS=compressSize, USAGE=P20, ACTUAL=A20,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=CREATEDATE, ALIAS=createDate, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=EXPIREDATE, ALIAS=expireDate, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=FORMAT, ALIAS=format, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=SIZE, ALIAS=size, USAGE=P20, ACTUAL=A20,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=VERSIONNUMBER, ALIAS=versionNumber, USAGE=I11, ACTUAL=A11,
REFERENCE=VERSION, PROPERTY=ELEMENT, $

SEGNAME=GETACCESSIBLECATEGORYINFOLISTBYCALLER, CONNECTION=RClibrary,
VERSION=1.1, OBJECT=getAccessibleCategoryInfoListByCaller, ACTION=,
ENCODING=http://schemas.xmlsoap.org/soap/encoding/,
TARGETNS=http://ws.api.broker.ibi, STYLE=RPC, $
ID=tns1, NS=urn:ReportCaster, ELEMFORM=unqualified, ATTRFORM=unqualified, $
FIELD=AUTHENTICATE, TYPE=Authenticate, NS_ID=tns1, FORM=qualified, $

FILENAME=M6ILO, SUFFIX=SOAP , $
SEGMENT=GETACCESSIBLECONTENTINFOLISTBYCALLER, SEGTYPE=S0, $
GROUP=AUTHENTICATE, ALIAS=authenticate, ELEMENTS=3, $
FIELDNAME=PASSWORD, ALIAS=password, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=SECURITYTOKEN, ALIAS=securityToken, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=USER1, ALIAS=user, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
GROUP=CATEGORY, ALIAS=category, ELEMENTS=5, $
FIELDNAME=ID, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=CATEGORY1, ALIAS=category, USAGE=A5, ACTUAL=A5, ACCESS_PROPERTY=(NEED_VALUE), $
GROUP=CONTENTLIST, ALIAS=contentList, ELEMENTS=1, $
GROUP=ITEM, ALIAS=item, ELEMENTS=12, ACCESS_PROPERTY=(ARRAY_ITEM), $
FIELDNAME=ID1, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=ACCESSLIST, ALIAS=accessList, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=ACCESSTYPE, ALIAS=accessType, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=BURSTVALUE, ALIAS=burstValue, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=DESCRIPTION, ALIAS=description, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=EXPIREINTERVAL, ALIAS=expireInterval, USAGE=I11, ACTUAL=A11, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=EXPIREMODE, ALIAS=expireMode, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=LASTEXECTIME, ALIAS=lastExecTime, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=LASTVERSION, ALIAS=lastVersion, USAGE=I11, ACTUAL=A11, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=OWNER, ALIAS=owner, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=SCHEDULEID, ALIAS=scheduleId, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
GROUP=VERSIONLIST, ALIAS=versionList, ELEMENTS=1, $
GROUP=ITEM1, ALIAS=item, ELEMENTS=8, ACCESS_PROPERTY=(ARRAY_ITEM), $
FIELDNAME=ID2, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=COMPRESSFORMAT, ALIAS=compressFormat, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=COMPRESSSIZE, ALIAS=compressSize, USAGE=P20, ACTUAL=A20, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=CREATEDATE, ALIAS=createDate, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=EXPIREDATE, ALIAS=expireDate, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=FORMAT, ALIAS=format, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=SIZE, ALIAS=size, USAGE=P20, ACTUAL=A20, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=VERSIONNUMBER, ALIAS=versionNumber, USAGE=I11, ACTUAL=A11, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=MRE, ALIAS=mre, USAGE=A5, ACTUAL=A5, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=NAME, ALIAS=name, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=RESPONSE, SEGTYPE=S0, SEGSUF=XML , PARENT=GETACCESSIBLECONTENTINFOLISTBYCALLER, POSITION=__RESPONSE, $
FIELDNAME=RESPONSE, ALIAS=getAccessibleContentInfoListByCallerResponse, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=GETACCESSIBLECONTENTINFOLISTBYCALLERRETURN, SEGTYPE=S0, PARENT=RESPONSE, $
FIELDNAME=GETACCESSIBLECONTENTINFOLISTBYCALLERRETURN, ALIAS=getAccessibleContentInfoListByCallerReturn, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=RESPONSE, PROPERTY=ELEMENT, $
SEGMENT=CONTENT, SEGTYPE=S0, PARENT=GETACCESSIBLECONTENTINFOLISTBYCALLERRETURN, $
FIELDNAME=CONTENT, ALIAS=getAccessibleContentInfoListByCallerReturn, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL, ARRAY_ITEM),
REFERENCE=GETACCESSIBLECONTENTINFOLISTBYCALLERRETURN, PROPERTY=ELEMENT, $
FIELDNAME=ID3, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=ACCESSLIST1, ALIAS=accessList, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=ACCESSTYPE1, ALIAS=accessType, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=BURSTVALUE1, ALIAS=burstValue, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=DESCRIPTION1, ALIAS=description, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=EXPIREINTERVAL1, ALIAS=expireInterval, USAGE=I11, ACTUAL=A11,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=EXPIREMODE1, ALIAS=expireMode, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=LASTEXECTIME1, ALIAS=lastExecTime, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=LASTVERSION1, ALIAS=lastVersion, USAGE=I11, ACTUAL=A11,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=OWNER1, ALIAS=owner, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=SCHEDULEID1, ALIAS=scheduleId, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
FIELDNAME=VERSIONLIST1, ALIAS=versionList, USAGE=A1, ACTUAL=A1,
MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=CONTENT, PROPERTY=ELEMENT, $
SEGMENT=VERSION, SEGTYPE=S0, PARENT=CONTENT, $
FIELDNAME=VERSION, ALIAS=Version, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL, ARRAY_ITEM),
REFERENCE=VERSIONLIST1, PROPERTY=ELEMENT, $
FIELDNAME=ID4, ALIAS=id, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=COMPRESSFORMAT1, ALIAS=compressFormat, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=COMPRESSSIZE1, ALIAS=compressSize, USAGE=P20, ACTUAL=A20,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=CREATEDATE1, ALIAS=createDate, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=EXPIREDATE1, ALIAS=expireDate, USAGE=HYYMDm, ACTUAL=A35,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=FORMAT1, ALIAS=format, USAGE=A30, ACTUAL=A30,
MISSING=ON,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=SIZE1, ALIAS=size, USAGE=P20, ACTUAL=A20,
REFERENCE=VERSION, PROPERTY=ELEMENT, $
FIELDNAME=VERSIONNUMBER1, ALIAS=versionNumber, USAGE=I11, ACTUAL=A11,
REFERENCE=VERSION, PROPERTY=ELEMENT, $

SEGNAME=GETACCESSIBLECONTENTINFOLISTBYCALLER, CONNECTION=RClibrary,
VERSION=1.1, OBJECT=getAccessibleContentInfoListByCaller, ACTION=,
ENCODING=http://schemas.xmlsoap.org/soap/encoding/,
TARGETNS=http://ws.api.broker.ibi, STYLE=RPC, $
ID=tns1, NS=urn:ReportCaster, ELEMFORM=unqualified, ATTRFORM=unqualified, $
FIELD=AUTHENTICATE, TYPE=Authenticate, NS_ID=tns1, FORM=qualified, $
FIELD=CATEGORY, TYPE=Category, NS_ID=tns1, FORM=qualified, $
FIELD=CATEGORY1, TYPE=boolean, NS_ID=xsd, $
ID=impl, NS=http://localhost:8080/rcaster/services/LibraryContentService,
ELEMFORM=unqualified, ATTRFORM=unqualified, $
FIELD=CONTENTLIST, TYPE=ArrayOf_tns1_Content, NS_ID=impl, $
FIELD=ITEM, TYPE=Content, NS_ID=tns1, $
FIELD=VERSIONLIST, TYPE=ArrayOf_tns1_Version, NS_ID=impl, $
FIELD=ITEM1, TYPE=Version, NS_ID=tns1, $
FIELD=VERSIONNUMBER, TYPE=integer, NS_ID=xsd, $
FIELD=MRE, TYPE=boolean, NS_ID=xsd, $
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
The following WebFOCUS Report, Master and Access files will delete ReportLibrary Content:

ENGINE SOAP SET CONNECTION_ATTRIBUTES RClibrary/,:'http://localhost:8080/rcaster/services/LibraryContentService file://c:/ibi/apps/reportcaster/LibraryContentService.wsdl'
TABLE FILE DELETECONTENT
PRINT
'DELETECONTENT.DELETECONTENT.CONTENTID'
HEADING
""
FOOTING
""
WHERE ( DELETECONTENT.DELETECONTENT.USER1 EQ 'admin' ) AND ( DELETECONTENT.DELETECONTENT.PASSWORD EQ '' ) AND ( DELETECONTENT.DELETECONTENT.CONTENTID EQ 'R150g9dsaj2' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

FILENAME=M6ILO, SUFFIX=SOAP , $
SEGMENT=DELETECONTENT, SEGTYPE=S0, $
GROUP=AUTHENTICATE, ALIAS=authenticate, ELEMENTS=3, $
FIELDNAME=PASSWORD, ALIAS=password, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=SECURITYTOKEN, ALIAS=securityToken, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=USER1, ALIAS=user, USAGE=A30, ACTUAL=A30,
MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=CONTENTID, ALIAS=contentId, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $

SEGNAME=DELETECONTENT, CONNECTION=RClibrary, VERSION=1.1,
OBJECT=deleteContent, ACTION=,
ENCODING=http://schemas.xmlsoap.org/soap/encoding/,
TARGETNS=http://ws.api.broker.ibi, STYLE=RPC, $
ID=tns1, NS=urn:ReportCaster, ELEMFORM=unqualified, ATTRFORM=unqualified, $
FIELD=AUTHENTICATE, TYPE=Authenticate, NS_ID=tns1, FORM=qualified, $
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
Efrem - Thanks for the samples. I tried the deletecontent service. I am getting the following error. Can you tell what is happenning?

(FOC44535) SOAP Request: htConnect failed : 3


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
(FOC44535) SOAP Request: htConnect failed : 3
means that the machine in the endpoint of the ENGINE SOAP command cannot be connected to.

Please ensure that all information within the ENGINE SOAP command is correct.

Below is an example of accessing ReportCaster Web Services when ReportCaster is configured to LOCALHOST:8080:

ENGINE SOAP SET CONNECTION_ATTRIBUTES RClibrary/,:'http://localhost:8080/rcaster/services/LibraryContentService file://c:/ibi/apps/reportcaster/LibraryContentService.wsdl'

You can also turn on the Reporting Server traces, run the request and take a look at the TSxxxxxxx.trc file.

Search for htconnect.
It should tell you what's causing your problem.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
I have checked the log. Found out that I was not referencing the connection name correctly in the connection string. After fixing the connection name the delete function works fine. I will test the get functionality. Thanks again.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
Efrem - The 'get' functionality is working great. Thank you.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
Efrem - After a long pause, I have started working on the RC/Library Web Services again. I have noticed that due to some reason the ADDSCHEDULE web services call is not pushing the report to the library. It is creating the schedule successfully. However, it is not executing the scheduled fex. I have checked the trace. I didn’t see any errors. The schedule has not created a RC log. This functionality was working fine. Do you have any suggestion?


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
Try running the schedule you created from the Web Service from the ReportCaster frontend.
Also, check the schedule definition in the ReportCaster frontend to see if anything is missing.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
When I open the schedule created by web services in the ReportCaster frontend I see no issues. It works fine when I run this schedule manually from the frontend. Also, I have noticed that when the schedule is created by the web service no log is created.

“Schedule ID: S1521ei3v00e No Log info exists for this request.”


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
The addSchedule doesn't have any setting for the log. So, my feeling is that the schedule never really did run. Especially since you are seeing no logs.
Do you get the log when you Run the job?
I'm assuming that you are just running the immediately that shows in the schedule list.
Is the schedule set to Active?
(eg. ACTIVE = 'true')
I can't repro your issue so I'm asking as many questions as I can even though they might be taken for granted.
I was able to schedule a job to distribute to Library and it ran fine.
I'll try to help you through FocalPoint for the time being but if I need screenshots or a streaming session, you would need to open up a Hotrrack case.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
I get log when I run the schedule manually from the frontend. I see the setting, ACTIVE EQ ’true’ in my web service call. I will try to open the hotrrack case. Anyway, I am posting the ADDSCHEDULE code hoping it may give you some idea.

SET DTSTANDARD=STANDARD
TABLE FILE ADDSCHEDULE
PRINT
ADDSCHEDULERETURN
WHERE PASSWORD EQ ''
WHERE USER1 EQ 'admin'
WHERE ACTIVE EQ 'true'
WHERE DELETEJOBAFTERRUN EQ 'false'
WHERE DESCRIPTION EQ 'WebFOCUS Report - To Library'
WHERE ACCESSTYPE EQ 'OWNER'
WHERE CATEGORY EQ 'Web Services Reports'
WHERE EXPIRATIONDATA EQ 3
WHERE EXPIRATIONMODE EQ 'D'
WHERE LIBRARYURL EQ 'http://localhost:8080/rcaster/library/libreport.jsp'
WHERE SENDEMAILAFTERSAVEREPORT EQ 'false'
WHERE TYPE3 EQ 'INACTIVE'
WHERE OWNER EQ 'admin'
WHERE DESCRIPTION1 EQ 'Task1 - RC Test Fex'
WHERE REPORTNAME EQ 'Carinst Report'
WHERE EXECID EQ 'admin'
WHERE EXECPASSWORD EQ 'admin'
WHERE NAME1 EQ 'COUNTRY'
WHERE VALUE EQ 'ENGLAND'
WHERE PROCEDURENAME3 EQ 'cat_test'
WHERE SENDFORMAT EQ 'HTML'
WHERE SERVERNAME3 EQ 'EDASERVE'
WHERE STARTTIME EQ DT(2010-04-08 15:27:00)
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
END


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
I think I see your problem.
Your StartTime is set to
WHERE STARTTIME EQ DT(2010-04-08 15:27:00)

That's April 8th, 2010 3:27PM GMT.

I'm not sure if schedules will run when the date is so far back.
I have run schedules successfully when the Date/Time is before the current Date/Time but within the same day.
That's a ReportCaster question as to how far back a schedule date can be.
I would change the WHERE clause to something like this:
WHERE STARTTIME EQ DT(2010-05-10 17:40:00)

Let me know what happens.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
You are right. Giving past Date/Time on same date executes the schedule. Interesting to know this. Thank you again.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
  Powered by Social Strata Page 1 2  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Scheduling ReportCaster job and distribute to Reports Library from Fex

Copyright © 1996-2020 Information Builders