Messages

1

MP Server / Re: AFP2PDF conversion possibility using IBM CMOD REST APIs

« on: August 10, 2023, 12:55:01 AM »

Thanks Spond,

It worked really appreciate your suggestion.

Thanks,
Mayank

2

MP Server / Re: AFP2PDF conversion possibility using IBM CMOD REST APIs

« on: August 09, 2023, 02:36:19 PM »

Thanks Much Spond

Really great to hear from you and addressing my concern, I am gonna try this as next step

Thanks,
Mayank

3

MP Server / AFP2PDF conversion possibility using IBM CMOD REST APIs

« on: August 09, 2023, 11:39:21 AM »

Hi Team,

We are integrating CMOD 10.5 REST APIs into a custom application to retrieve AFP documents from CMOD and we want to transform these APF documents into PDFs before sending it to the caller of the document.

Has anyone tried anything like this before with REST APIs if you can suggest the possible options that will be great.
 I understand that this is possible with ODWEK APIs with generic transform interface which allows us to leverage RICOH afp2pdf to transform it but I am not sure how to achieve the same with CMOD REST APIs

Any suggestions will be greatly appreciated.

Thanks,
Mayank 

4

MP Server / Re: CMOD 8.5.0.1 performance issues post machine restart

« on: August 07, 2023, 08:47:14 AM »

Seriously?  They're not even on the latest fixpack for CMOD v8.5?

Use this as an example as to why they should upgrade and get support reinstated.

-JD.

Yeah I have given the suggestions 

However I have figured out the problem with CMOD symbolic links.

5

MP Server / CMOD 8.5.0.1 performance issues post machine restart

« on: August 02, 2023, 10:11:53 AM »

Hello Everyone,

I have come across a very wired situation where in CMOD 8.5 has started responding very slowly post AIX LPAR reboot.
Document retrieval is taking 3-4 minutes to open the document.

I understand that it is out of support version but it seems customer is not in the mood of upgrade. Any suggestions would be greatly appreciated.

Can anyone suggest things to be checked in this case ?
 
Thanks,
Mayank

6

MP Server / Re: does IBM CMOD 10.5 support OCI as its archive storage solution

« on: April 18, 2023, 08:09:46 AM »

Hello All,

We have successfully moved on-prem TSM storage to OCI cloud successfully and it is also accessible through CMOD 10.5

Thanks

7

MP Server / Re: arsdoc query is failing with SQL0420N Invalid character found in a character st

« on: April 18, 2023, 08:08:14 AM »

Thanks Lars,

Actually the problem was with the date format we figured it out and it resolved the problem

8

MP Server / arsdoc query is failing with SQL0420N Invalid character found in a character st

« on: March 31, 2023, 10:59:03 PM »

Hi Team,
We are currently facing issue with one of our scripts. The primary area in which we are seeing this issue is the "arsdoc" query when it gets/extracts the documents from disk.
The snippet goes like below:

 

    /opt/IBM/ondemand/V10.5/bin/arsdoc \
      get -h $HOSTNAME \
          -f "$FOLDER" \
          -i "WHERE tstcrt_number||cast_number in (select tstcrt_number||min(cast_number) from root.$TABLE group by tstcrt_number) AND ARCHIVE_DATE = '$PREVMAXEXT' AND BS_CSI_No = '$CSI'" \
          -a \
          -d $WORK_DIR \
          -o ctbodctc.afp \
          -u dsgrep \
          -p /opt/IBM/ondemand/V10.5/config/ars.stash \
          -v >> $LOG 2>&1

 

Note : This arsdoc function gets/extracts data based on a filter criteria that takes customer_number into consideration.

 

Please note that the sql query in above arsdoc function is using "concat" or "||". The exact same query is running perfectly fine on AIX in our current production system.
However, when running this in Linux system in our new production machine



Error in Linux :
2023-03-31 20:19:04.331935: ARS6117I Querying database with SQL string 'WHERE concat(tstcrt_number,cast_number) in (select concat(tstcrt_number,cast_number) from root.RQD1) AND ARCHIVE_DATE = '03/30/2023' AND BS_CSI_No = '3147843''

 

2023-03-31 20:19:04.354335: ARS6085E Search unsuccessful

 

2023-03-31 20:19:04.354406: ARS6034W No hits were found that matched search criteria.

 

2023-03-31 20:19:04.354406: ARS6011E The error occurred on line number 1.

 

2023-03-31 20:19:04.354971: ARS6026I arsdoc completed.
---------------------------------------------------------------------------------------------------
Error in ondemand client :
2023-03-31 23:49:04.238311    DSGREP      130835221    Error    No        13    DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0420N  Invalid character found in a character string argument of the function "DECFLOAT".  SQLSTATE=22018  -- SQLSTATE=22018, SQLCODE=-420, File=arsdoc.c, Line=3563    system

9

MP Server / Re: does IBM CMOD 10.5 support OCI as its archive storage solution

« on: February 13, 2023, 05:36:53 AM »

Thanks Justin 

We have deployed Spectrum protect running on RHEL VM which is in OCI cloud

We can load new documents and retrieve them  but when we moved history data from exiting on-prem TSM to cloud Spectrum protect it is failing with below error
TSM Error ANS1302E (RC2) No objects on server match query return code = 2
object > 9077466HAAA  in application group >UXB> not found in node >ODNODE>

did anyone come across such errors in the past
we have upgrade CMOD and TSM

10

MP Server / does IBM CMOD 10.5 support OCI as its archive storage solution

« on: January 06, 2023, 05:41:09 AM »

Hello,

Did anyone try to use OCI with IBM CMOD 10.5 as its archive storage solution ? I checked in the documentation but did not see it as an option.

Mayank

11

MP Server / TSM Upgrade from TSM 7.1.1.100 AIX to Spectrum Protect 8.1.12 RHEL 8.6

« on: December 19, 2022, 04:14:47 PM »

What will be the best approach to upgrade CMOD archive storage from TSM 7.1.1.100 AIX 7.1.1.100 to Spectrum Protect 8.1.12 RHEL 8.6 ?

We are upgrading CMOD 8.5 to 10.5 , any suggestions for TSM upgrade as mentioned above will be appreciated 

12

MP Server / Re: AFP2PDF Plus Transform for CMOD 10.5 License type

« on: November 29, 2022, 03:47:14 PM »

Thank you everyone we were able to connect with RICOH via IBM

13

MP Server / Re: AFP2PDF Plus Transform for CMOD 10.5 License type

« on: November 15, 2022, 08:54:39 AM »

Have you had a look at StreamEDS? owned by TargetStream.

We are developing our own ICN plugin for AFP2PDF with use of StreamEDS.

Thanks Andreas

We could have opted that path but due to strict timelines looking for solution similar to RICHO because their AFP2PDF Plus transform can be integrated with ICN seamlessly     

14

MP Server / Re: AFP2PDF Plus Transform for CMOD 10.5 License type

« on: November 15, 2022, 08:47:38 AM »

Have you had a look at StreamEDS? owned by TargetStream.

We are developing our own ICN plugin for AFP2PDF with use of StreamEDS.

Hello,

We are in the process of upgrading our CMOD 8.5 to CMOD 10.5 and we are using afp2pdf software to transform afp documents to pdf and looks like IBM has stopped selling the license for it and have directed to us to connect with RICHO to buy the license. Does anyone has any contact details of RICHO if you can share that will be helpful. Also if anyone can share the experience of this tool with Navigator as plugin ?

Thanks
Mayank

Your IBM rep should be able to get you the contact information for this.

We reached out to IBM but they have not shared any contact information with us , hence thought of checking in this forum

15

MP Server / AFP2PDF Plus Transform for CMOD 10.5 License type

« on: November 15, 2022, 04:12:23 AM »

Hello,

We are in the process of upgrading our CMOD 8.5 to CMOD 10.5 and we are using afp2pdf software to transform afp documents to pdf and looks like IBM has stopped selling the license for it and have directed to us to connect with RICHO to buy the license. Does anyone has any contact details of RICHO if you can share that will be helpful. Also if anyone can share the experience of this tool with Navigator as plugin ?

Thanks
Mayank