Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Joe Wolken

Pages: [1] 2 3
1
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

2
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

3
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

4
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

5
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

6
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

7
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

8
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

9
MP Server / Error Creating Instance using Oracle
« on: September 24, 2021, 12:23:46 PM »
We have successfully installed and tested an identical QA Server (Instance = ondq) and we are now trying to replicate the process (following IBM Installation manual) to install and configure the PROD server (Instance = ondp).   It is:
RHELinux
Oracle v.19.10.0
CMOD v.10.5

The product installs successfully.  We compared these files to match the setting on QA but changing ondq to ondp:
/opt/ibm/ondemand/V10.5/config/ars.cfg
/opt/ibm/ondemand/V10.5/config/ars.ini
/opt/ibm/ondemand/V10.5/config/ars.dbfs

We get the following error when running the command:  arsdb -I ondp -rtv

[ondp@ause2ldaondp001 config]$ /opt/ibm/ondemand/V10.5/bin/arsdb -I ondp -rtv

ARS4054E DB Error: ORA-12154: TNS:could not resolve the connect identifier specified -- SQLSTATE=, SQLCODE=12154
ARS4023E Unable to connect to ORACLE ondp database

Our Oracle administrator seems to think that the Oracle database on ondp is configured the same as ondq...

Does anyone have an idea what is causing this error or what else to check or resolve this?

Thanks,
Joe

10
MP Server / arssockd not starting on New RHEL Server
« on: August 27, 2021, 09:19:39 AM »
I am installing a new OnDemand v.10.5 server on RHEL v.7.9 with an Oracle v.19 database. There is no TSM or SSL requirements. We plan to use LDAP but do not have this configured yet.

The software seems to be successfully installed and the arsdb command ran successfully to create an instance called ondq (this will be the QA Server).  I have been able to run the commands to create the System Log and System Load files.  I think this next step is to try to start the server job.  When I run either of these commands I get NO response.  I just get returned quickly with a command prompt:

./arssockd ondq arssockd
or
arssockd -S -I ondq

I can not find any new log files being created with any information to go on.

I feel like I'm missing something simple??  Any ideas?

Thanks,
Joe

11
I am installing a new OnDemand Windows v.10.5 server and I am testing the archive.  I have successfully loaded a file (exported from another system) using the following command from the OnDemand Command Window:

arsload -v -f -e -n -I ARCHIVE -g INVOICE C:\Downloads\TEST1.0.INVOICE.INVOICE

It stores all 305 documents referenced in the .IND file and .OUT file.

My 2 issues are when I try to load the SAME file using the Windows service as configured using the OnDemand Configurator tool:

The service job that is:
arsload.exe -I ARCHIVE -t 60 -c "C:\arstmp" -G DATASET -d "C:\arsload"

Issue 1:  No matter what parameter I define as the -G value the program appears to try to use the FIRST value in the filename (TEST1) a the Application Group.   I need it to be the third or fourth value.

Issue 2:  I changed the file names to replace TEST1 with INVOICE.  It appears to process the file assigning INVOICE to the Application Group.  But The message 88 error in the system log has an ARS4309E Indexing failed

The same file manually loaded successfully, so I think the .IND values should be all good.

Any ideas on Issue 1 or 2 are appreciated.

Joe


12
I am trying to install a new OnDemand v.10.5 server with DB2 on a Windows 2016 Server.  I have a single Instance called ARCHIVE.  The Instance Starts and the LibSvr Service is running.  I can logon as Admin to the Windows Client and Admin Client.  I have imported App Groups, Apps and Folders from another v.10.5 system.  I can start the run the Scheduler Service.

BUT, I can not get the Load Data Service to start.  Each time I try I get the same error message:
"The service did not respond to the start or control request in a timely fashion". 
I also get an error in the arssock.err file:
"OnDemand(1563) -> getaddrinfo.errno = 11001 rc = 11001"

I tried running arsload to store a single file and I get:
"ARS1106E Connection cannot be established for the >ARCHIVE< server"

It feels like I overlooked something in the installation process, maybe?
I'm much more familiar with OnDemand for iSeries and OnDemand Windows is sort of new to me.

Thanks for any advice.

Joe

13
This is a new OnDemand v.10.5 system archiving AFP documents.  Multiple Client PCs with the identical Client v.10.5.0.0 (64 bit).  I have some PCs that display AFP docs with no issue using the AFP Workbench for Windows Viewer v.2.08.01.00.
However, I have many PC on the network installed with the same software that will open the Viewer window for a second then close without viewing the document.  Every time I get a Windows Event log Error:

Has anyone experienced this issue or know what fixes it on the failing PCs.  Comparing DLL dates and files sizes between working and failing PCs, they are the same.  We can't find any issue with file or folder permissions.

Faulting application name: Ftdwinvw.exe, version: 2.8.1.0, time stamp: 0x5e1f8c18
Faulting module name: FTDBDT.dll, version: 2.8.1.0, time stamp: 0x5e1f8bcd
Exception code: 0xc000041d
Fault offset: 0x0000000000031fc6
Faulting process id: 0x35d0
Faulting application start time: 0x01d76dde438350dd
Faulting application path: C:\Program Files\IBM\OnDemand Clients\V10.5\bin\Ftdwinvw.exe
Faulting module path: C:\Program Files\IBM\OnDemand Clients\V10.5\bin\FTDBDT.dll
Report Id: e7089a93-a928-4c43-aaba-db21c106e3ca
Faulting package full name:
Faulting package-relative application ID:


HERE is a DETAILED Event Log App Crash Report:
Version=1
EventType=APPCRASH
EventTime=132672330612549374
ReportType=2
Consent=1
UploadTime=132672330617704338
ReportStatus=268435456
ReportIdentifier=b2009752-19d9-4614-91d5-5cc59d13169c
IntegratorReportIdentifier=888c09c7-fd27-4984-81a7-ed4c5066036d
Wow64Host=34404
NsAppName=arsgui.exe
AppSessionGuid=00003da0-0009-0018-9694-09d2c258d701
TargetAppId=W:0006b09f162e5664055957226eecb6446e8100000904!00004449e5569bdd700ff8e9800801d2bcf3a6e341e3!arsgui.exe
TargetAppVer=2020//03//05:22:38:22!55e106!arsgui.exe
BootId=4294967295
ServiceSplit=3813798193
TargetAsId=46925
UserImpactVector=808452880
IsFatal=1
EtwNonCollectReason=1
Response.BucketId=5912b67d31dd4a1de7eee41bb45fd197
Response.BucketTable=4
Response.LegacyBucketId=1724566514970907031
Response.type=4
Sig[0].Name=Application Name
Sig[0].Value=arsgui.exe
Sig[1].Name=Application Version
Sig[1].Value=10.5.0.0
Sig[2].Name=Application Timestamp
Sig[2].Value=5e617f5e
Sig[3].Name=Fault Module Name
Sig[3].Value=icuuc58.dll
Sig[4].Name=Fault Module Version
Sig[4].Value=58.2.0.0
Sig[5].Name=Fault Module Timestamp
Sig[5].Value=5e1ab853
Sig[6].Name=Exception Code
Sig[6].Value=c0000005
Sig[7].Name=Exception Offset
Sig[7].Value=00000000000c8710
DynamicSig[1].Name=OS Version
DynamicSig[1].Value=10.0.18362.2.0.0.256.4
DynamicSig[2].Name=Locale ID
DynamicSig[2].Value=1033
DynamicSig[22].Name=Additional Information 1
DynamicSig[22].Value=31e3
DynamicSig[23].Name=Additional Information 2
DynamicSig[23].Value=31e3d46994386205e8e2bffaa8198e51
DynamicSig[24].Name=Additional Information 3
DynamicSig[24].Value=7dd2
DynamicSig[25].Name=Additional Information 4
DynamicSig[25].Value=7dd2f4d1ba9c9a207dfcfc0e4d447d09
UI[2]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\arsgui.exe
LoadedModule[0]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\arsgui.exe
LoadedModule[1]=C:\WINDOWS\SYSTEM32\ntdll.dll
LoadedModule[2]=C:\WINDOWS\System32\KERNEL32.DLL
LoadedModule[3]=C:\WINDOWS\System32\KERNELBASE.dll
LoadedModule[4]=C:\WINDOWS\System32\USER32.dll
LoadedModule[5]=C:\WINDOWS\System32\win32u.dll
LoadedModule[6]=C:\WINDOWS\System32\GDI32.dll
LoadedModule[7]=C:\WINDOWS\System32\gdi32full.dll
LoadedModule[8]=C:\WINDOWS\System32\msvcp_win.dll
LoadedModule[9]=C:\WINDOWS\System32\ucrtbase.dll
LoadedModule[10]=C:\WINDOWS\System32\COMDLG32.dll
LoadedModule[11]=C:\WINDOWS\System32\msvcrt.dll
LoadedModule[12]=C:\WINDOWS\System32\combase.dll
LoadedModule[13]=C:\WINDOWS\System32\RPCRT4.dll
LoadedModule[14]=C:\WINDOWS\System32\bcryptPrimitives.dll
LoadedModule[15]=C:\WINDOWS\System32\shcore.dll
LoadedModule[16]=C:\WINDOWS\System32\SHLWAPI.dll
LoadedModule[17]=C:\WINDOWS\System32\SHELL32.dll
LoadedModule[18]=C:\WINDOWS\System32\cfgmgr32.dll
LoadedModule[19]=C:\WINDOWS\System32\windows.storage.dll
LoadedModule[20]=C:\WINDOWS\System32\sechost.dll
LoadedModule[21]=C:\WINDOWS\System32\advapi32.dll
LoadedModule[22]=C:\WINDOWS\System32\profapi.dll
LoadedModule[23]=C:\WINDOWS\System32\powrprof.dll
LoadedModule[24]=C:\WINDOWS\System32\UMPDC.dll
LoadedModule[25]=C:\WINDOWS\System32\kernel.appcore.dll
LoadedModule[26]=C:\WINDOWS\System32\cryptsp.dll
LoadedModule[27]=C:\WINDOWS\System32\OLEAUT32.dll
LoadedModule[28]=C:\WINDOWS\System32\WS2_32.dll
LoadedModule[29]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\icuio58.dll
LoadedModule[30]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\FTDFLTC.dll
LoadedModule[31]=C:\WINDOWS\WinSxS\amd64_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.18362.30_none_210ac8966535eaa7\gdiplus.dll
LoadedModule[32]=C:\WINDOWS\SYSTEM32\mfc140u.dll
LoadedModule[33]=C:\WINDOWS\System32\ole32.dll
LoadedModule[34]=C:\WINDOWS\System32\IMM32.dll
LoadedModule[35]=C:\WINDOWS\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_5.82.18362.30_none_e685621eb27f4d6a\COMCTL32.dll
LoadedModule[36]=C:\WINDOWS\SYSTEM32\WINSPOOL.DRV
LoadedModule[37]=C:\WINDOWS\System32\bcrypt.dll
LoadedModule[38]=C:\WINDOWS\SYSTEM32\VCRUNTIME140.dll
LoadedModule[39]=C:\WINDOWS\SYSTEM32\VCRUNTIME140_1.dll
LoadedModule[40]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\icuuc58.dll
LoadedModule[41]=C:\WINDOWS\SYSTEM32\VERSION.dll
LoadedModule[42]=C:\WINDOWS\SYSTEM32\MSVCP140.dll
LoadedModule[43]=C:\WINDOWS\SYSTEM32\UxTheme.dll
LoadedModule[44]=C:\WINDOWS\SYSTEM32\PROPSYS.dll
LoadedModule[45]=C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL
LoadedModule[46]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\icudt58.dll
LoadedModule[47]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\ctreestd.dll
LoadedModule[48]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\icuin58.dll
LoadedModule[49]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\FTDWSER.dll
LoadedModule[50]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\FTDODASC.dll
LoadedModule[51]=C:\Program Files\IBM\OnDemand Clients\V10.5\bin\FTDBDT.dll
LoadedModule[52]=C:\PROGRA~1\IBM\ONDEMA~1\V10.5\bin\ARSGSK64.DLL
LoadedModule[53]=C:\Program Files\ibm\gsk8\lib64\gsk8iccs_64.dll
LoadedModule[54]=C:\WINDOWS\SYSTEM32\MSVCR120.dll
LoadedModule[55]=C:\Program Files\ibm\gsk8\lib64\gsk8km_64.dll
LoadedModule[56]=C:\WINDOWS\SYSTEM32\MSVCP120.dll
LoadedModule[57]=C:\Program Files\ibm\gsk8\lib64\gsk8ssl_64.dll
LoadedModule[58]=C:\WINDOWS\SYSTEM32\WSOCK32.dll
LoadedModule[59]=C:\Program Files\ibm\gsk8\lib64\gsk8cms_64.dll
LoadedModule[60]=C:\Program Files\ibm\gsk8\lib64\C\icc\icclib\icclib084.dll
LoadedModule[61]=C:\Program Files\ibm\gsk8\lib64\gsk8kicc_64.dll
LoadedModule[62]=C:\PROGRA~1\IBM\ONDEMA~1\V10.5\locale\ENU\ARSLGC.DLL
LoadedModule[63]=C:\WINDOWS\System32\clbcatq.dll
LoadedModule[64]=C:\WINDOWS\System32\MSCTF.dll
LoadedModule[65]=C:\WINDOWS\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.18362.30_none_a1435978519dce7f\comctl32.DLL
LoadedModule[66]=C:\WINDOWS\SYSTEM32\TextInputFramework.dll
LoadedModule[67]=C:\WINDOWS\SYSTEM32\CoreMessaging.dll
LoadedModule[68]=C:\WINDOWS\SYSTEM32\CoreUIComponents.dll
LoadedModule[69]=C:\WINDOWS\SYSTEM32\ntmarta.dll
LoadedModule[70]=C:\WINDOWS\SYSTEM32\wintypes.dll
LoadedModule[71]=C:\WINDOWS\SYSTEM32\iertutil.dll
LoadedModule[72]=C:\Windows\System32\hhctrl.ocx
LoadedModule[73]=C:\WINDOWS\system32\mswsock.dll
LoadedModule[74]=C:\WINDOWS\SYSTEM32\DNSAPI.dll
LoadedModule[75]=C:\WINDOWS\System32\NSI.dll
LoadedModule[76]=C:\Windows\System32\rasadhlp.dll
LoadedModule[77]=C:\WINDOWS\System32\fwpuclnt.dll
State[0].Key=Transport.DoneStage1
State[0].Value=1
OsInfo[0].Key=vermaj
OsInfo[0].Value=10
OsInfo[1].Key=vermin



14
Windows Client / AFP Workbench Viewer Displays Doc - Then Errors
« on: June 09, 2021, 02:25:05 PM »
I am working on a new OnDemand iSeries v.7.3 (server v.10.5) implementation.  We are archiving AFP files (MOD:CA image files that are migrated from IBM Content Manager iSeries).    We have several Windows 10 PCs with the OnDemand Client v.10.5 64-bit installed that display the AFP documents perfectly in the AFP Workbench viewer v.2.08.01 (as expected).

However, other Windows 10 PCs that have been on the network longer (and used for more various functions) will launch and display the document for a few seconds and then the display a generic error message 'AFP Workbench Viewer has stopped working' with the only button to select as 'Close Program'.  This has to be understood and fixed before we can roll out more workstations.

This seems to be a possible conflict with other software running on some of the PCs?  Has anyone experienced this or know what to look for as a difference between the working PCs and failing PCs?

Confused...

Thanks,
Joe

15
Windows Client / Client Application Window is not Displaying
« on: February 19, 2021, 10:17:47 AM »
I have a situation where just a few Windows 10 64bit PCs are experiencing this issue with OnDemand Client v.10.1 64bit:
User selects the OnDemand Client icon and is presented the logon window BUT NO background application window.  They successfully logon and are presented their normal Folder selection window, still NO background application window.  So the user selects their Folder from the list and they see NOTHING, because the application window with the search criteria and hit list was never displayed.  The icon in the Windows tray at the bottom is there like the application is behaving normally.  All the user can do is close the application from the tray icon.
We have tried a repair install, but not yet a complete uninstall/reinstall.

Has anyone had a similar experience or know what is causing this behavior?

Thanks,

Joe

Pages: [1] 2 3