Messages

1

Other / Re: ODF Error ARS4703E Unable to run command java.exe Error number 17

« on: November 06, 2023, 01:38:25 PM »

Justin,
Thanks for your thoughts. I normally work with OnDemand iSeries, but this is on an OnDemand Windows implementation.

I will install the most current v.10.5.0.7 server fix pack on the server and try again. I will update this post with the results.

Joe

2

Other / Re: ODF Error ARS4703E Unable to run command java.exe Error number 17

« on: November 06, 2023, 07:27:49 AM »

More details from the Trace log:

I turned on the ODF program tracing and reran the ODF process to try to email send an OnDemand distribution using the SMTP Server:

This information was added to the arsodf.xml file:
<SMTPServer>smtp.office365.com</SMTPServer>
<SSL>false</SSL>

What I found in the Trace log file was that when I set <SSL>false</SSL> I get the following error:

<message>451 5.7.3 STARTTLS is required to send mail [PH0PR07CA0058.namprd07.prod.outlook.com 2023-11-01T15:45:01.489Z 08DBD9EA97EE27A0]

   com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:2373)
   com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1808)
   com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:1285)
   javax.mail.Transport.send0(Transport.java:231)
   javax.mail.Transport.send(Transport.java:100)
   ODFProcessDist.sendMail(ODFProcessDist.java:910)
   ODFProcessDist.process(ODFProcessDist.java:242)
   ODFProcessDist.main(ODFProcessDist.java:1203)</message>

When I tried setting <SSL>true</SSL> I get a different error:

<message>Could not connect to SMTP host: smtp.office365.com, port: 25Caused by: Unrecognized SSL message, plaintext connection?
   com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2211)
   com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:722)
   javax.mail.Service.connect(Service.java:342)
   javax.mail.Service.connect(Service.java:222)
   javax.mail.Service.connect(Service.java:171)
   javax.mail.Transport.send0(Transport.java:230)
   javax.mail.Transport.send(Transport.java:100)
   ODFProcessDist.sendMail(ODFProcessDist.java:910)
   ODFProcessDist.process(ODFProcessDist.java:242)
   ODFProcessDist.main(ODFProcessDist.java:1203)</message>

It appears that I need to be sharing this information the Email Server admin.  Does a change need to be made on the Email Server?  Or is a configuration change needed within ODF?  What should I be asking from the Email Server admin?

Thanks,
Joe

3

Other / ODF Error ARS4703E Unable to run command java.exe Error number 17

« on: October 26, 2023, 12:33:41 PM »

I am working on a functioning Windows v.10.5 server and trying to distribute my first ODF email.  The OnDemand Monitor is showing Processed Report Bundles status of Error with message num = ARS4703E.

If I look at the OnDemand System Log folder I see the same error as msg num = 446 (ODF Distribution processing failed.  The detailed message says:
ARS4703E Unable to run command >C:\PROGRA~1\IBM\OnDemand\V10.5\jre\bin\java.exe< The error number is 17

I confirmed that the java.exe program exists in this path.  I can see the temp folders being created in the ARSTMP folder.  Each folder contains the object file and the XML with the distribution info.  So it looks like ODF is working except for being able to invoke the java.exe??

Am I missing some setup needed to run the Java.exe from OnDemand?

Thanks,

Joe
Joe

4

Other / SQL for Last Load, Last Query and Last Retrieval of each Application Group

« on: June 29, 2022, 11:47:13 AM »

Within the Administration Client Application Group list there is now the ability to enable 'Document Activity Tracking (going forward) for the 'Last Load', 'Last Query' and 'Last Retrieve'.

Does anyone have and willing to share the SQL statements (I image one SQL each for Load, Query and Retrieve) to run that would result in a list of all of the Application Groups with their most recent dates for each.  I assume the data would come from the System Log.

I am looking for historical data.  For example, seeing if the most recent retrieval for some reports was 1 year ago, I would not have that if I just now turned on the Document Activity Tracking, since it only populates day forward.

Thanks,
Joe

5

iSeries / ADDRPTOND - New v.7.5 Feature for Convert to PDF - Questions

« on: June 06, 2022, 11:52:00 AM »

Looking at the OnDemand v.7.5 'What's New' document, I see there is a new option on the ARRRPTOND command to PDF.

"Convert to PDF prior to Index and archive.
Support for converting SCS and AFPDS spooled files to PDF during load time
The Add Report (ADDRPTOND) command now supports the ability to convert an input spooled file from SCS or AFPDS to PDF before indexing and loading into Content Manager OnDemand. Subsequent retrievals of the archived data are displayed and printed as PDF. The new support requires IBM Transform Services for i licensed program product (5770-TS1)."

I can not find any documentation on how this is implemented. Is anyone using this successfully?
Does it require new Applications be created that is defined as PDF?
Does it require use the PDF Indexer feature?

Thanks,
Joe

6

Other / ARSDOC Delete - Can a file be 'Undeleted'?

« on: May 27, 2022, 08:53:42 AM »

Someone, (not me) ran the ARSDOC Delete command and fat fingered one of the index values and deleted the wrong document. Is the delete absolutely permanent?  Or, is there any was to 'undelete' the document short of doing a recovery from backup media? 

Thanks,
Joe

7

iSeries / Re: Configuring Archive from iSeries to a Windows Server - Connection Error

« on: May 17, 2022, 02:17:34 PM »

I have found that when using the STRMONOND command from the iSeries to monitor an output queue for new spool files to load to a Windows Server that the command ALWAYS uses the 'Check First' value for matching the Application Group name to use to archive on the Windows Server.
It seems to ignore the 'Check next' and 'Check Last' values when searching for an existing Application Group to use for archive.
Instead it generates a message 88 in the system log saying that the Application Group does not exist.  It only read from the Check First value.

Is this anyone else's experience?

Thanks,
Joe

8

Other / Query Restrictions - Converting to a single Table

« on: February 25, 2022, 08:55:22 AM »

I am working on an OnDemand  v.10.5 implementation that has over 400 user ids that each have Query Restrictions defined that limit them to accessing between 1 and 100 different Vendor Numbers.   There are about 30 different Application Groups that are indexed and restricted in this way.

The issue is that there is a constant flow of change requests to add or remove Vendor Numbers from different User IDs.  This requires the OnDemand System Administrator to update 30 Application Groups for every change request.

The solution for this is to consolidate all of the Query Restrictions to a generic table or file with two columns, UserID and VendorNumber to contain all of the entries, then update the *PUBLIC Query Restriction to reference this table. as referenced in the IBM link:

https://www.ibm.com/support/pages/content-manager-ondemand-defined-macros-sql

HOWEVER, does anyone have an idea of how to automate the conversion of thousands of query restrictions to a single generic file.  I can use OnDemand Admin client to create a report of App Group Permissions that generates a TXT file with the information, but now to translate that information to a single table??  Manual data entry of SQL Insert Into commands in too much.

Has anyone solved this?  Are there any suggestion on the best way to approach automating this one-time conversion?

Thanks,
Joe

9

Documentation / Re: Copy all data from TSM to Cache

« on: February 09, 2022, 09:02:03 AM »

I recently had a similar requirement when moving objects archived to TSM on an OnDemand iSeries Server to another storage media on the same server.  I used a two step process:

1. For the TSM extract, I created a Java utility that read the records from the SAx System Load files to get each Application Group and LoadID, then automated the calling of the OnDemand ARSDOC Get API and passing it the -X parameter with individual LoadIDs, for example:

ARSDOC Get -c -g -N -o ONDTSM -h QUSROND -d /Home/OnDMon -G AppGroupName -X LoadID

2. Use OnDemand Load monitor tools to load the .IND and .OUT files from /Home/OnDMon

There may be other ways to accomplish the same result, but this is one approach that worked.

Joe

10

iSeries / Re: Configuring Archive from iSeries to a Windows Server - Connection Error

« on: February 07, 2022, 09:35:34 AM »

I identified and fixed the issue.  It was simply a Windows Server Firewall issue.  I added an Inbound Rule to the Firewall that enabled the OnDemand ARCHIVE Instance port 1445.

Now I can start the OnDemand Monitor STRMONOND and simply specify the Instance  = ARCHIVE and the SCS spool files are storing successfully.

Thanks Justin for prompting a closer look at the connectivity issues.

Joe

11

Content Navigator / Re: CMOD PDF Fails to Load

« on: January 26, 2022, 09:13:39 AM »

Have you tried checking the System Log folder for message #88, Failed Loads to help identify the failed LoadID?

12

iSeries / Configuring Archive from iSeries to a Windows Server - Connection Error

« on: January 25, 2022, 11:14:06 AM »

I am trying to use the IBM instructions to configure 2 OnDemand v.10.5 systems such that new spool files are indexed on the iSeries server and loaded on a Windows server.  Based on the instructions, I have done the following setup:

SERVER ODTEST Windows - Created Instance = ARCHIVE
   - Create Migration Policies
   - Export/Import all App Groups/Applications from iSeries
        - Successfully tested loading new local files
   - Create UserID = ONDADM as non-LDAP ID with same password as iSeries TEST Server
   - Configure Load UserID = ONDADM with same password as iSeries TEST Server

Server TEST iSeries - Created Instance = ARCHIVE
   - Updated ARS.INI with Host=ODTEST.domainname.com and Port=1445
   - Run QSH cmd = arsstash -a 3 -c -u ONDADM -s /QIBM/UserData/OnDemand/CONFIG/odarchive.sth
   - Add line to ARS.INI = SRVR_OD_STASH=/QIBM/UserData/OnDemand/CONFIG/odarchive.sth
   - DID NOT start the ARCHIVE Instance on the iSeries

TEST iSeries - Test 1 archive
   ADDRPTOND APPGRP(R09800) SPLF(R09800) JOB(141198/USERID/J098000019) SPLNBR(1) INSTANCE(ARCHIVE)

Results:
   - ADDRPT, QZSHSH, QP0ZSPWT runs for minutes then times out
   - Spool file error = ARS1106E Connection cannot be established for the >ARCHIVE< server
   - Ping to ODTEST.domainname.com is successful
I tried changing the ARS.INI to specify Host=IP address instead of fully qualified server name and get same results

Has anyone setup this environment successfully? Am I missing anything?  How can I debug an ARS1106E error on the iSeries?  I do not see that the request is ever making it to the Windows Server.

Any ideas would be appreciated.

Joe

13

MP Server / ARSDOC Delete Processed more records that listed in the Named Query

« on: October 14, 2021, 08:44:03 AM »

I used the OnDemand v.10.5 64bit client to create a Public Named query that used 3 index fields to create the hit-list of items I wanted to delete using the ARSDOC Delete API.  The 3 fields included:
- Job Number (user defined string field)
- Job Date (user defined date field)
- Data Type (OnDemand Application field (eg. PDF, AFP, SCS, TIF, etc..)

I needed to use Data Type to make the search unique to the items I wanted to delete.

My OnDemand returned just the 3 TIFF files I wanted to delete.

I ran the ARSDOC Delete API using -q QUERYNAME parameter

It deleted the 3 files PLUS all other Data Types that also matched the Job Number and Job Date parameters.  In this case is was 20 records.

I assume the difference is that DataType is an Application field and not a userdefined index field.  This seems WRONG.  It seems to me that if defining a Named Query to use in ARSDOC Delete, it should exactly process the records found with the Named Query.

This happened on iSeries Server running server v.10.5.

Has anyone experienced the same? 

Joe

14

MP Server / Re: arssockd server job starts and terminates immediately

« on: October 07, 2021, 07:55:53 AM »

Thank you Ed.  This is useful information and we will look into creating the trace that you recommend.

Some added detail:  We are using Oracle for the DB.  The instance was up and running, apparently without issue.  We manually terminated the instance and then tried to start it again.  This is when we are unable to restart it.  I'm not an Oracle guy, but I would think that if the Oracle database was up and running before we terminated the instance then it should still be rup and ready for us to restart the instance.

Also, the only way we've found to restart the instance is to completely reboot the server.  Then the instance restarts without issue.  We should not have to reboot the server...

Thanks,
Joe

15

MP Server / arssockd server job starts and terminates immediately

« on: October 06, 2021, 01:14:49 PM »

We have a new RHEL Server with CMOD v.10.5 and FP2 installed.  The system seems to have been working without issue.

Then we need to stop the server using:   arssockd -I ondp -T
We confirmed the job had terminated:   arssockd -I ondp -p

When we go to restart the server job:  arssockd -I ondp -S

We get the message:  ARS0351I The arssockd instance ONDP is ready
BUT; we then almost immediately get another message:  ARS0352I The arssockd instance ONDP is terminating

Are we doing something wrong?  Has anyone else experienced this?  Does anyone know why this would happen or where we can look for the cause? 

We are looking throughout the V10.5 directory and the ARS_TMP directory and do not see anything that looks like a log file or error file.

Ideas?

Thanks,
Joe