Help Needed with a Jaspersoft job running in SMA OpCon

[kevinwarren]

So I am running into an issue running a Jaspersoft job in OpCon. This is the Command Line for the job:

"[[Path JasperSoft]]SMARunJasperReportJobII.exe" -Configuration=[[Path JasperSoft INI]]SMARunJasperReportJobII.ini -ReportDirectory=/organizations/d0087T56/adhoc/Alabama/AO_Consumer_Loans_Opened_By_Branch_Daily -ReportName=AO_Consumer_Loans_Opened_By_Branch_Daily -OutputFileFormat=pdf -OutputFileName=\winfileBookkeepingMIS_ReportingLoan_ReportsDaily Reports[[$SCHEDULE DATE YYYYMMDD]]_Daily_Consumer_Loans_Opened_by_Branch.pdf

When I run the job this is the output it is generating:

2/6/2020 17:43:37:118 MSLSAM File Version 18.3.1.0 (Assembly version 18.3.1, Product Version 18.3.1.70), PID : 3528
2/6/2020 17:43:37:118 The Job Parameters are ...
2/6/2020 17:43:37:118 JobName : RUNDAILYDOWN     0000044512
2/6/2020 17:43:37:118 JobStartImage : c:Program FilesOpConxpsJasperSoftSMARunJasperReportJobII.exe
2/6/2020 17:43:37:118 JobArguments :  -Configuration=c:ProgramDataOpConxpsJasperSoftSMARunJasperReportJobII.ini -ReportDirectory=/organizations/d0087T56/adhoc/Alabama/AO_Consumer_Loans_Opened_By_Branch_Daily -ReportName=AO_Consumer_Loans_Opened_By_Branch_Daily -OutputFileFormat=pdf -OutputFileName=\winfileBookkeepingMIS_ReportingLoan_ReportsDaily Reports20200206_Daily_Consumer_Loans_Opened_by_Branch.pdf
2/6/2020 17:43:37:118 WorkingDirectory : 
2/6/2020 17:43:37:118 Job User : ALPH.LOCALOPCONSVC
2/6/2020 17:43:37:633 c:Program FilesOpConxpsJasperSoftSMARunJasperReportJobII.exe , File Version : 16.0.0.1, Product Version : 18.3.1.73, FileSize : 33928, File Modification Time : 2/19/2019 8:08:33 AM
2/6/2020 17:43:37:712 Job Environment : 
ALLUSERSPROFILE=C:ProgramData
APPDATA=C:UsersOPCONSVCAppDataRoaming
CommonProgramFiles=C:Program FilesCommon Files
CommonProgramFiles(x86)=C:Program Files (x86)Common Files
CommonProgramW6432=C:Program FilesCommon Files
COMPUTERNAME=LSOPCON
ComSpec=C:Windowssystem32cmd.exe
HOMEDRIVE=C:
HOMEPATH=UsersOPCONSVC
LOCALAPPDATA=C:UsersOPCONSVCAppDataLocal
LOGONSERVER=\WINDC2
MSMPI_BIN=C:Program FilesMicrosoft MPIBin
NUMBER_OF_PROCESSORS=4
OS=Windows_NT
Path=C:Program FilesMicrosoft MPIBin;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:Program Files (x86)Microsoft SQL Server140ToolsBinn;C:Program FilesMicrosoft SQL Server140ToolsBinn;C:Program Files (x86)Microsoft SQL Server140DTSBinn;C:Program FilesMicrosoft SQL Server140DTSBinn;C:Program FilesMicrosoft SQL ServerClient SDKODBC130ToolsBinn;C:Program Files (x86)Microsoft SQL ServerClient SDKODBC130ToolsBinn;C:Program Files (x86)Microsoft SQL Server140ToolsBinnManagementStudio;C:UsersOPCONSVCAppDataLocalMicrosoftWindowsApps
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 79 Stepping 1, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=4f01
ProgramData=C:ProgramData
ProgramFiles=C:Program Files
ProgramFiles(x86)=C:Program Files (x86)
ProgramW6432=C:Program Files
PSModulePath=%ProgramFiles%WindowsPowerShellModules;C:Windowssystem32WindowsPowerShellv1.0Modules;C:Program Files (x86)Microsoft SQL Server140ToolsPowerShellModules
PUBLIC=C:UsersPublic
SystemDrive=C:
SystemRoot=C:Windows
TEMP=C:UsersOPCONSVCAppDataLocalTemp
TMP=C:UsersOPCONSVCAppDataLocalTemp
USERDNSDOMAIN=ALPH.LOCAL
USERDOMAIN=ALPH
USERDOMAIN_ROAMINGPROFILE=ALPH
USERNAME=OPCON
USERPROFILE=C:UsersOPCON
windir=C:Windows
SMA_MSLSAM_SAM_JOB_ID=RUNDAILYDOWN     0000044512
SMA_MSLSAM_JOB_NAME=Run Daily Download Opened by Branch Report 0000044512
SMA_MSLSAM_SCHEDULE_DATE=20200206
SMA_MSLSAM_SCHEDULE_NAME=Daily Consumer Loans Opened by Branch
SMA_MSLSAM_SCHEDULE_FREQ=Mon-Fri-N
SMA_MSLSAM_RESTART_STEP=
SMA_MSLSAM_ROOT_DIRECTORY=C:Program FilesOpConxpsMSLSAM
SMA_MSLSAM_DATA_DIRECTORY=C:ProgramDataOpConxpsMSLSAM
SMA_MSLSAM_ECOF_DIRECTORY=
SMA_MSLSAM_LSAM_NAME=LSOPCON
SMA_MSLSAM_JOBOUTPUT_FILENAME=C:ProgramDataOpConxpsMSLSAMJobOutputArchives2020_02_06 (Thursday)RUNDAILYDOWN_0000044512.log
SMA_MSLSAM_PRERUN_ACTIVE=FALSE

2/6/2020 17:43:37:727 ************************************* Start Main Job Details *************************************

2/6/2020 17:43:37:727 Job Start Time : 174337
2/6/2020 17:43:37:727 Job Process Name : SMARunJasperReportJobII
2/6/2020 17:43:37:727 Job Process Id : 37180
2/6/2020 17:43:37:743 Getting Job Termination Status for Job RUNDAILYDOWN     0000044512
2/6/2020 17:43:38:852 Job terminated with Exit Code : 1
2/6/2020 17:43:38:852 Job finished at : 174338
2/6/2020 17:43:38:852 Job Standard Out/Error : 
Copyright Software Management and Associates - 2020
Version 16.0.0.1

Arg[0] = [-Configuration=c:ProgramDataOpConxpsJasperSoftSMARunJasperReportJobII.ini]
Arg[1] = [-ReportDirectory=/organizations/d0087T56/adhoc/Alabama/AO_Consumer_Loans_Opened_By_Branch_Daily]
Arg[2] = [-ReportName=AO_Consumer_Loans_Opened_By_Branch_Daily]
Arg[3] = [-OutputFileFormat=pdf]
Arg[4] = [-OutputFileName=\winfileBookkeepingMIS_ReportingLoan_ReportsDaily]
Arg[5] = [Reports20200206_Daily_Consumer_Loans_Opened_by_Branch.pdf]

Configuration
-------------

[ConnectionDetails]
JasperServerProtocol          : http
JasperServerIPAddress         : 10.xxx.xxx.xxx
JasperServerPort              : 8081
JasperServerDomain            : jasperserver-pro
JasperServerUser              : admin
JasperServerPassword          : *****
JasperServerTimeout           : 120000

[ReportDefaults]
ReportDirectory               : /reports/samples/
OutputFileFormat              : pdf

Command Line Arguments
----------------------
-Configuration                : c:ProgramDataOpConxpsJasperSoftSMARunJasperReportJobII.ini
                                ***** Overrides default *****
-ReportDirectory              : /organizations/d0087T56/adhoc/Alabama/AO_Consumer_Loans_Opened_By_Branch_Daily
                                ***** Overrides default *****
-ReportName                   : AO_Consumer_Loans_Opened_By_Branch_Daily
-OutputFileName               : \winfileBookkeepingMIS_ReportingLoan_ReportsDaily
-OutputFileFormat             : pdf
                                ***** Overrides default *****
-DumpXML                      : False
-Debug                        : False

Specified Report Parameters   --------------------

ERROR encountered in GetReportProperties() - outer try
The remote server returned an error: (404) Not Found.

Exit value: 1

The remote server returned an error: (404) Not Found.

Exit value: 1

2/6/2020 17:43:38:852 ************************************* End Main Job Details *************************************

 

Is anyone familiar with this error:

ERROR encountered in GetReportProperties() - outer try
The remote server returned an error: (404) Not Found.

Exit value: 1

The remote server returned an error: (404) Not Found.

Exit value: 1

 

Thanks in advance. This is the first Jaspersoft job I am automating in SMA OpCon.

 

Kevin

 

[swood_1]

Hi Kevin,

I don't know how you received access to JasperReports Server commercial editions. Did your organization buy Jaspersoft:

• directly from TIBCO Jaspersoft => Jaspersoft Support could help with this issuie
• through software you provided by another vendor => contact the vendor

From what I understand looking at the issue, you have set up a job with SAM OpCon that makes a REST call to the JasperReports Server.

The 404 means that the job is not able to connect to the JasperReports Server. It can't find that endpoint.

I can't see the actual URL you are using. That is the first thing to check.

The JasperReports Server REST API to run a report is defined here: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v750/reports-service

http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/path/to/report.<format>?<arguments>

 

Sherman